Forecasting Models with Excel | Data Science Online Course by Udemy

Development Online Course by Udemy, On Sale Here

Learn main forecasting models and methods from basic to expert level through a practical course with Excel.

An excellent training about Data Science

Forecasting Models with Excel

Full Course Content Last Update 06/2018Learn forecasting models through a practical course with Microsoft Excel using S & P 500 Index ETF prices historical data. It explores main concepts from basic to expert level which can help you achieve better grades, develop your academic career, apply your knowledge at work or do your business forecasting research. All of this while exploring the wisdom of best academics and practitioners in the field. Become a Forecasting Models Expert in this Practical Course with ExcelEstimate simple forecasting methods such as arithmetic mean, random walk, seasonal random walk and random walk with drift. Evaluate simple forecasting methods forecasting accuracy through mean absolute error, root mean squared error scale-dependent and mean absolute percentage error, mean absolute scaled error scale-independent metrics. Approximate simple moving averages and exponential smoothing methods with no trend or seasonal patterns such as Brown simple exponential smoothing method. Estimate exponential smoothing methods with only trend patterns such as Holt linear trend, exponential trend, Gardner additive damped trend and Taylor multiplicative damped trend methods. Approximate exponential smoothing methods with trend and seasonal patterns such as Holt-Winters additive, Holt-Winters multiplicative and Holt-Winters damped methods. Select exponential smoothing method with lowest Akaike, corrected Akaike and Schwarz Bayesian information loss criteria. Identify Box-Jenkins autoregressive integrated moving average model integration order through level and differentiated first order trend stationary time series deterministic test and Phillips-Perron unit root test. Recognize autoregressive integrated moving average model autoregressive and moving average orders through autocorrelation and partial autocorrelation functions. Estimate non-seasonal autoregressive integrated moving average models such as random walk with drift, differentiated first order autoregressive, Brown simple exponential smoothing, simple exponential smoothing with growth, Holt linear trend and Gardner additive damped trend models. Approximate seasonal autoregressive integrated moving average models such as seasonal random walk, seasonal random trend and seasonally differentiated first order autoregressive models. Choose autoregressive integrated moving average model with lowest Akaike, corrected Akaike and Schwarz Bayesian information loss criteria. Assess highest forecasting accuracy autoregressive integrated moving average model residuals or forecasting errors white noise requirement through Ljung-Box lagged autocorrelation test. Become a Forecasting Models Expert and Put Your Knowledge in PracticeLearning forecasting models is indispensable for business or financial data science applications in areas such as sales and financial forecasting, inventory optimization, demand and operations planning, and cash flow management. It is also essential for academic careers in data science, applied statistics, operations research, economics, econometrics and quantitative finance. And its necessary for business forecasting research. But as learning curve can become steep as complexity grows, this course helps by leading you step by step using S & P 500 Index ETF prices historical data for forecast modelling to achieve greater effectiveness. Content and OverviewThis practical course contains 42 lectures and 8 hours of content. Its designed for all forecasting models knowledge levels and a basic understanding of Microsoft Excel is useful but not required. At first, youll learn how to perform forecasting models operations using built-in functions and array calculations. Next, youll learn how to do optimal parameter estimation or fine tuning and linear regression calculation using Microsoft Excel Add-ins. Then, youll define simple forecasting methods such as arithmetic mean, random walk, seasonal random walk and random walk with drift. Next, youll evaluate simple methods forecasting accuracy through scale-dependent and scale-independent error metrics. For scale-dependent metrics, youll define mean absolute error and root mean squared error. For scale-independent metrics, youll define mean absolute percentage error and mean absolute scaled error. Next, youll define simple moving averages and exponential smoothing methods. For exponential smoothing methods with no trend or seasonal patterns, youll define Brown simple exponential smoothing method. For exponential smoothing methods with only trend patterns, youll define Holt linear trend, exponential trend, Gardner additive damped trend and Taylor multiplicative damped trend methods. For exponential smoothing methods with trend and seasonal patterns, youll define Holt-Winters additive, Holt-Winters multiplicative and Holt-Winters damped methods. After that, youll select exponential smoothing method with lowest information loss criteria. For information loss criteria, youll define Akaike, corrected Akaike and Schwarz Bayesian information loss criteria. Later, youll eva

Udemy is the leading global marketplace for learning and instruction

By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.

Study anytime, anywhere.

START HERE