Calculating Forecast Accuracy And Precision

In this Excel tutorial you will teach yourself how to calculate forecast accuracy and precision. To do it you need data table to calculate accuracyColumn A is Prediction. Actual value is in column B. In C column you will calculate forecast accuracy using Excel formula.Formula you need here is =IF($A2<$B2;$A2/$B2;$B2/$A2). Copy it and paste to C2 column. Next drag and drop it down to calculate other values as well.

Final data table looks like here:

accuracy calculated

This way you calculated forecast accuracy and precision in Excel. Thanks to it you can see how how accurate your forecasts were.

Tip: You can use simpler formula: =MIN($A1:$B1)/MAX($A1:$B1)

See also how to use Excel FORECAST function for forecast calculations..

Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell