Question

3. You work for Mut the Custard, a frozen custard company. You’ve collected data on monthly...

3. You work for Mut the Custard, a frozen custard company. You’ve collected data on monthly sales (S, number of regular-sized frozen custards per month) the price of your regular-sized frozen custard (P, in dollars), and the population size in the different cities in which your company operates (N, number of people; you currently only have one establishment in each city). You estimate the following regression model: S = a + bP + cN. In your regressions, you usually look for a 10%-or-better level of confidence.

a. What signs do you expect for a, b, and c?

b. Your regression yields the following results: Adjusted R Square 0.825 Independent Variables Coefficients Standard Error t Stat P-value Intercept 3510 639 5.494 0.00273 P -693.37 118.26 -5.863 0.00205 N 0.0176 0.0076 2.304 0.06943 Interpret what these coefficients mean.

c. Does price have a statistically significant effect on sales?

d. Does population have a statistically significant effect on sales?

e. What portion of the total variation in sales remains unexplained?

f. Mut the Custard is considering selling in a new city, where the population is 63,000, and setting its regular-sized frozen custard price at $4.25. What level of monthly sales would you expect in this new city (rounded to the nearest unit)?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a) the expected sign would be positive sign for intercept a, negative sign for price coefficient b because when price increases demand decreases and sales falls, and positive sign for population coefficient c as population increases demand increases and sales rises.

b) the coefficient value of intercept is 3510 which shows at 0 price the autonomous sales is 3510 unit frozen costars. The price coefficient is -693.37 which show a one dollar in crease in price would reduce the sale of frozen costars is 693.37 unit. The increase in population by one unit will increase the sales by 0.0178 unit.

c) yes, price has a statistical significant effect on the sales as the p value is 0.00205 which is less then the 10 percent level of significance.

d) yes, population also has significant effect on sales as its p value is less then the value of level of significance. 0.06943 means 6%<10%.

Add a comment
Know the answer?
Add Answer to:
3. You work for Mut the Custard, a frozen custard company. You’ve collected data on monthly...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A soft-drink bottler collected the following monthly data on its sales (measured in             thousand units)...

    A soft-drink bottler collected the following monthly data on its sales (measured in             thousand units) of 12-ounce cans at different prices.             Month 1 2 3 4 5 6 7 8 9 10 11 12 Price $0.45 0.50 0.45 0.40 0.35 0.35 0.50 0.55 0.45 0.50 0.40 0.40 Quantity 98 80 95 123 163 168 82 68 96 77 130 125             (a) Using Excel run a linear regression with Quantity the dependent variable and price    the independent...

  • Question 9 (1 point) You work for a company in the marketing department. Your manager has...

    Question 9 (1 point) You work for a company in the marketing department. Your manager has tasked you with forecasting sales by month for the next year. You notice that over the past 12 months sales have consistently gone up in a linear fashion, so you decide to run a regression the company's sales history. You find that the regression equation for the data is (sales) 104.21*(time) + 113.38. In 11 months you see the actual sales quantity was 380.64....

  • In cell C6, insert a Scatter Chart for the Returns Completed versus Return Price data from...

    In cell C6, insert a Scatter Chart for the Returns Completed versus Return Price data from the Data worksheet. You may be used to seeing Price placed on the Y-axis from other economics courses, but in this problem we are using price as the independent variable. Inserting Chart Select the Scatter chart from the provided chart options in the Charts group of the Insert tab of the Ribbon. Selecting Data Series Then choose Select Data in the Design tab on...

  • (I did this homework in completion but professor was not happy with answers whatsoever, need additional...

    (I did this homework in completion but professor was not happy with answers whatsoever, need additional answers and especially improvement to 1.b help!! photos not attaching? mean by severai steps. inis is a View Feedback homework and will need you to work, in one two View Feedback or various steps. Unfortunately, I cannot read your screen shot of what you did on excel. As I have said in numerous messages announcements etc, I cannot аcсept pictures. You need to write...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT