Activity Data Set

First, when you download the data set, you will find that you have three variables:

 

1) Lunch + Dinner Guests for 2012

2) Lunch + Dinner Guests for 2013

3) Lunch + Dinner Guests for 2014

 

it says to display your data set in a chart.  What you want to do is display these three variables in the best kind of chart you can find that will effectively tell the story of your data.  This could be a bar chart, a line graph or something else...experiment with your excel chart / graph making functions and see what you can come up with.

 

2) Central Tendency calculations are your MEAN (aka Average), your MODE and your MEDIAN.   You might want to review our week 1 material on what each of these three measures of center are before you attempt this part.  Excel will calculate them for you, though, which is the good news.  You want to calculate a Mean, Median AND a Mode for EACH of your three variables (so a total of nine calculations).  

 

It's super easy to do them in excel.  Simply pick an open cell and type the following:

 

For Mean of 2013, pick an open cell and type: =AVERAGE(C5:C23)

For Median of 2013, pick an open cell and type: =MEDIAN(C5:C23)

For Mode of 2013, pick and open cell and type: =MODE(C5:C23)

 

Repeat these three calculations for the 2014 and 2015 variables.