i need help solving this problem

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 [1 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% condence 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. Horizontal Error, x 0.0028 -0.0052 Standard Error 0.001728699 0.0052 Median 0.0016 0.0016 Mode #NXA Standard Deviation 0.003865488 Sample Variance 0.000014942 Kurbosis 2.777270793 -1.373334017 Range 0.0104 0.0052 0.0052 0.0059 5 Skewness Minimum Maximum Sum Count Margin of Error =CONFIDENCE(.05, 0.004, 5) =CONFIDENCE(95, 0.004, 5) =CONFIII.'IENCE(.95,r 0.004, 5) =CONFIDENCE(5, 0.004, .05) In cell C16 of the sample spreadsheet, enter the formula for computing the margin 0 error w en e con I-ence evel is 95%. From this formula you obtain a margin of error of You can be 95% condent that the population mean of the horizontal error is between and . (Round your answer to 4 decimal places.)