Discuss the below:
Q: 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