LEARN MORE...

Week 6

Content type

User Generated

Subject

Accounting

Type

Homework

Uploaded By

Vafvqre47

Pages

Showing Page:

1/4

Defective Flash Drives

Data set 2 presents a sample of the number of defective flash drives produced by a small

manufacturing company over the last 30 weeks. The company’s operations manager believes that

the number of defects produced by the process is less than seven defective flash drives per week.

Use this online calculator (or any statistical package that you are comfortable with) to construct a

hypothesis test to verify the operations manager’s claim. Your hypothesis test should include null

and alternative hypotheses, a t test statistic value, a p value, a decision, and a conclusion. Submit

a Word file that includes the hypothesis test.

Data Set

Week

#Flashdrives

Showing Page:

2/4

Descriptive Statistics

We used as a calculation tool, the following excel functions:

o Use the Excel =AVERAGE function to find the mean

o Use the Excel = STDEVA function to find the standard deviation

o Use the Excel = TDIST function to find the t-value

o Use the Excel = TDIST function to find the p-value

o Use the Excel = TINV function to find the t-critical

Mean













Substituting in equation (1):



   











Showing Page:

3/4

End of Preview - Want to read all 4 pages?

Access Now

Unformatted Attachment Preview

Defective Flash Drives Data set 2 presents a sample of the number of defective flash drives produced by a small manufacturing company over the last 30 weeks. The company’s operations manager believes that the number of defects produced by the process is less than seven defective flash drives per week. Use this online calculator (or any statistical package that you are comfortable with) to construct a hypothesis test to verify the operations manager’s claim. Your hypothesis test should include null and alternative hypotheses, a t test statistic value, a p value, a decision, and a conclusion. Submit a Word file that includes the hypothesis test. Data Set Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 #Flashdrives 6 7 6 5 7 5 6 6 8 9 9 7 5 6 8 8 9 7 6 8 5 7 6 24 25 26 27 28 29 30 8 10 9 7 8 7 6 Descriptive Statistics We used as a calculation tool, the following excel functions: o Use the Excel =AVERAGE function to find the mean o Use the Excel = STDEVA function to find the standard deviation o Use the Excel = TDIST function to find the t-value o Use the Excel = TDIST function to find the p-value o Use the Excel = TINV function to find the t-critic ...
Purchase document to see full attachment

Tags: Defective flash drives