At 12:51 PM 7/26/01 +0200, you wrote: >Hi, > >For some stats explaining I need an excel sheet that calculates and graphs >the normal(Bell)-shaped curve of some data set with a given average and a >known stdev. >It would be nice to demonstrate the calculation the chance of occurance of >some given value in relation to the data set. > >Does any one have such an examplesheet? or knows how it is easely done? try a good stat package ... like minitab ... these sorts of things are a "snap" (well, maybe a mouse click) with the proper tools here are a few quickie things ... not all in the best graphics but, they could be say you want to simulate a ND with mu = 100 and sigma = 16 NOOOOO problem mtb> rand 10000 c1; subc> norm 100 16. mtb> dotplot c1 and you get ..:... .::::::::::.. ..:::::::::::::::::.. ...........:::::::::::::::::::::::::.......... +---------+---------+---------+---------+---------+-------C1 25 50 75 100 125 150 here are the desc stats on this batch of 10000 cases MTB > desc c1 Descriptive Statistics: C1 Variable N Mean Median TrMean StDev SE Mean C1 10000 100.15 100.11 100.15 15.97 0.16 Variable Minimum Maximum Q1 Q3 C1 43.02 155.20 89.20 110.89 if you want the p values associated with different possible score values for the theoretical ND with mu = 100 and sigma = 16 ... easy to do ... MTB > pdf c2 c3; SUBC> norm 100 16. MTB > prin c2 c3 Data Display Row IQ prob 1 52 0.0002770 2 53 0.0003335 3 54 0.0003999 4 55 0.0004777 5 56 0.0005683 6 57 0.0006736 7 58 0.0007953 8 59 0.0009352 9 60 0.0010955 10 61 0.0012783 11 62 0.0014857 12 63 0.0017201 13 64 0.0019837 14 65 0.0022788 15 66 0.0026076 16 67 0.0029721 17 68 0.0033744 18 69 0.0038163 19 70 0.0042991 20 71 0.0048242 21 72 0.0053923 22 73 0.0060038 23 74 0.0066586 24 75 0.0073561 25 76 0.0080948 26 77 0.0088731 27 78 0.0096883 28 79 0.0105371 29 80 0.0114156 30 81 0.0123191 31 82 0.0132423 32 83 0.0141792 33 84 0.0151232 34 85 0.0160671 35 86 0.0170034 36 87 0.0179242 37 88 0.0188211 38 89 0.0196858 39 90 0.0205101 40 91 0.0212855 41 92 0.0220041 42 93 0.0226583 43 94 0.0232409 44 95 0.0237457 45 96 0.0241668 46 97 0.0244994 47 98 0.0247399 48 99 0.0248852 49 100 0.0249339 50 101 0.0248852 51 102 0.0247399 52 103 0.0244994 53 104 0.0241668 54 105 0.0237457 55 106 0.0232409 56 107 0.0226583 57 108 0.0220041 58 109 0.0212855 59 110 0.0205101 60 111 0.0196858 61 112 0.0188211 62 113 0.0179242 63 114 0.0170034 64 115 0.0160671 65 116 0.0151232 66 117 0.0141792 67 118 0.0132423 68 119 0.0123191 69 120 0.0114156 70 121 0.0105371 71 122 0.0096883 72 123 0.0088731 73 124 0.0080948 74 125 0.0073561 75 126 0.0066586 76 127 0.0060038 77 128 0.0053923 78 129 0.0048242 79 130 0.0042991 80 131 0.0038163 81 132 0.0033744 82 133 0.0029721 83 134 0.0026076 84 135 0.0022788 85 136 0.0019837 86 137 0.0017201 87 138 0.0014857 88 139 0.0012783 89 140 0.0010955 90 141 0.0009352 91 142 0.0007953 92 143 0.0006736 93 144 0.0005683 94 145 0.0004777 95 146 0.0003999 96 147 0.0003335 97 148 0.0002770 MTB > >With regards > >Wim > > > > >================================================================= >Instructions for joining and leaving this list and remarks about >the problem of INAPPROPRIATE MESSAGES are available at > http://jse.stat.ncsu.edu/ >================================================================= _________________________________________________________ dennis roberts, educational psychology, penn state university 208 cedar, AC 8148632401, mailto:[EMAIL PROTECTED] http://roberts.ed.psu.edu/users/droberts/drober~1.htm ================================================================= Instructions for joining and leaving this list and remarks about the problem of INAPPROPRIATE MESSAGES are available at http://jse.stat.ncsu.edu/ =================================================================