Question: Click on the datafile logo to reference the data. DATA (b) Use the COUNTIF function to detemine the number of students receiving each letter grade.



Click on the datafile logo to reference the data. DATA (b) Use the COUNTIF function to detemine the number of students receiving each letter grade. \begin{tabular}{|l|l|l|l|} \hline Martini & 65 & 85 & 75.0 \\ \hline Mattlin & 76 & 82 & 79.0 \\ \hline McGough & 63 & 74 & 73.5 \\ \hline Miller & 61 & 80 & 70.5 \\ \hline Minnick & 58 & 88 & 73.0 \\ \hline Minster & 66 & 64 & 65.0 \\ \hline Mueller & 88 & 91 & 79.5 \\ \hline Munzo & 81 & 92 & 86.5 \\ \hline Nanko & 82 & 94 & 88.0 \\ \hline Owen & 67 & 78 & 65.0 \\ \hline Reth & 92 & 82 & 74.5 \\ \hline Rezai & 80 & 98 & 95.0 \\ \hline Ridder & 85 & 76 & 78.0 \\ \hline Rodgers & 67 & 97 & 91.0 \\ \hline Ruschau & 74 & 86 & 76.5 \\ \hline Schneider & 70 & 89 & 83.5 \\ \hline Schnirring & 47 & 78 & 79.5 \\ \hline Schwartz & 41 & 75 & 62.5 \\ \hline Scott & 58 & 82 & 58.0 \\ \hline Shaw & 74 & 68 & 70.0 \\ \hline Sims & 78 & 74 & 71.0 \\ \hline Steelman & 61 & 68 & 64.0 \\ \hline Trentman & 76 & 79 & 77.5 \\ \hline Villaris & 62 & 57 & 59.5 \\ \hline Wettee & 91 & 93 & 92.0 \\ \hline Weyer & 88 & 89 & 88.5 \\ \hline Whipky & 86 & 93 & 89.5 \\ \hline Willis & 93 & \\ \hline \end{tabular} Click on the datafile logo to reference the data. DATA (b) Use the COUNTIF function to detemine the number of students receiving each letter grade. \begin{tabular}{|l|l|l|l|} \hline Martini & 65 & 85 & 75.0 \\ \hline Mattlin & 76 & 82 & 79.0 \\ \hline McGough & 63 & 74 & 73.5 \\ \hline Miller & 61 & 80 & 70.5 \\ \hline Minnick & 58 & 88 & 73.0 \\ \hline Minster & 66 & 64 & 65.0 \\ \hline Mueller & 88 & 91 & 79.5 \\ \hline Munzo & 81 & 92 & 86.5 \\ \hline Nanko & 82 & 94 & 88.0 \\ \hline Owen & 67 & 78 & 65.0 \\ \hline Reth & 92 & 82 & 74.5 \\ \hline Rezai & 80 & 98 & 95.0 \\ \hline Ridder & 85 & 76 & 78.0 \\ \hline Rodgers & 67 & 97 & 91.0 \\ \hline Ruschau & 74 & 86 & 76.5 \\ \hline Schneider & 70 & 89 & 83.5 \\ \hline Schnirring & 47 & 78 & 79.5 \\ \hline Schwartz & 41 & 75 & 62.5 \\ \hline Scott & 58 & 82 & 58.0 \\ \hline Shaw & 74 & 68 & 70.0 \\ \hline Sims & 78 & 74 & 71.0 \\ \hline Steelman & 61 & 68 & 64.0 \\ \hline Trentman & 76 & 79 & 77.5 \\ \hline Villaris & 62 & 57 & 59.5 \\ \hline Wettee & 91 & 93 & 92.0 \\ \hline Weyer & 88 & 89 & 88.5 \\ \hline Whipky & 86 & 93 & 89.5 \\ \hline Willis & 93 & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
