Explore BrainMass

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

    ADVERTISEMENT