Question

In: Statistics and Probability

A wildlife analyst gathered the data in the table to develop an equation to predict the...

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

Solutions

Expert Solution

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


Related Solutions

Develop a scatter diagram for these data. Develop the estimated regression equation.
Given the following: X: 1    2    3 4    5 Y: 3    7    5    11    14 Develop a scatter diagram for these data. Develop the estimated regression equation. Use the estimated regression equation to predict the value of Y when X = 4
Use the following data to develop a quadratic model to predict y from x. Develop a...
Use the following data to develop a quadratic model to predict y from x. Develop a simple regression model from the data and compare the results of the two models. Does the quadratic model seem to provide any better predictability? Why or why not? x y x y 15 229 15 247 9 74 8 82 6 29 5 21 21 456 10 94 17 320
14.1)use the following data to develop a quadratic model to predict y from x. develop a...
14.1)use the following data to develop a quadratic model to predict y from x. develop a simple regression model from the data and compare the results of the two models. Does the quadratic model seem to provide any better predictability? Why or why not ?       x       y         x       y 14 200 15 247 9 74 8 82 6 29 5 21 21 456 10 94 17 320 Answer:simple model: y^=   -14.27+27.128x, F=229.67 with p=.000, se=27.27, R2=.97,...
An analyst gathered the following data about stocks J. K. L which together form a value...
An analyst gathered the following data about stocks J. K. L which together form a value weighted index: December 31, Year 1 December 31, Year 2 Stock Price Shares outstanding Price Shares Outstanding J 50 10,000 $60 10,000 K 40 8,000 $30 16,000 L 50 12,000 $40 12,000 Calculate the ending value-weighted index (base index = 100), and briefly explain what it means. Provide your answer up to 2 decimal points.
Use the following data to develop a multiple regression model to predict from and . Discuss...
Use the following data to develop a multiple regression model to predict from and . Discuss the output, including comments about the overall strength of the model, the significance of the regression coefficients, and other indicators of model fit. y x1 x2 198 29 1.64 214 71 2.81 211 54 2.22 219 73 2.70 184 67 1.57 167 32 1.63 201 47 1.99 204 43 2.14 190 60 2.04 222 32 2.93 197 34 2.15 Appendix A Statistical Tables *(Round...
1. Obtain a linear regression equation for the data to predict the mean temperature values for...
1. Obtain a linear regression equation for the data to predict the mean temperature values for any given CO2 level. How good is the linear fit for this data? Explain using residual plot and R-square value. To draw residual plot, compute the estimated temperatures for every value of the CO2 level using the regression equation. Then compute the difference between observed (y) and estimated temperature values (called residual; ). Plot the residuals versus CO2 level (called a residual plot). 320.09...
Data was collected from 40 employees to develop a regression model to predict the employee’s annual...
Data was collected from 40 employees to develop a regression model to predict the employee’s annual salary using their years with the company (Years), their starting salary in thousands (Starting), and their Gender (Male = 0, Female = 1). The level of significance is .01. The results from Excel regression analysis are shown below: SUMMARY OUTPUT Regression Statistics Multiple R 0.718714957 R Square 0.516551189 Adjusted R Square 0.476263788 Standard Error 10615.63461 Observations 40 ANOVA Df SS MS F Significance F...
As an analyst, you have gathered the following information on a company you are tracking. The...
As an analyst, you have gathered the following information on a company you are tracking. The current dividend is $0.75. Dividends are expected to grow at a rate of 12% over the next three years, decline linearly to 4% over the next six years, and then remain at a long-term equilibrium growth rate of 4% in perpetuity. The required return is 9%. The value of the company is closest to:             a) $20.25. b) $23.2056 c) $78.25 d) $15.76 e)...
Data from a small bookstore are shown in the accompanying table. The manager wants to predict...
Data from a small bookstore are shown in the accompanying table. The manager wants to predict Sales from Number of Sales People Working. Complete parts a through h below. Number of ales peaople working sale (in $1000) 2 10 3 12 5 14 8 15 10 19 10 21 13 21 14 22 17 22 19 27 x(bar)= 10.1 y(bar)=18.3 SD(x)=5.74 SD(y)=5.33 A) find the slope etimate, b1. B) What does b1 mean, in thi context? C) Find the intercept,...
For the following data set: a) draw a scatter diagram, b) develop the estimation equation that...
For the following data set: a) draw a scatter diagram, b) develop the estimation equation that best describes the data, c) predict Y for X = 10, 15, 20. X 13 ,16 ,14 ,11 ,17 ,9 ,13 ,17 ,18, 12 Y 6.2 ,8.6 ,7.2 ,4.5 ,9.0 ,3.5 ,6.5 ,9.3 ,9.5, 5.7 Using the data given below, a) draw the scatterplot, b) develop the estimation equation that best describes the data, c) predict Y for X = 5, 6, 7. X...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT