Question

DETROIT                               ANN ARBOR

2008       59                           2008       61

2009       60                           2009       58

2010       61                           2010       60

2011       69                           2011       68

2012       66                           2012       67

2013       62                           2013       64

2014       64                           2014       66

2015       71                           2015       70

2016       69                           2016       72

2017       66                           2017       64

What is the mean, median, mode, range, midrange, variance, and standard deviation for both cities?

Detroit
Mean
Median
Mode
Range
Midrange
Variance
Standard Deviation

Ann Arbor
Mean
Median
Mode
Range
Midrange
Variance
Standard Deviation

Make sure you use actual numbers with the appropriate commas and decimal points. Also make sure you calculate your numbers to four decimal places.  

Answer 1

We can directly use here Excel for Discriptive statistics

Step1) Enter data in Excel.

Step 2) Data >>Data Analysis >> Select data >>Click on summary statistics >>ok

Detroit
Mean	64.7
Median	65
Mode	69
Range	12
Midrange	(59+71)/2=65
Variance	17.3444
Standard Deviation	4.1647

Ann Arbor
Mean	65
Median	65
Mode	64
Range	14
Midrange	(58+72)/2=65
Variance	20
Standard Deviation 4.4721