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
Asked Dec 6, 2019
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

Expert Answer

Step 1

Enter the Given data in Excel as shown below

help_outline

Image Transcriptionclose

23 13 61 33 132 HEADLEN LENGTH CHEST WEIGHT 24 13 54 28 90 80 25 11 53 26 10 40 23 40 45 344 26 3 16.5 67.5 16 63 42 220 416 27 10 43 23 46 4 15.5 72 54 28 348 13.5 66.5 34 154 17 72 49 29 166 30 220 31 13 60.5 31 116 15.5 62 35 13 60 34.5 182 13 70 41 14.5 61 34 150 262 32 41 15 73.5 9.5 40 26 65 49 13.5 68.5 360 33 13.5 64 48 356 14.5 65 48 316 204 34 10 13.5 64 38 35 144 36 332 37 34 11 49 29 94 11 12.5 58 11.5 47 29.5 86 16 73 44 13 59 35 150 13 37 19 270 38 16.5 72 44.5 140 39 14 12.5 63 32 202 14 65 39 180 40 15 14 67 37 13.5 63 40 202 41 15.5 70.5 50 365 16 11.5 52 29 105 42 166 43 204 44 26 11.5 48 31 79 17 13 59 33 12 50 38 148 18 13.5 64 39 76.5 15.5 55 446 19 36 19 45 46 27 62 20 120 46 13 59 30 14.5 61.5 44 236 48 436 47 13.5 63.5 44 212 21 16 72 48 10 48 26 60 22 57.5 12.5 32 125 49 132 10 41 26 64 23 13 61 33 B. 9, 2.

fullscreen
Step 2

continue

help_outline

Image Transcriptionclose

A 48 10 48 26 60 49 10 41 26 64 50 11.5 53 30.5 114 51 11.5 52.5 28 76 52 11 46 23 48 53 10 43.5 24 29 54 15.5 75 54 514 32.8 55 12.5 57.3 140

fullscreen
Step 3

Steps to perform regression analysis in excel

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

help_outline

Image Transcriptionclose

Regression Input OK Input Y Range: SDS1:SD$55 Cancel Input X Range: SAS1:SCS55 Help | Labels M Confidence Level: Constant is Zero 95 Output options Output Range: SH$39:SS$56 New Worksheet Ply: O New Workbook Residuals | Residuals Standardized Residuals Residual Plots Line Fit Plots Normal Probability O Normal Probability Plots

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Math

Statistics

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Question 4

A: Null Hypothesis:There is no statistically significant difference in the proportions of women deliver...

question_answer

Q: Match the definitions or illustrations below to their correct terms. The stated level of risk the re...

A: Type I error (α):Type I error is defined as the probability of rejecting the null hypothesis when it...

question_answer

Q: 6.46. The joint density of X and Y is f(x, y) = c(x? – y²)e¯ 0<x < ∞, - x <y <a Find the conditional...

A: From the given information, the joint density function for X and Y is,

question_answer

Q: Please answer d, e, f

A: The degrees of freedom, df = n – 1 = 16 – 1 = 15d. To the right of 2.583,The p-value is obtained usi...

question_answer

Q: Find the equation of the regression line for the given data. Then construct a scatter plot of the da...

A: Regression:In order to obtain the least square regression line, first perform regression analysis on...

question_answer

Q: Listed below are prices in dollars for one night at different hotels in a certain region. Find the r...

A: Step-by-step procedure to obtain the range, variance, and standard deviation using Excel:In Excel sh...

question_answer

Q: Calculate the Pearson Correlation Coefficient for these two variables and b) test whether the correl...

A: The correlation coefficient for exam score y and hours of study x is calculated by using Excel and i...

question_answer

Q: A factory produces LED bulbs with an average lifespan of 50,000 hours and a standard deviation of 4,...

A: Given dataMean = 50000Standard deviation = 4000If it is known that a bulb already has lasted for 52,...

question_answer

Q: A clinical trial is run to assess the effects of different forms of regular exercise on HDL levels i...

A: The null and the alternative hypotheses used to find the significant difference in the mean HDL leve...