| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How many Standard Deviations above and below the mean each number is.
I have a list of numbers in A1:A20 that has a STDEV of 27.6. I need a
formula that I can copy down that will tell me how many STDEV's above and below each number is. Thanks in advance PJ. 13 123 24 35 35 46 46 57 57 58 6 79 79 79 78 57 46 35 24 32 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plotting means and standard deviations I already have | Charts and Charting in Excel | |||
| Calculate 2 Standard Deviations | Excel Worksheet Functions | |||
| Formula to determine number of Standard Deviations based on % of population | Excel Worksheet Functions | |||
| Graph Standard Deviations | Excel Discussion (Misc queries) | |||
| Standard deviations in Excel | Charts and Charting in Excel | |||
Threaded Mode
