Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider our sales regression model. The data is contained as below. Month Unit Sales Price ($) Adexp ('000$) Promexp ('000$) 1 73959 8.75 50.04 61.13

Consider our sales regression model. The data is contained as below.

Month Unit Sales Price ($) Adexp ('000$) Promexp ('000$)
1 73959 8.75 50.04 61.13
2 71544 8.99 50.74 60.19
3 78587 7.50 50.14 59.16
4 80364 7.25 50.27 60.38
5 78771 7.40 51.25 59.71
6 71986 8.50 50.65 59.88
7 74885 8.40 50.87 60.14
8 73345 7.90 50.15 60.08
9 76659 7.25 48.24 59.90
10 71880 8.70 50.19 59.68
11 73598 8.40 51.11 59.83
12 74893 8.10 51.49 59.77
13 69003 8.40 50.10 59.29
14 78542 7.40 49.24 60.40
15 72543 8.00 50.04 59.89
16 74247 8.30 49.46 60.06
17 76253 8.10 51.62 60.51
18 72582 8.20 49.78 58.93
19 69022 8.99 48.60 60.09
20 76200 7.99 49.00 61.00
21 69701 8.50 48.00 59.00
22 77005 7.90 54.00 59.50
23 70987 7.99 48.70 58.00
24 75643 8.25 50.00 60.50

Please estimate the following model

Ln(Sales) = _0 + _1 Ln(Price) + _2 Ln(AdExp) + _3 Ln(PromExp)

where Sales is the unit sales, Price is the price in $, AdExp is the monthly amount of ad expenditure in '000$ and PromExp is the monthly amount of promotions expenditure in '000$

(a) What is the price elasticity of Sales, based on this regression model.

(b) Report and interpret the coefficient 3.

(c) Test the hypothesis that a 10% increase in AdExp corresponds to a Sales increase of at least 5%.

(d) Predict the Sales when the unit is priced at $8.50, the monthly ad expenditure is 51,000$ and the monthly promotion expenditure is 61,000$.

(e) Build a 95% confidence interval for your prediction.

(f) The company wants to use the regression output to show evidence that the sales in part (d) would be in excess of 73,000 units. Calculate the probability that the sales in part (d) is greater than 73,000 units.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Measure Theory And Integration

Authors: M M Rao, MM Rao

2nd Edition

1351991485, 9781351991483

More Books

Students also viewed these Mathematics questions

Question

What does this look like?

Answered: 1 week ago