Why statistical functions summarize data in Excel - Formula Trace Breakdown

Sample Data

This data shows test scores of 5 students.

Cell	Value
A1	Scores
A2	85
A3	90
A4	78
A5	92
A6	88

Formula Trace

=AVERAGE(A2:A6)

Step 1: A2:A6

Step 2: SUM(85, 90, 78, 92, 88)

Step 3: COUNT(85, 90, 78, 92, 88)

Step 4: 433 / 5

Cell Reference Map

   A   
1 Scores
2  85  
3  90  
4  78  
5  92  
6  88  

Formula references cells A2 to A6 which contain the scores.

The formula uses the scores in cells A2 through A6 to calculate the average.

Result

   A       B   
1 Scores  Result
2  85     86.6
3  90     
4  78     
5  92     
6  88     

Cell B2 shows the average of the scores from A2 to A6.

The average score 86.6 is displayed in cell B2, summarizing the data from the scores.

Sheet Trace Quiz - 3 Questions

What does the formula =AVERAGE(A2:A6) calculate?

A The average (mean) of the scores

B The total sum of the scores

C The middle value of the scores

D The highest score

Key Result

AVERAGE(range) sums all values in the range and divides by the count of values to find the mean.