In: Math
| 
 LED (kW usage)  | 
 516  | 
 487  | 
 502  | 
 501  | 
 498  | 
| 
 515  | 
|||||
| 
 HID (kW usage)  | 
 517  | 
 506  | 
 513  | 
 554  | 
 550  | 
| 
 499  | 
 535  | 
 490  | 
 510  | 
 529  | 
Here we have data:
| LED | HID | 
| 516 | 517 | 
| 487 | 506 | 
| 502 | 513 | 
| 501 | 554 | 
| 498 | 550 | 
| 515 | 499 | 
| 535 | |
| 490 | |
| 510 | |
| 529 | 
Here we use Excel to calculate:
Excel oputput:
| t-Test: Two-Sample Assuming Unequal Variances | ||
| Variable 1 | Variable 2 | |
| Mean | 503.1666667 | 520.3 | 
| Variance | 119.7666667 | 450.67778 | 
| Observations | 6 | 10 | 
| Hypothesized Mean Difference | 0 | |
| df | 14 | |
| t Stat | -2.12465636 | |
| P(T<=t) one-tail | 0.025953184 | |
| t Critical one-tail | 1.345030374 | |
| P(T<=t) two-tail | 0.051906368 | |
| t Critical two-tail | 1.761310136 | |
Hypothesis:
Ho: μ1 = μ2
Ha: μ1 < μ2
Test statistics:
t = - 2.12
P-value = p(t>|-2.12|)
= 0.0259
Critical value:
t-critical = - 1.345
Conclusion: Reject the null hypothesis.
Here we have sufficient evidence to reject the null hypothesis, because t-observed value (-2.12) is less than t-critical value (-1.345) so it is in the rejection region.
we can support the Claim that average kW usage is lower for the LED bulbs.