## Exercise #7 (VIDEO)

**Due Thu, Oct 3**

This exercise will be similar to Exercise #6 but instead of using the “Data Analysis” TookPak add-in we will calculate the statistics using basic Excel functionality. Here’s what you need to do, step by step:

**Step 1.** Download the Excel worksheet that I presented in class on Tuesday: CalcPearsonRegression

**Step 2.** In place of the 5 rows of data (x and y), you will need to insert your 30 property records (insert 60 or 90 if you have them and want to use a larger data set). Specifically, you want to insert Total Property Values as the dependent (y) variable and Total Finished Sq Ft as the independent (x) variable.

**Step 3.** Use the formulas I created, or create your own formulas, to calculate the Pearson Correlation Coefficient, the Slope of the Regression Line and the Y-Intercept.

**Step 4.** Format a single page, print the page and turn in during class on Thursday.

Here’s a **YouTube video** (this is the newer version with higher resolution for better viewing) that takes you through the exercise step by step: **http://youtu.be/Jg4Fr4FITmo**