IF_vs_VLOOKUP by uke86868

VIEWS: 6 PAGES: 4

									Stats Midterm Exam Grades

Normally distributed grades
Mean              75              Hold these cells as absolute references (eg. $B$4)
Stdev              9

Letter grade cutoff scores
Letter     Percentile     Score
A               0.90       86.5   =NORMINV(percentile, mean, std dev)
B               0.80       82.6   Anyone with a score between 82.6 and
C               0.70       79.7   86.4999 gets a B.
D               0.60       77.3
F               0.00       32.2

    Score   Grade    VL_Grade     Summary measures for selected variables
       72   F        F                                         Score
       95   A        A                Count                  100.000
       83   B        B                Mean                    79.390
       85   B        B                Median                  79.000
       65   F        F                Standard deviation       7.264
       82   C        C
       84   B        B
       74   F        F
                                                                           Histogram for Score
       74   F        F
       82   C        C
                                         50
       81   C        C
                                         45
       75   F        F
                                         40
       78   D        D                   35
       78   D        D                   30
       72   F        F                   25
       73   F        F                   20
       75   F        F                   15
                                         10
       79   D        D
                                          5
       72   F        F
                                          0
       75   F        F
                                                  <=60            60- 70             70- 80      80
       77   F        F
                                                                                   Category
       71   F        F
       78   D        D
       83   B        B
       84   B        B                   Frequency table for Score
       71   F        F
       81   C        C                           Upper limit    Category Frequency
       82   C        C                                   60        <=60          0
       79   D        D                                   70       60- 70        10
       71   F        F                                   80       70- 80        47
       73   F        F                                   90       80- 90        34
       89   A        A                                              >90          9
       74   F        F
       75   F        F
       93   A        A
       74   F        F
       88   A        A
83   B   B
90   A   A
82   C   C
79   D   D
62   F   F
73   F   F
88   A   A
76   F   F
76   F   F
76   F   F
80   C   C
84   B   B
84   B   B
91   A   A
70   F   F
76   F   F
74   F   F
68   F   F
80   C   C
87   A   A
92   A   A
84   B   B
79   D   D
80   C   C
91   A   A
74   F   F
69   F   F
88   A   A
84   B   B
83   B   B
87   A   A
82   C   C
72   F   F
97   A   A
88   A   A
70   F   F
83   B   B
92   A   A
94   A   A
63   F   F
83   B   B
81   C   C
84   B   B
78   D   D
84   B   B
91   A   A
78   D   D
71   F   F
77   F   F
78   D   D
70   F   F
86   B   B
79   D   D
70   F   F
75   F   F
80   C   C
75   F   F
77   F   F
74   F   F
87   A   A
78   D   D
85   B   B
70   F   F
VLOOKUP Table
Percentile Score    Letter
    0.00     32.2   F
    0.60     77.3   D
    0.70     79.7   C
    0.80     82.6   B
    0.90     86.5   A




80- 90      >90

								
To top