Question

In: Statistics and Probability

The following regression model has been proposed to predict sales at a computer store.                            Y=60-2X1+3

The following regression model has been proposed to predict sales at a computer store.

                           Y=60-2X1+30X2+10X3

                           Where

                           X1= competitor’s previous day’s sales (in $1,000s)

                           X2=population within 1 mile (in 1,000s)

                           X3= 1 if radio advertising was used; 0 if otherwise

  1. What is the estimated regression equation if no radio advertising was used?
  1. What is the estimated regression equation if radio advertising was used?
  1. What is the expected amount of sales attributable to radio advertising?

                           Y= Sales (in $1,000s)

Solutions

Expert Solution

The following regression model has been proposed to predict sales at a computer store.

                           Y=60-2X1+30X2+10X3

                           Where

                           X1= competitor’s previous day’s sales (in $1,000s)

                           X2=population within 1 mile (in 1,000s)

                           X3= 1 if radio advertising was used; 0 if otherwise

a)What is the estimated regression equation if no radio advertising was used?

X3= 1 if radio advertising was used; 0 if otherwise

Here it is absent, so x3 = 0

Y=60-2X1+30X2+10X3

Y=60-2X1+30X2+10*0

Y=60-2X1+30X2

The estimated regression equation if no radio advertising was used:-  Y=60-2X1+30X2

b)  

What is the estimated regression equation if radio advertising was used?

Here it is present , so x3 = 1

Y=60-2X1+30X2+10X3

Y=60-2X1+30X2+10*1

Y=60-2X1+30X2+10

Y=70-2X1+30X2

The estimated regression equation if radio advertising was used:- Y=70-2X1+30X2

c) What is the expected amount of sales attributable to radio advertising?

The coefficient of radio advertising is 10

So we may conclude that the expected amount of sales attributed to radio advertising is 10.

But Y= Sales (in $1,000s)

So $ 1,000 * 10 = $10000

Answer:-The expected amount of sales attributable to radio advertising $ 10,000.


Related Solutions

1. Management of a fast-food chain proposed the following regression model to predict sales at outlets:...
1. Management of a fast-food chain proposed the following regression model to predict sales at outlets: y = β0 + β1x1 + β2x2 + β3x3 + ε, where y = sales ($1000s) x1 = number of competitors within one mile x2 = population (in 1000s) within one mile x3 is 1 if a drive-up window is present, 0 otherwise Multiple regression analysis was performed on a random sample of data collected from 25 outlets. Given the following portion of an...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three independent variables. The three independent variables are price per unit (Price in $100s), advertising (ADV in $1,000s) and the number of product lines (Lines). Part of the regression results is shown below. Coefficient Standard Error Intercept 1.0211 22.8752 Price -0.1524 0.1411 ADV 0.8849 0.2886 Lines -0.1463 1.5340 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Regression 2708.61 Error (Residuals) Required:...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three...
A computer manufacturer has developed a regression model relating his sales (Y in $10,000s) with three independent variables. The three independent variables are price per unit (Price in $100s), advertising (ADV in $1,000s) and the number of product lines (Lines). Part of the regression results is shown below. Coefficient Standard Error Intercept 1.0211 22.8752 Price -0.1524 0.1411 ADV 0.8849 0.2886 Lines -0.1463 1.5340 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Regression 2708.61 Error (Residuals) Required:...
The following Regression function has been developed to check the relationship between Y- ‘Sales’ and the...
The following Regression function has been developed to check the relationship between Y- ‘Sales’ and the following independent variables; X1- Time (Length of time employed in months) X2 –Poten (Market potential) X3 – AdvExp (Advertising expenditure in the sales territory) X4 – Accounts (Number of accounts assigned to sales rep) 3 Consider the following Minitab output and answer the questions. Regression Analysis: Sales versus Time, Poten, AdvExp, Accounts Regression Equation Sales = -391 - 0.58 Time + 0.02227 Poten +...
A multivariate logistic regression model has been built to predict the propensity of shoppers to perform...
A multivariate logistic regression model has been built to predict the propensity of shoppers to perform a repeat purchase of a free gift that they are given. The descriptive features used by the model are the age of the customer, the socio-economic band to which the customer belongs (a, b, or c), the average amount of money the customer spends on each visit to the shop, and the average number of visits the customer makes to the shop per week....
The following linear regression model can be used to predict ticket sales at a popular water...
The following linear regression model can be used to predict ticket sales at a popular water park (the correlation is significant). Ticket sales per hour = -631.25 + 11.25(current temperature in °F) Choose the statement that best reflects the meaning of the slope in this context. Group of answer choices The slope is slippery. The slope tells us that a one degree increase in temperature is associated with an average increase in ticket sales of 11.25 tickets. The slope tells...
1) A multiple regression model to predict nacho sales at a baseball game yields the following...
1) A multiple regression model to predict nacho sales at a baseball game yields the following coefficients: Intercept 1500 Home Team Score 80 Temp. (Degrees F) 100 Home Team Loss? -2000 Assuming that all variables in this model are significant, what would be the expected result of the home team scoring another run? A- There would be no effect B- Nacho sales would increase by 80 C- Nacho sales would decrease by 80 D- Not enough info 2) The regression...
Question 4 A simple linear regression model was used in order to predict y, duration of...
Question 4 A simple linear regression model was used in order to predict y, duration of relief from allergy, from x, dosage of medication. A total of n=10 subjects were given varying doses, and their recovery times noted. Here is the R output. summary(lmod4) ## ## Call: ## lm(formula = y ~ x) ## ## Residuals: ##     Min      1Q Median      3Q     Max ## -3.6180 -1.9901 -0.4798 2.2048 3.7385 ## ## Coefficients: ##             Estimate Std. Error t value Pr(>|t|)    ## (Intercept)...
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...
The estimated regression equation for a model involving two independent variables and 60 observations is: y...
The estimated regression equation for a model involving two independent variables and 60 observations is: y ̂ = 30.17 - 2.5X1 + 0.428X2 Other statistics produced for analysis include: SSR = 1160.6, SST = 2183.4, Sb1 = 0.13, Sb2 = 0.20. Interpret b1 and b2 in this estimated regression equation Predict y when X1 = 50 and X2 = 60. Compute R-square and Adjusted R-Square. Comment on the goodness of fit of the model. Perform a “t” test using the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT