Answer the following 4 part question using an excel spreadsheet and explain.

Sigchi4life
Category:
Statistics
Price: $20 USD

Question description

Over the years, a math instructor has recorded the grades that she awards on a particular exam. The results are shown in the table to the right.

Part 1 - How many students in a typical class of 30 would she expect to score more than 95%?

Part 2 - How many students in a typical class of 30 would she expect to score more than 85%?

Part 3 - If she wanted to set the pass mark so that 65% of students passed and 35% failed, what  pass mark would she use?

Part 4 - This year, there are 5 students in a class of 38 who scored over 95%. What's the chance of this happening randomly?

Your Calculations
   
  Grades Students
  1 to 5 5
  6 to 10 1
  11 to 15 0
  16 to 20 1
  21 to 25 1
  26 to 30 6
  31 to 35 18
  36 to 40 47
  41 to 45 95
  46 to 50 183
  51 to 55 251
  56 to 60 260
  61 to 65 252
  66 to 70 249
  71 to 75 220
  76 to 80 200
  81 to 85 180
  86 to 90 160
  91 to 95 140
  96 to 100 85

1.xlsx

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Purdue University
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1830 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors