Business Research Project Part 4: Data Analysis

profilesarmar
ajax_data-2.xlsx
Home>Business & Finance homework help>Business Research Project Part 4: Data Analysis

Shift 1

Cases of Product from 0700 through 1500
Date 21-Jan
Time Number of cases Number of workers
0700-0800 129 18
0800-0900 125
0900-1000 137
1000-1100 136
1100-1200 137
1200-1300 156
1300-1400 151 103 185
1400-1500 122 82
Date 21-Feb
Time Number of cases Number of workers
0700-0800 133 18
0800-0900 135
0900-1000 137
1000-1100 136
1100-1200 138
1200-1300 139
1300-1400 138
1400-1500 137
Date 21-Mar
Time Number of cases Number of workers
0700-0800 128 18
0800-0900 145
0900-1000 146
1000-1100 146
1100-1200 146
1200-1300 146
1300-1400 135
1400-1500 138 Results of experience survey Shift 1
Participant Scores
1 2 2 2 2 2 3 3 2 1 3
2 2 2 2 2 2 3 3 2 1 3
3 2 2 2 2 2 3 3 2 1 3
4 2 2 2 2 2 3 3 2 1 3
5 2 2 2 2 2 3 3 2 1 3
6 2 2 2 2 2 3 3 2 1 3
7 2 2 3 3 3 3 3 2 1 3
8 2 2 3 3 3 3 3 2 1 3
9 2 2 3 3 3 3 3 2 1 3
10 2 2 3 3 3 3 3 2 1 3
11 2 2 3 3 3 3 3 2 1 3
12 2 2 3 3 3 3 3 2 1 3
13 2 2 3 3 3 3 3 2 2 3
14 2 2 2 2 2 3 3 2 2 3
15 2 2 2 2 2 3 3 2 2 3
16 2 2 2 2 2 3 3 2 2 3
17 2 2 2 2 2 3 3 2 1 3
18 2 2 2 2 2 3 3 2 1 3

Shift 2

Cases of Product from 1500 through 2300
Date 21-Jan
Time Number of cases Number of workers
1500-1600 108 18
1600-1700 107
1700-1800 105
1800-1900 109
1900-2000 110
2000-2100 112
2100-2200 104
2200-2300 103
Date 21-Feb
Time Number of cases
1500-1600 115 17
1600-1700 118
1700-1800 119
1800-1900 117
1900-2000 115
2000-2100 116
2100-2200 118
2200-2300 119
Date 21-Mar
Time Number of cases 19
1500-1600 123
1600-1700 129
1700-1800 151
1800-1900 151
1900-2000 129
2000-2100 131
2100-2200 131
2200-2300 159 Results of experience survey Shift 2
Participant Scores
1 3 3 3 3 2 3 3 2 2 3
2 3 3 3 3 2 3 3 2 2 3
3 3 3 3 3 2 3 3 2 2 3
4 3 3 3 3 2 3 3 2 2 3
5 3 3 3 4 4 4 4 4 2 3
6 3 3 3 3 2 3 3 2 2 3
7 3 3 3 3 2 3 3 2 2 3
8 3 3 3 4 4 4 4 4 2 3
9 3 3 3 3 2 3 3 2 2 3
10 3 3 3 3 2 3 3 2 2 3
11 3 3 3 4 4 4 4 4 2 3
12 3 3 3 3 2 3 4 4 4 4
13 3 3 3 4 4 4 4 4 2 3
14 3 3 3 3 2 3 3 2 2 3
15 3 3 3 3 2 3 3 2 2 3
16 3 3 3 4 4 4 4 4 2 3
17 3 3 3 3 2 3 3 2 2 3
18 3 3 3 3 2 3 3 2 1 3

Shift 3

Cases of Product from 2300 through 0700
Date 21-Jan
Time Number of cases Number of workers
2300-2400 159 18
2400-0100 156
0100-0200 153
0200-0300 156
0300-0400 159
0400-0500 181
0500-0600 128
0600-0700 185
Date 21-Feb
Time Number of cases Number of workers
2300-2400 162 17
2400-0100 168
0100-0200 169
0200-0300 168
0300-0400 159
0400-0500 182
0500-0600 182
0600-0700 185
Date 21-Mar
Time Number of cases Number of workers
2300-2400 193 19
2400-0100 121
0100-0200 112
0200-0300 106
0300-0400 159
0400-0500 181
0500-0600 169
0600-0700 185 Results of experience survey Shift 3
Participant Scores
1 3 3 3 3 4 3 3 4 4 3
2 3 3 3 5 5 5 5 5 5 5
3 3 3 3 5 5 5 5 5 5 5
4 3 3 3 5 5 5 5 5 5 5
5 3 3 3 5 5 5 5 5 5 5
6 3 3 3 5 5 5 5 5 5 5
7 3 3 3 5 5 5 5 5 5 5
8 3 3 3 5 5 5 5 5 5 5
9 3 3 3 5 5 5 5 5 5 5
10 3 3 3 5 5 5 5 5 5 5
11 3 3 3 5 5 5 5 5 5 5
12 3 3 3 5 5 5 5 5 5 5
13 3 3 3 5 5 5 5 5 5 5
14 3 3 3 5 5 5 5 5 5 5
15 3 3 3 5 5 5 5 5 5 5
16 3 3 3 4 4 4 4 4 2 3
17 3 3 3 3 2 3 3 2 2 3
18 3 3 3 3 2 3 3 2 3 3

