Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. advance math
  3. on top of the its own price effect on sales, mr. w

On top of the its own price effect on sales, Mr. Wok is also interested how...

Free

80.2K

Verified Solution

Question

Advance Math

  1. On top of the its own price effect on sales, Mr. Wok is alsointerested how the sales will change as Competitor’s pricechanges.

Please use data in “Linear regressionswith competitor price.xsls”

  • Estimate the coefficients with Mr. Work’s own price and itscompetitor
  • How do the two prices affect the Mr. Works’s sales?
Market IDSalesPrice  Competitor Price (Cprice)
12282.22.2
22162.72.9
32232.42.4
42072.92.6
52162.82.4
62472.22.5
72332.02.2
82492.32.7
92392.12.4
102092.72.4
112142.82.4
122362.63.0
132182.62.1
141912.92.2
152232.63.0

Answer & Explanation Solved by verified expert
4.1 Ratings (773 Votes)

Excel Results for multiple linear regression

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.899159
R Square 0.808488
Adjusted R Square 0.776569
Standard Error 7.453419
Observations 15
ANOVA
df SS MS F Significance F
Regression 2 2814.292 1407.146 25.32959 4.93E-05
Residual 12 666.6414 55.55345
Total 14 3480.933
Coefficients Standard Error t Stat P-value
Intercept 284.8645 22.03959 12.92513 2.11E-08
Price   -46.6048 6.807572 -6.84603 1.78E-05
Competitor Price (Cprice) 22.39825 6.962266 3.217092 0.007394

The regression equation is

Sales = 284.865 - 46.605 Price + 22.398 Cprice

Increase in 1 unit of Cprice increases the sales by 22.398 units keeping Price constant.

Increase in 1 unit of Price the sales of computer decreases by 46.605 units keeping the Cprice constant.

R2 = 0.8085 which means the model explains 80.85% variability in sales of computers with Price and Cprice as independent variables.
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Psychology
1.2K views

14. What is the “intra-racial network effect?” Select one: a. It says that there is no difference...

Biology
1.2K views

A student was studying the two types of nucleic acid. Based on his observation, a...

Biology
1.2K views

Which of the following would be considered a selective pressure on birds?The preferences of the...

Physics
1.2K views

To see his full height a boy that is 1 meter tall needs a mirror...

Physics
1.2K views

In the circuit shown in figure potential difference between points A and B VA VB...

Geometry
1.2K views

40 6 Graph the dilated image of Quadrilateral ABCD using a scale factor of 3...

Statistics
1.2K views

Points 0 of 1 34 births are randomly selected the sample space for genders is...

Calculus
1.2K views

The Mosteller formula for approximating the surface area, S, in m^2, of a human is...

Accounting
1.2K views

perrot industries has $325,000 to invest. Perrot industries has $325,000...

Accounting
1.2K views

(100 words minimum) Explain why bank reconciliations are necessary to every business? Explain why...

Accounting
1.2K views

Which of the following is included under the heading for Total liabilities in a statement...

Accounting
1.2K views

A company reports the following: Net income $250,000 Preferred dividends...