Hi,
I have two sets of data ( say predicted and actual) that I would like
to compare and come up with a "score" that tells me how close the
predicted was to the actual data.
The data I have has 48 intervals (for each half hour in a day).
I tried to get compare the data sets using Root Mean Square method, but
I am not very confident that it is the best way to do it.
Is there any other way I can do this. I am using Excel for the
analysis.
Re: Leading zeroes, text/numbers, import/export ... >If I want to do arithmetic, use a numeric format.... >> We import into Excel and sometimes later export to ... >> can compare them from one list or sheet to another, ... Then, when comparing to other lists or exporting, ... (microsoft.public.excel.misc)
Re: Opening Office 2003 files in a separate window ... I was getting confused yesterday with the behavior of Excel,...Excel kinda does it's own thing with ... >> OR...you can even compare docs by using the Compare feature to compare ... >> Dian D. Chapman, Technical Consultant ... (microsoft.public.office.misc)
Re: Open two excel windows side by side ...Compare side-by-side is additional not a replacement. ... Microsoft MVP - Excel... >I am trying to open two excel windows side by side. ... Previously, I had office XP on my computer and when I had a> excel file open and opened another, a separate excel window would open. ... (microsoft.public.excel.misc)
Re: Thursdays dates between 04/16/06 - 05/15/06 ... Your version won't work in Excel for Mac or any PC that uses that date ... ROWSrather than ROW--Regards,SandyIn Perth, the ancient capital of ... (microsoft.public.excel.worksheet.functions)
EXCEL, VSTO: Fastest way to access multiple cells ... Can anybody help clarifying my issues? ... In one part of my Excel/VSTO application, I have to compare values of cells ... for every change/call to a member/method of a Range ... to the Excel COM Server, ... (microsoft.public.office.developer.vba)
