Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi Experts, Please can you help , I am confused, we were given the following data for Chi-Square category test, '' to see if there
Hi Experts, Please can you help , I am confused, we were given the following data for Chi-Square category test, ''to see if there is any interaction between number of Bed and number of the Bath to determine the cost per squareftofthehouse'' using PHSTAT in excel and i don't know which data to chose. kindly help.
STATE | BATH | BED | SQ FT HOME | Type | Age of the house | Avg Price Per Sqft of Lot | Avg Price Per Sqr of home |
Alabama | 1 | 1 | 400 | Single Family | 76 | 1.530456076 | 26.04166667 |
Florida | 2 | 1 | 720 | Single Family | 71 | 5.050505051 | 25.84181676 |
Florida | 3 | 1 | 768 | Single Family | 30 | 0.582238725 | 54.6875 |
Alabama | 3 | 1 | 732 | Single Family | 96 | 5.74980575 | 25.51724138 |
Florida | 1 | 1 | 492 | Single Family | 26 | 0.992157732 | 35.04193849 |
Alabama | 1 | 1 | 795 | Single Family | 66 | 3.008137804 | 34.23423423 |
Alabama | 1 | 1 | 600 | Single Family | 48 | 4.157116066 | 35.15418502 |
Florida | 2 | 1 | 990 | Single Family | 66 | 3.401013502 | 55.17241379 |
Florida | 3 | 1 | 1115 | Single Family | 16 | 2.96217305 | 45.24886878 |
Florida | 3 | 1 | 944 | Single Family | 45 | 0.499578926 | 52.7638191 |
Florida | 2 | 2 | 952 | Single Family | 54 | 5.222681359 | 52.66203704 |
Florida | 3 | 1 | 1126 | Single Family | 36 | 2.16573973 | 50.40322581 |
Florida | 2 | 1 | 738 | Single Family | 66 | 2.869605142 | 51.02040816 |
Florida | 2 | 1 | 1125 | Single Family | 53 | 2.660906587 | 35.91549296 |
Florida | 2 | 1 | 842 | Single Family | 35 | 4.683195592 | 54.14012739 |
Florida | 2 | 1 | 1026 | Single Family | 38 | 5.141145937 | 56.5978022 |
Florida | 1 | 1 | 1200 | Single Family | 61 | 6.343644273 | 45.33678756 |
Florida | 3 | 2 | 1032 | Single Family | 43 | 21.04055088 | 42.4382716 |
Florida | 2 | 2 | 909 | Single Family | 27 | 6.766553891 | 55.55555556 |
Alabama | 2 | 1.5 | 1080 | Single Family | 56 | 3.540186555 | 44.12650602 |
Florida | 2 | 1 | 1210 | Single Family | 32 | 1.398071625 | 29.16666667 |
Florida | 3 | 1 | 936 | Single Family | 38 | 9.611264157 | 68.85964912 |
Florida | 2 | 1 | 720 | Single Family | 33 | 21.31846507 | 72.54464286 |
Alabama | 2 | 1 | 1277 | Single Family | 71 | 3.92682809 | 52.71695053 |
Florida | 3 | 1 | 1004 | Single Family | 49 | 4.878328742 | 40.16538689 |
Alabama | 3 | 1 | 1001 | Single Family | 68 | 2.127333946 | 26.73076923 |
Alabama | 1 | 1 | 1220 | Single Family | 46 | 4.383402792 | 68.69649446 |
Florida | 3 | 2 | 1296 | Single Family | 24 | 5.739210285 | 61.07491857 |
Florida | 3 | 1.1 | 1204 | Single Family | 48 | 7.826359178 | 51.72413793 |
Florida | 1 | 1 | 640 | Single Family | 36 | 5.380509642 | 69.31608133 |
Florida | 3 | 2 | 1410 | Single Family | 33 | 6.710461256 | 83.33333333 |
Alabama | 2 | 1 | 888 | Single Family | 33 | 5.28703008 | 57.75075988 |
Florida | 3 | 1 | 936 | Single Family | 60 | 12.090603 | 82.12058212 |
Florida | 2 | 2 | 1227 | Single Family | 9 | 8.337681311 | 159.8 |
Florida | 3 | 2 | 1056 | Single Family | 52 | 3.279548734 | 39.13894325 |
Florida | 3 | 1 | 1408 | Single Family | 0 | 7.063643427 | 40 |
Florida | 2 | 1 | 1281 | Single Family | 11 | 26.56608724 | 60.53811659 |
Florida | 2 | 1 | 928 | Single Family | 13 | 13.3486389 | 64.86055777 |
Florida | 3 | 1 | 1228 | Single Family | 44 | 8.235176682 | 75.54945055 |
Florida | 4 | 1 | 1337 | Single Family | 13 | 13.61102001 | 76.63896584 |
Florida | 3 | 1 | 1450 | Single Family | 43 | 9.756657484 | 83.82642998 |
Florida | 2 | 1 | 1073 | Single Family | 61 | 1.434802571 | 61.06321839 |
Florida | 2 | 1 | 952 | Single Family | 32 | 4.537980225 | 78.7037037 |
Florida | 3 | 2 | 1110 | Single Family | 11 | 27.87799278 | 63.24404762 |
Florida | 2 | 1 | 762 | Single Family | 63 | 4.787341262 | 52.38970588 |
Alabama | 3 | 1 | 1150 | Single Family | 71 | 20.11695906 | 95.98214286 |
Florida | 3 | 1 | 1116 | Single Family | 10 | 7.397204367 | 72.86432161 |
Florida | 3 | 2 | 1152 | Single Family | 55 | 7.992102847 | 50.30867052 |
Alabama | 2 | 1 | 936 | Single Family | 14 | 12.75649304 | 63.22901849 |
Florida | 2 | 1 | 1188 | Single Family | 37 | 6.009290769 | 40.32623471 |
Florida | 3 | 1 | 846 | Single Family | 66 | 10.21579431 | 50.56818182 |
Alabama | 3 | 2 | 1135 | Single Family | 9 | 20.43158861 | 69.6400626 |
Florida | 2 | 1 | 1136 | Single Family | 60 | 6.46965523 | 88.06818182 |
Alabama | 2 | 1 | 1054 | Single Family | 46 | 5.474323656 | 83.10991957 |
Alabama | 3 | 1.5 | 1040 | Single Family | 34 | 10.19427955 | 82.13043478 |
Florida | 3 | 1 | 1100 | Single Family | 20 | 2.183195592 | 65.5410062 |
Florida | 4 | 2 | 1588 | Single Family | 44 | 7.854519218 | 66.43550624 |
Florida | 2 | 1 | 788 | Single Family | 31 | 20.66374452 | 104.4303797 |
Florida | 3 | 2 | 1158 | Multi Family | 31 | 4.591368228 | 78.36990596 |
Florida | 2 | 1 | 1064 | Single Family | 29 | 10.93254619 | 53.87931034 |
Florida | 2 | 1 | 725 | Single Family | 35 | 5.739210285 | 47.61904762 |
Alabama | 2 | 2 | 884 | Single Family | 41 | 8.465581136 | 83.20145044 |
Florida | 2 | 1 | 528 | Single Family | 20 | 16.97277796 | 93.83499547 |
Florida | 2 | 1 | 1070 | Single Family | 10 | 21.70736798 | 83.26661329 |
Alabama | 4 | 2 | 1616 | Multi Family | 39 | 4.43832262 | 72.60083449 |
Florida | 3 | 1 | 864 | Single Family | 44 | 9.271031998 | 80.0304878 |
Alabama | 2 | 1 | 750 | Single Family | 28 | 2.41046832 | 46.68741663 |
Florida | 2 | 1 | 748 | Single Family | 36 | 6.403750423 | 57.45257453 |
Alabama | 3 | 2 | 1500 | Single Family | 71 | 8.111417202 | 55.20833333 |
Florida | 2 | 1.5 | 1446 | Single Family | 31 | 8.187940006 | 103.0828516 |
Alabama | 2 | 1 | 800 | Single Family | 20 | 27.21518987 | 91.80187874 |
Alabama | 3 | 1 | 1338 | Single Family | 19 | 19.72727273 | 82.69817073 |
Florida | 2 | 1 | 931 | Single Family | 34 | 4.95147554 | 69.13890635 |
Alabama | 3 | 1 | 1504 | Single Family | 69 | 12.42937853 | 135.9703337 |
Alabama | 3 | 1 | 796 | Single Family | 40 | 4.856254856 | 38.54239664 |
Florida | 4 | 1.5 | 1275 | Single Family | 39 | 7.898588154 | 54.94011976 |
Florida | 3 | 1 | 1008 | Single Family | 45 | 0.810027781 | 50.68181818 |
Florida | 2 | 1 | 1092 | Single Family | 36 | 14.28571429 | 104.4776119 |
Florida | 4 | 1 | 960 | Single Family | 10 | 17.14110805 | 63.92694064 |
Florida | 3 | 1 | 1008 | Single Family | 32 | 23.99833055 | 100.4366812 |
Florida | 3 | 2 | 1280 | Single Family | 46 | 8.800122436 | 87.12121212 |
Florida | 4 | 2 | 1350 | Multi Family | 34 | 6.769324951 | 78.49829352 |
Florida | 2 | 2 | 1180 | Single Family | 7 | 94.494659 | 94.494659 |
Alabama | 3 | 1 | 1200 | Single Family | 14 | 8.838383838 | 90.73055774 |
Florida | 2 | 2 | 1768 | Multi Family | 24 | 9.261897977 | 104.7448523 |
Florida | 3 | 1 | 972 | Single Family | 35 | 2.685950413 | 65 |
Florida | 3 | 2 | 1738 | Single Family | 13 | 26.97428834 | 97.10743802 |
Florida | 3 | 1 | 1513 | Single Family | 29 | 9.674668766 | 96.09120521 |
Florida | 2 | 1 | 660 | Single Family | 76 | 16.932128 | 86.95652174 |
Alabama | 3 | 1 | 864 | Single Family | 40 | 4.369205249 | 70.36374478 |
Alabama | 3 | 1 | 894 | Single Family | 18 | 19.81666667 | 108.6837294 |
Alabama | 2 | 1 | 1496 | Single Family | 60 | 3.959223327 | 59.17454003 |
Alabama | 1 | 1 | 550 | Single Family | 52 | 13.69142857 | 84.36619718 |
Florida | 3 | 1 | 1120 | Single Family | 40 | 11.97843881 | 100.3344482 |
Florida | 3 | 1 | 1356 | Single Family | 50 | 8.10241452 | 100 |
Florida | 3 | 1 | 1164 | Single Family | 36 | 4.173971116 | 93.16770186 |
Florida | 3 | 2 | 1533 | Single Family | 11 | 25.04696306 | 85.77555397 |
Alabama | 3 | 2 | 1320 | Single Family | 66 | 3.577689528 | 42.65908283 |
Alabama | 3 | 1 | 1872 | Single Family | 19 | 15.58441558 | 90.36144578 |
Alabama | 1 | 1 | 1871 | Single Family | 19 | 11.56357883 | 93.11583012 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started