An automotive part must be machined to close tolerances to be acceptable to customers. Production specifications call for a maximum variance in the lengths of the parts of 0.0004. A quality control sample produced the data in the Microsoft Excel Online file below. Using a = 0.05, test to see whether the population variance specification is being violated. Open spreadsheet 1. Formulate the null and alternative hypotheses for this application. Ho: 0² H₂: 0² 2. Test statistic = 3. The p-value is 4. Conclusion: 5. Test results: Check My Work © Reset Problem © (to 2 decimals)

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

please help asap i will upvote!!

An automotive part must be machined to close tolerances to be acceptable to customers. Production specifications call for a maximum variance in the lengths of the parts of 0.0004. A
quality control sample produced the data in the Microsoft Excel Online file below. Using a = 0.05, test to see whether the population variance specification is being violated.
X
Open spreadsheet
1. Formulate the null and alternative hypotheses for this application.
Ho: 0²
Ha: 0²
2. Test statistic =
3. The p-value is
4. Conclusion:
5. Test results:
Check My Work
↑
ŷ
(to 2 decimals)
Reset Problem
î
î
↑
Transcribed Image Text:An automotive part must be machined to close tolerances to be acceptable to customers. Production specifications call for a maximum variance in the lengths of the parts of 0.0004. A quality control sample produced the data in the Microsoft Excel Online file below. Using a = 0.05, test to see whether the population variance specification is being violated. X Open spreadsheet 1. Formulate the null and alternative hypotheses for this application. Ho: 0² Ha: 0² 2. Test statistic = 3. The p-value is 4. Conclusion: 5. Test results: Check My Work ↑ ŷ (to 2 decimals) Reset Problem î î ↑
D3
2
671SSA WN
A
1 Part Length
5.02
4.97
4.965
5.005
4.98
5.005
4.96
4.945
4.97
4.975
5.01
4.97
4.96
4.985
5
5.005
4.97
4.955
5
4.985
4.945
5.005
4.965
3
4
5
8
File
9
Home
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
25
5
4.95
5.02
4.97
4.95
4.965
4.945
B
Insert
Arial
fx
Draw
Page Layout
✓ 10
+
Sample size
Sample mean
Sample variance
Sample standard deviation
Hypothesized variance
Degrees of freedom
с
D
Inferences About a Population Variance
Level of significance
Critical Value (2 decimals)
Test statistic (2 decimals)
p-value (4 decimals)
Sheet1
Calculation Mode: Automatic Workbook Statistics
Reject null hypothesis?
B
Formulas
0.0004
0.05
↓
E
Data
Review
View
F
Formulas
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
ab
Help
General
G
H
←0
.00
.00
→.0
J
K
L
M
Editing
Ev AT
N
Give Feedback to Microsoft
P
Comments
100% +
Transcribed Image Text:D3 2 671SSA WN A 1 Part Length 5.02 4.97 4.965 5.005 4.98 5.005 4.96 4.945 4.97 4.975 5.01 4.97 4.96 4.985 5 5.005 4.97 4.955 5 4.985 4.945 5.005 4.965 3 4 5 8 File 9 Home 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 25 5 4.95 5.02 4.97 4.95 4.965 4.945 B Insert Arial fx Draw Page Layout ✓ 10 + Sample size Sample mean Sample variance Sample standard deviation Hypothesized variance Degrees of freedom с D Inferences About a Population Variance Level of significance Critical Value (2 decimals) Test statistic (2 decimals) p-value (4 decimals) Sheet1 Calculation Mode: Automatic Workbook Statistics Reject null hypothesis? B Formulas 0.0004 0.05 ↓ E Data Review View F Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A ab Help General G H ←0 .00 .00 →.0 J K L M Editing Ev AT N Give Feedback to Microsoft P Comments 100% +
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman