Calculate the following six { 6 + 1 ( qualitative ) } questions:

1. ( a ) Determine the sample mean from the grades provided below( worth 1 point ) ( Note that only some answers will necessarily be the same for everyone )
2. ( b ) Determine the sample standard deviation ( worth 1 point )
3. ( c ) Determine your COHP 350 mid-term grade and letter value ( proportion of 210 points ) ( check your Grades ( in Canvas ) and then total your points and then divide that by 210 to obtain your current mid-term proportion. ( worth 1 point )
4. ( d ) Determine your percentile ranking among all data, ( n = 88 ) ( worth 1 point )
5. ( e ) Determine a 95 % confidence interval ( for what your population mean might be ( Final Grade ? ) ( worth 2 points )
6. ( f ) Calculate the probability that you will beat ( go beyond ) your estimated upper bound confidence limit ( mean score ) by at least 5 points ( and potentially get a higher letter grade division ). [ that is P ( My Final COHP 350 Population Mean Score > ( will be greater than ) my ( 95 % confidence interval, upper bound ) Mean Grade Score + 5 points ) = ? ( worth 3 points )

Grades that need to be measured are the following:

13/20, 8/10, 19.29/25, 8.04/16, 4/4, 16.5/25, 10/10, 16.5/20, 11/10, 17.5/20, 21.5/25, 18.5/20, 15.67/20, 5/5

use the excel sheet to document answers fill in the yellow spots