Report the demographic and independent variables that are relevant to complete a
ID: 1177597 • Letter: R
Question
Report the demographic and independent variables that are relevant to complete a demand analysis providing a rationale for the selection of the variables.
Using Excel input the data you collected in criterion one to calculate an estimated regression.
Then, from the calculation provided, interpret the coefficient of determination indicating how it will influence your decision to open the pizza business.
Explain any additional variables that may improve the coefficient of determination.
Test the statistical significance of the variables and the regression equation indicating how it will impact your decision to open the pizza business.
Forecast the demand for pizza in your community for the next four months in your community, using the regression equation including the assumptions that were used to create the demand. Justify the assumptions made related to the forecast.
Based on the forecasting demand, determine whether Dominos should establish a restaurant in your community. Provide a rational and support for the decision.
The Pizza Company Market Demand (Q) Price (P) Competitor Price (Px) Advertising (Ad) Income (I) 1 596,611 7.62 6.54 200,259 54,880 2 596,453 7.29 5.01 204,559 51,755 3 599,201 6.66 5.96 206,647 52,955 4 572,258 8.01 5.30 207,025 54,391 5 558,142 7.53 6.16 207,422 48,491 6 627,973 6.51 7.56 216,224 51,219 7 593,024 6.20 7.15 217,954 48,685 8 565,004 7.28 6.97 220,139 47,219 9 596,254 5.95 5.52 220,215 49,775 10 652,880 6.42 6.27 220,728 54,932 11 596,784 5.94 5.66 226,603 48,092 12 657,468 6.47 7.68 228,620 54,929 13 519,866 6.99 5.10 230,241 46,057 14 612,941 7.72 5.38 232,777 55,239 15 621,707 6.46 6.20 237,300 53,976 16 597,215 7.31 7.43 238,765 49,576 17 617,427 7.36 5.28 241,957 55,454 18 572,320 6.19 6.12 251,317 48,480 19 602,400 7.95 6.38 254,393 53,249 20 575,004 6.34 5.67 255,699 49,696 21 667,581 5.54 7.08 262,270 52,600 22 569,880 7.89 5.10 275,588 50,472 23 644,684 6.76 7.22 277,667 53,409 24 605,468 6.39 5.21 277,816 52,660 25 599,213 6.42 6.00 279,031 50,464 26 610,735 6.82 6.97 279,934 49,525 27 603,830 7.10 5.30 287,921 49,489 28 617,803 7.77 6.96 289,358 49,375 29 529,009 8.07 5.76 294,787 48,254 30 573,211 6.91 5.96 296,246 46,017Explanation / Answer
Statistics of T-test
Test value %uFF1D3
T
df
Level of sig.
(two-tail)
95% Confidence interval
Lower bound
Upper bound
attractiveness
2.1122
29
.05
-3.00848
3.52488
Very important
Important
So-so
Not important
Not important at all
total
Score
5
4
3
2
1
---
Count(n)
8
16
4
2
0
30(N)
Weighted
score(xi)
40
64
12
4
0
120
Average( )
%u03C32=
4
0.689655
Table 4: Statistics of T-test when test value is 3.
Test value%uFF1D2
T
df
P value
Mean
Promotion A
2.0941
29
0.0268
3.733333
Promotion B
2.4631
29
0.0100
3.933333
Promotion C
1.5094
29
0.1256
3.233333
Table 8: Statistics of T-test when test value is 2.
Test the statistical significance of the variables and the regression equation indicating how it will impact your decision to open the pizza business.
67 percent, which is a big portion, of NCTU acceptance are still athirst afterwards they accept pizza with others. It is axiomatic that their charge isn%u2019t annoyed if accepting pizzas in groups.
It is a accepted anticipation that anybody would wish to accept the acidity they prefer. We can see from Fig.4 that there are 57 percent of NCTU acceptance acquainted that their best is rather bound if the acidity is assertively by the absolute group. They accept to accommodation with added humans in the group. But if they were to adjustment pizza alone, there will be no such problem.
This is a simple on how it suppose to look like, I have been trying to use google and other search trying to get the same data for NJ state regarding dominos pizza statistics.
Statistics of T-test
Test value %uFF1D3
T
df
Level of sig.
(two-tail)
95% Confidence interval
Lower bound
Upper bound
attractiveness
2.1122
29
.05
-3.00848
3.52488