Stats

AJAX Bottling Corp.
OUTPUT MEASUREMENTS BY SHIFTS AND TOTAL
Mean Output Standard Deviation Median Mode Range Variance Kurtosis Skewedness Skew Direction Max Min sum count
Shift 1 138.1666666667 7.9655053426 137 137 34 63.4492753623 0.2478421351 0.1379760501 R 156 122 3316 24
Shift 2 120.7916666667 15.1714238438 117.5 115 56 230.1721014493 1.0139861124 1.2353603902 R 159 103 2899 24
Shift 3 161.5833333333 23.6806959847 165 159 79 560.7753623188 0.5329677745 -1.0602933912 L 193 106 3878 24
All shifts 140.1805555556 23.5007839047 137 159 82 552.2868441358 -0.6923540541 0.401276834 R 193 103 10093 72
SKILL MEASUREMENTS BY SHIFTS AND TOTAL
Mean Experience Standard Deviation Median Mode Range Variance Kurtosis Skewedness Skew Direction Max Min sum count Mean # of workers
Shift 1 2.3388888889 0.6178344673 2 2 2 0.3817194289 -0.651617953 -0.3706244237 L 3 1 421 180 18
Shift 2 2.9222222222 0.6382199018 3 3 3 0.4073246431 -0.1802800181 -0.0630801907 L 4 1 526 180 18
Shift 3 4.1 1.0253763446 5 5 3 1.051396648 -1.584801859 -0.3911300832 L 5 2 738 180 18
All shifts 3.1203703704 1.0708044103 3 3 4 1.146622085 -0.5059893011 0.5119186899 R 5 1 1685 540 18
Shift 1 Mean Experience Median Mode Range Variance Max Min 2.338888888888889 2 2 2 0.38171942892613286 3 1 Shift 2 Mean Experience Median Mode Range Variance Max Min 2.9222222222222221 3 3 3 0.40732464307883265 4 1 Shift 3 Mean Experience Median Mode Range Variance Max Min 4.0999999999999996 5 5 3 1.0513966480446917 5 2 All shifts Mean Experience Median Mode Range Variance Max Min 3.1203703703703702 3 3 4 1.1466220850480109 5 1 Shift 1 Standard Deviation Kurtosis Skewedness 0.61783446725327074 -0.65161795304092029 -0.37062442369954557 Shift 2 Standard Deviation Kurtosis Skewedness 0.63821990181976673 -0.18028001813583305 -6.308019069477705E-2 Shift 3 Standard Deviation Kurtosis Skewedness 1.0253763445899713 -1.5848018589552508 -0.39113008322016157 All shifts Standard Deviation Kurtosis Skewedness 1.0708044102673517 -0.50598930108774853 0.51191868988962741 Shift 1 Standard Deviation 7.9655053425579263 Shift 2 Standard Deviation 15.171423843834649 Shift 3 Standard Deviation 23.680695984680057 All shifts Standard Deviation 23.50078390470842 Shift 1 Kurtosis Skewedness 0.24784213514024511 0.13797605005114444 Shift 2 Kurtosis Skewedness 1.0139861123716565 1.2353603902121575 Shift 3 Kurtosis Skewedness 0.5329677744665986 -1.0602933911975536 All shifts Kurtosis Skewedness -0.69235405412266537 0.40127683404587272 Shift 1 Mean Output Median Mode Range Variance Max Min 138.16666666666666 137 137 34 63.449275362318865 156 122 Shift 2 Mean Output Median Mode Range Variance Max Min 120.79166666666667 117.5 115 56 230.17210144927452 159 103 Shift 3 Mean Output Median Mode Range Variance Max Min 161.58333333333334 165 159 79 560.77536231884221 193 106 All shifts Mean Output Median Mode Range Variance Max Min 140.18055555555554 137 159 82 552.28684413580243 193 103

All shifts - Production

All shifts Mean Output Median Mode Range Max Min 140.18055555555554 137 159 82 193 103

All shifts - Experience

All shifts Mean Experience Median Mode Range Max Min 3.1203703703703702 3 3 4 5 1