The Soft Drink Excitation: minitab 1, checking data

Описание: See the overview of the project and analysis here:    • The Soft Drink Excitation (Visualisation) ...  

Getting your data into minitab, tally, crosstabulate and chart to check design before you do anything else!

Note that you should enter your data in the order you collect it. The students in this case did not randomise the order of the trials so the data appear to be "in order". This was because they were worried that once they opened a bottle the gas would leak out so they wanted to use all of one bottle as quickly as possible before opening the next. I'll go over this in part 3 when we look at residual plots.

Time (sec) Height (mm) Type of Soda Height of Drop (mm) Amount of BCS (ml)
25.6 115 Coke 180 2.5
26.1 109 Coke 180 2.5
24.9 95 Coke 180 2.5
22.9 64 Coke 80 2.5
23.8 89 Coke 80 2.5
23.5 82 Coke 80 2.5
29 101 Coke 180 5
29.3 104 Coke 180 5
27.5 120 Coke 180 5
20 65 Coke 80 5
24.8 87 Coke 80 5
24.6 77 Coke 80 5
29 85 Coke 180 7.5
29.3 99 Coke 180 7.5
24.5 80 Coke 180 7.5
36 100 Coke 80 7.5
31.3 92 Coke 80 7.5
35.6 99 Coke 80 7.5
18.7 114 Lemonade 180 2.5
18.8 126 Lemonade 180 2.5
18.5 103 Lemonade 180 2.5
17.8 107 Lemonade 80 2.5
17.5 119 Lemonade 80 2.5
17.8 120 Lemonade 80 2.5
18.3 157 Lemonade 180 5
17.5 133 Lemonade 180 5
18 130 Lemonade 180 5
18.5 115 Lemonade 80 5
18.7 125 Lemonade 80 5
18.2 125 Lemonade 80 5
18.2 121 Lemonade 180 7.5
17.4 123 Lemonade 180 7.5
18 130 Lemonade 180 7.5
18.3 145 Lemonade 80 7.5
19.2 141 Lemonade 80 7.5
17.3 145 Lemonade 80 7.5
18.2 64 Orange 180 2.5
19 54 Orange 180 2.5
19.4 64 Orange 180 2.5
18.6 52 Orange 80 2.5
18.7 80 Orange 80 2.5
18.6 64 Orange 80 2.5
19.1 107 Orange 180 5
19.2 89 Orange 180 5
20 105 Orange 180 5
19.6 90 Orange 80 5
19.6 105 Orange 80 5
19.1 91 Orange 80 5
17.7 77 Orange 180 7.5
18.8 70 Orange 180 7.5
17.2 82 Orange 180 7.5
18.2 109 Orange 80 7.5
20.2 112 Orange 80 7.5
19.6 115 Orange 80 7.5
14.7 69 Diet Coke 180 2.5
12.9 45 Diet Coke 180 2.5
13.5 49 Diet Coke 180 2.5
13.5 50 Diet Coke 80 2.5
12.6 47 Diet Coke 80 2.5
12.3 34 Diet Coke 80 2.5
16.6 78 Diet Coke 180 5
18.5 88 Diet Coke 180 5
18.7 82 Diet Coke 180 5
14.8 57 Diet Coke 80 5
15.6 56 Diet Coke 80 5
15 55 Diet Coke 80 5
20.4 95 Diet Coke 180 7.5
17.8 83 Diet Coke 180 7.5
18.1 95 Diet Coke 180 7.5
15.6 58 Diet Coke 80 7.5
14.5 53 Diet Coke 80 7.5
16.8 64 Diet Coke 80 7.5