1a.

Navigate to http://tinyurl.com/grd-data where you will find a list of all of the grades recorded for students who took an undergraduate statistics course at NU between 2006 and 2015 (names have been removed, of course).Download the data into an Excel file.

( Make sure you've downloaded all of the datai.e., all 6537 grades. If the file is giving you trouble, try this one instead: http://bit.ly/28P3ubV )

Then, using tools available in the program, answer this question: What percentage of students who took the stats course received a B-range grade ?

("B range" means all grades that include the letter "B":B,B-,andB+.)

1b.

What steps did you take to arrive at your answer? Explain. Be specific. Explain exactly what you did inside the spreadsheet program.