How to determine the stability?
Yours is perhaps a different sigma from that usually used. The percentage
between the -3 sigma and +3 sigma points is about 99.73%
Try =NORMSDIST(3)-NORMSDIST(-3)
--
David Biddulph
"Joel" wrote in message
...
You can use Stdev - Standard Deviation as a simple method.
A better method is to use NORMDIST which uses the Standard Deviation to
calculate the width of the Normalized curve. The width of the normalized
curve is oftern refer to by the Term sigma. 3 sigma would indicate 95
percent of the results where inside th enormalized curve. 6 sigma is
something like 98%.
"Eric" wrote:
There are three lists of numbers under column A,B,C
Is there any build-in function to determine the stability within change?
For example,
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
On above list, there is no change at all, which is considered very
stable.
Does anyone have any suggestions on following lists?
Thanks in advance for any suggestions
Eric
Under column A:
1064 1099 1116 1154 1105 1118 1092 1089 1087 1055 1057 1058 967 923 874
845
864 950 1024 971
Under column B:
845 840 887 863 865 886 851 843 825 805 818 792 711 687 677 642 642 640
681
702
Under column C:
1064 1065 1100 1129 1098 1120 1086 1084 1070 1022 1034 1003 921 883 862
843
843 882 923 905
|