Need help with Quality Control 5 assignment

Prob08-18.xlsx

Home >Business & Finance homework help >Operations Management homework help >Need help with Quality Control 5 assignment

Prob. 8-18A Statistics

Problem 8-18 - Part A
Mach4 Tool Co - Machining Process
DATA	Place Descriptive Statistics output below
		Original Data
		0.556	0.562	0.564	0.564	0.572
		0.572	0.572	0.572	0.573	0.575
		0.575	0.574	0.575	0.575	0.577
		0.577	0.577	0.577	0.577	0.580
		0.579	0.581	0.583	0.586	0.575
		Copy original data above (by rows) into the yellow highlighted column. Use "Paste Special," then "Transpose" to convert row data to column data. Use data in Yellow cells to perform Excel Descriptive Statistics. Copy ALL of the Descriptive Statistics output into the yellow cells C6:D20

Analysis Instructions: 1. Students must CORRECTLY analyze the data, and answer the questions for the problem listed in the text. 2. Analysis MUST be in a narrative format using the Report Template, and be at LEAST 2 paragraphs in length. 3. Analysis MUST be detailed and concise, and should paint a mental picture of the distribution based on the descriptive statistics. Concentration should be focused on mean, median, mode, std dev, variation, skew, range and mininum/maximum values.

Prob. 8-18A Histogrm -Proc Cap.

Problem 8-18 - Part A
Mach4 Tool Co - Process Capability Analysis
Nominal specification						Nominal spec and tolerance given in problem. Enter values to the left
Upper specification limit																Frequency Distribution and Histogram
Lower specification limit
																Data Minimum	0.0000
						Copy original data from previous tab into yellow cells below. Data should be exactly as it is in the Original Data table from the previous tab										Data Maximum	0.0000
																Number of Cells	10
DATA	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	Enter smallest and largest limits for the frequency distribution below.
1																The lower limit should be slightly less than the data minimum.
2																The upper limit should be slightly larger than the data maximum.
3																				Use Minimum and Maximum values above. Round Min value to third decimal; Round Max value to second decimal. (i.e. if Min value is .6540, round down to .6530; if Max value is .6860, round to .6900) Make sure you use FOUR DECIMAL places Enter rounded values into Lower Limit and Upper Limit respectively.
4																Lower limit
5																Upper limit
6																Cell width	0.0000
7
8																	From	To (inclusive)	Frequency
9																Cell	-Infinity	0.0000	0
10																1	0.0000	0.0000	0
																2	0.0000	0.0000	0
																3	0.0000	0.0000	0
Process Capability Index Calculations																4	0.0000	0.0000	0
Average			ERROR:#DIV/0!													5	0.0000	0.0000	0
Standard deviation			ERROR:#DIV/0!													6	0.0000	0.0000	0
																7	0.0000	0.0000	0	All purple cells will autocalculate and populate. DO NOT alter any embedded formulas
																8	0.0000	0.0000	0
Cp	ERROR:#DIV/0!															9	0.0000	0.0000	0
Cpl	ERROR:#DIV/0!															10	0.0000	0.0000	0
Cpu	ERROR:#DIV/0!
Cpk	ERROR:#DIV/0!
All purple cells will autocalculate and populate. DO NOT alter any embedded formulas

Histogram

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Cell Upper Limit

Frequency

Analysis Instructions: 1. Students must CORRECTLY analyze the data, the chart, and answer the questions for the problem listed in the text. 2. Analysis MUST be in a narrative format using the Report Template, and be at LEAST 2 paragraphs in length. 3. Analysis MUST be detailed and concise, and NOT just describing the chart. How does chart reflect the descriptive statistics? Does the histogram support any conclusions about the distribution? Etc.

Prob. 8-18B Stats & Proc Cap.

Problem 8-18 - Part B
Mach4 Tool Company											Copy/Paste below data into DATA section
																Frequency Distribution and Histogram
											0.573	0.578	0.576	0.579	0.574
Nominal specification						Nominal spec and tolerance given in problem. Enter values to the left					0.575	0.575	0.573	0.577	0.576	Data Minimum	0.0000
Upper specification limit											0.573	0.574	0.576	0.575	0.579	Data Maximum	0.0000
Lower specification limit											0.576	0.577	0.577	0.574	0.575
											0.576	0.574	0.575	0.575	0.576
																Number of Cells	8
DATA	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	Enter smallest and largest limits for the frequency distribution below.
1																The lower limit should be slightly less than the data minimum.
2																The upper limit should be slightly larger than the data maximum.
3
4																Lower limit				Use Minimum and Maximum values above. DO NOT Round Min value! Use Min value as displayed Round Max value to second decimal. (i.e. if Max value is .6860, round to .6900) Make sure you use FOUR DECIMAL places Enter values into Lower Limit and Upper Limit respectively.
5																Upper limit
6																Cell width	0.000
7
8																	From	To (inclusive)	Frequency
9																Cell	-Infinity	0.0000	0
10																1	0.0000	0.0000	0
																2	0.0000	0.0000	0
																3	0.0000	0.0000	0
Process Capability Index Calculations																4	0.0000	0.0000	0
Average			ERROR:#DIV/0!													5	0.0000	0.0000	0
Standard deviation			ERROR:#DIV/0!													6	0.0000	0.0000	0
																7	0.0000	0.0000	0
																8	0.0000	0.0000	0	All purple cells will autocalculate and populate. DO NOT alter any embedded formulas
Cp	ERROR:#DIV/0!															9	0.0000	0.0000	0
Cpl	ERROR:#DIV/0!															10	0.0000	0.0000	0
Cpu	ERROR:#DIV/0!
Cpk	ERROR:#DIV/0!
All purple cells will autocalculate and populate. DO NOT alter any embedded formulas

Histogram

Frequency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Cell Upper Limit

Frequency