CSC 161 Fall 2025 - Homework 2 (10 pts. total)
due Sun Sep 7
Answer the following questions using Excel. They should all be in a single Excel file (with multiple sheets/tabs) named hw2-LastName.xls (where LastName is replaced by
your last name):
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)
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 both the sample and population standard deviation of the set of numbers {2,3,5,7,11}. State which one is larger and explain why.
Last Modified: 8/27/25