Math

StatisticsQ&A LibraryFor 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.8140Question

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 |

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...

Tagged in

Find answers to questions asked by student like you

Show more Q&A

Q: Question 4

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

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...

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,

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...

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...

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...

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...

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,...

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...