Question

Run a regression analysis in Excel using the following data. The dependent variable is Y: X...

Run a regression analysis in Excel using the following data. The dependent variable is Y:

X Y
2 19
4 43
6 55
8 73
10 110

What is the value for the regression sum of squares? Round your answer to 1 decimal place.

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1


0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Run a regression analysis in Excel using the following data. The dependent variable is Y: X...
Run a regression analysis in Excel using the following data. The dependent variable is Y: X 2 4 6 8 10 Y 19 43 55 73 110 What is the value for the regression sum of squares? Round your answer to 1 decimal place.
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 39947.80 Residual (Error) 10 8280.81 Total 11 48228.61 Coefficients Standard Error t Stat P-value Intercept 69.190 26.934 2.569 0.02795 X 2.441 0.351 6.946 0.00004 1.   What is the estimated regression equation that relates Y to X? 2.   Is the regression relationship significant? Use the p-value approach and alpha = 0.05 to answer this question. 3.   What is the...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 3348.312 Residual 8 9529.811 Total 9 12878.123 Coefficients Standard Error t Stat P-value Intercept 247.56 83.280 1.689 0.030 X 148.62 38.312 1.283 0.075 1. What is the estimated regression equation that relates y to x? (2 Points) 2. Is the regression relationship significant? Use a p-value and alpha = 0.05. (2 Points) 3. What is...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...
Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 39947.80 Residual (Error) 10 8280.81 Total 11 48228.61 Coefficients Standard Error t Stat P-value Intercept 69.190 26.934 2.569 0.02795 X 2.441 0.351 6.946 0.00004 1.   What is the estimated regression equation that relates Y to X? (2 Points) 2.   Is the regression relationship significant? Use the p-value approach and alpha = 0.05 to answer this...
Use these data for Questions 5 and 6. Conduct a regression analysis in Excel using the...
Use these data for Questions 5 and 6. Conduct a regression analysis in Excel using the following data: X Y 12 40 23 50 40 59 33 58 18 45 What is the value of b0? Include 1 decimal place in your answer. What is the value of b1? Include 2 decimal places in your answer.
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data with y as the response variable. x y 28.8 90.1 30.6 139.6 12.6 42.2 18.1 94.8 13.9 28.5 31.9 102.4 -3.9 -13.4 16.7 57.1 11 55.8 16.8 76.3 31.7 80.1 43.5 123.8 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a percentage...
A regression and correlation analysis resulted in the following information regarding a dependent variable (y) and...
A regression and correlation analysis resulted in the following information regarding a dependent variable (y) and an independent variable (x). Σx = 90 Σ(y - )(x - ) = 466 Σy = 170 Σ(x - )2 = 234 n = 10 Σ(y - )2 = 1434 SSE = 505.98 ​ The least squares estimate of the intercept or b0 equals Question 18 options: a) -1.991. b) .923. c) -.923. d) 1.991.
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data with y as the response variable. x y 48 41.8 39.2 67.4 34.7 68.4 42.9 50.2 49 50.6 45.6 57 58.7 29.7 40.5 68.4 47.4 34.7 45.7 50.9 38.9 47.7 40.9 53.6 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a percentage...
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data with y as the response variable. x y 81.1 86 77.5 60.4 92.7 126.5 104 132.5 85 53.1 64.3 95.5 64.6 31.7 39.7 5.7 82.3 121.3 82.4 98.2 29.2 -50.2 34.2 -1 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a percentage...
Run a regression analysis on the following bivariate set of data with y as the response...
Run a regression analysis on the following bivariate set of data with y as the response variable. x y 51.3 17.4 60.8 88.6 37.4 32.9 44.6 53.4 53.7 53.6 52.2 41.5 32.7 28.6 62.4 84.7 47.4 35.7 39.8 33.7 62.1 123 62 83.7 Find the correlation coefficient and report it accurate to three decimal places. r = _______ What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT