Explore BrainMass

Statistics - Conclusion based on given data

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

© BrainMass Inc. brainmass.com June 3, 2020, 10:11 pm ad1c9bdddf
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.

\$2.19