CSC 161 Fall 2024 - Homework 5 (10 pts. total)
Assigned Wed Sep 25, due Wed Oct 2
Answer the following questions using Excel. They should all be in a single Excel file (with multiple sheets/tabs) named hw5-LastName.xls (where LastName is replaced by
your last name):
Questions for Sep 25 lesson
1. [2 pts.] Use Excel to solve #29 from the January 2023 Algebra 2 Regents.
2. [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)
Questions for Sep 30 lesson
3. [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?
4. [2 pts.] Find the sample standard deviation of the set of numbers {2,3,5,7,11}.
Last Modified: 9/25/24