formula128.xlsx

	A	B	C	E	F	H	J
1	Student	Points	Count of Ratings	Average	85,1	=AVERAGE($B$2:$B$21)	https://exceltable.com/
2	Michael Anderson	98	1	Median	90,5	=MEDIAN(B2:B21)
3	James Miller	96	1	Mode	93	=MODE(B2:B21)
4	Kimberly Scott	95	1
5	Sarah Davis	93	4
6	Jessica Taylor	93	4
7	Jennifer Thompson	93	4
8	Robert Lewis	93	4
9	Elizabeth King	92	1
10	David Moore	91	2
11	William White	91	2		90,5
12	Emily Johnson	90	1		90,5
13	Ashley Wilson	80	2
14	Anthony Hall	80	2
15	Matthew Martinez	77	2
16	Nicole Lee	77	2
17	Joshua Wright	76	1
18	Megan Clark	73	1
19	Amanda Robinson	72	1
20	Christopher Brown	71	2
21	Daniel Harris	71	2
22
23
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