How does a data compared to future dated output information from a program that is changed, contrary to the race that they use the current files for input? The customer did not want to mask dates on the output data to allow compares.
Compare a single data to a dated output
Those are two sets of data that you are dealing with, the current data and the data you are projecting to have in some time to come, and the best way to compare such data will be by the use of an ms excel application.
-
You will need to open the Microsoft Excel program.
-
And then in a heading for your first (input) variable in cell A1, type in a heading for the first set of data that you want to compare.
-
You will again need to type in a heading for your second comparison data cell B1.
-
After that you will enter your data down columns A and B, and then save the file.
-
Once you have done that you need to enter a formulae that will calculate the standard deviations for each mean of the data you have entered, and then you will be able to figure out how the data has been spread.
The formula for the standard deviation is as follows:
=STDEV(RANGE)
Regards
Thompson Locker
Â
