Please give step-by-step instructions how to solve. (please Don’t Give Answer) . Use only Microsoft Excel tools and functions in Microsoft Excel. Give detailed instructions on which tool or function used on each step. (Even the beginning). Needs to be solved in Microsoft Excel.
Question.- What fraction of mowers fails for each of the 30 samples in the excel worksheet Mower Test? What distribution might be appropriate to model the failure of an individual mower? Using these data, estimate the sampling distribution of the mean, the overall fraction of failures, and the standard error of the mean. Is a normal distribution an appropriate assumption for the sampling distribution of the mean?
