This Project Will Focus Primarily On Studying The Average Price Variable In Depth; You Will Be Using Average Income

Sheet1 City Name Average Price Median Household Income Alachua $202,500 $ 69,186.36 Altamonte Springs $199,200 $ 55,460.31 Altoona $154,200 $ 76,196.89 Alva $218,700 $ 68,273.78 Anthony $182,800 $ 81,901.00 Apollo Beach $283,700 $ 82,327.38 Apopka $247,700 $ 76,530.65 Arcadia $128,800 $ 80,942.90 Archer $206,500 $ 50,215.99 Astatula $225,200 $ 51,264.94 Astor $185,500 $ 45,460.40 Atlantic Beach $391,500 $ 66,477.69 Auburndale $172,100 $ 41,721.32 Aventura $314,100 $ 94,444.42 Avon Park $119,900 $ 69,588.16 Baker $196,300 $ 51,785.02 Bal Harbour $904,000 $ 115,128.90 Bartow $144,200 $ 50,693.80 Bay Harbor Islands $283,500 $ 57,310.50 Bay Hill $517,000 $ 80,834.55 Bay Pines $220,300 $ 60,808.84 Bell $121,100 $ 80,194.45 Belle Isle $341,400 $ 83,276.29 Belleair $402,900 $ 105,729.96 Belleview $134,400 $ 38,579.59 Beverly Hills $127,100 $ 34,643.90 Biscayne Park $461,200 $ 83,469.51 Bithlo $322,300 $ 74,024.58 Boca Raton $344,500 $ 75,592.46 Bonita Springs $338,700 $ 81,523.89 Bowling Green $78,200 $ 52,256.79 Boynton Beach $256,900 $ 74,489.22 Bradenton $245,200 $ 86,794.13 Brandon $218,300 $ 61,084.02 Branford $132,200 $ 36,360.89 Broadview Park $252,800 $ 66,492.64 Bronson $124,200 $ 52,769.62 Brooksville $116,300 $ 62,952.28 Bushnell $144,100 $ 45,908.86 Butler Beach $340,700 $ 68,103.71 Callahan $227,100 $ 66,401.82 Callaway $158,700 $ 37,556.23 Cantonment $190,700 $ 81,675.33 Cape Canaveral $227,800 $ 46,429.41 Cape Coral $231,300 $ 84,545.34 Carol City $290,700 $ 76,335.25 Casselberry $227,900 $ 81,618.35 Celebration $394,300 $ 98,135.04 Century Village $51,000 $ 70,194.86 Chattahoochee $51,200 $ 67,796.75 Chipley $115,100 $ 68,630.99 Christmas $263,100 $ 55,964.55 Citra $193,900 $ 46,035.44 Citrus Park $250,500 $ 83,594.00 Citrus Ridge $231,900 $ 70,074.99 Clearwater $219,600 $ 58,044.25 Clermont $268,800 $ 59,131.19 Clewiston $112,900 $ 74,522.29 Cocoa $183,300 $ 67,681.70 Cocoa Beach $324,000 $ 94,849.57 Coconut Creek $186,300 $ 79,303.93 Conway $273,100 $ 62,957.64 Cooper City $409,800 $ 95,505.88 Coral Gables $753,400 $ 131,828.88 Coral Springs $366,900 $ 88,888.23 Country Club $230,100 $ 60,513.05 Country Walk $372,800 $ 68,183.74 Crawfordville $181,300 $ 80,214.88 Crescent City $100,500 $ 60,339.62 Crestview $180,100 $ 86,374.59 Cross City $57,100 $ 54,064.26 Crystal River $165,700 $ 38,227.10 Cutler Bay $313,100 $ 76,043.01 Dade City $125,700 $ 54,576.73 Dania Beach $235,200 $ 78,581.04 Davenport $219,600 $ 50,659.25 Davie $346,600 $ 96,026.22 Daytona Beach $150,400 $ 70,168.14 De Leon Springs $185,400 $ 56,876.46 Debary $243,400 $ 55,935.19 Deerfield Beach $187,000 $ 65,642.51 Deland $202,000 $ 53,222.65 Delray Beach $211,100 $ 47,700.28 Deltona $181,900 $ 47,647.53 Destin $380,900 $ 70,683.96 Doctor Phillips $334,300 $ 71,482.49 Doral $329,300 $ 100,637.44 Dover $236,700 $ 86,072.15 Dundee $147,100 $ 72,260.09 Dunedin $260,300 $ 51,440.21 Dunnellon $163,000 $ 54,300.69 East Palatka $143,500 $ 33,316.21 Edgewater $186,300 $ 64,223.93 Edgewood $307,100 $ 49,735.56 Egypt Lake-Leto $192,600 $ 50,744.21 Elkton $246,100 $ 59,463.60 Ellenton $265,000 $ 76,136.43 Englewood $229,100 $ 76,114.64 Enterprise $225,700 $ 89,077.65 Estero $309,200 $ 77,333.32 Eustis $204,300 $ 70,950.29 Feather Sound $344,900 $ 88,764.22 Fernandina Beach $369,800 $ 70,369.51 Flagler Beach $319,700 $ 102,076.11 Fleming Island $283,800 $ 51,102.32 Floral City $148,900 $ 70,700.02 Florida City $169,800 $ 40,807.68 Fort Lauderdale $319,300 $ 67,373.35 Fort Mc Coy $59,700 $ 40,002.72 Fort Meade $117,700 $ 58,696.46 Fort Myers $214,500 $ 88,073.27 Fort Myers Beach $445,800 $ 68,161.61 Fort Pierce $158,100 $ 48,505.59 Fort Walton Beach $197,900 $ 86,991.07 Fort White $175,200 $ 78,755.49 Fountainbleau $194,800 $ 79,592.91 Freeport $228,800 $ 85,976.82 Frostproof $87,700 $ 47,753.18 Fruit Cove $327,500 $ 87,024.50 Fruitland Park $185,200 $ 75,113.58 Gainesville $189,400 $ 83,820.10 Geneva $332,400 $ 74,981.61 Gibsonia $183,600 $ 76,240.52 Gibsonton $206,400 $ 48,605.05 Glen Saint Mary $206,900 $ 80,751.76 Glenvar Heights $258,400 $ 91,485.33 Golden Glades $267,300 $ 53,797.07 Golden Lakes $100,600 $ 47,116.56 Gotha $312,200 $ 82,356.54 Goulds $275,400 $ 79,478.29 Graceville $81,100 $ 38,174.08 Grand Island $206,200 $ 55,780.17 Grand Ridge $94,200 $ 27,644.34 Grant-Valkaria $370,200 $ 63,263.28 Greater Carrollwood $240,300 $ 87,539.02 Greater Northdale $270,400 $ 80,894.24 Green Cove Springs $212,800 $ 67,727.27 Greenacres $173,800 $ 49,835.31 Greenwood $94,000 $ 55,818.46 Groveland $228,400 $ 46,504.05 Gulf Breeze $312,100 $ 51,079.60 Gulfport $226,400 $ 82,319.24 Haines City $184,000 $ 80,787.29 Hallandale $213,200 $ 74,257.03 Hastings $148,000 $ 75,734.56 Havana $166,200 $ 59,662.80 Haverhill $268,400 $ 84,399.42 Hawthorne $115,200 $ 42,143.93 Hernando $212,200 $ 50,335.63 Hialeah $290,000 $ 60,775.66 Hialeah Gardens $260,600 $ 85,945.03 High Springs $178,100 $ 71,436.77 Highland Beach $551,000 $ 80,625.46 Hobe Sound $273,500 $ 70,273.41 Holden Heights $238,300 $ 89,935.21 Holiday $116,000 $ 44,497.46 Holly Hill $138,100 $ 64,660.40 Hollywood $286,800 $ 77,600.55 Holt $154,600 $ 37,226.66 Homestead $221,800 $ 46,511.95 Homosassa $186,500 $ 61,707.81 Howey in the Hills $255,100 $ 62,731.28 Hudson $176,000 $ 62,807.01 Hutchinson Island South $310,400 $ 53,212.61 Hypoluxo $203,000 $ 44,798.06 Indian Harbour Beach $309,100 $ 51,545.38 Indian River Shores $862,200 $ 140,640.60 Indian Rocks Beach $537,800 $ 94,608.26 Inglis $133,700 $ 57,343.00 Interlachen $84,100 $ 34,482.31 Inverness $136,500 $ 47,175.35 Ives Estates $176,800 $ 37,450.54 Jacksonville $180,600 $ 44,837.29 Jacksonville Beach $366,400 $ 75,003.52 Jan-Phyl Village $146,200 $ 58,756.62 Jensen Beach $242,400 $ 87,920.78 June Park $237,300 $ 81,652.80 Juno Beach $470,300 $ 68,396.14 Jupiter $374,300 $ 103,536.85 Kendale Lakes $258,800 $ 80,337.09 Kendall $328,100 $ 67,623.15 Kendall West $228,100 $ 92,440.23 Kenneth City $180,600 $ 47,998.29 Key Biscayne $1,058,800 $ 172,123.45 Key Largo $669,900 $ 106,451.21 Key West $629,600 $ 92,765.02 Keystone Heights $168,800 $ 37,690.27 Kissimmee $221,100 $ 68,350.37 Labelle $130,900 $ 67,732.66 Lady Lake $210,100 $ 89,806.87 Lake Alfred $162,600 $ 65,486.93 Lake Belvedere Estates $269,900 $ 55,487.54 Lake City $143,300 $ 58,324.33 Lake Clarke Shores $365,700 $ 59,784.94 Lake Helen $180,800 $ 75,800.18 Lake Magdalene $255,100 $ 49,760.28 Lake Mary $310,200 $ 50,140.73 Lake Park $236,000 $ 83,026.56 Lake Placid $151,300 $ 49,473.61 Lake Wales $141,300 $ 44,073.51 Lake Worth $211,900 $ 51,961.80 Lake Worth Corridor $219,500 $ 60,873.31 Lakeland $168,100 $ 81,305.68 Lakeland Highlands $261,700 $ 64,773.38 Land O Lakes $261,900 $ 80,935.26 Lantana $232,900 $ 80,895.40 Largo $200,600 $ 78,900.48 Lauderdale Lakes $79,800 $ 55,246.85 Lauderdale-by-the-Sea $410,700 $ 77,079.35 Lauderhill $124,700 $ 75,155.32 Lawtey $107,400 $ 77,530.54 Lecanto $210,000 $ 47,570.92 Leesburg $175,900 $ 55,081.07 Lighthouse Point $487,000 $ 88,415.27 Live Oak $128,400 $ 37,345.14 Longboat Key $647,500 $ 124,874.45 Longwood $301,000 $ 94,342.16 Loughman $223,800 $ 92,182.77 Loxahatchee Groves $428,800 $ 94,645.66 Lutz $285,800 $ 89,164.14 Lynn Haven $215,200 $ 49,081.85 Macclenny $188,900 $ 74,862.39 Madeira Beach $510,700 $ 73,279.27 Madison $73,900 $ 66,229.33 Maitland $363,300 $ 89,513.35 Malabar $326,700 $ 63,605.98 Marathon $498,800 $ 86,784.30 Marco Island $546,600 $ 77,566.06 Margate $210,300 $ 55,907.75 Marianna $112,000 $ 62,251.82 Mary Esther $208,700 $ 70,070.69 Medulla $211,500 $ 54,112.04 Melbourne $195,600 $ 67,663.43 Melbourne Beach $412,400 $ 98,631.35 Melrose $174,000 $ 71,937.19 Merritt Island $291,700 $ 71,180.66 Miami $337,900 $ 71,952.36 Miami Beach $379,500 $ 95,672.78 Miami Gardens $263,100 $ 69,844.55 Miami Lakes $409,200 $ 85,310.24 Miami Shores $541,500 $ 116,644.07 Miami Springs $403,500 $ 99,740.60 Micanopy $195,800 $ 48,798.31 Micco $224,200 $ 68,927.54 Middleburg $211,100 $ 50,850.28 Milton $160,900 $ 50,937.93 Mims $240,500 $ 71,718.91 Miramar $318,900 $ 54,974.59 Miramar Beach $407,900 $ 75,246.00 Miromar Lakes $628,300 $ 118,175.79 Molino $171,700 $ 76,716.55 Monticello $127,300 $ 73,683.78 Montverde $380,700 $ 60,097.07 Moore Haven $92,000 $ 40,341.64 Morriston $238,600 $ 72,971.03 Mount Dora $236,200 $ 86,799.45 Mulberry $179,700 $ 46,877.83 Myakka City $357,100 $ 62,975.02 Naples $324,200 $ 99,440.45 Navarre $265,600 $ 46,928.08 Neptune Beach $438,800 $ 67,956.75 New Port Richey $175,400 $ 79,418.37 New Smyrna Beach $306,800 $ 59,691.73 Newberry $211,200 $ 74,104.22 Niceville $303,900 $ 75,501.45 Nokomis $336,100 $ 56,437.42 Norland $84,700 $ 27,156.95 North Bay Village $252,800 $ 81,703.64 North Fort Myers $179,800 $ 52,677.77 North Lauderdale $216,200 $ 86,819.26 North Miami $244,100 $ 62,465.78 North Miami Beach $257,600 $ 58,765.80 North Palm Beach $333,900 $ 68,133.72 North Port $206,300 $ 59,891.11 North Weeki Wachee $216,200 $ 77,712.26 O Brien $151,900 $ 72,280.25 Oak Hill $187,600 $ 46,283.16 Oakland $359,600 $ 83,472.54 Oakland Park $239,100 $ 69,720.73 Ocala $153,000 $ 41,425.60 Ocklawaha $135,500 $ 60,632.94 Ocoee $254,200 $ 76,257.81 Odessa $428,000 $ 81,865.13 Ojus $131,500 $ 51,866.30 Okeechobee $140,400 $ 71,062.05 Old Town $78,800 $ 55,755.44 Oldsmar $250,200 $ 73,160.17 Olympia Heights $395,200 $ 62,178.51 Orange City $172,100 $ 70,984.32 Orange Park $201,900 $ 54,325.71 Orlando $245,600 $ 55,730.89 Ormond Beach $258,500 $ 73,524.27 Osprey $458,500 $ 78,606.11 Oviedo $320,700 $ 59,987.52 Oxford $215,500 $ 73,456.68 Pace $196,300 $ 71,546.02 Palatka $104,100 $ 29,117.49 Palm Bay $183,600 $ 87,296.52 Palm Beach $1,155,300 $ 148,383.43 Palm Beach Gardens $382,100 $ 74,552.25 Palm City $369,500 $ 103,217.69 Palm Coast $225,900 $ 89,799.53 Palm Harbor $282,500 $ 66,076.09 Palm Springs $164,900 $ 35,187.57 Palm Springs North $396,200 $ 66,675.92 Palmetto $226,100 $ 47,208.41 Palmetto Estates $312,700 $ 84,429.25 Panama City $196,700 $ 54,659.78 Panama City Beach $288,100 $ 67,413.78 Parkland $618,200 $ 110,173.76 Parrish $299,000 $ 67,687.34 Pebble Creek $283,000 $ 47,637.80 Pembroke Park $151,700 $ 48,930.37 Pembroke Pines $318,000 $ 56,783.12 Pensacola $152,000 $ 80,281.19 Perry $89,900 $ 27,216.88 Pierson $176,300 $ 39,263.84 Pine Castle $205,000 $ 67,408.88 Pinecrest $954,700 $ 154,408.95 Pinellas Park $185,400 $ 76,737.46 Plant City $196,700 $ 42,067.78 Plantation $332,100 $ 87,420.79 Poinciana $187,000 $ 57,198.51 Pomona Park $111,200 $ 40,464.30 Pompano Beach $220,700 $ 69,357.60 Ponce Inlet $372,200 $ 106,386.10 Ponte Vedra $395,100 $ 95,454.57 Ponte Vedra Beach $503,300 $ 87,014.64 Port Charlotte $182,600 $ 86,400.11 Port Orange $230,900 $ 86,771.58 Port Richey $122,600 $ 69,145.56 Port Saint Joe $245,200 $ 55,523.13 Port Saint Lucie $228,300 $ 87,996.11 Punta Gorda $241,000 $ 45,034.61 Quincy $77,900 $ 59,801.97 Reddick $224,700 $ 50,673.24 Richmond Heights $272,500 $ 88,805.00 Richmond West $351,000 $ 67,380.62 Riverview $226,000 $ 60,629.47 Riviera Beach $219,000 $ 78,612.61 Rockledge $262,900 $ 58,004.67 Rotonda West $260,100 $ 54,847.33 Royal Palm Beach $310,200 $ 64,095.73 Royal Palm Estates $217,400 $ 59,247.55 Ruskin $212,800 $ 53,514.27 Safety Harbor $310,900 $ 99,702.31 Saint Augustine $259,000 $ 87,989.98 Saint Augustine Beach $361,600 $ 60,439.36 Saint Cloud $242,300 $ 73,846.84 Saint Pete Beach $482,500 $ 107,733.93 Saint Petersburg $228,900 $ 89,576.76 Sanderson $97,000 $ 74,223.69 Sanford $206,200 $ 76,789.17 Sanibel $751,000 $ 127,726.30 Santa Rosa Beach $557,100 $ 91,454.85 Sarasota $263,500 $ 68,441.32 Satellite Beach $333,900 $ 65,997.72 Satsuma $114,500 $ 59,347.35 Sebastian $220,000 $ 65,769.02 Sebring $141,200 $ 53,576.57 Seffner $207,100 $ 83,496.64 Seminole $248,600 $ 78,215.12 Shady Hills $212,900 $ 82,898.21 Shalimar $267,300 $ 79,265.07 Siesta Key $630,000 $ 125,452.78 Silver Springs $120,000 $ 48,788.10 Sky Lake $183,900 $ 59,616.35 Sneads $82,600 $ 27,260.19 Sorrento $257,500 $ 86,775.86 South Daytona $178,000 $ 37,552.83 South Highpoint $183,600 $ 52,453.52 South Miami $525,800 $ 85,363.35 South Pasadena $244,700 $ 66,632.42 Southwest Ranches $691,400 $ 128,852.51 Spring Hill $169,600 $ 45,670.79 Starke $122,000 $ 35,241.92 Stuart $236,400 $ 48,499.33 Summerfield $201,600 $ 64,631.89 Sun City Center $178,400 $ 43,892.59 Sunny Isles Beach $379,300 $ 61,395.90 Sunrise $236,300 $ 76,083.39 Sunset $427,800 $ 101,627.25 Surfside $627,700 $ 124,905.14 Sweetwater $280,000 $ 79,976.57 Tallahassee $183,800 $ 43,747.40 Tamarac $194,400 $ 43,763.14 Tamiami $358,600 $ 72,000.13 Tampa $224,900 $ 72,907.12 Tarpon Springs $266,900 $ 50,828.31 Tavares $198,500 $ 49,069.72 Temple Terrace $200,700 $ 88,098.42 Tequesta $400,700 $ 67,855.26 The Crossings $283,800 $ 76,969.32 The Hammocks $337,200 $ 62,622.77 The Villages $284,700 $ 74,030.79 Thonotosassa $233,000 $ 73,310.34 Three Lakes $313,200 $ 57,916.95 Timber Pines $175,800 $ 75,692.13 Titusville $167,900 $ 48,463.80 Town 'n' Country $220,300 $ 41,886.84 Treasure Island $424,600 $ 86,107.14 Trenton $121,200 $ 40,048.39 Umatilla $162,400 $ 51,878.05 University $81,400 $ 55,695.90 University Park $373,400 $ 89,720.39 Valparaiso $205,700 $ 51,520.47 Valrico $259,700 $ 65,741.56 Venice $248,300 $ 87,018.30 Vernon $97,300 $ 48,598.51 Vero Beach $214,100 $ 61,576.50 Village of Palmetto Bay $568,300 $ 115,379.24 Virginia Gardens $349,300 $ 66,627.63 Wauchula $99,300 $ 55,275.33 Webster $140,600 $ 56,001.93 Wedgefield $298,900 $ 86,489.40 Weirsdale $248,600 $ 64,480.12 Wellington $391,300 $ 100,790.81 Wesley Chapel $249,800 $ 74,918.41 West Melbourne $252,600 $ 68,073.76 West Miami $371,900 $ 80,982.27 West Palm Beach $244,200 $ 87,839.72 West Perrine $276,500 $ 63,015.64 Westchase $352,100 $ 70,650.97 Westgate-Belvedere Homes $205,500 $ 71,147.58 Weston $455,000 $ 111,182.18 Westville $77,500 $ 39,329.21 Westwood Lake $363,900 $ 74,563.00 Wewahitchka $76,200 $ 67,730.98 Williamsburg $238,600 $ 66,016.03 Williston $136,800 $ 31,836.17 Wilton Manors $374,300 $ 77,285.85 Wimauma $265,000 $ 87,243.43 Windermere $444,300 $ 101,134.50 Winter Garden $310,900 $ 67,108.31 Winter Haven $171,100 $ 42,749.91 Winter Park $404,200 $ 98,980.19 Winter Springs $281,100 $ 76,190.92 Youngstown $168,200 $ 77,059.62 Yulee $227,700 $ 68,832.47 Zephyrhills $159,100 $ 47,353.00 Zolfo Springs $79,600 $ 29,488.97 STA 2023 - Kirby Santa Fe College Course Project Statistics in Action Please type your work (recommended) or write your report on separate sheet of paper. Your project should present your data, answer all the required questions and provide any additional analysis or conclusions you think may be of use. There is no required word count, but it should be 2-3 pages – possibly longer depending on your use of graphs and the level of detail in your analysis. A Grading Rubric with the requirements to earn full points on the assignment and how your work will be evaluated is available on Canvas. The data you will be using is found in the file “prices.xlsx” available on Canvas. It contains information on 441 cities, towns, and incorporated municipalities in the state of Florida. The data file contains two variables – the first, Average Price, shows the average selling price of a single- family house in the municipality; the second, Average Income, shows the mean per capita income for the municipality. This project will focus primarily on studying the Average Price variable in depth; you will be using Average Income only as a second variable for comparison. Be sure to include a Bibliography with any outside sources you cite. (APA or MLA citation is fine!) Outline: I. Research & Data Processing A. Comment on any difficulties involved in analyzing and processing this volume of data. B. Select a sample of data for analysis. Be sure to use an appropriate randomization method (for example, SRS or systematic sampling). Select an appropriate sample size that is sufficiently large but manageable to work with. a. EXPLAIN the method you used for selecting your sample b. LIST the values you selected in a table. (both variables) C. Examine the distribution of your sample data. a. INCLUDE at least a histogram showing the distribution of the Average Price variable, and any other graphs you may find helpful. b. COMMENT on the type of distribution of the Average Price variable and its general shape. D. Find the MEAN, STANDARD DEVIATION and FIVE-NUMBER SUMMARY for your sample data. Comment on shape, outliers and which numbers are a better summary in this case. E. Compare your two variables, and run a regression with Average Price as the dependent variable, and Average Income as the independent variable. a. Create a SCATTERPLOT of the two variables (include your graph if possible – if you graph it on your calculator you are not required to include your graph) b. Perform a LINEAR REGRESSION, and give the REGRESSION EQUATION, CORRELATION COEFFICIENT and R-SQUARED, and interpret the R- SQUARED. c. COMMENT on whether your regression is valuable. STA 2023 - Kirby Santa Fe College Course Project II. Data Analysis & Hypothesis Testing A. Head to the library, Google, or your online research tool of choice and find a primary source with information on the average home price in the United States. a. Be sure to CITE YOUR SOURCE properly! b. Include a reference to your source in your report as well as the data value. B. Produce the appropriate Confidence Interval for the mean of your sample data. a. Establish an appropriate LEVEL OF CONFIDENCE and be sure to state what it is. b. CALCULATE a confidence interval from your sample data. c. COMMENT on whether your primary source data for the average value is within your confidence interval, and what that may imply. C. Using your primary source, perform the appropriate hypothesis test to compare the results from the sample you found, to the reference value you calculated a. Clearly state the appropriate NULL HYPOTHESIS, as well as the ALTERNATE HYPOTHESIS you will be testing. b. TEST your hypothesis, and compare the p-value you compute to the level of confidence you established in Part B. c. DETERMINE based on the results of your hypothesis test whether you will accept or reject the null hypothesis. III. Conclusions A. COMMENT on the results of your hypothesis test, and on what conclusions you can draw based on those results. B. EVALUATE the procedure and methodology used in this research process, including any issues you encountered or noteworthy observations you may have noticed. C. SUGGEST any improvements or direction for future research, or any alternate tests you may wish to do to examine your data.