Time Series analysis in Excel with Python & AI
- Gain skills in exploratory analysis, including understanding trends, seasonality, and cyclic patterns, and visualizing data through various plots.
- Learn to use ARIMA models for predictive insights, including model parameter selection and application to stock price prediction, and apply different exponential smoothing methods for sales forecasting.
- Evaluate forecasting accuracy with metrics like RMSE, MAPE, and AIC/BIC, and understand how to handle common data issues like missing values, outliers, and choose between ARIMA and exponential smoothing based on forecasting needs.