# Learning Goal: I’m working on a data analytics exercise and need a sample draft

Learning Goal: I’m working on a data analytics exercise and need a sample draft to help me learn.Question 1In a regression analysis involving 30 observations, the following estimated regression equation was obtained:(hat{y}\)=17.6+3.8×1−2.3×2+7.6×3+2.7x4A. Interpret b1, b2, b3, and b4 in this estimated regression equation.B. Predict y when x1=10, x2=5, x3=1, and x4=2.Upload your answers in an Excel file. Question 2The estimated regression equation for a model involving two independent variables and 10 observations follows:(hat{y}\)=29.1270+0.5906×1+0.4980x2The values of SSTSST=6724.125 and SSR=6216.375.A. Find SSE.B. Compute R2.C. Compute R a 2.D. Comment on the goodness of fit.Upload your answers in an Excel file. Question 3The estimated regression equation for a model involving two independent variables and 10 observations follows:(hat{y}\)=29.1270+0.5906×1+0.4980x2Here, SST=6724.125SSR=6216.375sb1=0.0813sb2=0.0567A. Compute MSR and MSE.B. Compute Fand perform the appropriate F test. Use α=0.05α=0.05.C. Perform a t test for the significance of β1. Use α=0.05.D. Perform a t test for the significance of β2. Use α=0.05.Submit your answers in an Excel fileQuestion 4The estimated regression equation for a model involving two independent variables and 10 observations follows:(hat{y}\)=29.1270+0.5906×1+0.4980x2A. Develop a point estimate of the mean value of y when x1=180 and x2=310.B. Develop a point estimate for an individual value of y when x1=180 and x2=310.Upload your answers in an Excel file. Question 5Ultimately, who/what decides if the sign of a coefficient is the correct one?Textbook ReadingsAnderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., & Cochran, J. J. (2020). Essentials of statistics for business and economics (9th ed.). Stamford, CT: Cengage.Chapter 15: Multiple Regression, Sections 15.1–15.6
Appendix 15.2: Multiple Regression with Excel
Videos (2)Note: The videos linked in this course will not play in the Canvas system. Clicking on the text links will take you to YouTube to watch the video.Recommended VideosOptional VideosStatistics 101: Multiple Regression, The Very Basics (Links to an external site.)Operations Management 101: Time-Series Forecasting Introduction (Links to an external site.)
Requirements: 150-200 words