Create an Excel spreadsheet that will generate random numbers based on the following probability distributions. You can keep the answers to (a) (b) and (c) on the same spreadsheet. If I click on F9 key, the random numbers mustbe refreshed.

a) Use Excel generic function to generate randomly 50 observations following a general discrete distribution described in the table below. To keep things compact, you dont need to put the 50 random numbers down one column, instead put them in rectangle region (e.g., 5 columns by 10 rows or 10 columns by 5 rows).

X	P(X = x)
4	0.1
7	0.15
12	0.40
15	0.20
20	0.15

2. Use Excel generic function to randomly generate 10 observations following a normal distribution with a mean of 50 and a standard deviation of 15, and use ROUND() to round these random numbers to the nearest integer.

3. Use Excel generic function to randomly generate 10 observations following a symmetric triangular distribution (50, 65, 80), and use ROUND() to round these random numbers to the nearest integer.