Question 327230: Instructions: For each exercise, use Excel, or MegaStat to make an attractive, well-labeled time-series line chart. Adjust the Y-axis scale if necessary to show more detail (since Excel usually starts the scale at zero). If a fitted trend is called for, use Excel’s option to display the equation and R2 statistic (or MAPE, MAD, and MSD in MINITAB). Include printed copies of all relevant graphs with your answers to each exercise.
(a) Plot the data on full-time mathematics graduate students. (b) Would a fitted trend be helpful? Explain. (c) Make a forecast for 2003, using a trend model of your choice (or a judgment forecast).
MathGrads
Full-Time Mathematics Graduate Students, 1993–2002
Year Total
1993 10,525
1994 10,185
1995 9,761
1996 9,476
1997 9,003
1998 8,791
1999 8,838
2000 9,637
2001 9,361
2002 9,972
Answer by Fombitz(32388)   (Show Source):
You can put this solution on YOUR website! Open up EXCEL.
Make one column with the year data.
Right next to it make another column with the total data.
Highlight the data.
Click on the Chart Wizard, pick scatter plot.
Once the chart is complete, right click on the data point and choose Add trendline.
Choose Linear.
In the Options tab, choose Display equation .... and Display  value.
|
|
|
