The data (Prob04-06 in Ch04Data.xlsx on the Student Companion Site) represent the weight of castings (in kilograms)

Question:

The data (Prob04-06 in Ch04Data.xlsx on the Student Companion Site) represent the weight of castings (in kilograms) being made in the Harrison Metalwork foundry. Based on this sample of 100 castings, compute the mean, standard deviation, and other relevant statistics, as well as a frequency distribution and histogram. What do you conclude from your analysis?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For answer-question

An Introduction To Six Sigma And Process Improvement

ISBN: 9781133604587

2nd Edition

Authors: James R. Evans, William M. Lindsay

See More Books

Question Posted: Jul 05, 2023 10:28 AM

See More Questions


Harrison Metalwork Foundry

Descriptive Statistics and Frequency Chart
This spreadsheet is designed for up to 100 pieces of data Enter data ONLY in yellow-shaded cells.

Note: The Histogram macro and the Descriptive Statistics macro have been used to develop this solution.
They can be loaded into the Data menu during standard setup of Excel.
If available, they will show up as the Data Analysis label on the Data menu.


SORTED
DATA			Frequency Table
1	37
2	38		Upper Cell		Cumulat.
3	38		Boundaries	Frequencies	Freq.	Cumulative %
4	38
5	38	Cell 1	37.5	1	1	1.00%
6	38	Cell 2	37.8	3	4	4.00%
7	38	Cell 3	38.1	8	12	12.00%
8	38	Cell 4	38.4	26	38	38.00%
9	38	Cell 5	38.7	29	67	67.00%
10	38	Cell 6	39.0	15	82	82.00%	Original Data set
11	38	Cell 7	39.3	13	95	95.00%
12	38	Cell 8	39.6	4	99	99.00%	38.1	38.5	38.3	37.3	38.4	39.2	38.9	38.7	39.0	38.6
13	38	Cell 9	39.9	1	100	100.00%	38.1	38.5	38.4	37.6	38.4	39.2	38.9	38.7	39.0	38.6
14	38						38.2	38.5	38.4	37.7	38.4	39.3	38.9	38.7	39.1	38.7
15	38	Descriptive Statistics					38.2	38.5	38.4	37.8	38.4	39.3	38.9	38.7	39.1	38.7
16	38	Mean	38.6320				38.3	38.6	38.4	37.9	38.4	39.3	38.9	38.7	39.1	38.7
17	38	Standard Error	0.0444				38.3	38.6	38.4	37.9	38.4	39.4	39.0	38.7	39.1	38.7
18	38	Median	38.6000				38.3	38.6	38.4	37.9	38.4	39.4	39.0	38.7	39.1	38.7
19	38	Mode	38.4000				38.3	38.6	38.4	38.1	38.4	39.5	39.0	38.8	39.1	38.7
20	38	Standard Deviation	0.4436				38.3	38.6	38.4	38.1	38.5	39.6	39.0	38.8	39.2	38.7
21	38	Sample Variance	0.1967				38.3	38.6	38.4	38.1	38.5	39.9	39.0	38.8	39.2	38.7
22	38	Kurtosis	0.5580
23	38	Skewness	-0.0247
24	38	Range	2.6000

The data (Prob04-06 in Ch04Data.xlsx on the Student Companion Site) represent the weight of castings (in kilograms)

Question:

Step by Step Answer:

Descriptive statistics for the Harrison Metalwork fou...View the full answer

An Introduction To Six Sigma And Process Improvement

Students also viewed these Business questions