How to determine the stability?
Thank everyone very much for suggestions
After using the function confidence (95%, 2 S.D. 100 data samples)
there are the result, 0.133, 0.155, 0.137.
Does it mean that data under column A will be the most stable?
Do they compare like with like? since they are different set of numbers?
Does anyone have any suggestions?
Thank everyone very much for any suggestions
Eric
"Joel" wrote:
Try confidence (see spreadsheet help). Use the 95% and compare rresults.
"Eric" wrote:
Does anyone have any suggestions on how to select the most stability among 3
lists?
If I use STDEV(), I cannot compare which one is the most stability with
different scaling.
Does anyone have any suggestions?
Thank everyone for any suggestions
Eric
"Gary''s Student" wrote:
Consider the standard deviation
=STDEV()
--
Gary''s Student - gsnu200812
"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
|