Project 1: Time Series Analysis

February 9, 2022

Due Tue, Feb 15 at 11:15am

Instructions:

  • You will analyze the price index tracking rent in the Denver Metro area
  • Create a polynomial regression model
    • The model will be used to forecast the Price Index of rent in the Denver Metro area for 2023, 2024 and 2025.
    • There should be 3 separate forecasts, one per year.
  • Prepare a Spreadsheet file
    • You’ll use the spreadsheet to explain your forecast
    • Make it easy to understand and navigate
  • Create a Video
    • You will provide a brief tour of your spreadsheet and explain your analysis.
    • Your video should be approximately 2-3 minutes in length. It’s okay if it’s a little longer or a little shorter.
    • It doesn’t need to be fancy. Just you speaking clearly and explaining your spreadsheet and your forecast.
    • You can use Zoom or some other screen recording setup OR you can simply use your phone’s video recorder.
    • You need to appear on camera, at least for a few seconds.
  • Submit links to your Spreadsheet and your Video
    • Upload your video to YouTube or Google Drive some other hosting location and save the link
    • Share your Google Sheets spreadsheet and save the link
    • Submit both the video link and the Google Sheets link in Bb.
    • Look for the “Time Series Analysis” column in the Bb Grade Center

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.

Leave a Reply