Lesson 13

Part III (Continuation of Spreadsheet, continued)

In this part, you will learn how to create a scatter plot and then fit a regression curve to it. Many times people will collect data to help them try to predict the future. Once they have enough data, they can plot the data and try to fit a curve to it. This curve is called a regression curve.

1. Creating a Scatter Plot

2. Experimenting with Regression Curves

3. Experimenting with Regression Curves (continued)

Part III


Practice Exercises

  1. Please open the eActivity application.
  2. Open the eActivity named L13_PartIII_a in the Lesson13 folder.
  3. Within the eActivity, expand the Spreadsheet strip and create a scatter plot using columns A and B.
  4. Get a screen capture and paste it into your Lesson13 document (under a title of PART III).
  5. We should zoom the data. Open the View menu and select Zoom Box. Click and drag a box about your scatter plot. Your box will become the new window size.
  6. Get a screen capture. Add two blank spaces following the first screen capture and then paste this one.
  7. Draw a regression curve that you think best fits the data. Select your regression curve so that its equation shows in the status bar.
  8. Get a screen capture. Add two blank spaces following the second screen capture and then paste this one.
  9. You do not have to save this eActivity!

Part IV

Reflection Exercises

You have just completed the thirteenth lesson in ClassPad 101. Excellent. Please take a few moments to copy and paste the following four questions at the end of your Lesson13 document and answer them.

  1. Approximately how long did it take you to complete this lesson?
  2. Which activity did you find particularly useful?
  3. Did you find any part of this activity difficult to follow? If so, which part? Also, how did you overcome the difficulty?

Assessment 13: Continuation of Spreadsheet