Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting data | Excel Worksheet Functions | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
Sorting Data | Excel Discussion (Misc queries) | |||
Sorting Data | Excel Worksheet Functions |