Page 1 of 1
Consider the following data: SALES₁ ADV; 3 4 6 5 7 6 5 9 10 9 1 2 3 4 5 6 7 8 9 10 ∞ In Excel's regression, Y is the dep
Posted: Fri Jul 01, 2022 7:55 am
by answerhappygod
- Consider The Following Data Sales Adv 3 4 6 5 7 6 5 9 10 9 1 2 3 4 5 6 7 8 9 10 In Excel S Regression Y Is The Dep 1 (61.04 KiB) Viewed 37 times
Consider the following data: SALES₁ ADV; 3 4 6 5 7 6 5 9 10 9 1 2 3 4 5 6 7 8 9 10 ∞ In Excel's regression, Y is the dependent variable and X is the independent variable. For this exercise, Y = Sales and X = Advertising. 1. Input this data on a spreadsheet. Using the regression option, generate regression predictions. Write your results as an estimated regression equation, as shown in my lecture notes. In particular, Equation: (a) Write the regression equation, with estimated coefficients, (b) Below the regression equation, list in parentheses the t-values of the coefficient estimates (c) To the right of the estimated equation write R¹ = Y = t-values () () R =