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

[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 36 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 =