Question

please check I have included all data needed. Question 2. (Minitab or R and Excel)

Normal, clean rain has a pH value of between 5.0 and 5.5, which is slightly acidic. However, when rain combines with sulfur dioxide or nitrogen oxides— produced from power plants and automobiles—the rain becomes much more acidic. Typical acid rain has a pH value of 4.0. The data are the pH of precipitation observed in Colorado.

a) Make a histogram of the data in 3 ways: i. Minitab or R (not both) ii. Excel defaults iii. Excel with categories (bin ranges): 4.14, 4.34, 4.54, 4.74, 4.94, 5.14, 5.34, 5.54, 5.74, 5.94, 6.14, 6.34, 6.54, 6.74, 6.94, 7.14 iv. Excel with categories (bin ranges): 4.2, 4.4, 4.6, 4.8, 5.0, 5.2, 5.4, 5.6, 5.8, 6.0, 6.2, 6.4, 6.6, 6.8, 7.0. Put all four in your lab report.

b) Briefly tell whether you prefer Minitab, R or Excel for histograms and why. Also comment on the default categories that Excel, R and Minitab give.

c) Do the categories make a difference in the shape of the histogram? Describe the shapes of the histograms and any differences that you see in the histograms.

3888559911568 3344 344467512 1235 55566777 8 9 0-1:2 3 4-5 1 1 1 1 1 1 1 1 2 22 22 2 2 2 2 2 333 333 012345 67890 123 4567 CD 34 5.13 5.15 35 36 5.15 37 5.15 38 5.16 5.16 39 5.16 40 415.18 5.19 42 43 5.23 5.24 45 5.29 46 47 5.32 5.33 48 5.35 495.37 50 5.37 5.39 52 5.41 53 5.43 54 5.44 5.46 56 5.46 57 5.47 5.5 58 59 5.51 60 5.53 61 5.55 62 5.55 63 5.56 64 5.61 65 5.62 5.64 67 5.65 68 5.65 5677 8 975556698 111155996 7931 A555 555-555555 5.55-555 9 GE·68 69 70 72-73-74-56 2 9999 9 9 999 9.1 1 1 5678 90-123 789 31251 46668 0000000012 5-6-7 8 9-0 1-2-3-4 5 0:111(- 11 ▲ 848 86 88 90 91 92 93 94 95 96 97 98 99 100 5 6 7 8| 00123456789 8999999 999-9 0000 3

Answer 1

Histogram of ph Histogram of ph 18-1 16 14- 12 10- 4 6.4 4.4 4.8 5.2 5.6 6.0 6.8 ph

###a) ll default histogram Bin Frequenc histogram 4.33 25 4.578 10 20 4.826 5.074 13 17 5.322 17 5.57 5.818 21 6.066 6.314 1 2 345 6 789 10 11 6.562 More

### a) 3 histogram by bin bin Frequen Chart Title 4.14 4.14 4.34 4.34 14 4.54 4.74 4.74 4.94 4.94 5.14 5.14 5.34 5.34 13 13 5.54 5.74 5.74 14 5.94 5.94 6.14 6.14 10 1 2 34 5 6 7 8 9 10 11 12 13 14 15 16 17 6.34 6.34 6.54 6.74 6.74 6.94 6.94 7.14 7.14 More

###a) 4 histogram with categorical range bin Histogranm bin 4.2 4.2 4.4 4.4 4.6 4.6 4.8 4.8 17 5.2 5.2 9 5.4 5.4 12 5.6 18 5.8 5.8 6.2 1 23 45 6 7 8910 11 12 13 14 15 16 6.2 2 class 6.4 6.4 6.6 6.6 6.8 6.8 0 More

### first graph from Minitab and all others are from Excel

### b) actually from R Minitab and Excel all three are prefer for Graphing for Histogram because three are nearly or exactly same gives result but if we compare for difficulty I will prefer Minitab and R because it is easy to draw in Excel we have to chose bins and then we get frequency and then we draw first bar chart then from design we get Histogram it is lenghty process than Minitab and R ### c) yes bins changes histogram shapes changes here default , taking categorical bins are result are different and hence shape are different