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.