I NEED THE EXCEL FUNCTIONS THAT YOU USE TOO, NOT ONLY THE ANSWERS. PLEASE SHOW ME WHAT YOU DID IN EACH QUESTION. THANK YOU SO MUCH :)

1. Given the following set of data, find the mean, median, mode, and standard deviation (Note: Enter each number in a cell (ex 13 would be in A1, 12 would be in A2, 14 would be in A3...) Use Commands: =AVERAGE(A1:last cell), = MEDIAN(A_:A_), =MODE(A_:A_), STDEV(A_:A_) = 13, 12, 14, 14, 16, 18, 21, 26, 10, 14, 25, 24, 21, 23, 16, 15, 19, 21, 23, 26, 28, 13, 11, 17, 14, 23, 25, 28 a) Mean/Average b) Median c) Mode d) Standard Deviation 2. Find the expected value of the random variable X, whose probability distribution is given in the following table: X 2 P(X = x) 0.12 4 0.1 6 0.03 8 0.1 10 0.19 12 0.09 14 0.02 16 0.12 18 0.04 20 0.05 Note: the easiest way to do this is by copying and pasting this into Excel, and then multiplying the cells (Ex. If 2 is in A1 and 0.12 is in A2, type = A1*A2), then highlight all the values and press autosum (top