Excel Formulas - Adjustable Bins

Bin Size: 10 Student Grades Student 1 66 Student 2 82 Student 3 11 Student 4 78 Student 5 61 Student 6 69 Student 7 58 Student 8 83 Student 9 65 Student 10 53 Student 11 77 Student 12 77 Student 13 56 Student 14 87 Student 15 81 Student 16 73 Student 17 53 Student 18 18 Student 19 58 Student 20 70 Student 21 30 Student 22 68 Student 23 49 Student 24 62 Student 25 14 Student 26 71 Student 27 75 Student 28 20 Student 29 66 Student 30 12 Student 31 81 Student 32 10 Student 33 20 Student 34 76 Student 35 70 Student 36 10 Student 37 76 Student 38 69 Student 39 47 Student 40 89 Student 41 79 Student 42 100

Lower Upper Freq 1 10 3 11 20 6 21 30 3 31 40 3 41 50 4 51 60 9 61 70 13 71 80 12 81 90 11 91 100 3 101 110 0 111 120 0 121 130 0 131 140 0 141 150 0 151 160 0 161 170 0 171 180 0 181 190 0 191 200 0 201 210 0 211 220 0 221 230 0 231 240 0 241 250 0 251 260 0 261 270 0 271 280 0 281 290 0 291 300 0 301 310 0 311 320 0 321 330 0 331 340 0 341 350 0 351 360 0 361 370 0 371 380 0 381 390 0 391 400 0 401 410 0 411 420 0

13 12 11 10 9 8 7 6 5 4 3 10

20

30

40

50

60

70

80

90

100

Note: The chart uses named formulas (Catego Frequencies) in its SERIES formula

Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student Student

43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67

60 34 81 76 99 90 95 48 47 65 54 57 78 69 89 61 54 82 9 28 37 85 40 72 27

421 431 441 451 461 471 481 491 501 511 521 531 541 551 561 571 581 591 601 611 621 631 641 651 661 671 681 691 701 711 721 731 741 751 761 771 781 791 801 811 821 831 841 851 861

430 440 450 460 470 480 490 500 510 520 530 540 550 560 570 580 590 600 610 620 630 640 650 660 670 680 690 700 710 720 730 740 750 760 770 780 790 800 810 820 830 840 850 860 870

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

871 881 891 901 911 921 931 941 951 961 971 981 991

880 890 900 910 920 930 940 950 960 970 980 990 1000

0 0 0 0 0 0 0 0 0 0 0 0 0

80

90

100

med formulas (Categories and ES formula