Confidence intervals for the population mean in Excel ( population standard deviation known)

A rifle manufacturer is creating a new sniper rifle and is interested in testing the accuracy of its new automatic sighting mechanism. The gun is fired at various equidistant targets, and the vertical and horizontal distance from the shot to the desired target (the error) is measured each time the gun is fired. Consider the horizontal error (in centimeters) to be a random variable x; assume that x follows a normal distribution with an unknown population mean u and a standard deviation of o = 0.004. The rifle manufacturer wants the population mean of x to be zero because this suggests that the automatic sighting mechanism, on average, is accurate. To answer the questions that follow, download an Excel spreadsheet containing five observed values of the variable x by clicking on the following words in bold: Download Excel File Go through the following steps to compute a 95% confidence interval for the population mean of x. Use Excel's Descriptive Statistics tool (with output set to Bl) to obtain a list of important descriptive statistics for the sample data. Use this output to answer the questions that follow. In cell C3 of the following sample Excel sheet, select the value of the mean. \f