使用 MS Excel 进行时间序列分析和预测
Time Series Analysis and Forecasting with MS Excel
- 1. Introduction
- 1. Introduction to Project
- 2. Forecasting with Excel
- 2. Scenario
- 1. 21st Century in Low Emission Scenario
- 2. 21st Century in Low Emission Scenario Continue
- 3. 21st Century in Medium Emission Scenario
- 4. 21st Century in Medium Emission Scenario Continue
- 5. 21st Century in High Emission Scenario
- 6. 21st Century in High Emission Scenario Continue
- 3. Weighted Average
- 1. Calculating Annual Minimum Temperature Average LES
- 2. Weighted Average Maximum Temperature LES
- 3. Weighted Average Minimum Temperature
- 4. Weighted Average Temperature 2A and 2B
- 5. Weighted Average Max Temperature MES
- 6. Weighted Average Minimum Temperature HES
- 7. Weighted Average Max Temperature HES
- 4. Exponential Moving Average Analysis
- 1. Exponential Average Minimum Temperature Best Scenario
- 2. Exponential Average Maximum Temperature Best Scenario Continue
- 3. Exponential Average Minimum Temperature Normal Scenario
- 4. Exponential Average Maximum Temperature Normal Scenario Continue
- 5. Exponential Average Minimum Temperature Worst Scenario
- 6. Exponential Average Maximum Temperature Worst Scenario Continue
- 5. Regression
- 1. Correlated MES Min and Max Temperature
- 2. Correlated HES Min and Max Temperature
- 3. Simple Regression LES and HES Max Temperature
- 4. Simple Regression MES and Max Temperature
- 5. Simple Regression HES and Max Temperature
- 6. Multiple Regression Range Prediction