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

Sorting data
 

I understand how you want the outputs to look what does the input look like?

"Eric" wrote:

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