| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative Standard Deviations?
I have a spreadsheet with 52 data points on which I'm trying to identify a +1
standard deviation and a -1 standard deviation. When I use the Excel 2003 std dev function to calculate the info, I get a negative standard deviation on the -1 calculation. Not being a stats wizard, I think it's mathematically impossible for a standard deviation to be negative. I am assuming I have a error in my data or formula. My data has a wide variation from a few around 1500 to many 0 and some data in between. Any thoughts would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many Standard Deviations above and below the mean each number is. | Excel Worksheet Functions | |||
| Plotting means and standard deviations I already have | Charts and Charting in Excel | |||
| Calculate 2 Standard Deviations | Excel Worksheet Functions | |||
| Graph Standard Deviations | Excel Discussion (Misc queries) | |||
| Standard deviations in Excel | Charts and Charting in Excel | |||
Threaded Mode
