1 State County Region House listing Cost per price Square square fo footage Random 2,062 10...

Transcribed Image Text:

1 State County Region House listing Cost per price Square square fo footage Random 2,062 10 13 15 18 19 30 31 234567890-234567890-234567% 1012 NC rutherford 16 21 29 32 HUNGWHWWHHNNNNNNNNNNNUS lee berkeley South Atlantic South Atlantic South Atlantic $298,050 $136 $299,950 $165 $282,500 $126 NC stanly South Atlantic $290,050 GA laurens South Atlantic $125,550 WV ohio South Atlantic $145,000 $138 $56 $98 st.johns South Atlantic $384,043 $174 NC alamance South Atlantic $199,950 $78 0.27080187 1,800 0.41043883 2,363 0.67532669 1,998 0.91578662 1,730 0.0242162 1,549 0.09541838 2,230 0.18385887 1,344 0.83194746 National average listing price Sample mean sample standard deviation Standard error 288,407 $287,187 119159.7637 Quartile1 238.3195275 quartile3 204837.5 339162.5 HO: u=288,407 VA bedford South Atlantic $278,521 $123 VA bedford South Atlantic $349,950 $148 DE kent South Atlantic $262,850 $122 brevard South Atlantic $299,050 $161 MD st. mary's South Atlantic GA barrow South Atlantic VA henry South Atlantic NC bedford randolph South Atlantic South Atlantic $321,550 $235,950 $115,050 $339,050 $169,950 $120 1,833 0.13712047 2,498 0.18858686 1,871 0.24486525 1,857 0.38347135 1,235 0.95547677 H1: u <288,407 Level of signifigance = 0.05 Test statistic P value -$5.12 2.20232E-07 $99 1,888 0.57569561 $64 1,733 0.40941224 $150 2,300 0.91522034 Conclusion: since the p value higher than the level of signifigance we will not reject the null hypothesis Interpretation: there is evidence in the average listing price is higer in the South Alantic region than the National Average $98 1,800 0.34602993 NC alamance South Atlantic $215,050 $79 1,380 0.58401527 NC rutherford South Atlantic $243,450 $122 1,908 0.24914882 SQ FT NC halifax South Atlantic $165,800 $88 1,780 GA whitfield South Atlantic $192,400 $85 1,690 loudoun South Atlantic $626,300 $193 NC VA stanly pittsylvania South Atlantic $273,800 $138 South Atlantic $169,779 $87 NC henderson South Atlantic $377,050 $150 kershaw South Atlantic $258,550 $107 2,347 NC union walton South Atlantic $419,500 $130 3,262 0.42230167 0.1518883 3,032 0.89607964 1,861 0.24330347 1,740 0.7908817 2,457 0.26909122 0.307331 0.76420242 National average Sample mean Standard deviation Standard error 1,944 1,983 Quartile1 389.7938463 Quartile3 1750 2229.25 8.75 HO: u 1944 South Atlantic $650,050 $336 MD st. mary's South Atlantic $312,450 $123 sumter South Atlantic charleston South Atlantic $154,965 $499,000 $83 $237 2,085 0.92320333 1,228 0.54777923 1,917 0.95641288 2,099 0.73822069 H1: u not equal to 1944 level of signifigance =0.05 Test statistic P value 4.493484751 8.71679E-06 New England Mid Atlantic South Atlantic (2) South Atlantic East North Central East South Central Mountain Pacific West North Central 32 A B C D E F SC charleston 33 34 GA GA columbia gordon 35 GA bulloch 36 NC rutherford South Atlantic South Atlantic South Atlantic South Atlantic South Atlantic $499,000 $258,950 $237 G 2,099 0.73822069 H K L M N P P value 8./16/9E-06 $103 2,559 0.44691121 $179,950 $90 $173,750 $90 $289,950 $131 37 GA gwinnett South Atlantic $329,950 $116 38 MD calvert South Atlantic $359,500 $159 39 VA roanoke South Atlantic $262,025 $121 40 NC harnett 41 GA glynn 42 FL st. lucie 43 MD queen anne's South Atlantic South Atlantic South Atlantic South Atlantic $236,664 $105 1,800 0.59313441 1,806 0.59786457 2,015 0.96358986 2,485 0.53872937 2,040 0.80434142 2,154 0.75668459 2,129 0.70859834 Conclusion: since the p value is more than the level of signifigance we will not reject null hypthesis Interpretation: There is evidence that the National average of square feet in the South Atlantic Region is not equal to the National average 95% confidence interval Alpha 0.05 $419,950 $184 2,136 0.61433013 $269,050 $143 1,873 0.55403103 44 FL orange South Atlantic 45 NC lee South Atlantic $392,250 $312,588 $235,050 $179 2,194 0.62358985 Confidence interval Margin of error Lower bound sample mean +/- margin of error 174.2659982 $145 2,124 0.50375512 Upper bound 1,809 2,158 $98 2,300 0.47093363 46 GA lowndes South Atlantic $162,050 $88 1,825 47 FL miami-dade South Atlantic $450,050 $337 1,372 48 NC halifax South Atlantic 49 FL palm beach South Atlantic $181,250 $395,050 $90 1,810 $197 50 FL hernando South Atlantic $204,950 $105 0.73077066 0.91781686 0.10503136 1,881 0.04783168 1,990 0.32293562 (1,809,2,158) We are 95% confident that the sq footage in the South Atlantic Region is between 1,809 and 2,158 square feet 51 SC lancaster South Atlantic $318,474 $125 2,447 0.67145402 52 FL escambia South Atlantic $235,000 $114 1,856 0.31267117 53 FL manatee South Atlantic $349,950 $167 2,046 0.52552412 54 VA chesterfield South Atlantic $319,750 $128 2,523 0.38557936 55 FL orange South Atlantic $335,050 $155 2,200 0.02054559 56 FL nassau South Atlantic $393,971 $171 2,258 0.44390646 57 FL lee South Atlantic $299,050 $167 1,768 0.27106695 58 FL sumter South Atlantic $259,950 $156 1,768 59 NC wayne South Atlantic $161,950 $87 1,807 60 GA chatham South Atlantic $288,879 $131 2,069 61 VA roanoke city South Atlantic $151,775 $101 0.69272429 0.19955793 0.11068059 1,699 0.24779981 62 NC davidson South Atlantic $184,950 $93 63 WV berkeley South Atlantic $212,750 $110 64 NC harnett South Atlantic $234,850 $105 65 FL alachua South Atlantic $239,500 $129 1,662 0.65168002 1,756 0.31451425 2,100 0.14768064 1,832 0.49563491 66 FL marion South Atlantic $209,950 $111 1,861 0.17989323 6202 1 State County Region House listing Cost per price Square square fo footage Random 2,062 10 13 15 18 19 30 31 234567890-234567890-234567% 1012 NC rutherford 16 21 29 32 HUNGWHWWHHNNNNNNNNNNNUS lee berkeley South Atlantic South Atlantic South Atlantic $298,050 $136 $299,950 $165 $282,500 $126 NC stanly South Atlantic $290,050 GA laurens South Atlantic $125,550 WV ohio South Atlantic $145,000 $138 $56 $98 st.johns South Atlantic $384,043 $174 NC alamance South Atlantic $199,950 $78 0.27080187 1,800 0.41043883 2,363 0.67532669 1,998 0.91578662 1,730 0.0242162 1,549 0.09541838 2,230 0.18385887 1,344 0.83194746 National average listing price Sample mean sample standard deviation Standard error 288,407 $287,187 119159.7637 Quartile1 238.3195275 quartile3 204837.5 339162.5 HO: u=288,407 VA bedford South Atlantic $278,521 $123 VA bedford South Atlantic $349,950 $148 DE kent South Atlantic $262,850 $122 brevard South Atlantic $299,050 $161 MD st. mary's South Atlantic GA barrow South Atlantic VA henry South Atlantic NC bedford randolph South Atlantic South Atlantic $321,550 $235,950 $115,050 $339,050 $169,950 $120 1,833 0.13712047 2,498 0.18858686 1,871 0.24486525 1,857 0.38347135 1,235 0.95547677 H1: u <288,407 Level of signifigance = 0.05 Test statistic P value -$5.12 2.20232E-07 $99 1,888 0.57569561 $64 1,733 0.40941224 $150 2,300 0.91522034 Conclusion: since the p value higher than the level of signifigance we will not reject the null hypothesis Interpretation: there is evidence in the average listing price is higer in the South Alantic region than the National Average $98 1,800 0.34602993 NC alamance South Atlantic $215,050 $79 1,380 0.58401527 NC rutherford South Atlantic $243,450 $122 1,908 0.24914882 SQ FT NC halifax South Atlantic $165,800 $88 1,780 GA whitfield South Atlantic $192,400 $85 1,690 loudoun South Atlantic $626,300 $193 NC VA stanly pittsylvania South Atlantic $273,800 $138 South Atlantic $169,779 $87 NC henderson South Atlantic $377,050 $150 kershaw South Atlantic $258,550 $107 2,347 NC union walton South Atlantic $419,500 $130 3,262 0.42230167 0.1518883 3,032 0.89607964 1,861 0.24330347 1,740 0.7908817 2,457 0.26909122 0.307331 0.76420242 National average Sample mean Standard deviation Standard error 1,944 1,983 Quartile1 389.7938463 Quartile3 1750 2229.25 8.75 HO: u 1944 South Atlantic $650,050 $336 MD st. mary's South Atlantic $312,450 $123 sumter South Atlantic charleston South Atlantic $154,965 $499,000 $83 $237 2,085 0.92320333 1,228 0.54777923 1,917 0.95641288 2,099 0.73822069 H1: u not equal to 1944 level of signifigance =0.05 Test statistic P value 4.493484751 8.71679E-06 New England Mid Atlantic South Atlantic (2) South Atlantic East North Central East South Central Mountain Pacific West North Central 32 A B C D E F SC charleston 33 34 GA GA columbia gordon 35 GA bulloch 36 NC rutherford South Atlantic South Atlantic South Atlantic South Atlantic South Atlantic $499,000 $258,950 $237 G 2,099 0.73822069 H K L M N P P value 8./16/9E-06 $103 2,559 0.44691121 $179,950 $90 $173,750 $90 $289,950 $131 37 GA gwinnett South Atlantic $329,950 $116 38 MD calvert South Atlantic $359,500 $159 39 VA roanoke South Atlantic $262,025 $121 40 NC harnett 41 GA glynn 42 FL st. lucie 43 MD queen anne's South Atlantic South Atlantic South Atlantic South Atlantic $236,664 $105 1,800 0.59313441 1,806 0.59786457 2,015 0.96358986 2,485 0.53872937 2,040 0.80434142 2,154 0.75668459 2,129 0.70859834 Conclusion: since the p value is more than the level of signifigance we will not reject null hypthesis Interpretation: There is evidence that the National average of square feet in the South Atlantic Region is not equal to the National average 95% confidence interval Alpha 0.05 $419,950 $184 2,136 0.61433013 $269,050 $143 1,873 0.55403103 44 FL orange South Atlantic 45 NC lee South Atlantic $392,250 $312,588 $235,050 $179 2,194 0.62358985 Confidence interval Margin of error Lower bound sample mean +/- margin of error 174.2659982 $145 2,124 0.50375512 Upper bound 1,809 2,158 $98 2,300 0.47093363 46 GA lowndes South Atlantic $162,050 $88 1,825 47 FL miami-dade South Atlantic $450,050 $337 1,372 48 NC halifax South Atlantic 49 FL palm beach South Atlantic $181,250 $395,050 $90 1,810 $197 50 FL hernando South Atlantic $204,950 $105 0.73077066 0.91781686 0.10503136 1,881 0.04783168 1,990 0.32293562 (1,809,2,158) We are 95% confident that the sq footage in the South Atlantic Region is between 1,809 and 2,158 square feet 51 SC lancaster South Atlantic $318,474 $125 2,447 0.67145402 52 FL escambia South Atlantic $235,000 $114 1,856 0.31267117 53 FL manatee South Atlantic $349,950 $167 2,046 0.52552412 54 VA chesterfield South Atlantic $319,750 $128 2,523 0.38557936 55 FL orange South Atlantic $335,050 $155 2,200 0.02054559 56 FL nassau South Atlantic $393,971 $171 2,258 0.44390646 57 FL lee South Atlantic $299,050 $167 1,768 0.27106695 58 FL sumter South Atlantic $259,950 $156 1,768 59 NC wayne South Atlantic $161,950 $87 1,807 60 GA chatham South Atlantic $288,879 $131 2,069 61 VA roanoke city South Atlantic $151,775 $101 0.69272429 0.19955793 0.11068059 1,699 0.24779981 62 NC davidson South Atlantic $184,950 $93 63 WV berkeley South Atlantic $212,750 $110 64 NC harnett South Atlantic $234,850 $105 65 FL alachua South Atlantic $239,500 $129 1,662 0.65168002 1,756 0.31451425 2,100 0.14768064 1,832 0.49563491 66 FL marion South Atlantic $209,950 $111 1,861 0.17989323 6202