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