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

Reply via email to