A rifle manufacturer is developing a new sniper rifle with an advanced automatic sighting mechanism. To test the accuracy of the sighting mechanism, five rifles are randomly selected. Each rifle is fired at the same target, and the vertical distance and horizontal distance between the shot and the target are measured (the error). (If the shot is to the left of the target, the horizontal distance is recorded with a minus sign; if the shot is below the target, the vertical distance is recorded with a minus sign.) Consider the horizontal error (in centimeters) to be a random variable x; assume that x follows a normal distribution with an unknown population mean, p, and standard deviation, 0. 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 90% 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 the following sample Excel sheet, enter the value of the mean in cell C3 (rounded to five decimal places), and enter the margin of error in cell C16 (rounded to six decimal places). NOTE: Excel uses the label "Confidence Level (90%)" instead of margin of error. Horizontal Error, x 0.0050 -0.0098 Mean |:| —0.0091 Standard Error 0.00441153 0.0064 Median 0.005 0.0122 Mode #NfA Standard Deviation 0.009864482 Sample Variance 0.000097308 Kurtosis —2.626910746 Skewness —0.257649449 Range 0.022 Minimum —0.0098 Maximum 0.0122 Sum 0.0047 Count 5 Confidence Level (90%) |:| You can be 90% confident that the population mean of x is between and .