A random survey of enrollment at 35 community colleges across the United States yielded the following figures: 6,414; 1,550; 2,109; 9,350; 21,828; 4,300; 5,944; 5,722; 2,825; 2,044; 5,481; 5,200; 5,853; 2,750; 10,012; 6,357; 27,000; 9,414; 7,681; 3,200; 17,500; 9,200; 7,380; 18,314; 6,557; 13,713; 17,768; 7,493; 2,771; 2,861; 1,263; 7,285; 28,165; 5,080; 11,622. Assume the underlying population is normal.

1.

x

x

= __________

sx= __________

n= __________

n- 1 = __________

2. Define the random variablesXand

X

X

in words.

3. Which distribution should you use for this problem? Explain your choice.

4. Construct a 95% confidence interval for the population mean enrollment at community colleges in the United States.

5. State the confidence interval.

6. Sketch the graph.

7. Calculate the error bound.

8. What will happen to the error bound and confidence interval if 500 community colleges were surveyed? Why?

I need some help how to do this in excel sheet please. functions etc