an Pizza restaurant chain wants to understan monthly sales of deep-dish pizzas at his resta lata are provided in the file P10_04.xlsx. Esti e best explanatory variable: average price of surrounding the outlets (X3). Round your an y. If your answer is negative number, enter X1

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

The owner of Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza. He has gathered data on the monthly sales of deep-dish pizzas at his restaurants and observations on other potentially relevant variables for each of several outlets in central Indiana. These data are provided in the file P10_04.xlsx. Estimate a simple linear regression equation between the quantity sold (Y) and each of the following candidates for the best explanatory variable: average price of deep-dish pizzas (X1), monthly advertising expenditures (X2), and disposable income per household in the areas surrounding the outlets (X3). Round your answers for intercept coefficients to the nearest whole number and slope coefficients to two decimal places, if necessary. If your answer is negative number, enter "minus" sign.

The owner of Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza. He
has gathered data on the monthly sales of deep-dish pizzas at his restaurants and observations on other potentially relevant variables for each of several outlets
in central Indiana. These data are provided in the file P10_04.xlsx. Estimate a simple linear regression equation between the quantity sold (Y) and each of the
following candidates for the best explanatory variable: average price of deep-dish pizzas (X₁), monthly advertising expenditures (X2), and disposable income
per household in the areas surrounding the outlets (X3). Round your answers for intercept coefficients to the nearest whole number and slope coefficients to two
decimal places, if necessary. If your answer is negative number, enter "minus" sign.
Ŷ =
ŷ =
+
+
X1
+
X2
X3
Ŷ =
Which variable is most strongly associated with the number of pizzas sold? Explain your choice.
The variable most strongly associated with the number of pizzas sold is the monthly advertising expenditures
correlation coefficient with the quantity sold
because it has the strongest
Transcribed Image Text:The owner of Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza. He has gathered data on the monthly sales of deep-dish pizzas at his restaurants and observations on other potentially relevant variables for each of several outlets in central Indiana. These data are provided in the file P10_04.xlsx. Estimate a simple linear regression equation between the quantity sold (Y) and each of the following candidates for the best explanatory variable: average price of deep-dish pizzas (X₁), monthly advertising expenditures (X2), and disposable income per household in the areas surrounding the outlets (X3). Round your answers for intercept coefficients to the nearest whole number and slope coefficients to two decimal places, if necessary. If your answer is negative number, enter "minus" sign. Ŷ = ŷ = + + X1 + X2 X3 Ŷ = Which variable is most strongly associated with the number of pizzas sold? Explain your choice. The variable most strongly associated with the number of pizzas sold is the monthly advertising expenditures correlation coefficient with the quantity sold because it has the strongest
1
2
3
4
5
6
7
8
9
10
11
234 15 16
12
13
14
A
Outlet Number
1
2
3
45600
7
8
9
DELE HE
10
11
12
13
14
15
B
Quantity Sold
85,300
40,500
61,800
50,800
60,600
79,400
71,400
70,700
55,600
70,900
77,200
63,200
71,100
55,500
42,100
C
Average Price
$10.14
$10.88
$12.33
$12.70
$12.29
$9.79
$11.26
$11.23
$11.97
$12.07
$10.68
$12.49
$12.36
$9.96
$11.77
D
Monthly Advertising Expenditures
$64,800
$42,800
$58,600
$46,500
$50,700
$60,100
$55,600
$57,900
$52,100
$60,700
$64,400
$55,600
$60,900
$47,200
$46,100
E
Disposable Income per Household
$42,100
$38,300
$41,000
$43,300
$44,000
$41,200
$41,700
$43,600
$39,900
$44,800
$41,800
$44,200
$40,100
$39,100
$38,000
Transcribed Image Text:1 2 3 4 5 6 7 8 9 10 11 234 15 16 12 13 14 A Outlet Number 1 2 3 45600 7 8 9 DELE HE 10 11 12 13 14 15 B Quantity Sold 85,300 40,500 61,800 50,800 60,600 79,400 71,400 70,700 55,600 70,900 77,200 63,200 71,100 55,500 42,100 C Average Price $10.14 $10.88 $12.33 $12.70 $12.29 $9.79 $11.26 $11.23 $11.97 $12.07 $10.68 $12.49 $12.36 $9.96 $11.77 D Monthly Advertising Expenditures $64,800 $42,800 $58,600 $46,500 $50,700 $60,100 $55,600 $57,900 $52,100 $60,700 $64,400 $55,600 $60,900 $47,200 $46,100 E Disposable Income per Household $42,100 $38,300 $41,000 $43,300 $44,000 $41,200 $41,700 $43,600 $39,900 $44,800 $41,800 $44,200 $40,100 $39,100 $38,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman