• Generate a Representative Sample of the Data
  • Select a region and generate a simple random sample of 30 from the data.
  • Report the mean, median, and standard deviation of the listing price and the square foot variables.
• Analyze Your Sample
  • Discuss how the regional sample created is or is not reflective of the national market.
    • Compare and contrast your sample with the population using the National Summary Statistics and Graphs Real Estate Data PDF document.
  • Explain how you have made sure that the sample is random.
    • Explain your methods to get a truly random sample.
• Generate Scatterplot
  • Make a scatterplot of the x and y variables noted above and include a trend line and the regression equation
• Observe patterns
  • Answer the following questions based on the scatterplot:
    • Define x and y. Which variable is useful for making predictions?
    • Is there an association between x and y? Describe the association you see in the scatter plot.
    • What do you see as the shape (linear or nonlinear)?
    • If you had a 1,800 square foot house, based on the regression equation in the graph, what price would you choose to list at?
    • Do you see any potential outliers in the scatterplot?
      • Why do you think the outliers appeared in the scatterplot you generated?
      • What do they represent?

AutoSave . Off H MAT 240 Real Estate Data (1) - Excel Search (Alt+Q) Drew Dowling DD X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share LO Arial 11 A" A E = 2 7 v de Wrap Text General Z APO Past BIUVVMAY EE EE Merge & Center $ ~ % 9 08 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting " Table Styles Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis A105 X fx East North Central B C D E F G H K M N O P Region State County listing price square foot square feet East North Central In grant 219,500 $116 1,89 East North Central il vermilion 254,500 $156 1,632 8 East North Central in henry 235,000 $148 1,588 9 East North Central in wayne 203,800 $141 1,441 10 East North Central il coles 220,800 $117 1,893 11 East North Central macoupin 197,600 $11 1,783 12 East North Central in vigo 165,800 $122 1,362 13 East North Central oh jefferson 246,500 $136 1,814 14 East North Central jackson 154,300 $105 1,463 15 East North Central oh marion 149,700 $116 1,296 16 East North Central mi bay 145, 100 $117 1,239 17 East North Central whiteside 283,700 $136 2,087 18 East North Central oh trumbull 243,000 $133 1,827 19 East North Central in madison 229, 100 $187 1,224 20 East North Central knox 205, 100 $118 1,740 21 East North Central stephenson 235,600 $140 1,682 22 East North Central macon 212,900 $128 1,659 23 East North Central delaware 221,600 $134 1,651 24 East North Central henry 257,700 $123 2,087 25 East North Central oh seneca 211,900 $168 1,263 26 East North Central oh darke 160,800 $1 14 1,416 27 East North Central oh scioto 204,200 $131 1,562 28 East North Central oh belmont 172,500 $101 1,710 29 East North Central oh sandusky 253,900 $146 1,738 30 East North Central il rock island 166.300 $127 1,305 31 East North Central oh clark 240,500 $137 1,752 32 East North Central oh columbiana 241,400 $164 1,469 33 East North Central in howard 304,300 $152 1,996 34 East North Central oh richland 248,900 $132 1,880 35 East North Central peoria 187,900 $131 1,434 36 East North Central la salle 311, 100 $154 2,015 37 East North Central madison 254,500 $156 1,628 38 East North Central mi wayne 213,800 $172 1.243 project 1 data + Ready Accessibility: Good to go Display Settings + 100% Type here to search O X w 66F Sunny 1:31 PM 11/10/2022 73