STAT

profileVad1
INFO240_Finalii_Sp20.xlsx

FastFood

Burger Chicken Sandwich Pizza/Pasta
2400.0 933.0 452.0 855.0
1230.0 2694.4 2200.0 657.0
1418.0 1053.0 838.0 863.0
1023.0 695.0 420.0 460.0
1322.0 1548.0 753.0 538.5
540.0 1573.3 2226.6 908.0
1054.0 1400.0 988.0 623.0
1709.0 1015.0
1590.0
1139.0
1641.2
830.4
1300.0
1925.0
1036.0

Q1

Q1
Burger Annual sales in Thousands The Restaurant claims that the average annual sales for burgers is $1500K for Burgers
2400.0 Test this claim by formulating Null and Alternate hypotheses. Assume the alpha =0.05.
1230.0 Calculate the test statistics and critical values, etc.….
1418.0
1023.0
1322.0
540.0
1054.0
1709.0
1590.0
1139.0
1641.2
830.4
1300.0
1925.0
1036.0

q2

Q2
Burger Sales (000) Chicken Sales (ooo) Test the claim that the mean sales of burgers and chicken sandwiches are not equal.
2400.0 933.0 Formulate the null and alternate hypotheses.
1230.0 2694.4
1418.0 1053.0
1023.0 695.0
1322.0 1548.0
540.0 1573.3
1054.0 1400.0
1709.0 1015.0
1590.0
1139.0
1641.2
830.4
1300.0
1925.0
1036.0

Q3

Q3
Burger Chicken Sandwich Pizza/Pasta Using ANOVA, test if the four mean sales are equal.
2400.0 933.0 452.0 855.0 Write the null and alternate hypotheses, etc.
1230.0 2694.4 2200.0 657.0
1418.0 1053.0 838.0 863.0
1023.0 695.0 420.0 460.0
1322.0 1548.0 753.0 538.5
540.0 1573.3 2226.6 908.0
1054.0 1400.0 988.0 623.0
1709.0 1015.0
1590.0
1139.0
1641.2
830.4
1300.0
1925.0
1036.0

Q4

Q4
This sample data was collected to study the relationship between the rent charged with the size of a dwelling.
Size (Square feet) Rent ($)
655 1975
663 1581 A. Identify the dependent variable and independent variable. Do they have a cause and effect relationship? Explain.
718 1429
665 1350
715 1633
903 1807 B. Run Regression on this data. Make sure to check the boxes for charts, normal distribution, residual charts, etc.
708 1632
785 1528
955 1800
525 1206 C Write the null and alternate hypotheses to test if the linear relationship (slope) is significant or not.
630 1421
731 1870
694 1858 D Conduct F test to determine if you are going to accept or reject the nul hypothesis. You can use p-value test also.
685 1782
675 1750
750 1440 E. Write down the regression model (Linear equation) that the regression program output.
610 1212
531 1176
750 1270
675 1503
725 1595
820 1795
660 998
535 1080
628 1337
434 1075
775 1574
707 1556
702 1300
872 1400
578 1200
470 1450
770 1590
784 1525
872 1575
675 1478
768 1450
797 1750
600 1150
660 1850
925 1650
650 1275
550 1100
665 1398
916 1600
850 1350
750 1550
900 1300
690 1600
574 1300
800 1500
775 1400
873 1650
814 1575
739 1600
820 1425
665 1270

Q5

Q5 A. Write down the four assumptions that are made in conducting a regression analysis.
1
2
3
4
B. Determine which of these assumptions are met by looking at the charts (linear and residual, probability) and explain…
1
2
3
4
C. what will be the predicted value of the rent for a dwelling of 600 square foot?
D. If the actual rent for a dwelling of 600 square foot is $1200, would you consider that a good deal or bad?