Details of this Paper

ECON 3305 Problem Set Assignment - Simple and Multiple Regression Analyses




Question;ECON 3305 Problem Set: Simple and Multiple Regression AnalysesConsider the following data:SALESi34657659109ADVi12345678910In 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,(a) Write the regression equation, with estimated coefficients,(b) Below the regression equation, list in parentheses the t-values of the coefficient estimates2(c) To the right of the estimated equation write R =^Equation: ____Y_=___________________________________t-values()()R =2. Multivariate Regression. Now add to your above regression in a price variable, with values:8, 7.5, 7.25, 7.25, 6, 6.75, 6, 5, 4.4, 5.2. Estimate the new multiple regression equation (now we have 2 independent variables). Print regression results. Write out the estimated demand equation, as in 1 above.Equation: ____Y_=___________________________________t-values ()()()R2 =3. Evaluating regression results: A Descriptive Statistic. With the data you generated in (2) abovedo the following.2 a. Interpret the R. (In a sentence)b. At an approximate 95% level of confidence, can you conclude that price affects sales? Inother words, is the estimated coefficient of PRICE statistically significant at the 5% level?ExplainDoes Price affect Sales? Y/N (circle one)


Paper#56299 | Written in 18-Jul-2015

Price : $25