homework average income of all countries

	A	B	C	D	E	G	H
1	hours studied	results	prediction	lse	normalized value (Z)
2	9	100	97.3	7.1	1.2	Z = (X - μ) / σ
3	2	50	55.1	25.7	-1.5
4	6	80	79.2	0.6	0.1	Where:
5	4	75	67.1	61.7	-0.2
6	8	85	91.3	39.6	0.4	Z is the normalized value (Z-score).
7	average=	78	sum	135		X is the original data point.
8	Coefficient					μ (mu) is the mean (average) of the data.
9	6.0	43.0	=LINEST(B2:B6,A2:A6,1,0)			σ (sigma) is the standard deviation of the data.
10
11	stand deviation	18.23458253	standard deviation		=STDEV.S(B2:B6)
12			probability			0 is like the mean of the average
13
14			normal curve			this data is normalized
15
16						0	mean
17						1 standard deviation in the positive direction (meaning > 0) covers 34.13% of all observations
18
19
20
21						observation
22						0 is the average test score normalied
23
24
25
26						the probability that someone made result > 1 standard deviation is
27
28						std	probability
29						-3	0.13%
30						-2	2.14%
31						-1	13.59%
32						0	34.13%
33						0	34.13%
34						1	13.59%
35						2	2.14%
36						3	0.13%
37							99.98%
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