E
Eric
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
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