Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help Question 17 Problem 3. Part of an Excel output relating x (independent variable, which is the price of the product) and y (dependent

image text in transcribedimage text in transcribedimage text in transcribed

please help

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Question 17 Problem 3. Part of an Excel output relating x (independent variable, which is the price of the product) and y (dependent variable, which is the sales of the product) is shown below. Some of the blanks are marked with "?". We also calculated the value E(x; - I) = 0.7, and I = 3.5. Please answer questions (Question 3.1. to 3.20) regarding problem 3. SUMMARY OUTPUT Regression Statistics Multiple R R Square Standard Error 1.119948978 Observations 7 ANOVA df SS MS F Significance F Regression 37.15714286 ? Residual 6.271428571 ? Total 43.42857143 Coefficients Standard Error t Stat P-value Intercept 29.78571429 4.704166629 ? Price (x) -7.28571429 ? Question 3.1. What is the coefficient of determination (r- )?Question 18 Question 3.2. What is the correlation coefficient Try? Question 19 Question 3.3. What is the Mean Square Error (MSE or s?)? Question 20 Question 3.4. What is the degree of freedom for SSR? Question 21 Question 3.5. What is the degree of freedom for SSE? Question 22 Question 3.6. What is the standard error of the t test for significance (so, )?Question 23 Question 3.7. What is the t test statistic for significance? Question 24 Question 3.8. What is the p-value of the t test? Question 25 Question 3.9. What is the F test statistic for significance? Question 26 Question 3.10. What is the p-value of the F test (two-tailed)? Question 27 Question 3.11. Based on either test, what is your conclusion on 0.05 level of significance? O Reject the Null Hypothesis O Fail to reject the Null hypothesis.Question 28 Question 3.12. For price I* = 3, what is the point estimation of the sales y*? Question 29 Question 3.13. For confidence interval estimation for the average sales of y with price * = 3 and confidence level of 95%, what is the standard error sy? Question 30 Question 3.14. For confidence interval estimation for the average sales of y with price r* = 3 and confidence level of 95%, what is the margin of error? Question 31 Question 3.15. For confidence interval estimation for the average sales of y with price x* = 3 and confidence level of 95%, what is the upper bound? D Question 32 Question 3.16. For confidence interval estimation for the average sales of y with price r* = 3 and confidence level of 95%, what is the lower bound?Question 33 Question 3.17. For prediction interval estimation for the sales of y with price a* = 3 and confidence level of 95%, what is the standard error S pred? Question 34 Question 3.18. For prediction interval estimation for the sales of y with price * = 3 and confidence level of 95%, what is the margin of error? Question 35 Question 3.19. For prediction interval estimation for the sales of y with price * = 3 and confidence level of 95%, what is the upper bound? Question 36 Question 3.20. For prediction interval estimation for the sales of y with price * = 3 and confidence level of 95%, what is the lower bound

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction To Categorical Data Analysis

Authors: Alan Agresti

2nd Edition

0470653205, 9780470653203

More Books

Students also viewed these Mathematics questions

Question

What database technology options might the firm elect to use?

Answered: 1 week ago

Question

How did the plague contribute to the Renaissance?

Answered: 1 week ago