Brennan Ross Problem Set 1

Employee Hours of Overtime Days Absent 1 243 3 2 126 2 3 86 0 4 424 6 5 236 3 6 128 0 7 0 0 8 126 2 9 324 3 10 118 0 11 62 0 12 128 3 13 460 6 14 135 1 15 118 1 16 260 2 17 0 1 18 126 1 19 234 2 20 246 3 21 120 1 22 80 0 Bin Widt 23 112 1 Number 24 237 3 25 129 2 26 24 1 27 36 0 28 128 2 29 246 3 30 326 6 a. Develop tw distributed? b. Develop a appear to be This chart Editing th permanen a. Deve data ap Based o skewed seeing i

0 0 1 2 3 4 5 6 7 Days Absent b. Deve hours a Based o correlat strong p Additio regress that as to incre

50 100 150 200 250 300 350 400 450 500 f(x) = 0.013504690912871 x − 0.325551300026178 R² = 0.77835307944634 Days Absent Hours of Overtime elop a scatter plot of hours of overtime versus days absent. Do the data overtime and days absent appear to be correlated? on the scatter plot of hours of overtime versus days absent, the data appears to be ted. This is supported by seeing that the correlation coefficient is 0.88, indicating a positive relationship between the hours of overtime and days absent variables. onally, the R Squared valued of 0.78 indicates that the hours of overtime in the sion model explains about 78% of the variance for days absent. This data suggests the number of hours of overtime increases, the number of days absent also tends ease, and vice versa.

Bin Width = Range / Number of Bins = 6/5 = 1.2 Number of Bins = log (n) / log (2) = log (30) / log (2) = 5 pear to be d days absent This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart. a. Develop two separate histograms for hours of overtime a data appear to be distributed? Based on the data shown in the histogram, it appears distributed with a rig supported by looking at the Skewness value of 1, indicating a moderately p example, the mean is pulled towards the higher end by the presence of ext on the right side of the distribution, causing the mean to be less than the m in positively skewed histograms. If a frequency chart was used instead of a would appear to be relatively uniform, since 0 and 1 days absent would be

Summary Statistics Days Absent Mean 1.9333333333 Standard Error 0.3213954249 Median 2 Mode 3 Standard Deviation 1.7603552411 Sample Variance 3.0988505747 Kurtosis 0.7826063576 Skewness 1.0428812409 Range 6 Minimum 0 Maximum 6 Sum 58 Count 30 and days absent. How do the ght skewedness. This can be further positive skewed histogram. In this treme values, which are more prevalent median, which does not typically occur a histogram for this example, the data e placed into separate bins.

Lower 95.0% Upper 95.0% -0.8887942119792 0.2376916119 0.0107149463402 0.0162944355

Frequency (Number of Times) Percentage Cumulative Percentage 22 37% 37% 15 25% 62% 12 20% 82% 7 12% 93% 3 5% 98% 1 2% 100% 60 B, C, D, E, and F are problems that occur in a process. Develop a pareto chart for th t available in your version of Excel. hape or saving this workbook into a different file format will permanently break the chart.

his data. Which problem should you focus on The letters A, B, C, D, E, and F are problems that occur in a process. Develop a pareto chart for this data. Which problem should you focus on first? Based on the results of the pareto chart data, the first problem that should be focused on is A. This is the first problem that should be focused on because it has the highest frequency of occurence, and greatest contribution to the majority of the problems that are occuring in the process.

Final Ranking Criteria A B C 1 3 4 2 2 2 3 4 1 4 1 3 Final Ranking Machine 1 2 3 4 1 2 3 4 3 2 4 1 4 2 1 3 core Total Score 15 Machine 1 15 12 Machine 2 12 19 Machine 3 19 14 Machine 4 14 UCT FXN MANUAL Complete the analysis for the given p information by finding the final rankin Assume for Ranking: 1 - best and 4 - worst. For imp 3 - least important. Based on the Total Score from organization would be advise machine is selected since the considered the highest priori

prioritization grid ng. portance: 1 - most important and m the prioritization grid, the ed to purchase Machine 2. This e lowest total score is ity given the decision criteria.