from excel: data-data analysis: regression
a)
y^ =8.61+0.470x
b)
y^ =-12.94+2.930x-0.0593x2
c)
predicted value =-12.94+2.930*20-0.0593*(20^2)=21.94 (please try 21.92 if this comes wrong)
Consider the following data for two variables, x and y. (a) Develop an estimated regression equation...
A statistical program is recommended. Consider the following data for two variables, x and y. x 9 32 18 15 26 y 11 19 20 16 22 (a) Develop an estimated regression equation for the data of the form ŷ = b0 + b1x. (Round b0 to two decimal places and b1 to three decimal places.) ŷ = Comment on the adequacy of this equation for predicting y. (Use α = 0.05.) The high p-value and low coefficient of determination...
A statistical program is recommended. Consider the following data for two variables, x and y. x 22 24 26 30 35 40 y 13 20 33 35 40 36 (a) Develop an estimated regression equation for the data of the form ŷ = b0 + b1x. (Round b0 to one decimal place and b1 to three decimal places.) ŷ = (b) Use the results from part (a) to test for a significant relationship between x and y. Use α =...
course NGAGE MINDTAP z and y. z | 10 220 11 24 12 30 21 18 27 equation for the data of the form bo + b z. Comment on the adequacy of this equation for predicting p. Enter negative value as negative number. x (to 2 decimals) R-sq adj (to 1 decimal) (to 1 decimal) Analysis of Variance SOURCE OF MS F-value (to 2 Residual Error Total |%(to 1 decimal) of the variability in y has been explained byz,...
eBook Video Consider the following data for a dependent variable y and two independent variables, i and 99 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to 21. ý= Predict y if zı = 35. b. Develop an estimated regression equation relating y to 22. + Predict y if Zz = 25. y= c. Develop an estimated regression equation relating y to %1 and...
Consider the following data for a dependent variable y and two independent variables, 21 and 22. 21 22 30 12 95 47 11 108 25 18 113 51 16 178 40 5 94 52 20 176 74 7 171 36 12 118 59 13 142 77 16 211 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to @i. + 31 Predict y if *1...
The following estimated regression equation relating sales to inventory investment and advertising expenditures was given. ý = 24 + 14x + 7x2 The data used to develop the model came from a survey of 10 stores; for those data, SST = 18,000 and SSR = 12,780. (a) For the estimated regression equation given, compute RS R2 = (b) Compute R, (Round your answer to two decimal places.) (c) Does the model appear to explain a large amount of variability in...
Find the estimated value of y when x=34 this data, consider the equation of the regression line, y bo + bj, for predicting the number of bids an item will receive based on the in practice, it Price in Dollars 22 25 27 34 38 Number of Bids 2 3 5 6 8 Table Step 3 of 6: Find the
The data shown below for the dependent variable, y, and the independent variable, x, have been collected using simple random sampling. X 10 15 11 19 18 17 5 17 18 y 9070 30 8020 30 5060 40 40 a. Develop a simple linear regression equation for these data. b. Calculate the sum of squared residuals, the total sum of squares, and the coefficient of determination c. Calculate the standard error of the estimate. d. Calculate the standard error for...
Consider the following data for a dependent variable y and two independent variables, 11 and 12. 175 117 142 211 3 142 211 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to 1. = Predict y if x1 = 35. y = b. Develop an estimated regression equation relating y to 22. Predict y if 22 = 15. c. Develop an estimated regression equation...
Consider the following data for a dependent variable y and two independent variables, *1 and 29. Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating y to 21. Predict y if 21 = 45. b. Develop an estimated regression equation relating y to 29. Predict y if t = 15 c. Develop an estimated regression equation relating y to 1 and 29 02 Predict y if...