Print

Multiple Regression

NOTE:
The links on this handout must be saved to your computer or flash drive before opening them in Minitab.  They are Excel files.  After saving them, open Minitab.  Click on File, Open Worksheet.  Change the directory to your flash drive.  Change the file type to Excel (XLS).  Double click on the file and it will add the database to Minitab as a worksheet.
 
Problem 1:
Using the attached worksheet, predict the weight of a female bear based upon her age, the size of her neck and chest, and her overall length.

Bear Worksheet
 
Problem 2:
Using the attached worksheet, predict the speed of the roller coaster based upon its height and length.

Roller Coaster Worksheet
 
Problem 3:
Using the attached worksheet, predict the speed of the roller coaster based upon its height, length, and type of material.

Roller Coaster Worksheet
 
Problem 4:
Using the attached worksheet, predict the price of the California homes based upon their square footage, the number of bedrooms, and the number of bathrooms.

California Homes Worksheet
 
Problem 5:
Using the attached worksheet, predict a person's height based upon his/her gender, left arm size, right arm size, left foot size, right foot size, left hand size, right hand size, the circumference of his/her head, and the length of his/her nose.

Body Measures Worksheet
 
Problem 6:
Investigators studied physical characteristics and ability in 13 football punters. Each volunteer punted a football ten times. The investigators recorded the average distance for the ten punts, in feet. They also recorded the average hang time (time the ball is in the air before the receiver catches it) for the ten punts, in seconds. In addition, the investigators recorded five measures of strength and flexibility for each punter: right leg strength (pounds), left leg strength (pounds), right hamstring muscle flexibility (degrees), left hamstring muscle flexibility (degrees), and overall leg strength (foot-pounds). From the study "The relationship between selected physical performance variables and football punting ability" by the Department of Health, Physical Education and Recreation at the Virginia Polytechnic Institute and State University, 1983.

a.  Using the attached worksheet, predict the punter's distance based upon hang time, right strength, left strength, right flexibility, left flexibility, and overall strength.

b.  Using the attached worksheet, predict the punter's hang time based upon distance, right strength, left strength, right flexibility, left flexibility, and overall strength.

Punter Worksheet
 
Problem 7:
Data on 102 male and 100 female athletes collected at the Australian Institute of Sport, courtesy of Richard Telford and Ross Cunningham.

a.  Using the attached worksheet, predict Percent Body Fat based upon Gender, Height, Weight, Lean Body Mass, Red Cell Count, White Cell Count,
Hematocrit, Hemoglobin, Plasma Ferritin Concentration, Body Mass Index, and Sum of Skin Folds.

b.  Using the attached worksheet, predict
Plasma Ferritin Concentration based upon Gender, Sport Played, Height, Weight, Lean Body Mass, Red Cell Count, White Cell Count, Hematocrit, Hemoglobin, Body Mass Index, Sum of Skin Folds, and Percent Body Fat.

Australian Institute of Sports Worksheet