timeserieslab

timeserieslab - Excel Lab: Smoothing and Time-Series...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Excel Lab: Smoothing and Time-Series Prediction Part I. Setup A. Be sure youve got the data analysis tool pack added in Under tools in the main tool bar at the top of the screen see if the option data analysis is available (it should be at the bottom of the list). If data analysis is not there do the following: 1. Under tools select add-ins 2. Click on the box for analysis toolpak 3. Click OK 4. Go back and check to see that data analysis is now an option under tools. B. Purpose of Todays lab In todays lab were going to learn how to get Excel to perform smoothing and prediction with time series data. C. Open the data for Todays Lab The data set for todays lab is titled cars data for time series lab, and is on our class webpage. Copy and paste the YEAR and PRIME columns into a new sheet and save it. We will only work with these two variables - the prime interest rate and time. You should have a time series of 64 data points. The variable prime rate is collected quarterly....
View Full Document

This note was uploaded on 01/19/2012 for the course ECN 422 taught by Professor Peterschuhmann during the Spring '11 term at UNC.

Page1 / 3

timeserieslab - Excel Lab: Smoothing and Time-Series...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online