Please solve the exercise in Excel and show your work (including formulas)
The population of lengths of aluminum-coated steel sheets is normally distributed with a meanof 30.05 inches and a standard deviationof 0.27 inches.
A sample of 9 metal sheets is randomly selected from a batch. What is the probabilitythat the average length of a sheet is between 30.23 and 30.32 inches long?
The solution provides step by step method for the calculation of probability using the Z score. Formula for the calculation and Interpretations of the results are also included.