applications of statistical methods assignment.
n123
Assign3Data.xlsx
Question 1
| | Price (cents per liter) |
| Year | Montreal | Toronto | Vancouver |
| 1 | 100.8 | 94.4 | 105.7 |
| 2 | 117.3 | 110.1 | 119.1 |
| 3 | 128.0 | 118.1 | 126.6 |
| 4 | 129.5 | 120.5 | 122.2 |
| 5 | 136.3 | 127.3 | 125.4 |
Question 2
| Seed type | Fertilizer type | Crop yield |
| A | 1 | 5.19 |
| A | 1 | 4.88 |
| A | 1 | 4.78 |
| A | 1 | 4.89 |
| A | 1 | 4.69 |
| A | 1 | 4.96 |
| A | 1 | 5.00 |
| A | 1 | 4.93 |
| A | 1 | 5.10 |
| A | 1 | 4.78 |
| A | 2 | 4.90 |
| A | 2 | 5.15 |
| A | 2 | 4.68 |
| A | 2 | 4.98 |
| A | 2 | 4.66 |
| A | 2 | 4.46 |
| A | 2 | 4.70 |
| A | 2 | 4.37 |
| A | 2 | 4.69 |
| A | 2 | 4.97 |
| A | 3 | 4.31 |
| A | 3 | 4.36 |
| A | 3 | 4.75 |
| A | 3 | 4.62 |
| A | 3 | 3.74 |
| A | 3 | 4.34 |
| A | 3 | 4.52 |
| A | 3 | 4.37 |
| A | 3 | 4.40 |
| A | 3 | 4.52 |
| A | 4 | 4.04 |
| A | 4 | 4.22 |
| A | 4 | 4.39 |
| A | 4 | 3.89 |
| A | 4 | 4.26 |
| A | 4 | 4.41 |
| A | 4 | 4.39 |
| A | 4 | 4.52 |
| A | 4 | 3.87 |
| A | 4 | 4.70 |
| B | 1 | 4.94 |
| B | 1 | 4.59 |
| B | 1 | 4.58 |
| B | 1 | 4.48 |
| B | 1 | 4.55 |
| B | 1 | 4.53 |
| B | 1 | 4.59 |
| B | 1 | 4.66 |
| B | 1 | 4.73 |
| B | 1 | 5.24 |
| B | 2 | 4.88 |
| B | 2 | 4.80 |
| B | 2 | 4.46 |
| B | 2 | 4.73 |
| B | 2 | 3.96 |
| B | 2 | 4.42 |
| B | 2 | 4.30 |
| B | 2 | 4.68 |
| B | 2 | 4.45 |
| B | 2 | 4.56 |
| B | 3 | 4.11 |
| B | 3 | 4.35 |
| B | 3 | 4.17 |
| B | 3 | 4.11 |
| B | 3 | 4.02 |
| B | 3 | 4.41 |
| B | 3 | 4.48 |
| B | 3 | 3.76 |
| B | 3 | 4.66 |
| B | 3 | 4.44 |
| B | 4 | 3.89 |
| B | 4 | 4.45 |
| B | 4 | 3.80 |
| B | 4 | 4.15 |
| B | 4 | 4.41 |
| B | 4 | 3.75 |
| B | 4 | 3.98 |
| B | 4 | 4.07 |
| B | 4 | 4.21 |
| B | 4 | 4.23 |
| C | 1 | 3.57 |
| C | 1 | 3.77 |
| C | 1 | 3.90 |
| C | 1 | 4.49 |
| C | 1 | 4.00 |
| C | 1 | 4.66 |
| C | 1 | 4.48 |
| C | 1 | 4.64 |
| C | 1 | 4.31 |
| C | 1 | 4.43 |
| C | 2 | 4.20 |
| C | 2 | 3.94 |
| C | 2 | 4.20 |
| C | 2 | 3.88 |
| C | 2 | 4.35 |
| C | 2 | 3.99 |
| C | 2 | 4.01 |
| C | 2 | 4.22 |
| C | 2 | 3.70 |
| C | 2 | 4.48 |
| C | 3 | 3.90 |
| C | 3 | 3.77 |
| C | 3 | 3.86 |
| C | 3 | 4.10 |
| C | 3 | 4.10 |
| C | 3 | 3.81 |
| C | 3 | 3.97 |
| C | 3 | 3.67 |
| C | 3 | 4.05 |
| C | 3 | 3.67 |
| C | 4 | 3.45 |
| C | 4 | 4.06 |
| C | 4 | 3.35 |
| C | 4 | 3.67 |
| C | 4 | 3.74 |
| C | 4 | 3.80 |
| C | 4 | 3.90 |
| C | 4 | 4.08 |
| C | 4 | 3.52 |
| C | 4 | 4.03 |
| D | 1 | 4.10 |
| D | 1 | 4.50 |
| D | 1 | 4.47 |
| D | 1 | 4.42 |
| D | 1 | 4.56 |
| D | 1 | 4.69 |
| D | 1 | 4.42 |
| D | 1 | 4.17 |
| D | 1 | 4.31 |
| D | 1 | 4.59 |
| D | 2 | 4.07 |
| D | 2 | 4.13 |
| D | 2 | 4.25 |
| D | 2 | 4.23 |
| D | 2 | 4.57 |
| D | 2 | 4.33 |
| D | 2 | 4.17 |
| D | 2 | 4.47 |
| D | 2 | 4.60 |
| D | 2 | 4.02 |
| D | 3 | 3.89 |
| D | 3 | 4.18 |
| D | 3 | 3.82 |
| D | 3 | 4.09 |
| D | 3 | 3.94 |
| D | 3 | 4.41 |
| D | 3 | 4.14 |
| D | 3 | 4.15 |
| D | 3 | 4.06 |
| D | 3 | 3.90 |
| D | 4 | 3.56 |
| D | 4 | 3.91 |
| D | 4 | 4.05 |
| D | 4 | 3.91 |
| D | 4 | 4.11 |
| D | 4 | 3.61 |
| D | 4 | 3.72 |
| D | 4 | 3.69 |
| D | 4 | 3.79 |
| D | 4 | 3.45 |
