Local PR excel computations example by k01nsY8

VIEWS: 0 PAGES: 2

									    ID       CogAT       ELL                      LPR    NPR
     8        121         0                       0.98   91
    10        114         0                       0.93   81
     3        111         0                       0.90   75
    15        107         0                       0.84   67
     5        105         0                       0.80   62
    11        100         0                       0.68   50
    16         97         0                       0.59   43
    18         93         0                       0.48   33
     1         92         0                       0.45   31
    17         86         0                       0.28   19
     2         85         0                       0.26   17
    20         78         0                       0.12    8
    12         74         0                       0.07    5
     6        102         1                       0.73   55
     9         95         1                       0.54   38
     4         90         1                       0.39   27
    14         88         1                       0.33   23
    19         84         1                       0.23   16
    13         81         1                       0.17   12
     7         72         1                       0.05    4


 Mean =       13.4
  SD =        93.8


Getting Rank order
1. Select data to be sorted (all columns!)
2. Data menu --> Sort
3. My data has headers?
4. Sort by column (drop down menu) "CogAT"

Getting Local Percentile Ranks
1. Get mean - use "average" function
2. Get Standard Deviation (use" STDEV"function.
3. Insert Mean & SD in" NormDist" function
                                                                    Within
    ID       CogAT       ELL                   LPR                  ELL LPR   NPR
     8        121         0                    0.98                  0.95     91
    10        114         0                    0.93                  0.88     81
     3        111         0                    0.90                  0.83     75
    15        107         0                    0.84                  0.75     67
     5        105         0                    0.80                  0.71     62
    11        100         0                    0.68                  0.58     50
    16         97         0                    0.59                  0.49     43
    18         93         0                    0.48                  0.38     33
     1         92         0                    0.45                  0.36     31
    17         86         0                    0.28                  0.22     19
     2         85         0                    0.26                  0.20     17
    20         78         0                    0.12                  0.09      8
    12         74         0                    0.07                  0.05      5
     6        102         1                    0.73                  0.93     55
     9         95         1                    0.54                  0.78     38
     4         90         1                    0.39                  0.61     27
    14         88         1                    0.33                  0.52     23
    19         84         1                    0.23                  0.36     16
    13         81         1                    0.17                  0.25     12
     7         72         1                    0.05                  0.06      4


 Mean =       13.4
  SD =        93.8


Steps
1. Select data to be sorted (all columns!)
2. Data menu --> Sort
3. My data has headers?
4. Sort by column (drop down menu) "CogAT" or, for within group, "ELL"
5. Add level ? (if sorting within ELL)
6. Sort by ("CogAT")

								
To top