Show your work and explain your process for determining the solution for each of these problems on a word document with the solution given below the problem.
• If Excel was used, please indicate that as well on the word document.
• A word document and/or the Excel Workbook (if used) should be submitted to the Dropbox with labels on the worksheets to indicate which problem is being evaluated.
• All answers should be clearly indicated.
• Written explanation, reasoning, and rationale should use complete sentences.
A time series model is a forecasting technique that attempts to predict the future values of a variable by using only historical data on that one variable. Here are some examples of variables you can use to forecast. You may use a different source other than the ones listed (be sure to reference the website). There are many other variables you can use, as long as you have values that are recorded at successive intervals of time.
• Currency price: XE (http://www.xe.com/currencyconverter/)
• GNP: Trading Economics (http://www.tradingeconomics.com/united-states/gross-national-product)
• Average home sales: National Association of Realtors (http://www.realtor.org/topics/existing-home-sales)
• College tuition: National Center for Education Statistics (https://nces.ed.gov/fastfacts/display.asp?id=76)
• Weather temperature or precipitation: (http://www.weather.gov/help-past-weather)
• Stock price: Yahoo Finance (https://finance.yahoo.com)
Sample Solution