LEGEND Answer must be typed to four decimals Answer must be chosen from drop down menu Answer must be derived using cell references Suppose a quiz...

Please download the excel file for all information.

Suppose a quiz has 9 multiple choice questions. Each question has 5 answer choices. If a student takes the quiz and randomly guesses on every question....

Q1.  Find the probability the student gets between 3 and 8, exclusive, questions correct.             ________

Q2. Find the probability the student gets more than 5 questions correct.                                        ________

One state lottery has 900 prizes of $1, 115 prizes of $10, 25 prizes of $70, 5 prizes of $340, 2 prizes of $1,170, and 1 prize of $2,800. Assume that 21,000 lottery tickets are issued and sold for $1.