#### JohnnyCash

##### New Member

- Joined
- Dec 20, 2016

- Messages
- 1

I have collected data in excel that i will be using for my thesis research. For many of the data sets, the standard deviation in the third interval is above 100 and below 0, though no numbers in any of these sets are below 0 or above 100.

For example,

The mean of one data set is 40.33 and the standard deviation is 21.29...meaning its extends from about -24-104, but this makes no sense to me as no number is >100 or <0. I want to create a normal distribution graph, using the data points I collected, in order to find data points that are at the extremities of the distribution to compare them. I have looked online for days and have tried everything. Is this an input error or does -24-104 make sense and if it does how? I just want a standard deviation that can be multiplied 3 times and is still less than the mean so to have a positive range.