Explore BrainMass

Explore BrainMass

    Using Pivot Tables to find average selling price

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

    1-2
    A national homebuilder builds single family homes and condominiums style townhouses. The excel file shows information on selling price, lot cost, type of home, and region of the country (M-Midwest and S-South) for closings during one month. Use PivotTables to find the average selling price and lot cost for each type of home in each region. What conclusions might you draw for this information?

    Region Type Selling Price Lot Cost
    M SF $348,744 $53,000
    M SF $274,455 $41,000
    M SF $277,720 $44,650
    M SF $307,373 $41,292
    M SF $271,105 $45,000
    M SF $262,740 $44,900
    M SF $175,000 $28,000
    M SF $201,700 $40,940
    M SF $283,440 $50,900
    M SF $185,160 $29,000
    M SF $323,716 $34,500
    M SF $281,487 $57,285
    M SF $184,460 $22,300
    M SF $289,000 $44,000
    M SF $410,810 $66,500
    M SF $184,210 $28,000
    M SF $223,890 $28,000
    M SF $189,120 $35,000
    M SF $230,440 $33,000
    M SF $330,486 $35,000
    M SF $250,005 $33,000
    M SF $203,950 $33,000
    M SF $230,555 $28,000
    M SF $183,370 $28,000
    M T $112,740 $20,700
    M T $179,365 $32,200
    M T $155,870 $24,650
    M T $155,270 $19,600
    M T $116,415 $19,600
    M T $147,905 $24,650
    M T $139,955 $30,400
    M T $184,873 $33,400
    M T $212,079 $33,400
    M T $265,500 $35,800
    M T $175,470 $28,600
    M T $115,350 $18,030
    M T $85,145 $17,030
    M T $139,435 $29,155
    M T $133,070 $24,455
    M SF $165,220 $25,500
    M SF $136,530 $25,500
    M SF $153,845 $27,500
    M SF $165,350 $25,000
    M SF $168,354 $27,316
    M SF $170,000 $25,200
    M SF $210,380 $33,856
    M SF $268,210 $29,700
    M SF $233,900 $44,200
    M SF $168,500 $33,000
    M SF $248,500 $20,000
    M SF $220,257 $31,300
    M SF $214,900 $31,300
    M SF $211,513 $31,300
    M SF $188,603 $31,300
    M T $187,390 $27,000
    S T $335,000 $68,375
    S T $294,450 $73,400
    S T $267,060 $73,400
    S T $250,800 $73,400
    S T $269,410 $73,400
    S T $267,640 $73,400
    S T $260,100 $73,400
    S SF $301,500 $59,000
    S SF $309,075 $82,250
    S SF $290,190 $82,250
    S SF $322,920 $82,250
    S SF $319,602 $82,250
    S SF $294,990 $57,000
    S SF $286,758 $57,000
    S SF $352,781 $60,000
    S SF $310,372 $60,000
    S SF $400,330 $75,510
    S SF $446,507 $75,510
    S T $198,202 $45,025
    S T $200,423 $45,025
    S T $181,916 $45,025
    S T $203,076 $45,025
    S T $196,898 $45,025
    S T $182,237 $45,025
    S T $224,108 $45,025
    S T $230,000 $45,025
    S T $172,749 $45,025
    S SF $318,274 $85,800
    S SF $191,028 $45,000
    S SF $200,119 $45,000
    S SF $242,899 $48,252
    S SF $387,527 $48,000
    S SF $257,040 $37,631
    S SF $270,518 $46,499
    S SF $265,058 $41,404
    S SF $255,000 $43,198
    S SF $385,942 $49,123
    S SF $354,065 $48,115
    S SF $333,158 $49,123
    S SF $254,048 $39,680
    S SF $246,648 $41,600
    S SF $367,600 $50,000
    S SF $318,523 $50,000
    S SF $359,949 $50,591
    S SF $281,824 $50,448
    S SF $355,688 $65,373
    S SF $305,000 $49,067
    S SF $299,096 $43,784
    S SF $280,622 $45,130
    S SF $404,510 $58,225
    S SF $371,152 $58,223
    S SF $219,990 $37,557
    S SF $432,426 $57,422
    S SF $268,000 $43,344
    S SF $312,898 $40,768
    S SF $267,250 $45,676
    S SF $379,000 $72,915
    S SF $342,423 $48,309
    S SF $337,374 $70,399
    S SF $358,162 $44,470
    S SF $398,651 $65,429
    S SF $280,804 $40,667
    S SF $407,076 $48,668
    S SF $268,500 $41,099
    S SF $444,304 $53,938
    S SF $324,266 $47,891
    S SF $307,387 $45,850
    S SF $369,101 $46,773
    S SF $350,702 $46,386
    S SF $329,611 $48,611
    S SF $242,191 $33,434
    S SF $379,424 $64,902
    S SF $324,412 $62,523
    S SF $340,730 $50,850
    S SF $310,100 $41,800
    S SF $354,117 $56,219
    S SF $330,710 $49,920
    S SF $417,790 $63,099
    S SF $290,000 $48,300
    S SF $274,903 $45,345
    S SF $209,400 $43,579
    S SF $205,821 $39,299
    S SF $287,771 $46,300
    S SF $575,120 $79,790
    S SF $226,000 $35,600
    S SF $216,049 $35,600
    S SF $207,345 $35,600
    S SF $211,797 $34,000
    S SF $204,900 $34,000
    S SF $206,400 $35,851
    S SF $186,000 $35,851
    S SF $249,900 $38,200
    S SF $214,205 $36,500
    S SF $256,235 $48,500
    S SF $262,890 $48,500
    S SF $338,065 $54,850
    S SF $326,570 $51,000
    S SF $239,000 $39,169
    S SF $239,870 $41,354
    S SF $241,195 $41,340
    S SF $252,135 $41,341
    S SF $253,055 $41,340
    S SF $160,000 $29,500
    S SF $337,380 $49,150
    S SF $492,820 $84,122
    S SF $385,000 $75,000
    S SF $340,000 $40,000
    S SF $202,000 $31,160
    S SF $234,971 $29,202
    S SF $225,900 $28,618
    S SF $366,990 $55,508
    S SF $307,663 $44,840
    S SF $379,575 $44,294

    © BrainMass Inc. brainmass.com June 4, 2020, 1:24 am ad1c9bdddf
    https://brainmass.com/statistics/quantative-analysis-of-data/using-pivot-tables-to-find-average-selling-price-398166

    Attachments

    Solution Summary

    A national homebuilder builds single family homes and condominiums style townhouses. The excel file shows information on selling price, lot cost, type of home, and region of the country (M-Midwest and S-South) for closings during one month. Use PivotTables to find the average selling price and lot cost for each type of home in each region. What conclusions might you draw for this information?

    $2.19

    ADVERTISEMENT