Activity 2 - Problem 2_022319.xlsx

Problem 2: Below table is the gathered data of inspectors related to variation of steel plate dimension. Table 1: Steel Plate (Width in terms of mm) 30.55 33.90 32.33 32.77 31.00

31.99 31.23 34.90 35.10 32.77

30.12 34.11 35.50 34.09 30.90

33.40 34.34 32.45 31.11 32.22

34.44 35.66 30.44 31.22 32.22

Table 2: Steel Plate (Length in terms of mm) 55.55 53.33 55.60 60.88 56.66

57.88 58.88 56.99 57.05 56.09

55.90 58.09 57.77 56.88 57.00

56.09 58.01 53.22 55.55 60.03

58.88 57.09 56.00 57.66 59.99

Table 3: Steel Plate (Thickness in terms of mm) 1.33 2.54 3.33 1.22 5.01

4.22 2.33 2.90 1.09 4.00

3.45 5.09 2.33 3.44 2.33

2.30 2.11 1.22 2.33 4.00

2.09 2.90 2.80 3.44 5.01

a. Calculate the mean and standard deviation of each dimensions. b. Create a stem-leaf plot of each dimensions. c. Create a frequency histogram and box-plot.