In: Statistics and Probability
A wildlife analyst gathered the data in the table to develop an equation to predict the weights of bears. He used WEIGHT as the dependent variable and CHEST, LENGTH, and SEX as the independent variables. For SEX, he used male=1 and female=2. Using Microsoft Excel, perform a regression analysis and find R-squared, adjusted R-squared, and the p-value for the regression. y=dependent x=independent
Weight | Chest | Length | Sex |
344 | 45 | 67.5 | 1 |
416 | 54 | 72 | 1 |
220 | 41 | 70 | 2 |
360 | 49 | 68.5 | 1 |
332 | 44 | 73 | 1 |
140 | 32 | 63 | 2 |
436 | 48 | 72 | 1 |
132 | 33 | 61 | 2 |
356 | 48 | 64 | 2 |
150 | 35 | 59 | 1 |
202 | 40 | 63 | 2 |
365 | 50 | 70.5 | 1 |
Regression equation: y = -442.60+12.13X1+3.58X2-23.84X3
R-squared = 0.93
adjusted R-squared = 0.90
and the p-value (Significance F) = 0.000066