# IF_vs_VLOOKUP by uke86868

VIEWS: 6 PAGES: 4

• pg 1
```									Stats Midterm Exam Grades

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

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

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