\relax 
\@writefile{toc}{\contentsline {section}{\numberline {1}Introduction}{1}}
\@writefile{toc}{\contentsline {section}{\numberline {2}Opening a data file}{1}}
\@writefile{lof}{\contentsline {figure}{\numberline {1}{\ignorespaces Opening a data file from Microsoft Excel.}}{2}}
\newlabel{fig:excel_open_screen}{{1}{2}}
\@writefile{lof}{\contentsline {figure}{\numberline {2}{\ignorespaces Specifying which file to open. You may have to choose ``All Readable Documents'' from the ``Enable'' pulldown menu before you can access a plain-text file.}}{2}}
\newlabel{fig:open_dialog}{{2}{2}}
\@writefile{lof}{\contentsline {figure}{\numberline {3}{\ignorespaces The first of three dialog boxes.}}{3}}
\newlabel{fig:text_import_dialog_1}{{3}{3}}
\@writefile{lof}{\contentsline {figure}{\numberline {4}{\ignorespaces The second of three dialog boxes.}}{3}}
\newlabel{fig:text_import_dialog_2}{{4}{3}}
\@writefile{lof}{\contentsline {figure}{\numberline {5}{\ignorespaces The third of three dialog boxes.}}{4}}
\newlabel{fig:text_import_dialog_3}{{5}{4}}
\@writefile{lof}{\contentsline {figure}{\numberline {6}{\ignorespaces What you get.}}{4}}
\newlabel{fig:data_in_window}{{6}{4}}
\@writefile{toc}{\contentsline {section}{\numberline {3}Making a plot}{5}}
\@writefile{lof}{\contentsline {figure}{\numberline {7}{\ignorespaces Click on the Charts tab in the Ribbon, then select Scatter as the type of plot.}}{6}}
\newlabel{fig:scatter_plot_screen}{{7}{6}}
\@writefile{lof}{\contentsline {figure}{\numberline {8}{\ignorespaces This is what you get.}}{6}}
\newlabel{fig:scatter_plot_result}{{8}{6}}
\@writefile{toc}{\contentsline {section}{\numberline {4}Adding error bars}{7}}
\@writefile{lof}{\contentsline {figure}{\numberline {9}{\ignorespaces Click on the Chart Layout tab next to the Charts tab in the Ribbon, then select Error Bars. To specify the value of your error bars, as opposed to letting Excel decide what they should be, go straight to Error Bar Options.}}{7}}
\newlabel{fig:error_bars_screen}{{9}{7}}
\@writefile{lof}{\contentsline {figure}{\numberline {10}{\ignorespaces Even though Excel puts error bars on the independent variable (X), you don't get to specify them yet.}}{8}}
\newlabel{fig:format_error_bars_window}{{10}{8}}
\@writefile{lof}{\contentsline {figure}{\numberline {11}{\ignorespaces To set the X error bars, click on one of the data points in your plot. That will bring up this dialog box, which now contains a tab at the top that will allow you to adjust either the X or the Y error bars. To suppress the X error bars, choose Fixed Value, and set it to zero.}}{8}}
\newlabel{fig:x_error_bars_window}{{11}{8}}
\@writefile{lof}{\contentsline {figure}{\numberline {12}{\ignorespaces This is what you get.}}{9}}
\newlabel{fig:x_error_bars_result}{{12}{9}}
\@writefile{toc}{\contentsline {section}{\numberline {5}Adding a theory curve}{10}}
\@writefile{lof}{\contentsline {figure}{\numberline {13}{\ignorespaces To create a new data set, first enter the first X-value in a particular cell, in this case zero in cell c2. This will ``seed'' a new series of independent variables. Then choose Fill $\rightarrow $ Series from the Edit menu. This will bring up a dialog box allowing you to specify the parameters of the series.}}{10}}
\newlabel{fig:fill_series_screen}{{13}{10}}
\@writefile{lof}{\contentsline {figure}{\numberline {14}{\ignorespaces Choose a Step value of 0.1, a Stop value of 10 (these should be self-explanatory), and check the Columns radio button under Series in. This last step ensures that your series fills cells downward instead of accross, which is the default.}}{10}}
\newlabel{fig:fill_series_dialog}{{14}{10}}
\@writefile{lof}{\contentsline {figure}{\numberline {15}{\ignorespaces After you have defined the first point in your theory curve by typing your formula (=0.5*c2+3.5) into cell d2, select the whole column you want your theory curve to be in, and choose Fill $\rightarrow $ Down. This will propagate your formula through all the cells in your selection, updating the dependent-variable reference c2 to c3, c4, etc. as appropriate.}}{11}}
\newlabel{fig:fill_down_screen}{{15}{11}}
\@writefile{lof}{\contentsline {figure}{\numberline {16}{\ignorespaces Now you should have your theory function evaluated in column D.}}{12}}
\newlabel{fig:fill_down_result}{{16}{12}}
\@writefile{lof}{\contentsline {figure}{\numberline {17}{\ignorespaces Now that you have defined a table with the values for your theory curve, it is time to add it to your plot using Add Data. Control-click on your plot (right-click for you Windows users), and choose Select Data...}}{13}}
\newlabel{fig:select_data_screen}{{17}{13}}
\@writefile{lof}{\contentsline {figure}{\numberline {18}{\ignorespaces Click Add, then select the appropriate columns for the X and Y values of your theory function.}}{14}}
\newlabel{fig:select_data_window}{{18}{14}}
\@writefile{lof}{\contentsline {figure}{\numberline {19}{\ignorespaces This is the result. You can clean up the formatting as you like.}}{15}}
\newlabel{fig:select_data_result}{{19}{15}}
\@writefile{toc}{\contentsline {section}{\numberline {6}Residuals}{16}}
\@writefile{lof}{\contentsline {figure}{\numberline {20}{\ignorespaces Residuals plotting in Excel.}}{16}}
\newlabel{fig:residuals}{{20}{16}}
\@writefile{toc}{\contentsline {section}{\numberline {7}$\mathaccent "0365\relax {\chi }^2$ test}{16}}
\@writefile{lof}{\contentsline {figure}{\numberline {21}{\ignorespaces Calculating the reduced chi squared is simple, once you have the residuals.}}{17}}
\newlabel{fig:chi_squared_result}{{21}{17}}
\@writefile{toc}{\contentsline {section}{\numberline {8}Automated fitting}{17}}
\@writefile{lof}{\contentsline {figure}{\numberline {22}{\ignorespaces To perform a linear least-squares fit, click on the ``Trendline'' button in the ``Chart Layout'' ribbon. You will want to choose ``Trendline Options...'' from the pulldown menu.}}{18}}
\newlabel{fig:trendlines_screen}{{22}{18}}
\@writefile{lof}{\contentsline {figure}{\numberline {23}{\ignorespaces Under Options, select ``Display equation on chart.'' You can also have it display the R-squared value of the fit, which is not the same thing as the reduced $\chi ^2$ but serves a similar purpose, \emph  {i.e.}\ it provides a measure of the goodness of the fit.}}{19}}
\newlabel{fig:format_trendline_window}{{23}{19}}
\@writefile{lof}{\contentsline {figure}{\numberline {24}{\ignorespaces This is what you get.}}{19}}
\newlabel{fig:trendline_result}{{24}{19}}