Data Exploration: Menu Prices

Learning Outcomes

  • Use a spreadsheet to explore measures of central tendency of a data set
  • Use a spreadsheet to explore measures of spread and variation of a data set

now its your turn

Practice putting the entire sheet together and performing an analysis of the descriptive statistics on your own. The solutions are presented for each step, but don’t peek until you have completed each one!

A downtown historic district has taken a census of the average dinner plate price at all the main-street restaurants. They are displayed in the table below, rounded to the nearest dollar.

7 7 7 8 8 8
8 8 8 12 12 12
13 13 14 17 17 18
22 23 25 27 32 47

Hands-on Spreadsheet: Explore the Data

step 1

Store the data in a new sheet named Menu Prices.

step 2

Obtain the descriptive statistics. What are the mean, median, and mode? What is the standard deviation? Does the data appear to be tightly centered or more spread out? What is the skewness? Does the mean appear to have been pulled left or right of center by any extra large or extra small values?

Step 3

Now create a frequency table and histogram. Use 6 intervals beginning with 0-7.

step 4

Create a 5-number summary and box plot.

step 5

Analyze the data.