Predict Performance Using MA Forecasting in Google Sheets

4.6
별점
12개의 평가
제공자:
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영어
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.

요구 사항

Some familiarity with spreadsheet software is helpful, but not required.

개발할 기술

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.

안내형 프로젝트 진행 방식

작업 영역은 브라우저에 바로 로드되는 클라우드 데스크톱으로, 다운로드할 필요가 없습니다.

분할 화면 동영상에서 강사가 프로젝트를 단계별로 안내해 줍니다.

자주 묻는 질문

자주 묻는 질문

궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.