Please use Excel to solve the statistics problem. It is EXTREMELY important that you use EXCEL and prepare a written discussion of problem to accompany the numerical calculations. You should attach the Excel file.
A large candy manufacturer is concerned that the mean weight of their Chunky Chocolate Crisp bar is not greater than 4.3 ounces. It can be assumed that the population standard deviation is .03 ounces based on past experience. A sample of 100 candy bars is selected and the sample mean is 4.34 ounces. Using a level of significance of .10, is there evidence that the population mean weight of the candy bars is greater than 4.3? Fully explain your answer.
The solution contains a hypothesis testing problem using the z-test.