Exercise #7 (VIDEO)
October 2, 2013
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