document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=327230>Question 327230</A>: <I><SPAN STYLE=\"word-break: break-all;\"> 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.\r<BR>\n" );
document.write( "\n" );
document.write( "(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).<BR>\n" );
document.write( "MathGrads<BR>\n" );
document.write( "Full-Time Mathematics Graduate Students, 1993–2002<BR>\n" );
document.write( "Year            Total<BR>\n" );
document.write( "1993            10,525<BR>\n" );
document.write( "1994            10,185<BR>\n" );
document.write( "1995             9,761<BR>\n" );
document.write( "1996             9,476<BR>\n" );
document.write( "1997             9,003<BR>\n" );
document.write( "1998             8,791<BR>\n" );
document.write( "1999             8,838<BR>\n" );
document.write( "2000             9,637<BR>\n" );
document.write( "2001             9,361<BR>\n" );
document.write( "2002             9,972<BR>\n" );
document.write( " </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #234363 by </B><A HREF=/tutors/aboutme.mpl?userid=Fombitz><B>Fombitz(32388)</B></A><img src=\"/images/stars/stars-13.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=Fombitz><IMG SRC=http://www.algebra.com/images/aboutme-small.gif BORDER=0 alt=\"About Me\" VALIGN=MIDDLE></A>&nbsp;<IMG SRC=http://www.algebra.com/cgi-bin/show-face.mpl?user=Fombitz><BR>You can <A HREF=\"/cgi-bin/embed-solution.mpl?show=1&solution=234363\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> Open up EXCEL.<BR>\n" );
document.write( "Make one column with the year data.<BR>\n" );
document.write( "Right next to it make another column with the total data.<BR>\n" );
document.write( "Highlight the data.<BR>\n" );
document.write( "Click on the Chart Wizard, pick scatter plot.<BR>\n" );
document.write( "Once the chart is complete, right click on the data point and choose Add trendline. <BR>\n" );
document.write( "Choose Linear.<BR>\n" );
document.write( "In the Options tab, choose Display equation .... and Display <IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=R%5E2 ALIGN=MIDDLE  ALT=\"R%5E2\"   DISABLED_style= \"max-width:90%; height:auto;\" > value.  </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );