Confidence Intervals Please answer all questions using Microsoft Word, Excel, and the StatCrunch/Graphing Calculator. Use Word to write-up your solutions while copy/pasting graphs from Excel and StatCrunch/Graphing Calculator. You may use this sheet as a guide. Please submit projects the day of the exam: Good luck! 1) A. Generate 50 random samples of n=30 from a normal population with =69 and =3.Construct 90% confidence intervals for each of the 50 samples. These confidence intervals will appear in the output session window. Copy/paste them into your excel spread sheet and print the spreadsheets to turn in. B. Look at the confidence intervals. How many of your intervals failed to correctly estimate ?________(Hilite these intervals on your print out) How many of your intervals actually did contain ?_________ C. What percentage of your intervals contained ?__________ D. Based on the confidence level used in this example, what percentage of the intervals did you expect to contain ? E. How does your actual percentage compare with the percentage you expected based on the confidence level? How has this experiment helped you understand