Compare a single data to a dated output

Asked By zarahvasquez 0 points N/A Posted on - 12/07/2011

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.

• Status: Open
• Question Views: 913
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Thompson Locker 10 points N/A #94108

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.

1. You will need to open the Microsoft Excel program.
2. 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.
3. You will again need to type in a heading for your second comparison data cell B1.
4. After that you will enter your data down columns A and B, and then save the file.
5. 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

 

About Thompson Locker

Questions
0

Answers
619

Best Answers
77

• Vote Up 0 Vote Down

• Posted on - 12/17/2011
• Question Category: Misc Databases