Question

In: Statistics and Probability

Consider the following data for two variables,  and . x 8 27 21 16 22 y 8...

Consider the following data for two variables,  and .

x 8 27 21 16 22
y 8 30 23 12 26

a. Develop an estimated regression equation for the data of the form y=b0+b1x . Comment on the adequacy of this equation for predicting . Enter negative value as negative number.

The regression equation is
Y=_______+_______ (to 2 decimals)
s= (to 3 decimals) R^2= % (to 1 decimal) R^2 adj= % (to 1 decimal)
Analysis of Variance
SOURCE DF SS
(to 2 decimals)
MS
(to 2 decimals)
F
(to 2 decimals)
-value
(to 4 decimals)
Regression
Residual Error
Total

Using a .05 significance level, the p-value indicates a - Select your answer -weak relationship strong relationship no relationship ; note that  (to 1 decimal) of the variability in  has been explained by .

b. Develop an estimated regression equation for the data of the form y=b0+b1x+b2x^2. Comment on the adequacy of this equation for predicting y . Enter negative value as negative number. If your answer is zero, enter "0".

The regression equation is
Y=______+_____x+______x^2 (to 2 decimals)
S= (to 3 decimals) R^2= % (to 1 decimal) R^2 adj= % (to 1 decimal)
Analysis of Variance
SOURCE DF SS
(to 3 decimals)
MS
(to 3 decimals)

(to 2 decimals)
-value
(to 4 decimals)
Regression
Residual Error
Total

At the .05 level of significance, the relationship - Select your answer -is/ is not significant; note that   (to 1 decimal) of the variability in  has been explained by .

c.Using the appropriate regression model, predict the value of y when x=17 .

(to 2 decimals)

Solutions

Expert Solution

a) Answer

The regression equation is
y = - 3.82 + 1.26 x

S = 2.967       R-Sq = 92.5%     R-Sq(adj) = 90.0%

Analysis of Variance

Source            DF          SS          MS         F        P
Regression         1      326.38      326.38     37.07    0.009
Residual Error     3       26.42        8.81
Total                   4      352.80

using 0.05 significance level, p-value indicates strong relationship

b) Answer

The regression equation is
y = 2.5 + 0.38 x + 0.0254 x2

S = 3.285       R-Sq = 93.9%     R-Sq(adj) = 87.8%

Analysis of Variance

Source            DF          SS          MS         F        P
Regression         2      331.22      165.61     15.35    0.061
Residual Error     2       21.58       10.79
Total              4      352.80

using 0.05 significance level, p-value indicates weak relationship.

Since model in a) represents strong relationship, hence using model in a) the value of y when x=17

is y= -3.82+ 1.26*17= 17.6


Related Solutions

Consider the following sample data: x 22 24 27 21 23 14 14 15 y 101...
Consider the following sample data: x 22 24 27 21 23 14 14 15 y 101 139 250 88 87 14 16 20 Data is in the spreadsheet. Use Excel's Regression tool in Data Analysis to find the sample regression equation for the model: y = β0 + β1x + ε. What is the coefficient for β0 ? (Enter your answer rounded to 2 decimal places. If you got 876.36905323 for your answer, you would type 876.37)
Consider the following data for two variables, x and y. x 22 24 26 30 35...
Consider the following data for two variables, x and y. x 22 24 26 30 35 40 y 13 20 34 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 α = 0.05. Find the value of the test...
Consider the following data for two variables, x and y. x 22 24 26 30 35...
Consider the following data for two variables, x and y. x 22 24 26 30 35 40 y 11 20 32 34 39 35 (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 α = 0.05. Find the value of...
Consider the following data for two variables, x and y. x 22 24 26 30 35...
Consider the following data for two variables, x and y. x 22 24 26 30 35 40 y 12 20 34 36 39 37 (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 α = 0.05. Find the value of the test...
Consider the following data for two variables, x and y.
  Consider the following data for two variables, x and y. x 22 24 26 30 35 40 y 11 20 33 34 39 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.)ŷ = −8.3+1.259x    (b) Use the results from part (a) to test for a significant relationship between x and y. Use α = 0.05. Find the...
Consider the following data for two variables, x and y.
Consider the following data for two variables, x and y. x   2 3 4 5 7 7 7 8 9 y 4 5 4 6 4 6 9 5 11 a. Does there appear to be a linear relationship between x and y? Explain.(f-test, to do f-test for the overall significance) b. Develop the estimated regression equation relating x and y. c. Plot the standardized residuals versus yˆ for the estimated regression equation developed in part (b). Do the model assumptions...
Consider the following data for two variables, x and y. x1 = 4 5 7 8...
Consider the following data for two variables, x and y. x1 = 4 5 7 8 10 12 12 22 y1 = 12 14 16 15 18 20 24 19 b. Compute the standardized residuals for these data (to 2 decimals, if necessary). Enter negative values as negative numbers. Observation 1 Observation 2 Observation 3 Observation 4 Observation 5 Observation 6 Observation 7 Observation 8 Do the data include any outliers? - Select your answer -Yes, there appear to be...
Consider the following sample data: x 21 22 25 28 24 y 15 22 26 28...
Consider the following sample data: x 21 22 25 28 24 y 15 22 26 28 29 a. Calculate the covariance between the variables. (Negative value should be indicated by a minus sign. Round your intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) b. Calculate the correlation coefficient. (Round your intermediate calculations to 4 decimal places and final answer to 2 decimal places.)
A statistical program is recommended. Consider the following data for two variables, x and y. x...
A statistical program is recommended. Consider the following data for two variables, x and y. x 22 24 26 30 35 40 y 12 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 α = 0.05....
A statistical program is recommended. Consider the following data for two variables, x and y. x...
A statistical program is recommended. Consider the following data for two variables, x and y. x 9 32 18 15 26 y 11 20 22 17 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT