data.xls

	A	B	C	D	E	F	G	H	I
1	SUMMARY OUTPUT					32rhrh obiekt
2
3	Regression Statistics
4	Multiple R	0,9998825559
5	R Square	0,9997651255
6	Adjusted R Square	0,9997390284
7	Standard Error	2881,69401
8	Observations	21
9
10	ANOVA
11		df	SS	MS	F	Significance F
12	Regression	2	636253787110	318126893555	38309,33887	0
13	Residual	18	149474886,6	8304160,368
14	Total	20	636403261996
15
16		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
17	Intercept	-292337,1776	16911,9601	-17,2858247	0	-327867,8873	-256806,468	-327867,8873	-256806,468
18	X Variable 1	8389,831361	1159,067889	7,238429636	0,000000988080417	5954,72009	10824,94263	5954,72009	10824,94263
19	X Variable 2	338,2935683	19,24010387	17,58273088	0	297,8716101	378,7155265	297,8716101	378,7155265
20
21
22
23	RESIDUAL OUTPUT
24
25	Observation	Predicted Y	Residuals
26	1	10776,87692	3,229080745		0
27	2	33036,74458	308,1254189
28	3	55973,19938	-2101,51338
29	4	79586,24131	-7,077314761
30	5	103875,8704	2221,899614
31	6	128842,0866	-4199,446595
32	7	154484,8899	471,5600602
33	8	180804,2804	2522,489579
34	9	207800,258	1232,78196
35	10	235472,8228	2628,987206
36	11	263821,9747	1992,295314		Shapiro-Wilk Test:
37	12	292847,7137	-240,2237139
38	13	322550,0399	-748,6498786		W (observed value)	0,968
39	14	352928,9532	-1571,08318		One-tailed p-value	0,691
40	15	383984,4536	-1184,363618		Alpha	0,05
41	16	415716,5412	-1942,241192
42	17	448125,2159	-4598,445903		Conclusion:
43	18	481210,4778	6628,012249		At the level of significance Alpha=0.050 the decision is to not reject the null hypothesis that the sample follows a normal distribution.
44	19	514972,3267	-4274,816735		In other words, the non-normality is not significant.
45	20	549410,7629	-533,9428565
46	21	584525,7861	3392,423886
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