Homework Help is Here – Start Your Trial Now!
Math
Statistics
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

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

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter1: Expressions And Functions
Section1.5: Descriptive Modeling And Accuracy
Problem 15PPS
See similar textbooks
icon
Related questions
Topic Video
Question
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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Means
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
SEE MORE TEXTBOOKS