Spreadsheet Activity

For this activity, you will review how a spreadsheet can be used to plot data, determine the slope and intercept of regression line, and draw the regression line. The instructions for creating the scatter graph and regression line are in Section 4.25. However, for this activity, we are solving for the problem presented in Section 4.4. The supporting spreadsheet files (links above to both Excel and Open Office versions) include a tab titled "Starter File", which contains everything you need to get started on the activity. Once you have worked through the activity, you can click on the "Solution File" tab to see how your finished spreadsheet should look.