AVERAGE FUNCTION

The AVERAGE function returns the average of a set of data. The AVERAGE function can be broken down into three categories:

Data Set

90

91

84

93

97

·         There can be a maximum of 255 values in a set of data.

Sum of Data Set

90+91+84+93+97

=   455

Average

Sum of Data set		455	=    91
Number of Data Points		5

So what does this show? Well if you had five students with grades of 90, 91, 84, 93 and 97 on a test, you could use the AVERAGE function to determine what the class average is for the test. This data can be used to compare to other classes to see how well multiple classes did verse similar classes. The class average will show which students need more work and which students stand out above the rest of their class.