In: Statistics and Probability
| Sea Level Change (mm) | Annual Lobbying on Oil and Gas ($mil) |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| na | na |
| -38.15 | na |
| -36.98 | na |
| -35.56 | na |
| -31.70 | na |
| -25.89 | na |
| -23.88 | 62.4 |
| -20.92 | 60 |
| -17.92 | 50.8 |
| -12.56 | 51.2 |
| -9.26 | 58.6 |
| -6.19 | 56.8 |
| -4.35 | 52.4 |
| 0.10 | 66.5 |
| 1.10 | 75.2 |
| 1.73 | 86.5 |
| 4.20 | 135.1 |
| 8.98 | 174.9 |
| 10.12 | 147.9 |
| 9.09 | 150.2 |
| 19.73 | 139.1 |
| 22.03 | 143.9 |
| 25.30 | 141.1 |
| 35.60 | 130.4 |
| 37.44 | 117.5 |
We do not use na values in our calculation.
We use Minitab to solve this question
Results for: Worksheet 2
MTB > OneT 'Sea Level Change (mm)';
SUBC> Test 0;
SUBC> Confidence 95.0;
SUBC> Alternative 1.
One-Sample T: Sea Level Change (mm)
Test of μ = 0 vs > 0
Variable
N
Mean StDev SE Mean 95% Lower
Bound
T P
Sea Level Change (mm) 24 -3.66
22.40
4.57
-11.50
-0.80 0.784
Observe that p-value = 0.784 > alpha = 0.05, Do not reject Ho
Conclusion - From given sample information there is not enough evidence to say that sea levels exceeded 0.
MTB > OneT 'Annual Lobbying on Oil and Gas';
SUBC> Test 100;
SUBC> Confidence 95.0;
SUBC> Alternative 1.
One-Sample T: Annual Lobbying on Oil and Gas
Test of μ = 100 vs > 100
Variable
N Mean StDev
SE Mean 95% Lower
Bound
T P
Annual Lobbying on Oil a 19 100.03
43.21
9.91
82.84
0.00 0.499
Observe that p-value = 0.499 > alpha = 0.05, Do not reject Ho
Conclusion - From given sample information, there is not enough evidence to say that, Annual lobbying on Oil and Gas ($mil): Has annual spending on the oil and gas lobby been above $100 million