Mcdonald.xlsx

	A	B	C	D	F	H	S	T	U	V	W	X	Y	Z	AA
1	Big Mac	Wage	Fitted	Residual
2	4.84	15.91	28.492236	-12.582236	Y = 8.46(BigMac) - 12.44
3	4.94	46.29	29.338026	16.951974			SUMMARY OUTPUT
4	6.16	11.65	39.656664	-28.006664	0.7334513675
5	5	36.56	29.8455	6.7145			Regression Statistics
6	4.07	13.13	21.979653	-8.849653			Multiple R	0.7334513675
7	5.48	51.67	33.905292	17.764708			R Square	0.5379509086
8	4.04	9.17	21.725916	-12.555916			Adjusted R Square	0.5122815146
9	4.67	21.42	27.054393	-5.634393			Standard Error	11.88025912
10	4.08	36.71	22.064232	14.645768			Observations	20
11	2.74	6.48	10.730646	-4.250646
12	4.41	23.38	24.855339	-1.475339			ANOVA
13	2.78	2.01	11.068962	-9.058962				df	SS	MS	F	Significance F
14	3.09	8.83	13.690911	-4.860911		-12.444	Regression	1	2957.868458	2957.868458	20.95689946	0.0002333338543
15	3.65	22.6	18.427335	4.172665		8.4579	Residual	18	2540.530022	141.1405568
16	3.5	18.91	17.15865	1.75135			Total	19	5498.39848
17	7.64	49.12	52.174356	-3.054356
18	8.06	60.4	55.726674	4.673326				Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
19	2.6	9.34	9.54654	-0.20654			Intercept	-12.4440179	8.702629261	-1.429914745	0.1698702296	-30.72756352	5.839527724	-30.72756352	5.839527724
20	3.89	30.77	20.457231	10.312769			Big Mac	8.457923954	1.847567275	4.577870625	0.0002333338543	4.576329146	12.33951876	4.576329146	12.33951876
21	4.07	35.53	21.979653	13.550347							H0: Coefficient is 0
22								Wage = 8.46(x) - 12.44			Ha: Coefficient is not 0
23								If x increases by 1 Wage increases by 8.46			P is < 0.05:	Can use x to project y
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100