5. Using Excel - confidence intervals for the population mean (population standard deviation unknown) 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 vertical error (in centimeters) to be a random variable x; assume that x follows a normal distribution with an unknown population mean, μ, and standard deviation, σ. 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. First, to produce an output similar to the table shown, use Excel 2010’s Descriptive Statistics tool by clicking the Data tab on the Ribbon. In the Data Analysis group, select Descriptive Statistics. Specify the input range of A1:A6, check Labels in first row, and specify the Output Range of B1. Finally, check the boxes for Summary statistics and Confidence Level for Mean. Enter the appropriate confidence level 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. A B C 1 Vertical Error, x 2 –0.0014 3 0.0058 Mean _________ 4 0.0055 Standard Error 0.001372807 5 0.0038 Median 0.0038 6 0.0011 Mode #N/A 7 Standard Deviation 0.003069691 8 Sample Variance 0.000009423 9 Kurtosis –1.235544668 10 Skewness –0.712034776 11 Range 0.0072 12 Minimum –0.0014 13 Maximum 0.0058 14 Sum 0.0148 15 Count 5 16 Confidence Level (90%) _________ You can be 90% confident that the population mean of x is between_____ and ______ .
5. Using Excel - confidence intervals for the population mean (population standard deviation unknown) 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 vertical error (in centimeters) to be a random variable x; assume that x follows a normal distribution with an unknown population mean, μ, and standard deviation, σ. 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. First, to produce an output similar to the table shown, use Excel 2010’s Descriptive Statistics tool by clicking the Data tab on the Ribbon. In the Data Analysis group, select Descriptive Statistics. Specify the input range of A1:A6, check Labels in first row, and specify the Output Range of B1. Finally, check the boxes for Summary statistics and Confidence Level for Mean. Enter the appropriate confidence level 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. A B C 1 Vertical Error, x 2 –0.0014 3 0.0058 Mean _________ 4 0.0055 Standard Error 0.001372807 5 0.0038 Median 0.0038 6 0.0011 Mode #N/A 7 Standard Deviation 0.003069691 8 Sample Variance 0.000009423 9 Kurtosis –1.235544668 10 Skewness –0.712034776 11 Range 0.0072 12 Minimum –0.0014 13 Maximum 0.0058 14 Sum 0.0148 15 Count 5 16 Confidence Level (90%) _________ You can be 90% confident that the population mean of x is between_____ and ______ .
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
5. Using Excel - confidence intervals for the population mean (population standard deviation unknown)
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 vertical error (in centimeters) to be a random variable x; assume that x follows a normal distribution with an unknown population mean, μ, and standard deviation, σ. 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.
First, to produce an output similar to the table shown, use Excel 2010’s Descriptive Statistics tool by clicking the Data tab on the Ribbon. In the Data Analysis group, select Descriptive Statistics. Specify the input range of A1:A6, check Labels in first row, and specify the Output Range of B1. Finally, check the boxes for Summary statistics and Confidence Level for Mean. Enter the appropriate confidence level
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.
|
A
|
B
|
C
|
---|---|---|---|
1 | Vertical Error, x | ||
2 | –0.0014 | ||
3 | 0.0058 | Mean |
_________
|
4 | 0.0055 | Standard Error | 0.001372807 |
5 | 0.0038 | 0.0038 | |
6 | 0.0011 | #N/A | |
7 | Standard Deviation | 0.003069691 | |
8 | Sample Variance | 0.000009423 | |
9 | Kurtosis | –1.235544668 | |
10 | Skewness | –0.712034776 | |
11 | Range | 0.0072 | |
12 | Minimum | –0.0014 | |
13 | Maximum | 0.0058 | |
14 | Sum | 0.0148 | |
15 | Count | 5 | |
16 | Confidence Level (90%) |
_________
|
You can be 90% confident that the population mean of x is between_____ and ______ .
Expert Solution
Step 1
The given data is as follows,
Vertical error, |
-0.0014 |
0.0058 |
0.0055 |
0.0038 |
0.0011 |
The confidence interval for the population is as follows.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman