Follow the instructions under the title of “Using Excel’s Regression Tool for the Armand’s Pizza Parlors Example” to develop regression equation and ANOVA table as in Figure 14.13 and answer the following questions:1. Open the dataset of Armand’s (attached).2. Follow the instructions under the title of “Using Excel’s Regression Tool for the Armand’s Pizza Parlors Example” to develop regression equation and ANOVA table as in Figure 14.13 (attached).3. Upload the Figure 14.13.4. What is the estimated regression equation?5. Conduct the hypothesis test to test for significance of regression. Can we conclude that there is a significant relationship between student population and sales? Provide the rationale for your answer. RestaurantPopulationSales1258261053888481185121176161377201578201699221491026202 Bb Unit 8: Learning Activities - 21/SF Xвы 1759848B Unit 8: Promotional Strategy Part x b The purpose of this assignment i: x+A learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com/5fda9d7e7f5d0/1759848?X-Blackboard-Expiration=1615356000000&X-Blackboard-Signature=a4...E Apps• Paraphrasing Tool -. P My Perfect Resume C Plagiarism Checker.O Text To Speech Rea.S All the answersO Homework/test helpFREE BOOKS downl.Microsoft 365>>1 /1 ||+ |1759848100%14.7 Excel's Regression Tool647FIGURE 14.13 Regression Tool Output for Armand's Pizza ParlorsDEFGHPopulntionRestaurant2Sales5836.105488511861211716137201572016910221491110262021213 SUMMARY OUTPUT1415Regression Statistics16 Multiple R17 R Square18 Adjusted R Square19 Standard Error20 Observations0.95010.90270,890613,8293102122 ANOVA23drSSMSSignificance F1420024 Regression25 Residual1420074.24842.55E-051530191.2526 Total91573027Coefficients60Standard Error I StarP-valueUpper 95% Louer 99.096 Upper 99.09628Lower 959681.275329 lutercept30 Population9.22606.50330.000238.724729.043190.95698.6167 2.55E-053.66190.58036.33813.05306.947031X Armand's.xlsxShow all8:01 PMO Type here to search5)3/9/20219.

The data is given as follows. population sales 2 58 6 105 8 88 8 118 12 117 16 137…

Answered: Follow the instructions under the title…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

Follow the instructions under the title of “Using Excel’s Regression Tool for the Armand’s Pizza Parlors Example” to develop regression equation and ANOVA table as in Figure 14.13 and answer the following questions:

1. Open the dataset of Armand’s (attached).

2. Follow the instructions under the title of “Using Excel’s Regression Tool for the Armand’s Pizza Parlors Example” to develop regression equation and ANOVA table as in Figure 14.13 (attached).

3. Upload the Figure 14.13.

4. What is the estimated regression equation?

5. Conduct the hypothesis test to test for significance of regression. Can we conclude that there is a significant relationship between student population and sales? Provide the rationale for your answer.

Restaurant	Population	Sales
1	2	58
2	6	105
3	8	88
4	8	118
5	12	117
6	16	137
7	20	157
8	20	169
9	22	149
10	26	202

Bb Unit 8: Learning Activities - 21/SF X
вы 1759848
B Unit 8: Promotional Strategy Part x b The purpose of this assignment i: x
+
A learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com/5fda9d7e7f5d0/1759848?X-Blackboard-Expiration=1615356000000&X-Blackboard-Signature=a4...
E Apps
• Paraphrasing Tool -. P My Perfect Resume C Plagiarism Checker.
O Text To Speech Rea.
S All the answers
O Homework/test help
FREE BOOKS downl.
Microsoft 365
>>
1 /1 ||
+ |
1759848
100%
14.7 Excel's Regression Tool
647
FIGURE 14.13 Regression Tool Output for Armand's Pizza Parlors
D
E
F
G
H
Populntion
Restaurant
2
Sales
58
3
6.
105
4
88
5
118
6
12
117
16
137
20
157
20
169
10
22
149
11
10
26
202
12
13 SUMMARY OUTPUT
14
15
Regression Statistics
16 Multiple R
17 R Square
18 Adjusted R Square
19 Standard Error
20 Observations
0.9501
0.9027
0,8906
13,8293
10
21
22 ANOVA
23
dr
SS
MS
Significance F
14200
24 Regression
25 Residual
14200
74.2484
2.55E-05
1530
191.25
26 Total
9
15730
27
Coefficients
60
Standard Error I Star
P-value
Upper 95% Louer 99.096 Upper 99.096
28
Lower 9596
81.2753
29 lutercept
30 Population
9.2260
6.5033
0.0002
38.7247
29.0431
90.9569
8.6167 2.55E-05
3.6619
0.5803
6.3381
3.0530
6.9470
31
X Armand's.xlsx
Show all
8:01 PM
O Type here to search
5)
3/9/2021
9.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Correlation, Regression, and Association$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions