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


Justin

Justin Holman is CEO of Aftermarket Analytics, where he leads efforts to develop cutting edge sales forecasting and inventory optimization technology for the Automotive Aftermarket. Prior to joining Aftermarket Analytics, Justin managed corporate consulting for the Strategy & Analytics division at MapInfo Corporation, leading major projects for retail clients including The Home Depot, Darden Restaurants, Bridgestone-Firestone, Sainsbury’s and New York & Company. Before that, Justin served as Vice President of Software Development at LogicTools, now part of IBM's supply chain application software group. Justin holds a B.A. from Claremont McKenna College, a Ph.D. from the University of Oregon and an Executive Management certificate from Northwestern University's Kellogg School of Management.

6 Comments

  • Reply
    justinholman 11 years ago

    Oops, I think I inadvertently published a low-res video. I will re-record and post a higher-res version.

  • Reply
    justinholman 11 years ago

    New video is rendering…it’s been running for about 45 min and progress bar says 45.1%. I have to attend a meeting at 6pm so hopefully I will have it posted before then.

  • Reply
    justinholman 11 years ago

    New video has been posted.
    Here’s the link to the old one (low res): http://youtu.be/VvyTwkGSj8o
    And, here’s a link to the new one (higher res): http://youtu.be/Jg4Fr4FITmo

  • Reply
    Anders 11 years ago

    I’m unable to acces my data because it was saved on the school server. Will we be able to do this assignment when it’s back running and just email it to you?

  • Reply
    Exercise #9 | Inferential Statistics and Problem Solving 11 years ago

    […] your previously completed correlation analysis (see Exercise #7) to identify other key variables that may improve the regression […]

Leave a Reply