Share
Explore BrainMass

Using Pivot Tables to find average selling price

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

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