# For reasons of safety, a study of bears involved the collection of various measurements that were taken after the bears were anesthetized. When obtaining measurements from an anesthetized bear in the wild, it is relatively easy to use a tape measure to obtain the size of the chest, the length of the head, and the total length of the bear. It is difficult to find the weight because the bear must be lifted! Instead of actually weighing the bear, an estimate of the bears weight can be obtained from other measurements that were obtained. Use the data provided in cells E1 to H55 to answer the following questions. Head Length (HEADLEN) data is in cells E1 to E55. Length data is in cells F1 to F55. Chest size data is in cells G1 to G55. Weight data is in cells H1 to H55. All data sets have labels in first row. Develop the estimated regression equation that can be used to predict a bear's weight based on head length (HEADLEN), Length, and chest size.  Place output in cell I1Is the joint  relationship significant using alpha .05?Are all the independent variables significant? why or why not?Interpret the coefficient for Head LengthIs the model a good fit? Why or why not?HEADLENLENGTHCHESTWEIGHT1153268016.567.54534415.5725441617724934815.562351661370412201573.54126213.568.54936013.5643820412.55831144167344332937193412.5633214014673718011.5522910513593316613.56439204936192613593012016724843612.557.53212513613313213542890104023401663422201043234613.566.5341541360.531116136034.518214.561341509.540266513.5644835614.565483161149299411.54729.58613593515016.57244.527014653920213.5634020215.570.55036511.548317912503814815.576.555446946276214.561.54423613.563.544212104826601041266411.55330.511411.552.52876114623481043.5242915.5755451412.557.332.8140

Question
145 views
 For reasons of safety, a study of bears involved the collection of various measurements that were taken after the bears were anesthetized. When obtaining measurements from an anesthetized bear in the wild, it is relatively easy to use a tape measure to obtain the size of the chest, the length of the head, and the total length of the bear. It is difficult to find the weight because the bear must be lifted! Instead of actually weighing the bear, an estimate of the bears weight can be obtained from other measurements that were obtained. Use the data provided in cells E1 to H55 to answer the following questions. Head Length (HEADLEN) data is in cells E1 to E55. Length data is in cells F1 to F55. Chest size data is in cells G1 to G55. Weight data is in cells H1 to H55. All data sets have labels in first row. Develop the estimated regression equation that can be used to predict a bear's weight based on head length (HEADLEN), Length, and chest size.  Place output in cell I1 Is the joint  relationship significant using alpha .05? Are all the independent variables significant? why or why not? Interpret the coefficient for Head Length Is the model a good fit? Why or why not?
 HEADLEN LENGTH CHEST WEIGHT 11 53 26 80 16.5 67.5 45 344 15.5 72 54 416 17 72 49 348 15.5 62 35 166 13 70 41 220 15 73.5 41 262 13.5 68.5 49 360 13.5 64 38 204 12.5 58 31 144 16 73 44 332 9 37 19 34 12.5 63 32 140 14 67 37 180 11.5 52 29 105 13 59 33 166 13.5 64 39 204 9 36 19 26 13 59 30 120 16 72 48 436 12.5 57.5 32 125 13 61 33 132 13 54 28 90 10 40 23 40 16 63 42 220 10 43 23 46 13.5 66.5 34 154 13 60.5 31 116 13 60 34.5 182 14.5 61 34 150 9.5 40 26 65 13.5 64 48 356 14.5 65 48 316 11 49 29 94 11.5 47 29.5 86 13 59 35 150 16.5 72 44.5 270 14 65 39 202 13.5 63 40 202 15.5 70.5 50 365 11.5 48 31 79 12 50 38 148 15.5 76.5 55 446 9 46 27 62 14.5 61.5 44 236 13.5 63.5 44 212 10 48 26 60 10 41 26 64 11.5 53 30.5 114 11.5 52.5 28 76 11 46 23 48 10 43.5 24 29 15.5 75 54 514 12.5 57.3 32.8 140
check_circle

Step 1

Enter the Given data in Excel as shown below

Step 2

continue

Step 3

Steps to perform regression analysis in excel

Go to data-> Data Analysis-> S...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in