The data for  Exercise 1.40 are presented on page 37 of your text book and stored on the CD in the file:
F:\PCDataSets\Excel\ CHAP01\EX01_040.XLS.  If you do not have the CD read note .

To load the data in your Excel worksheet you should follow the steps described in Ex. 1.30 .

As you look at the loaded data, you see that the  times for the winning men are in the rows C2:C44 and the
times for the winning women are in the rows C45:C74, with the years in the corresponding rows of the  column B.

It is very easy to make a time plot in Excel.  Let's start with the winning men's times.

Highlight the cells B2:C44, then click on the Chart icon, choose the "XY-scater" chart type, and click
"Finish".  You should get a Time plot chart like:
 

With Excel you may add to the chart a "Trend Line".

Highlight the chart by clicking on it, then click on "Chart" from the menu, and choose "Add trendline " to
open the "Add trendline" window, and then just click OK.
 

You should get a chart like below:
 

        The trend line shows that the winning times keep improving over the recorded period, but  does not
answer the second question from the textbook exercise 1.38: "Have times stopped improving in recent years".
        This is because the trend line linearly extrapolates forever; of course, this is unrealistic in practice.

        A more realistic model can be obtained from the "Moving average " option, which plots the successive
averages for a selected number of years.
        You may select the number of years to be averaged (called the "Period " on the "Type" tab of the "Add
Trendline" menu), and here is what you get for a 4-year moving average.
 

Based on the 4-year moving average, it appears that the winning times were stagnant after 1981.

Note that the trend line was removed in the chart above.  For this you highlight the trend line by clicking on it, then choose the "Edit" menu
and then "Clear trendline" as below:
 

Now you'll make a chart with both men's and women's winning times.  For this:

Drag the women's times to the cells D15:D44 and then label the columns as below:
 

Then
highlight the cells B1:D44 and make a time plot chart as above.

Note. There are two "Series" of y-coordinates (men and women) plotted against the shared x-axis (year). See .

The X-range and Y-range chosen by Excel for this time plot may be improved.  For this
highlight the X-axis by clicking on it (see below):
 

then click "Format" from the menu  bar to open the "Format Axis" window, and choose new limits for the X-axis:
 

Make changes for the Y-axis also.  You should get a neat time plot chart like: 

Note that the plotted points are connected with lines.  This kind of time plot is obtained using the corresponding subtype from the Chart Wizard.
 

Question 1. On a single worksheet make two neat    (this is a link to the chart that you should use as
a model for your homework) time plots.  Each chart should show the two time series (men's and women's winning times).
In the first chart add a trend line to the women's time series; in the second chart add a 4-point moving average
to the women's time series.

Which of these two would you recommend for predicting the women's winning times in the near future? Why?
 

Hand in the printed Excel worksheet.
 

SUCCESS !!