Mathematics Homework Help

MATH 245 NVCC Random Selected Variables & Confidence Intervals Excel Worksheet

 

1.    Find the probability that a randomly selected university will be public.

2.    Find the probability that a randomly selected university will have an Admissions rate equal  to 70% but less than 80%.

3.    Find the probability that a randomly selected university will have an admissions rate below 60% given that it is a private institution.

Section 4 Confidence Intervals:  In this section you will need to construct 95% Confidence intervals of the mean and variance of all the numerical (quantitative) data.  For each please interpret the confidence interval and explain any surprising results. 

Section 5 Hypothesis Testing: In this section you will make some hypotheses about the data and then use what we learned in lecture/homework to test these hypotheses.  

1.    Is the average Admissions Rate greater than 70?

2.    Is the average Retention Rate less than 80?

3.    Is the average Graduation Rate equal to 55?

4.    Is the average Admissions Rate for Private universities the same as that for 

Public?