Please read the following scenario and answer the questions below. Use the information below and your answers from your Unit 1 Application Assignment to complete this assignment. you may create your assignment using either Microsoft Word or Excel. When you have completed your assignment, use the following naming convention to name your file: The course number, your first initial, your last name, the unit number and the assignment. For example: MTH140_C_Smith_U3 App Assign.doc Scenario Another sample of candies was opened and recorded. The sample size was 30. Below is the summary of the sample. Assume the standard deviation is known. Color Red Blue Green Total Mean 3.16 3.32 2.63 9.1 Standard Deviation 1.61 1.42 1.42 2.54 Using that information, construct the following: A 90% confidence interval for the mean number of red candies. A 90% confidence interval for the standard deviation of the total number of candies. Hint: The Excel functions confidence.norm() and confidence.T() can be used to find the margin of error E quite easily. Also, you might want to use the following calculators in Statcrunch: Stat- > Z Statistics -> One Sample Stat -> T Statistics -> One Sample Stat -> Proportion Statistics -> One Sample Stat -> Variance Statistics -> One Sample
