# A.1.9.2 Finding Spreadsheet Statistics

- Author:
- Katie Akesson

## Use this spreadsheet to do the tasks below (the same spreadsheet as the previous page). Alternatively, you could open a new window with a GeoGebra spreadsheet to work side-by-side with this window to get answers.

In cell D1 type the following (be sure to include the = sign)
=Sum(A1:A20)
Type your answer to the ** sum** below

In cell D2 type the following (be sure to include the = sign)
=Mean(A1:A20)
Type your answer to the ** mean** below

In cell D3 type the following (be sure to include the = sign)
=Median(A1:A20)
Type your answer to the ** median** below

We can use GeoGebra to create displays.

- Click the letter A for the first column so that the entire column is highlighted.
- Click on the button that looks like a histogram to get a new window labeled "OneVariable Statistics"
- Click "Analyze" to see a histogram of the data.
- Click the