# Statistics - Conclusion based on given data

The US energy administration publishes data on residential energy consumption and expenditures in residential consumption survey: consumption and expenditures. Suppose you want to decide whether last years mean annual mean expenditure for house holds using natural gas is different from that for house holds using only electricity. At the 5% significance level what conclusion would you draw given the data in dollars shown in the following table?

Natural Gas:

2002,1338,1478,1305,1636,1557,1456,1495,1376,1458,1698,1491,1394,1526, 1579,1369,1249,1505,1541,1385,1375,1495,1377,1355,1321,1801,1664,1507, 1648,1574

Electricity:

1376,1327,1168,1014,1379,1177,949,1456,1452,1059,1070,1461,987,1150,1351, 1235,1400,1180,1102,1002,1352,1259,1480,1227,1221,976,1532,1266,1179,1185, 1102,1351,1394,1450,1109,1393

https://brainmass.com/statistics/hypothesis-testing/statistics-conclusion-based-given-data-219379

#### Solution Preview

The solution file is attached.

The US energy administration publishes data on residential energy consumption and expenditures in residential consumption survey: consumption and expenditures. Suppose you want to decide whether last years mean annual mean expenditure for house holds using natural gas is different from that for house holds using only electricity. At the 5% significance level what conclusion would you draw given the data ...

#### Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.