Wk3.xlsx - House Sales Selling Price Lot Cost $85,145...

This preview shows page 1 - 16 out of 50 pages.

House SalesSelling PriceLot Cost$85,145$17,030$112,740$20,700Go to Insert above$115,350$18,030Select Scatter Chart$116,415$19,600$133,070$24,455$136,530$25,500$139,435$29,155$139,955$30,400$147,905$24,650$153,845$27,500$155,270$19,600$155,870$24,650$160,000$29,500$165,220$25,500$165,350$25,000$168,354$27,316$168,500$33,000$170,000$25,200$172,749$45,025$175,000$28,000$175,470$28,600$179,365$32,200$181,916$45,025$182,237$45,025$183,370$28,000$184,210$28,000$184,460$22,300$184,873$33,400$185,160$29,000$186,000$35,851$187,390$27,000$188,603$31,300$189,120$35,000$191,028$45,000$196,898$45,025$198,202$45,025$200,119$45,000$200,423$45,025$201,700$40,940$202,000$31,160$203,076$45,025$203,950$33,000$204,900$34,000$205,821$39,299$0$100,000$200,000$0$10,000$20,000$30,000$40,000$50,000$60,000$70,000$80,000$90,000$100,000Midwest / SLot Cost
$206,400$35,851$207,345$35,600$209,400$43,579$210,380$33,856$211,513$31,300$211,797$34,000$212,079$33,400$214,205$36,500$214,900$31,300$216,049$35,600$219,990$37,557$220,257$31,300$223,890$28,000$224,108$45,025$225,900$28,618$226,000$35,600$230,000$45,025$230,440$33,000$230,555$28,000$233,900$44,200$234,971$29,202$239,000$39,169$239,870$41,354$241,195$41,340$242,191$33,434$242,899$48,252$246,648$41,600$248,500$20,000$249,900$38,200$250,005$33,000$250,800$73,400$252,135$41,341$253,055$41,340$254,048$39,680$255,000$43,198$256,235$48,500$257,040$37,631$260,100$73,400$262,740$44,900$262,890$48,500$265,058$41,404$265,500$35,800$267,060$73,400$267,250$45,676$267,640$73,400$268,000$43,344$268,210$29,700
$268,500$41,099$269,410$73,400$270,518$46,499$271,105$45,000$274,455$41,000$274,903$45,345$277,720$44,650$280,622$45,130$280,804$40,667$281,487$57,285$281,824$50,448$283,440$50,900$286,758$57,000$287,771$46,300$289,000$44,000$290,000$48,300$290,190$82,250$294,450$73,400$294,990$57,000$299,096$43,784$301,500$59,000$305,000$49,067$307,373$41,292$307,387$45,850$307,663$44,840$309,075$82,250$310,100$41,800$310,372$60,000$312,898$40,768$318,274$85,800$318,523$50,000$319,602$82,250$322,920$82,250$323,716$34,500$324,266$47,891$324,412$62,523$326,570$51,000$329,611$48,611$330,486$35,000$330,710$49,920$333,158$49,123$335,000$68,375$337,374$70,399$337,380$49,150$338,065$54,850$340,000$40,000$340,730$50,850
$342,423$48,309$348,744$53,000$350,702$46,386$352,781$60,000$354,065$48,115$354,117$56,219$355,688$65,373$358,162$44,470$359,949$50,591$366,990$55,508$367,600$50,000$369,101$46,773$371,152$58,223$379,000$72,915$379,424$64,902$379,575$44,294$385,000$75,000$385,942$49,123$387,527$48,000$398,651$65,429$400,330$75,510$404,510$58,225$407,076$48,668$410,810$66,500$417,790$63,099$432,426$57,422$444,304$53,938$446,507$75,510$492,820$84,122$575,120$79,790
$300,000$400,000$500,000$600,000$700,000168; $79,790South Regional House Sales April 2018Selling Price
Background image
Background image
Background image
Colleges and UniversitiesSchoolTop 10% HSAcceptance RateExpenditures/StudentAmherst8522%$ 26,636 Barnard6953%$ 17,653 Bates5836%$ 17,554 Berkeley9537%$ 23,665 Bowdoin7824%$ 25,703 550%10%20%30%40%50%60%175540
60657075808590951002663600%1765300%00%2366500%2570300%Colleges & Universities
State Unemployment RatesQuestion #State January 2013 RateHistorical HighHistorical LowAlabama 6.914.43.3Alaska 6.711.55.9Arizona 811.53.6Arkansas 7.210.24.1California 9.8114.7Colorado 7.39.12.5Connecticut 8.1102.1Delaware 7.28.22.9District of Columbia 8.611.44.8Florida 7.89.73.3Georgia 8.78.33.4Hawaii 5.210.22.2Idaho 6.39.42.7Illinois 912.94.1Indiana 8.612.82.6Iowa 58.52.6Kansas 5.57.42.9Kentucky 7.912.14Louisiana 5.912.93.2Maine 7.393Maryland 6.78.33.3Massachusetts 6.710.92.7Michigan 8.916.93.2Minnesota 5.692.5Mississippi 9.313.74.9Missouri 6.510.52.6Montana 5.78.73.1Nebraska 3.86.82.2Nevada 9.710.74.1New Hampshire 5.87.71.9New Jersey 9.510.63.5New Mexico 6.69.93.1New York 8.410.54North Carolina 9.510.23.1North Dakota 3.36.92.5Ohio 713.83.9Oklahoma 5.19.42.7Oregon 8.412.14.7Pennsylvania 8.212.94Rhode Island 9.89.72.9South Carolina 8.711.43.1South Dakota 4.45.92.4Tennessee 7.712.43.8Texas 6.39.34.1Utah 5.49.72.4Vermont 4.792.2Virginia 5.67.82.2Washington 7.512.24.4West Virginia 7.418.24.3The use of because it iand easy to
Wisconsin 711.82.9Wyoming 4.910.11.912345678910111213141516171819202122232425262728293002468101214161820State Unemployment RateJanuary 2013 RateHistorical HighHisto
#3a line chart would have better to use in this instance is easier to show trending data over a period of time o understand.
0313233343536373839404142434445464748495051esorical Low
Store and Regional Sales DatabaseIDStore No.Sales RegionItem No.Item DescriptionUnit PriceUnits Sold726East8500Laptop$849.9599716East8500Laptop$849.9588626East200524" Monitor$229.0085535North3006Wireless Keyboard$19.9582525North3006Wireless Keyboard$19.9580706East8500Laptop$849.9578545North3006Wireless Keyboard$19.9575666East3006Wireless Keyboard$19.9569555North6050PC Mouse$8.9565656East3006Wireless Keyboard$19.9558595North8500Laptop$849.9557837East8500Laptop$849.9557636East200524" Monitor$229.0056575North6050PC Mouse$8.9555585North8500Laptop$849.9555827East8500Laptop$849.9555847East8500Laptop$849.9555646East3006Wireless Keyboard$19.9552767East3006Wireless Keyboard$19.9549787East3006Wireless Keyboard$19.9548605North8500Laptop$849.9547777East3006

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture