Question

In: Statistics and Probability

Given the estimated regression equation results for the sale of energy bars (a food item). It...

Given the estimated regression equation results for the sale of energy bars (a food item). It is expected that sales of the bars varies depending on which quarter of the year it is.

SALES = 6837 – 532 (PRICE) + 62 (ORGANIC) + 27 Q2 + 35 Q3 – 21 Q4

SALES = number of individual energy bars (not dollars) sold per month

PRICE = price of bars in dollars

ORGANIC = dummy variable: 1 if organic, 0 if not organic

Q2 = dummy variable (second quarter: April, May, June)

Q3 = dummy variable (third quarter: July, August, September)

Q4 = dummy variable (fourth quarter: October, November, December )

(3 pts.) Interpret the coefficient on the PRICE variable.

(3 pts.) Interpret the coefficient on the Q4 dummy variable. (Be as specific as possible)

(3 pts.) Calculate (with a calculator) what SALES would be (how many bars would we sell) if PRICE was $1.50, they are NOT ORGANIC, and we are in the third quarter of the year. SHOW YOUR WORK.

(2 pts.) What changes to this regression would you make (if any) if the p-value on the coefficient of the ORGANIC dummy variable were 0.36? EXPLAIN.

Solutions

Expert Solution

ANSWER::

(a)

Interpret the coefficient on the PRICE variable.?

Ans:: For every additional increase in price, sales will decrease by 532.

(b)

Interpret the coefficient on the Q4 dummy variable. (Be as specific as possible)?

Ans:: When the food is purchased in the fourth quarter, sales will decrease by 21.

(c)

Calculate (with a calculator) what SALES would be (how many bars would we sell) if PRICE was $1.50, they are NOT ORGANIC, and we are in the third quarter of the year. ?

Ans: Sales = 6837 - 532*1.50 +62*0 +35*3 = 6144

(d)

What changes to this regression would you make (if any) if the p-value on the coefficient of the ORGANIC dummy variable were 0.36?

Ans:: The variable would be omitted because the variable is not significnat.

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...

***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU


Related Solutions

Explain the differences between the regression model, the regression equation, and the estimated-regression equation. Discuss the...
Explain the differences between the regression model, the regression equation, and the estimated-regression equation. Discuss the application of regression analysis in business decision making. Give examples on how the regression analysis can be used in business.
Given are five observations for two variables, x and y. The estimated regression equation for these...
Given are five observations for two variables, x and y. The estimated regression equation for these data is y = 1 + 2.4x (A) Compute SSE, SST, and SSR (B) Compute the coefficient of determination, R^2. (C) Compute the sample correlation coefficient. x y 1 3 2 8 3 5 4 12 5 13
The estimated regression equation for these data is ŷ = 70 − 3x.
Consider the data. xi 3 12 6 20 14 yi 55 35 60 10 25 The estimated regression equation for these data is ŷ = 70 − 3x. (a) Compute SSE, SST, and SSR using equations SSE = Σ(yi − ŷi)2, SST = Σ(yi − y)2, and SSR = Σ(ŷi − y)2. SSE= SST= SSR= (b) Compute the coefficient of determination r2. (Round your answer to three decimal places.) r2 = (c) Compute the sample correlation coefficient. (Round your answer...
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...
Develop a scatter diagram for these data. Develop the estimated regression equation.
Given the following: X: 1    2    3 4    5 Y: 3    7    5    11    14 Develop a scatter diagram for these data. Develop the estimated regression equation. Use the estimated regression equation to predict the value of Y when X = 4
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary...
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary table and interpret the intercept and slope coefficient estimates of the linear model.                                                           Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary table and interpret the intercept and slope coefficient estimates of the linear model.                                                           
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary...
Estimate a simple linear regression model and present the estimated linear equation. Display the regression summary table and interpret the intercept and slope coefficient estimates of the linear model.                                                           
a. Develop the estimated regression equation by using the formula for computing the values for bo...
a. Develop the estimated regression equation by using the formula for computing the values for bo and b1. “ SHOW YOUR WORK” means WRITE the formula and create the columns as needed below follow the steps through. If you need more space below, create them by pressing ENTER b. Compute SSE, SST, and SSR using only Computing formulas. c. Compute the coefficient of determination r (The same as R ). Comment on the goodness of fit (That is, what does...
a. Develop the estimated regression equation by using the formula for computing the values for bo...
a. Develop the estimated regression equation by using the formula for computing the values for bo and b1. “ SHOW YOUR WORK” means WRITE the formula and create the columns as needed below follow the steps through. If you need more space below, create them by pressing ENTER b. Compute SSE, SST, and SSR using only Computing formulas. c. Compute the coefficient of determination r (The same as R ). Comment on the goodness of fit (That is, what does...
A measure of goodness of fit for the estimated regression equation is the Question 5 options:...
A measure of goodness of fit for the estimated regression equation is the Question 5 options: sample size mean square due to regression mean square due to error multiple coefficient of determination
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT