please complete in excel sheet with formulas

1- The following is a set of data for a population with N = 10:

7 5 11 8 3 6 2 1 9 8

a. Calculate the population mean.

b. Calculate the population standard deviation.

2- The following is a set of data from a sample of n = 7:

12 7 4 9 0 7 3

a. Calculate the first quartile (Q1), the third quartile (Q3), and the interquartile range.

b. List the five-number summary.

c. Construct a boxplot and describe its shape.

d. Compare your answer in (c) with that from Problem 3.3 (d) on page 122. Discuss.