An electronics company is looking to develop a regression model to predict the number of units sold for a special running watch. Data on Sales, Price, Advertising expenditures and whether or not there was a Holiday are provided below. #1 Sales (units) Price ($) Advertising ($) Holiday 500 $100.00 $50.00 Yes 480 $120.00 $40.00 Yes 485 $110.00 $45.00 No 510 $103.00 $55.00 Yes 490 $108.00 $40.00 No 488 $109.00 $30.00 No 496 $106.00 $45.00 Yes Develop a multiple regression analysis using Price, Advertising, and Holiday as independent variables. To incorporate holiday, create a dummy variable as follows: a. D-H = {1 if Yes, 0 otherwise} b. Write the estimated regression equation. Explain the adjusted coefficient of determination. d. Test for significance of the overall model using = 0.05. Test for significance in the relationship of each independent variable using = 0.05. с. %3D %3D
An electronics company is looking to develop a regression model to predict the number of units sold for a special running watch. Data on Sales, Price, Advertising expenditures and whether or not there was a Holiday are provided below. #1 Sales (units) Price ($) Advertising ($) Holiday 500 $100.00 $50.00 Yes 480 $120.00 $40.00 Yes 485 $110.00 $45.00 No 510 $103.00 $55.00 Yes 490 $108.00 $40.00 No 488 $109.00 $30.00 No 496 $106.00 $45.00 Yes Develop a multiple regression analysis using Price, Advertising, and Holiday as independent variables. To incorporate holiday, create a dummy variable as follows: a. D-H = {1 if Yes, 0 otherwise} b. Write the estimated regression equation. Explain the adjusted coefficient of determination. d. Test for significance of the overall model using = 0.05. Test for significance in the relationship of each independent variable using = 0.05. с. %3D %3D
Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter4: Eigenvalues And Eigenvectors
Section4.6: Applications And The Perron-frobenius Theorem
Problem 22EQ
Related questions
Question
Completely work the problems in Excel, conclusions and answers may be typed in Excel or Word
Transcribed Image Text:An electronics company is looking to develop a
regression model to predict the number of units sold for a
special running watch. Data on Sales, Price, Advertising
expenditures and whether or not there was a Holiday are
provided below.
#1
Sales (units) Price ($) Advertising ($) Holiday
500
$100.00
$50.00
Yes
480
$120.00
$40.00
Yes
485
$110.00
$45.00
No
510
$103.00
$55.00
Yes
490
$108.00
$40.00
No
488
$109.00
$30.00
No
496
$106.00
$45.00
Yes
Develop a multiple regression analysis using Price,
Advertising, and Holiday as independent variables. To
incorporate holiday, create a dummy variable as follows:
а.
D-H = {1 if Yes, 0 otherwise}
b. Write the estimated regression equation.
Explain the adjusted coefficient of determination.
d. Test for significance of the overall model using = 0.05.
. Test for significance in the relationship of each
independent variable using = 0.05.
с.
||
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 2 images
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt