unit 4 assignment
docx
keyboard_arrow_up
School
Park University *
*We aren’t endorsed by this school
Course
415
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
docx
Pages
2
Uploaded by AgentThunder521
LG415
Homework, Chapter 6, Problems 11, 13 and 23
11. Use the data for Twenty-first Century Laundry for the weights of loads of clothes processed
through their washing department in a week. (See Prob. 6- 11 in C06Data workbook.)
a. Apply the Excel Descriptive Statistics tool to compute the mean, standard deviation, and other
relevant statistics, and interpret the results in a meaningful fashion.
This data uses Cluster Sampling, where the population is divided into weekly groups, and all loads within
each week were included in the sample. The load weights are measured in pounds.
In this sample, there were 100 laundry loads, with weights ranging from 1 to 107 pounds, resulting in a
range of 106 pounds. The average load weight is approximately 32.92 pounds, and the standard
deviation is about 25.8986 pounds. This standard deviation of 25.9 pounds shows that the load weights
varied significantly from the average.
The skewness value is 0.9941, which is close to 1, indicating a high degree of skewness. The positive
value suggests a right-skewed histogram, meaning there are more lighter loads and fewer heavier loads.
The kurtosis value is 0.232, which is lower than the kurtosis of a normal distribution (which is around 3).
This suggests a flatter and more widely dispersed histogram, indicating that the data points are less
concentrated around the mean compared to a normal distribution.
b. Use the Frequency Distribution and Histogram Excel template to construct a frequency distribution
and histogram for the data. From what type of distribution might you suspect the data are drawn?
Experiment with the number of cells to create a visually appealing histogram and use the Excel
Histogram tool to verify the results.
The histogram's positive skew reflects that a significant number of laundry loads have a lower weight,
while fewer loads tip the scales with heavier weights. Looking at this from a business angle, it raises
questions about why there's such a broad range of weights and why there's a prevalence of lighter loads
in the data. Investigating this could uncover opportunities for waste reduction within the operations of
Twenty-first Century Laundry. This might involve scrutinizing processes to understand why lighter loads
dominate and exploring potential areas for efficiency improvement, resource optimization, or even
reevaluating the types of loads or services offered.
13. The data for Prob. 6-13 found in C06Data Excel workbook shows the weight of a set of castings (in
kilograms) being made in the Fillmore Metalwork foundry. Construct an Excel spreadsheet to compute
the mean and standard deviation using formulas (6.15) and (6.19). Verify your results using Excel
functions.
23. The process engineer at Sival Electronics was trying to determine whether three suppliers would
be equally capable of supplying the mounting boards for the new “gold plated” components that she
was testing. The table found in the worksheet Prob. 6-23 in the Excel workbook C06Data shows the
coded defect levels for the suppliers, according to the finishes that were tested. Lower defect levels
are preferable to higher levels. Using one-way ANOVA, analyze these results. What conclusion can be
reached, based on these data?
The analysis of the sum of squared deviations between supplier groups and within those groups reveals
a substantial variation. This difference is reflected in the F statistic, which significantly surpasses the
critical F value (Fcrit). This outcome leads to the conclusion that there exists a considerable difference in
means among the suppliers. This discrepancy strongly suggests that the capabilities of these suppliers in
providing mounting boards are not equal.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help