#### Description of this paper

##### ECON 3305 Problem Set: Simple and Multiple Regression Analyses-Consider the following data:..

Description

solution

Question

Question;ECON 3305 Problem Set: Simple and Multiple Regression AnalysesFor detailed ques refer attachmentConsider the following data:SALESi34657659109ADVi12345678910In Excel?s regression, Y is the dependent variable and X is the independent variable. Forthis exercise, Y = Sales and X = Advertising.1. Input this data on a spreadsheet. Using the regression option, generate regressionpredictions. Write your results as an estimated regression equation, as shown in my lecturenotes. 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()()2R =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 (nowwe have 2 independent variables). Print regression results. Write out the estimated demandequation, 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.2a. 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)Reason

Paper#55408 | Written in 18-Jul-2015

Price : \$37