Five marbles, standard error, confidence intervals

	A	B	C	D	F	G	H	I	J	K	L
1		Before Data	After Data	Sample means	Class upper limits	Freq before	Frequency after	RF before	Relative Freq data after	Frequency means	Rel Freq means

2		5	7	4.2	2	0	5	0	0.2631578947	0	0
3		5	4	4.8	4	0	2	0	0.1052631579	1	0.25
4		5	5	3.4	6	20	8	1	0.4210526316	2	0.5
5		5	5	7.6	8	0	3	0	0.1578947368	1	0.25
6		5	0		11	0	1	0	0.05263157895	0	0
7		5	5			0	1			0
8		5	4		Sums:	20	19			4
9		5	5
10		5	5		Buckets	Before trade data	After trade data	Distribution of sample means
11		5	5		2	0	0.2631578947	0
12		5	9		4	0	0.1052631579	0.25
13		5	1		6	1	0.4210526316	0.5
14		5	5		8	0	0.1578947368	0.25
15		5	2		11	0	0.05263157895	0
16		5	0
17		5	6
18		5	7					3
19		5	2					4
20		5	15					5
21		5	8					4
22								5
23								4.2
24								0.8366600265
25							SE	0.3741657387
26
27		Before Data	After Data	Sample means
28	Sum:	100	100
29	Sample size n:	20	20	4
30	Average:	5	5	5
31	Standard deviation:	0	3.40279	1.8257
32	Standard error of the mean:		0.76089
33
34	Note that the standard error
35	of the mean formula estimates
36	based on the data being normally
37	distributed
38	Sample means should exceed
39	30 means before a clear normal
40	distribution could be expected to
41	be seen.
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