MV20-20Final20Assignment20Data.xlsx

MSA Data

Inspectors
Part
Length (mm)

1
A
145

1
B
138

1
C
138

2
A
147

2
B
137

2
C
139

3
A
141

3
B
138

3
C
138

4
A
145

4
B
134

4
C
136

5
A
148

5
B
135

5
C
139

6
A
148

6
B
137

6
C
139

7
A
149

7
B
160

7
C
149

1
A
146

1
B
137

1
C
138

2
A
148

2
B
137

2
C
139

3
A
139

3
B
131

3
C
147

4
A
145

4
B
135

4
C
136

5
A
148

5
B
136

5
C
139

6
A
147

6
B
137

6
C
139

7
A
149

7
B
139

7
C
139

Fuel Consumption

Fuel Consumption
Car Speed

3.38
98

5.02
60

5.25
68

3.00
45

4.12
49

5.19
64

5.31
71

4.33
50

3.05
99

4.76
80

4.42
72

4.55
54

3.91
88

1.24
113

5.29
79

3.91
47

5.13
74

2.22
106

4.82
54

1.23
117

3.19
99

4.77
83

2.74
106

3.57
45

4.53
52

5.20
65

0.25
117

3.90
45

4.43
51

4.54
53

3.45
89

4.91
60

2.85
106

4.60
86

5.23
77

3.39
90

1.99
110

5.15
74

Trip Duration

Destination
Method
Road
Duration (min)

Home
Uber
A
73

Office
Uber
B
61

Office
Car
A
64

Home
Uber
B
69

Home
Car
B
75

Office
Car
B
58

Office
Car
A
51

Office
Uber
A
62

Home
Uber
B
82

Office
Uber
A
48

Home
Uber
A
72

Office
Car
B
48

Office
Uber
B
41

Home
Car
B
66

Home
Car
A
74

Home
Car
A
61

Supplier Data

22
10
64
4

22%
10%
64%
4%

Supplier
Price
Delivery Time
Quality
Response

Delivery Time
Quality
Response

1
18
Good
Good
Poor
2.3

2
2
1
1.52

2
21
Poor
Poor
Good
1.5

1
1
1
0.78

3
15
Poor
Good
Good
3.0

1
1
1
0.78

4
17
Good
Good
Good
2.5

2
2
2
1.56

5
23
Good
Poor
Good
1.0

2
2
2
1.56

6
20
Poor
Poor
Poor
1.8

1
1
1
0.78

7
18
Good
Good
Poor
2.3

2
2
2
1.56

8
21
Good
Excellent
Poor
1.5

2
2
2
1.56

9
16
Excellent
Good
Poor
2.8

3
3
3
2.34

10
16
Good
Excellent
Poor
2.8

2
2
2
1.56

11
21
Poor
Poor
Poor
1.5

0.00

12
18
Excellent
Poor
Good
2.3

0.00

13
23
Excellent
Excellent
Good
1.0

14
21
Poor
Good
Poor
1.5

15
22
Excellent
Good
Poor
1.3

16
15
Excellent
Good
Good
3.0

17
23
Poor
Poor
Good
1.0

18
19
Excellent
Poor
Poor
2.0

19
21
Poor
Good
Poor
1.5

20
15
Poor
Good
Poor
3.0

2.0

3.0

15

1.0

1.0

23

3.0

8

Customer Survey

Customer ID
Product A
Product B
Product C

1
4
0
4

2
1
7
4

3
4
5
1

4
9
8
7

5
1
3
9

6
1
10
2

7
0
4
3

8
4
3
2

9
4
1
5

10
9
2
2

11
3
1
4

12
1
9
2

13
10
0
5

14
6
7
9

15
2
9
6

16
8
2
5

17
8
10
5

18
0
3
6

19
4
7
1

20
7
6
8

21
0
4
2

22
4
3
10

23
0
2
8

24
10
3
0

25
9
7
4

26
3
7
2

27
1
6
2

28
10
5
4

29
10
0
9

30
1
8
0

31
10
4
5

32
4
0
6

33
9
3
1

34
8
10
7

35
9
10
8

36
0
6
2

37
9
5
0

38
0
0
3

39
8
5
9

40
10
4
7

41
0
8
5

42
3
1
8

43
10
1
3

44
1
2
9

45
6
6
7

46
8
4
6

Labor Production

Training (h)
Age (y)
Temp. (Co)
Experience (y)
Shift #
Production (kg)

77.495
34.32
16.62
11.4
1
118

74.845
36.5
16.46
11.26
2
120

68.445
34.66
17.66
13.34
2
108.4

81.965
34.07
16.04
9.6
2
121.4

86.045
35.75
16.4
7.15
1
114.4

87.515
34.46
16.28
7.56
2
117.2

90.945
34.6
16.06
8.42
3
120

90.555
35.38
15.93
9.24
2
121

75.6
35.85
16.6
6.7
2
104

76.935
35.68
16.41
6.95
1
108.8

79.35
35.35
16.17
7.69
1
117.2

80.165
35.04
15.92
8.36
3
117

81.965
34.07
16.04
9.6
2
121.4

80.855
32.2
16.19
10.56
3
121.4

77.495
34.32
16.62
11.4
1
118

71.185
31.08
17.37
13.18
2
109.2

69.485
35.73
18.12
13.54
1
103.2

63.81
34.11
18.53
14.31
3
89

77.455
34.79
15.54
9.93
2
126.6

75.79
35.77
15.7
10.63
1
123.8

75.335
36.44
16.45
11.79
2
121.6

69.715
37.2
16.71
11.2
1
119.8

66.68
35.07
18.12
13.9
1
102

56.855
35.26
19.05
14.73
2
82.4

65.31
35.56
16.51
6.6
2
103.4

70.405
35.73
16.02
7.52
2
115.2

70.96
36.46
15.89
8.36
2
119.6

72.69
36.26
15.83
9.33
2
120.8

69.715
37.2
16.71
11.2
1
119.8

77.495
34.32
16.62
11.4
1
118

Reference no: EM132069492

WhatsApp
Hello! Need help with your assignments? We are here

GRAB 25% OFF YOUR ORDERS TODAY

X