In this post, we are going to cover how to plot a time series in excel. This post helps you to in plotting Time Series In Excel. Without further delay let’s jump into our main topic. Time Series is nothing but the numerical values of statistical indicators placed in chronological order. We use time series … Read more

SMAPE is also known as “Symmetric Mean Absolute Percentage Error”. It is used to predict the accuracy of measures on the basis of percentage error. In this tutorial, we are going to how we can calculate SMAPE in Excel with just 3 easy steps. SMAPE = (1/n) * Σ(|forecast – actual| / ((|actual| + |forecast|)/2) … Read more

Have you ever heard of Forecasting Accuracy? Forecasting Accuracy is nothing but the closeness of actual quantity to a particular quantity. Here the actual quantity is often called True Value. The concept of Mean Absolute Percentage Error (MAPE) is more focused on Forecasting Accuracy. We can measure the forecasting accuracy by using the MAPE model. … Read more

Mean Squared Error (MSE) or Mean Square Deviation (MSD) is used to determine the measure of the average of the square of error for any model. In this tutorial, we are going to see how you can calculate the Mean Squared Error or Mean Squared Deviation In Excel by using just simple 3 steps. As … Read more