Question

In: Statistics and Probability

The following is part of the results of a regression analysis involving sales (Y in millions...

  1. The following is part of the results of a regression analysis involving sales (Y in millions of dollars), advertising expenditures (X1 in thousands of dollars), and number of salespeople (X2) for a corporation. The regression was performed on a sample of 10 observations.

                                    Coefficient         Standard Error        t value             p value

            Constant            -11.340                   20.412

                 X1                      0.798                     0.332                2.404               0.0345

                 X2                      0.141                     0.278                0.507               0.2305

a.   Write the regression equation.

            b.   Interpret the coefficients of the estimated regression equation found in Part (a).

c.   At a =0.05, test for the significance of the coefficient of advertising.

            d.   At a =0.05, test for the significance of the coefficient of number of salespeople.

            e.   If the company uses $50,000 in advertisement and has 800 salespersons, what are the expected sales? Give your answer in dollars.

Solutions

Expert Solution


Related Solutions

Given The following results from LINEAR REGRESSION Analysis for the variables X and Y Slope= 12.7...
Given The following results from LINEAR REGRESSION Analysis for the variables X and Y Slope= 12.7 y-intercept =3.2 n=10 SE=4.3 The equation of the regression line is …… and 95% confidence interval for the slope is…. (A)Y=3.2+12.7X, and (3.675,12.768) (B)Y=12.7+3.2X, and (2.784,12.745) (C)Y=3.2+12.7X, and (2.784,22.616)
The following table contains results from the regression of sales price (y) on lot size (x1),...
The following table contains results from the regression of sales price (y) on lot size (x1), number of bedrooms (x2), number of bathrooms(x3) and number of storeys (x4). Sales price is the dependent variable and x1,x2,x3,x4 are independent variables. R2 = 0.54 F= stat = 48.3235 p value and F - stat of 1.18E - 88 n > 30. a. Write down the least square prediction equation b.use R2 to check the validity of the model. c use " t-stat"...
In a regression analysis involving 30 observations, the following estimated regression equation was obtained. ŷ =...
In a regression analysis involving 30 observations, the following estimated regression equation was obtained. ŷ = 17.6 + 3.2x1 − 2.2x2 + 7.6x3 + 2.7x4 1. Interpret b1 in this estimated regression equation. (choose an option) a)b1 = −2.2 is an estimate of the change in y corresponding to a 1 unit change in x1 when x2, x3, and x4 are held constant. b)b1 = 7.6 is an estimate of the change in y corresponding to a 1 unit change...
Shown below is a portion of the computer output for a regression analysis relating sales (Y...
Shown below is a portion of the computer output for a regression analysis relating sales (Y in millions of dollars) and advertising expenditure (X in thousands of dollars). Predictor Coefficient Standard Error Constant 4.00 0.800 X -0.12 0.045          Analysis of Variance SOURCE DF SS Regression 1 1,400 Error 18 3,600 Please answer the following questions with showing all the steps needed.      a.  (8’) What has been the sample size for the above? Please explain how you obtain the answer using the...
What are the SAS Coding and SAS Results for a multiple regression analysis of the following...
What are the SAS Coding and SAS Results for a multiple regression analysis of the following data, where the price of the house is the dependent variable? House Price Living Area Bathrooms Bedrooms 97739 1276 2 2 97783 1061 1 3 98423 1355 1 3 99045 937 1 2 99082 924 1 2
In a regression model involving 64 observations, the following estimated regression equation was obtained: Y=29+18X1+43X2+877X3 For...
In a regression model involving 64 observations, the following estimated regression equation was obtained: Y=29+18X1+43X2+877X3 For this model SSR=700 and SSE=500 Required: a. Calculate the coefficient of determination for the above model. b. Calculate the correlation coefficient. c- Calculate the MSR. d. Calculate the computed F statistics for testing the significance of the above model.
a) Run a regression analysis on the following bivariate set of data with y as the...
a) Run a regression analysis on the following bivariate set of data with y as the response variable. x y 10.7 81.6 13.7 81.5 36.7 56.5 4 72.1 50.7 23.2 47.6 -4.8 37.3 31.9 24.3 75.2 21.5 59.3 17.2 54.6 23.6 75.5 22.2 60.8 29.3 51 14 63.4 0.2 102.7 30.7 48.2 10.3 74.8 26.5 48.2 23.1 87 Verify that the correlation is significant at an ?=0.05?=0.05. If the correlation is indeed significant, predict what value (on average) for the...
A Regression analysis was applied between sales data (y in $1000s) and advertising expenditure (x in...
A Regression analysis was applied between sales data (y in $1000s) and advertising expenditure (x in $100s) and the estimated regression equation is obtained as ŷ = 12 + 1.8 x. Suppose SST=300, SSE=75, sb1 =0.2683 and ?=17 a) Carry out a t-test to see whether the advertising expenditure is significant. Use α = 0.05 and critical value approach to draw your conclusion. Make sure to show all your steps. b) Carry out an F-test to see whether the advertising...
) Consider the following regression results based on 30 observations. y = 238.33 – 0.95x1 +...
) Consider the following regression results based on 30 observations. y = 238.33 – 0.95x1 + 7.13x2 + 4.76x3; SSE = 3,439 y = 209.56 – 1.03x1 + 5.24(x2 + x3); SSE = 3,559 a. Formulate the hypotheses to determine whether the influences of x2 and x3 differ in explaining y. b. Calculate the value of the test statistic. c. At the 5% significance level, find the critical value(s). d. What is your conclusion to the test?
The following is part of regression output produced by Excel ( for Y vs X1 and...
The following is part of regression output produced by Excel ( for Y vs X1 and X2): Y 12.9 6.1 1.1 39.7 3.4 5.9 8.9 15 7.3 X1 0.9 0.8 1.0 0.3 0.4 0.7 0.71 0.5 0.9 X2 4.2 3.1 1.2 15.7 2.5 0.7 5.0 6.4 3.0 A) write out the estimated regression equation showing that depends on X1 and X2. b)if. X1=0.58 and X2=7.0, what is the value predicted for y c)write the number which is the standard error...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT