Exercise 1: Descriptive statistics: A) In your excel spreadsheet, use the Rand function to create 10 random numbers between 0 and 10 in the Cells A1 through A10. Then in some other cells compute the following (be sure to label which is which): the mean of Al-AIO (1.11), the median, the min and max, the range, the standard deviation (0'1), 01, QB, and the inter-quartile range. B) Repeat step (1) and generate another 10 random numbers between 0 and 10 in the Cells B1 through B10. Compute the same statistics as you did in (1). Denote the mean and standard deviation by 1.12 and 02, respectively. C) Subtract B 1-B10 from A1A10 accordingly, i.e., Al-B 1, A2-B2, etc., save the results in C1 through C10. D) Now compute the mean (1.1) and standard deviation (0) of the numbers in C1-C10. Can you guess the relationship between 1.1, 1.11, and 112? Does this relationship apply to 0', (11, and Cl\"2 as well? Exercise 2: Pie Charts and Bar Graphs: You are doing a study where you wait outside of a local bar and survey the college students who come in as to what year they are in. The responses are Freshman, Sophomore, Junior, Senior, and Graduate Student. Suppose you see 200 college students, and that the tallies of the evening amount to: Freshman Sophomore Junior Senior Graduate 20 25 4'7 64 44 Display this data in an array on a spread sheet and then create a pie chart and a bar graph to illustrate this data. Exercise 3: The Normal Distribution. The function NORMDIST(X, mu, sigma, TRUE) computes the probability that a normal observation with a fixed mean (mu) and standard deviation (sigma) is less than it. There is also a function for computing the inverse operation: the function NORMINWp, mu, sigma) computes a value x such that the probability that a normal observation is less than x is equal to P. A) Compute the probability that an observation from a N(3, 5) population is less than 7. B) Find the number x such that P{ N(4, 4)