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/
=================================================================
