Question

Find out the Mean， Median ，Modal Interval， Range， IQR ，Standard Deviation， of this set of data

Year Tea (L per person) Coffee(L per person) 1994 42.4 95.85 42.12 1995 97.28 1996 47.61 87.62 1997 60.86 92.04 1998 55.58 99.21 50.61 95.63 1999 2000 49.89 97.42 56.77 2001 93.93 62.53 2002 95.67 2003 68.31 99.25 2004 101.31 69.88 2005 72.99 101.68 104.02 2006 71.36 106.09 2007 90.78 105.8 2008 74.7 2009 67.15 102.15 2010 67.03 101.15 87.83 2011 104.05 102.7 2012 93.4 78.9 2013 105.28 106.3 2014 111.32 98.39 2015 104.96 2016 105.25 103.57

Answer 1

A Tea (L per Person) Coffee (L Per Person) 42.4 95.85 42.12 3 97.28 4 47.61 87.62 60.86 5 92.04 6 55.58 99.21 7 50.6 95.63 8 49.89 97.42 56.77 62.53 9 93.93 95.67 10 11 68.31 99.25 12 13 69.88 101.31 72.99 101.68 104.02 14 71.36 15 90.78 106.09 105.8 102.15 101.15 16 74.7 17 67.15 18 67.03 19 87.83 104.05 20 93.4 102.7 21 78.9 105.28 22 111.32 106.3 23 98.39 105.25 104.96 103.57 24 25 Mean 26 Median 27 Mode 28 Range 70.68 100.13 101.31 68.31 #N/A #N/A 69.20 18.68 29 Q1 30 Q3 31 IQR 56.18 96.57 104.04 7.47 83.37 27.19 32 Standard Deviatio 19.68 5.00 33 N LO CO Ncoo N

Formula Ref:

A B Tea (L per Person) Coffee (L Per Person) 1 2 42.4 95.85 42.12 97.28 3 4 47.61 87.62 60.86 92.04 6 55.58 99.21 7 50.61 95.63 8 49.89 97.42 56.77 93.93 10 62.53 95.67 11 68.31 99.25 12 69.88 101.31 101.68 13 72.99 71.36 90.78 14 104.02 15 106.09 16 74.7 105.8 67.15 17 102.15 18 67.03 101.15 19 87.83 104.05 20 93.4 102.7 78.9 21 105.28 22 111.32 106.3 98.39 23 104.96 103.57 24 105.25 25 Mean -AVERAGE (B2:B24) =MEDIAN(B2:B24) MODE(B2:B24) MAX(B2:B24) - MIN(B2:B24) QUARTILE (B2:B24,1) QUARTILE (B2:B24,3) =AVERAGE (C2:C24) MEDIAN(C2:C24) MODE(C2:C24) MAX (C2:C24)-MIN(C2:C24) -QUARTILE ( C2:C24,1) -QUARTILE ( C2:C24,3) 26 Median 27 Mode 28 Range 29 Q1 30 Q3 31 IQR B30-B29 C30-C29 =STDEV (C2: C24) =STDEV ( B2 :B24) 32 Standard Deviation 33 N L CO NCO O

Mode will find repeated values in the data set. But in the both data set there is no repeated numbers