幸运28

A.1.9.2 Finding Spreadsheet Statistics

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