How-To Compare Data Sets

[GreenWizard]

I'm very new to BI tools and was wondering if there is a quick way compare data sets to determine accuracy.

For example,

I have 4 Columns. Column A shows Actual Temperatures, while Columns B-D show Foretasted Temperatures. I'm wondering if there is a tool for determining which data set (or group of forecasts) was most accurate. See below:


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Actual Temperature[/TD]
[TD]Forecast 1[/TD]
[TD]Forecast 2[/TD]
[TD]Forecast 3[/TD]
[/TR]
[TR]
[TD]81
[/TD]
[TD]55[/TD]
[TD]83[/TD]
[TD]62[/TD]
[/TR]
[TR]
[TD]68[/TD]
[TD]62[/TD]
[TD]67[/TD]
[TD]101[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]101[/TD]
[TD]104[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD]79[/TD]
[TD]71[/TD]
[TD]76[/TD]
[TD]78[/TD]
[/TR]
</tbody>[/TABLE]

Note: Forecast 2 did the best for predicting the Actual forecast.

Thanks so much!

 

[anvg]

Hi
I think there is not a simple quick way to do that.
You can compute a coefficient of determination (https://en.wikipedia.org/wiki/Coefficient_of_determination) between Actual Temperature column and each Forecast columns. Which from those is closest to 1 that you can select for a next work.
Regards,