Predict Performance Using MA Forecasting in Google Sheets

4.0
5 個評分
提供方
Coursera Project Network
在此指導項目中,您將:

Identify use cases for forecasting trends with moving averages (MA).

Build two MA Forecasting models in a spreadsheet.

Visualize the forecast output and test the MA models for accuracy.

Clock2 hours
Intermediate中級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

There are many times when having a crystal ball might be useful and it’s natural to leverage trusted predictions of future outcomes to prepare for the future and make strategic decisions. Predicting Performance is especially key to decision-making and risk management. In this project, you will build prediction skills with Moving Averages or MA. MA is classic method of time series decomposition most often used with financial predictions. As you work with MA you will also learn how to evaluate and choose the highest performing model to make the most accurate predictions. You will build your skill as we work side-by-side in the free-to-use software Google Sheets. By the end of this project, you will understand use cases for conducting MA trend forecasts in your workplace, be able to conduct MA forecasting in any spreadsheet software, and be able to confidently select the best performing forecast model to enable decision-making. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

您要培養的技能

Trend AnalysisPredicting PerformanceBusiness IntelligenceModel SelectionFinance

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  1. Visualize the forecast output and test the MA models for accuracy.

  2. Identify use cases for MA forecasting and import data into Google Sheets.

  3. Build MA Forecasting models in Google Sheets.

  4. Create and visualize MA output and test the models for accuracy.

  5. Evaluate the test statistics and choose the winning model.

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心