frequency distributions

Sheet1 Data Minimum: 43 52 Maximum: 100 71 69 Bins Frequency CumFreq. CumPct. Binsusingarrayformula 55 55 9 9 0.90% 48.7 82 60 26 35 3.50% 54.4 68 65 88 123 12.30% 60.1 63 70 169 292 29.20% 65.8 78 75 229 521 52.10% 71.5 80 80 236 757 75.70% 77.2 70 85 157 914 91.40% 82.9 55 90 63 977 97.70% 88.6 61 95 18 995 99.50% 94.3 85 100 5 1000 100.00% 100 99 69 72 71 67 85 81 82 43 79 78 66 84 70 72 62 73 81 73 79 72 73 78 68 71 69 74 81 75 79 71 65 71 70 86 74 73 89 75 66 75 93 62 70 76 83 74 66 86 67 76 73 81 86 69 77 76 76 78 80 75 78 86 85 75 62 70 64 82 81 92 69 65 78 60 66 77 69 65 82 66 79 75 79 79 70 74 67 81 62 70 85 58 81 82 100 84 63 62 66 77 69 79 72 62 81 84 70 84 81 72 92 79 68 67 83 77 76 65 70 72 61 82 63 69 80 71 72 75 71 74 60 78 76 76 68 91 64 72 81 84 74 81 92 91 82 85 75 78 73 72 88 68 73 71 76 80 81 69 78 83 71 62 79 70 77 66 64 61 78 81 67 76 80 76 79 78 74 79 81 71 82 87 79 77 77 72 65 83 76 87 63 85 65 64 76 70 81 71 78 82 67 87 75 70 77 67 74 92 71 84 74 78 74 65 74 76 74 86 64 69 72 71 67 68 68 68 75 85 84 77 70 75 79 64 71 61 74 81 66 80 66 73 77 71 72 76 81 71 73 76 70 53 81 77 55 79 77 75 61 64 69 90 75 78 95 93 78 70 71 97 64 67 69 79 87 71 63 74 77 83 71 71 86 86 65 80 70 89 82 79 58 61 77 84 80 73 66 89 65 85 76 84 68 91 72 77 78 69 79 77 73 75 76 80 84 67 59 59 62 87 85 88 84 78 73 72 78 73 80 81 78 73 67 63 81 75 80 77 73 64 84 68 68 68 63 81 74 72 79 72 87 67 72 85 76 68 74 80 74 82 55 80 86 78 77 77 80 73 70 76 72 75 77 87 74 69 69 64 73 81 86 95 63 77 68 79 74 74 62 66 86 69 76 77 85 67 83 65 74 57 63 84 68 75 76 64 68 75 86 77 63 65 82 83 61 81 86 60 76 82 62 88 70 80 75 79 68 82 72 78 79 61 90 75 65 78 79 71 83 73 76 85 68 74 66 71 89 79 77 60 68 63 80 67 70 57 76 80 80 64 58 85 87 80 70 81 80 62 79 84 74 83 60 58 66 77 61 65 74 84 79 72 72 75 60 70 69 70 79 79 72 83 75 64 75 77 73 74 63 76 83 88 86 76 78 83 80 79 68 82 77 80 68 74 74 85 73 65 70 66 76 73 77 74 68 69 89 73 82 85 81 78 72 66 80 80 65 70 72 80 78 85 69 73 69 67 98 67 75 74 64 72 73 72 75 74 70 67 87 82 81 72 66 85 71 73 82 67 66 65 76 83 68 67 82 65 74 74 68 80 79 83 79 79 75 86 63 72 66 81 76 83 78 69 70 80 67 80 72 82 69 86 77 79 71 80 81 60 73 66 73 73 79 77 77 76 77 94 83 87 76 75 72 83 70 74 82 70 85 80 65 71 73 82 73 73 67 71 89 84 71 72 78 72 81 73 80 79 96 84 88 77 85 68 74 82 64 76 59 84 88 73 70 79 68 73 68 75 69 89 79 82 80 82 69 72 76 76 77 74 73 73 83 69 91 70 75 67 87 75 75 77 70 70 76 75 77 80 80 69 77 73 83 75 83 81 66 79 70 83 67 77 67 87 78 67 65 77 77 82 69 79 73 87 71 72 70 81 64 73 72 65 86 81 80 68 71 88 80 62 77 76 84 74 86 71 82 70 65 78 71 68 83 66 74 85 91 67 62 66 79 75 83 71 68 80 70 75 69 75 92 79 80 74 81 81 56 82 73 88 71 71 80 69 68 70 81 88 81 79 68 76 88 78 74 73 58 73 80 78 68 69 71 73 73 83 71 88 68 72 57 62 75 86 75 72 66 64 61 65 77 77 72 78 83 85 62 76 74 74 64 70 73 70 76 72 81 74 74 80 78 68 77 87 63 74 79 76 59 53 73 82 87 81 83 75 84 83 83 73 64 60 76 77 74 72 69 72 76 77 80 75 70 69 82 75 81 69 88 68 81 60 76 67 80 81 72 77 65 76 78 58 88 81 65 70 76 78 67 78 89 54 62 88 69 81 77 64 89 69 72 68 81 77 78 76 73 78 66 58 91 78 82 61 78 83 59 75 69 91 82 85 78 93 86 74 71 79 76 76 74 81 75 62 87 79 73 57 86 88 83 72 76 69 62 76 71 85 68 89 78 75 66 74 84 71 72 83 79 71 78 71 77 83 75 78 77 81 84 61 80 78 81 77 71 83Sheet1 CumPctFrequencySheet2 Data 62.7 Bin Frequency Cumulative% Bin Frequency Cumulative% 61.96 32.74 1 .83% 53.08 25 20.83% 48.45 36.13 5 5.00% 56.47 20 37.50% 46.47 39.52 6 10.00% 49.69 16 50.83% 55.02 42.91 9 17.50% 59.86 16 64.17% 59.11 46.3 12 27.50% 46.3 12 74.17% 54.51 49.69 16 40.83% 42.91 9 81.67% 66.64 53.08 25 61.67% 63.25 9 89.17% 53.08 56.47 20 78.33% 39.52 6 94.17% 43.19 59.86 16 91.67% 36.13 5 98.33% 49.66 63.25 9 99.17% 32.74 1 99.17% 51.46 More 1 100.00% More 1 100.00% 55.92 47.27 55.26 47.96 54.42 50.67 51.16 43.69 60.52 56.45 61.66 53.4 62.58 46.52 61.8 35.45 61.41 49.11 46.8 49.45 48.75 56.51 51.68 46.61 41.53 53.78 42.83 57.37 50.04 39.68 53.56 50.71 53.89 35.04 35 42.01 43.79 54.68 52.42 58.86 46.63 53.59 55.76 53.07 52.94 57.92 57.97 43.57 37.58 59.21 40.1 51.43 52.44 60.06 39.33 37.48 40.87 52.27 56.19 57.71 43.83 45.13 48.74 51.79 58.86 45.93 45.43 52.44 57.11 38.96 58.53 59.14 36.4 53.96 46.09 42.22 55.47 40.44 49.15 43.68 59.09 56.63 56.45 52.9 54.16 58.85 46.48 52 52.63 38.2 50.54 42.7 51.06 54.68 32.74 45.28 61.25 52.15 50.17 33.56 34.92 44.89 52.17 49.57 51.09 50.25 56.82 55.93&FPage&PSheet2 &APage&PFrequencyCumulative%BinFrequencyHistogramSheet3 BinSize: 6 Student Grades Lower Upper Freq 1 66 1 6 0 2 82 7 12 5 3 11 13 18 2 4 78 19 24 2 5 61 25 30 3 6 69 31 36 1 7 58 37 42 2 8 83 43 48 3 9 65 49 54 5 10 53 55 60 5 11 77 61 66 7 12 77 67 72 8 13 56 73 78 9 14 87 79 84 7 15 81 85 90 5 16 73 91 96 1 17 53 97 102 2 Note:Thechartusesnamedformulas(CategoriesandFrequencies) 18 18 103 108 0 initsSERIESformula 19 58 109 114 0 20 70 115 120 0 21 30 121 126 0 22 68 127 132 0 23 49 133 138 0 BinSize =Sheet3!$E$1 24 62 139 144 0 categories =OFFSET(Sheet3!$E$4,0,0,ROUNDUP(100/BinSize,0)) 25 14 145 150 0 data =Sheet1!$A$2:$A$1001 26 71 151 156 0 frequencies =OFFSET(Sheet3!$F$4,0,0,ROUNDUP(100/BinSize,0)) 27 75 157 162 0 Grades =Sheet3!$B$4:$B$70 28 20 163 168 0 29 66 169 174 0 30 12 175 180 0 31 81 181 186 0 32 10 187 192 0 33 20 193 198 0 34 76 199 204 0 35 70 205 210 0 36 10 211 216 0 37 76 217 222 0 38 69 223 228 0 39 47 229 234 0 40 89 235 240 0 41 79 241 246 0 42 100 247 252 0 43 60 253 258 0 44 34 259 264 0 45 81 265 270 0 46 76 271 276 0 47 99 277 282 0 48 90 283 288 0 49 95 289 294 0 50 48 295 300 0 51 47 301 306 0 52 65 307 312 0 53 54 313 318 0 54 57 319 324 0 55 78 325 330 0 56 69 331 336 0 57 89 337 342 0 58 61 343 348 0 59 54 349 354 0 60 82 355 360 0 61 9 361 366 0 62 28 367 372 0 63 37 373 378 0 64 85 379 384 0 65 40 385 390 0 66 72 391 396 0 67 27 397 402 0 403 408 0 409 414 0 415 420 0 421 426 0 427 432 0 433 438 0 439 444 0 445 450 0 451 456 0 457 462 0 463 468 0 469 474 0 475 480 0 481 486 0 487 492 0 493 498 0 499 504 0 505 510 0 511 516 0 517 522 0 523 528 0 529 534 0 535 540 0 541 546 0 547 552 0 553 558 0 559 564 0 565 570 0 571 576 0 577 582 0 583 588 0 589 594 0 595 600 0Sheet3 0 5 2 2 3 1 2 3 5 5 7 8 9 7 5 1 2Changethebinsizetovarythenumberofbins