Illustrate through excel a run chart displaying the quarterly data contained in the attacheddata file.

1.Title the chart and label the x- and y-axes appropriately.Someone unfamiliar with your data should be able to understand your chart without you explaining it to them.

2.Remember that a run chart requires a median line.Excel won't automatically put the median line on your chart.You'll need to determine what the median of your data is and then add a column to your data that includes the median at each data point.That way Excel will display your d/c data and your median.

Quarter Private Discharges Y2003_Q1 38450 Y2003_Q2 40100 Y2003_Q3 45650 Y2003_Q4 45100 Y2004_Q1 44450 Y2004_Q2 45100 Y2004_Q3 40700 Y2004_Q4 40400 Y2005_Q1 39350 Y2005_Q2 40600 Y2005_Q3 40150 Y2005_Q4 39900 Y2006_Q1 39400 Y2006_Q2 40600 Y2006_Q3 41350 Y2006_Q4 41200 Y2007_Q1 40850 Y2007_Q2 41500 Y2007_Q3 41250 Y2007_Q4 40300 Y2008_Q1 47050 Y2008_Q2 47400 Y2008_Q3 42700 Y2008_Q4 42500 Y2009_Q1 39900 Y2009_Q2 40050 Y2009_Q3 40350 Y2009_Q4 39850 Y2010_Q1 38450 Y2010_Q2 39100 Y2010_Q3 38700 Y2010_Q4 38450 Y2011_Q1 37500 Y2011_Q2 37650 Y2011_Q3 37300 Y2011_Q4 36700 Y2012_Q1 36300 Y2012_Q2 35850 Y2012_Q3 36100 Y2012_Q4 35400 Y2013_Q1 33550 Y2013_Q2 34250 Y2013_Q3 33550 39625 Y2013_Q4 Y2014_Q1 Y2014_Q2 Y2014_Q3 Y2014_Q4 Y2015_Q1 Y2015_Q2 33250 32800 33400 32750 32550 30450 31050