Speeding Cars Day 2

posted Aug 27, 2015, 9:46 AM by Tony Farley   [ updated Aug 28, 2015, 12:56 PM ]
Today you will find the average speed of the cars, the fastest car, and the slowest car.  You will also create an histogram of the speed of the cars.

1. Open your Sheet from yesterday.  If you were not here yesterday, click here and use mine.  Follow the directions from yesterday to catch up.

2. Add the words Average Speed (mph), Maximum Speed (mph) and Minimum Speed (mph) like this:

3. Click under Average speed, type =average and then select all the speeds in the D column to average them all.

4. Then do the same thing for Maximum and Minimum.

5. Next you will create an histogram of the speeds of the cars.  Select all the speeds, including the title. (don't pull down the blue square!) by dragging your mouse over them.  Then click the insert chart button:

6. Select Histogram as the chart type.

7. Click Customization.  Change the Title to something that describes what the chart is, get rid of the legend (set to None), and set the Bucket size to 5.

Insert your chart and move it under your data table.  You can still edit the chart by clicking the Quick Edit pencil
or right clicking and selecting Advanced Edit.

Share your Sheet with tonyfarley@mac.com to turn it in.

Tomorrow we will write a paper about this.  You can get started early if you want.  Just follow these directions.