Explore BrainMass
Share

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 March 21, 2019, 9:56 pm 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