CSC 161 Fall 2022 - Homework 5 (10 pts. total)
Assigned Tue Sep 27 (revised Thu Sep 29), due Tue Oct 4
Answer the following questions in a single Excel file (with multiple sheets/tabs) named hw5-LastName.xls (where LastName is replaced by
your last name):
1. [3 pts.] A bag contains 6 red marbles & 8 blue marbles. If you pick out 4 marbles, find:
a) P(exactly 2 red marbles)
b) P(at most 2 red marbles)
c) P(at least 2 red marbles)
2. [3 pts.] Given a set of normally distributed data with mean = 80 and standard deviation = 5:
a) What percent of the data is less than 65?
b) What percent of the data is between 65 and 90?
c) What percent of the data is greater than 86?
3. [4 pts.] Find the sample standard deviation of the set of numbers {2,3,5,7,11}:
a) Without using the SUMPRODUCT function
b) With using the SUMPRODUCT function
****Refer to the 9/29 In-Class Excel file, as needed, for how to do this. Since none of the numbers repeat, you can use a frequency of 1 for each number.****
Last Modified: 9/29/22