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)?
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%.
3. You work for Mut the Custard, a frozen custard company. You’ve collected data on monthly...
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 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 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 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...