Using the raw class fast food data we collected today (stored in the Google Sheet below):
Input the data in the form of a frequency distribution.
Insert a frequency histogram. You will need to “customize histogram” with classes of width 5 (under bucket size type 5).
Title the chart and label the x- and y-axis appropriately. (In Sheets, right click to on the chart to change title/axes)
Create a pie chart (You will need use the data you organized into a frequency distribution to do this.) Title the chart and clearly label the legend.
Use the formulas built into Google Sheets to calculate mean, median, and population standard deviation:
Use a spreadsheet formula in Google Sheets to calculate the mean and clearly label it.
Use a spreadsheet formula in Google Sheets to calculate the median and clearly label it.
Use a spreadsheet formula in Google Sheets to calculate the standard deviation and clearly label it.
If you are having trouble doing any of the above steps, try an internet search that says the following:
“How do I __________________________ in Google Sheets.”
https://docs.google.com/spreadsheets/d/1j1gClC9LIygCcJhN5G1H7yj0nRm3bkY38_dLdj7XF3E/edit?usp=sharinghttps://docs.google.com/spreadsheets/d/1j1gClC9LIygCcJhN5G1H7yj0nRm3bkY38_dLdj7XF3E/edit?usp=sharing
