1) Upload EXCELHW - Part1. It lists 10 students and their quiz, HW, midterm grades. I would like you to complete the table:

a) Find the average quiz grade and the average midterm grade for each student. Then use the percentages as HW 20%, Quiz 20%, Midterm 30%, Final 30% to find the overall average for each student.

b) Find the mean, variance, standard deviation, median for each column one by one.

c) Make a histogram that shows the number of students that has an overall average of 90.

2) Upload EXCELHW Part2. It lists the outcomes of a discrete random variable and the corresponding probabilities. You can assume it is a biased die. I would like you to find the mean, variance, standard deviation.

3) Now you will make this excel chart: I would like you to consider a binomial distribution, where the number of trials is 15 and the probability of success is 0.3, I would like you to generate a table that lists the probability of obtaining x successes for each x from 0 to 15. Then I would like you to make a bar chart that plots these probabilities.

H3 X V fx Quiz -average N 0 P Q R S T U V W X Y Z AA B C D E F G H K L M Quiz 1 Quiz 2 Midterm 1 Midterm 2 Final HW Quiz-avera Midterm-a\\ Overall Average 5 Student] 100 79 90 91 100 Student2 60 89 66 95 83 100 Student3 75 75 100 47 77 100 8 Student4 90 97 99 68 94 95 9 Student5 80 90 57 80 80 90 10 Student6 84 47 86 84 80 90 Student7 86 89 90 69 89 95 Student8 90 68 80 85 95 100 Student 98 84 75 80 90 95 14 Student10 95 90 95 66 90 100 15 16 mean median 18 standard deviat 19 variance 20 22 45 46 Sheet1 + + 100% ReadyInsert Draw Page Layout Formulas Data Review View , vj Share 13 Comments mean variance standard deviation Ready E E + WOW\