Sorting data
Hello all,
I am trying to find the # of inputs per month, the mean of the total for
each month and STD of inputs for each month. Then I need to do it for all
the tests for the year.
The data runs from row 2 to row 1500 but will probably more since the end of
the year isn't here yet. My idea is to have it look something like the
following.
Month Year # of Tests 3/8"
February 08 100 99~~ mean
0.5~~Standard
Deviation
March 08 75 80
0.2
Then have at the bottom of the sheet:
year # of tests 3/8"
08 175 90~~~ Avg. of all
tests (175)
0.35~~STD of all
tests (175)
I hope this makes some kind of sense......Any help would be appreciative
Thank you in advance.
Eric
|