80.2K

Verified Solution

Link Copied!

1. hypotheses statement for question 4 and 5

2. test output for question 4 and 5

3. decision rule for question 4 and 5

4. conclusion for question 4 and 5

1 record Agent 2 1 Marty 3 2 Rose 3 Carter 4 Peterson 5 Carter 6 Peterson 7 Carter 8 Isaacs 9 Peterson 10 Isaacs 11 Rose 12 Peterson. 13 Marty 14 Rose 15 Rose 16 Isaacs 17 Carter 18 Peterson 19 Rose 20 Rose 21 Marty 22 Rose 23 Carter 24 Isaacs 25 Carter 26 Isaacs 27 Carter 28 Marty 29 Isaacs 30 Marty 31 Isaacs 32 Isaacs 33 Carter 34 Carter 4 5 6 7 8 9 10 11 12 13 14 15: 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Price Bedrooms Baths Pool (yes is 1) 2 1.5 3 2 4 3 3 2.5 6 4.5 3 4 2.5 5 3.5 5 3.5 6 4 6 4 4 3 3 2.5 2 1.5 4 3 6 4 5 3.5 5 3.5 3 2 4.5 6 2 1.5 2 1.5 4 3 2.5 3 4 3 5 3.5 5 3.5 4 3 3 2 2 2 4 4 2 Size 206424 1820 3010 346150 372360 3210 310622 3330 496100 4510 294086 3440 228810 384420 4470 2630 416120 4040 487494 4380 448800 5280 388960 4420 335610 2970 276000 2300 346421 2970 453913 3660 376146 3290 694430 5900 251269 2050 547596 4920 214910 1950 188799 1950 459950 4680 264160 2540 393557 3180 478675 4660 384020 4220 313200 3600 274482 2990 167962 1920 175823 1970 226498 2520 316827 3150 189984 1550 644 in 5 ~ M 1.5 1.5 3 3 1.5 1 0 0 1 0 1 0 0 0 1 0 0 0 0 1 1 1 1 1 1 1 1 1 0 1 1 0 0 1 1 1 1 1 Garage (Yes is 1) 1 OH 0 1 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0 1 0 1 1 0 Days 33 36 21 26 13 31 39 26 26 32 35 50 25 34 17 12 28 36 38 37 20 52 31 40 54 26 23 31 37 31 28 28 22 22 Township Mortgage type 2 Fixed 4 Fixed 2 Fixed 3 Fixed 4 Fixed 4 Fixed 4 Adjustable 2 Fixed 4 Fixed 3 Fixed 4 Fixed 2 Adjustable 3 Adjustable 1 Fixed 3 Adjustable 3 Fixed 2 Adjustable 3 Adjustable 3 Fixed S Fixed 4 Fixed 1 Fixed 4 Fixed 1 Fixed 1 Fixed 5 Adjustable 4 Adjustable 3 Fixed 3 Fixed 5 Fixed 5 Adjustable 3. Fixed 4 Fixed 2 Fixed FICO 2 824 9 820 18 819 17 817 17 816 19 813 10 813 6 812 810 808 6 8 806 9 805 9 801 798 795 792 792 788 10 16 786 785 784 10 782 8 781 780 776 9 773 9 772 19 772 769 769 9 766 763 759 2 17 758 Years 888986269 20 103 1000 10 18 18 20 9956 86 6 7 8 9 0 $1 2 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 34 Carter 35 Marty 36 Isaacs 37 Isaacs 38 Rose 39 Carter 40 Peterson 41 Rose 42 Rose 43 Peterson 44 Rose 45 Marty 46 Marty 47 Marty 48 Rose 49 Isaacs 50 Isaacs 51 Isaacs 52 Isaacs 53 Peterson 54 Peterson 55 Rose 56 Carter 57 Isaacs 58 Carter 59 Carter 60 Rose 61 Peterson. 62 Peterson 63 Isaacs 64 Isaacs 65 Marty 66 Isaacs 67 Peterson 189984 1550 366350 3090 416160 4080 308000 3500 294357 2620 337144 2790 299730 2910 4370 445740 410592 4200 667732 5570 523584 336000 3360 5050 202598 2270 326695 2830 321320 2770 246820 2870 546084 5910 6800 174528 1600 793084 392554 3970 263160 3060 237120 1900 225750 2150 848420 7190 371956 3110 404538 3290 250090 2810 369978 3830 209292 1630 190032 1850 216720 2520 323417 3220 316210 3070 226054 2090 2 1.5 3 2 4 3 4 4 3 4 3 3 2 4 3 4 3 5 3.5 6 4 3 2 3 2 3 2.5 3 2 4 3 6 4 8 5.5 2 1.5 4 3 3 2 2 1.5 2 1.5 6 5 3.5 4 3.5 5 4 3 4 25 2 1.5 15 3 2.5 4 3 3 2 2 1.5. 2 3 1 1 0 0 1 1 0 0 1 1 1 0 1 1 0 0 1 1 1 1 0 1 1 0 1 1 0 11 1 1 0 1 0 0 1 1 1 1 1 0 1 1 1 1 0 0 0 1 1 1 1 0 1 1 0 1 1 1 1 1 1 0 1 0 1 0 1 22 23 25 37 15 19 31 19 27 29 19 32 28 30 23 27 35 27 39 30 26 14 27 49 29 24 18 27 18. 30 2 22 30 28 2 Fixed 3 Fixed 4 Fixed 2 Fixed 4 Fixed 3 Fixed 2 Fixed 3 Fixed 1 Adjustable 5 Fixed 5 Adjustable 3 Fixed 1 Fixed 4 Fixed 4 Fixed 5 Fixed 5 Adjustable 4 Fixed 2 Fixed 4 Fixed 3 Fixed 3 Fixed 2 Fixed 1 Fixed 5 Fixed 2 Fixed 5 Fixed 4 Fixed 3 Fixed 4 Adjustable 4 Adjustable 4 Adjustable 1 Adjustable 1 Adjustable $ 17 758 5 754 12 753 18 752 10 751 15 749 13 748 5 746 9 741 4 740 10 739 6 737 10 737 8 736 6 736 13 735 10 731 6 729 728 726 10 726 18 723 15 715 710 710 14 707 11 704 10. 703 10 701 675 5 674 2 673 1 673 6 670 NOOHH35 15 17 8 Home Get Data 066 58 59 70 21 8 67 Peterson 68 Marty 69 Rose 70 Isaacs 71 Rose 72 Peterson 73 Rose 74 Rose 75 Marty 76 Marty 77 Carter 78 Marty 79 Marty 80 Peterson 81 Rose 82 Marty 84 83 Carter 85 84 Carter 86 85 Peterson 87 86 Carter 81 87 Carter 89 88 Carter 90 89 Rose 91 90 Carter 92 91 Marty 93 92 Isaacs 94 93 Carter 95 94 Peterson 96 95 Peterson 96 Marty 97 98 97 Peterson 99 98 Marty 100 99 Isaacs 101 100 Carter 102 01 Peterson 72 73 74 75 76 Excel FIL Insert 27 78 79 80 81 82 83 A Data from Picture x 01 COIL view 2. C... Draw Page Layout Refresh All fx 10015 Formulas Data Queries & Connections Properties Edit Links C D E 226054 2090 183920 2090 * 248400 2300 466560 5760 667212 6110 362710 4370 265440 3160 706596 6600 293700 3300 199448 2330 369533 4230 230121 2030 169000 1690 190291 2040 393584 4660 363792 2860 360960 3840 310877 3180 919480 7670 392904 3400 200928 1840 537900 4890 258120 2390 558342 6160 302720 3440 240115 2220 793656 6530 218862 1930 383081 3510 351520 3380 841491 7030 336300 2850 312863 3750 275033 3060 229990 2110 Sheet2 02 F 1.5 2 3 2 3 2.5 5 3.5 6 4 4 2.5 5 3.5 7 5 3 2 2 1.5 3 4 2 2 1.5 1.5 1.5 2 4 3 3 2.5 6 4.5 2 8 5.5 3 2 2 1.5 4 6 3 6 2.5 4 4 2.5 1.5 5 2 7 2 3 1.5 2 3 2 6 4 3 2.5 4 2 Sheet3 G 1 0 1 0 1 0 1 1 0 1 1 1 0 1 1 1 0 1 1 1 1 0 0 1 0 1 1 1 1 0 1 0 1 1 Review Stocks Q3 H Heip View Tell me Geography 1 1 0 1 28 30 50 42 21 24 22 40 14 1 25 1 32 0 21 0 20 1 31 1 34 1 48 1 32 1 40 1 30 0 40 1 36 1 23 1 23 1 24 1 38 0 39 1 53 0 58 1 27 1 35 1 50 0 28 1 12 1 27 Sheet4 1 1 1 1 1 0 Final Excel (1).xls- Compatibility Mode Clear Reapply Advanced Text to Columns U M 6 670 8 669 4 667 3 665 8 662 2 656 3 653 7 652 7 647 644 5 2 642 3 639 7 639 6 631 7 630 3 626 5 626 6 624 1 623 8 618 3 618 7 614 6614 3 7 613 609 1 609 3 605 1 604 6 601 8 599 H 596 6 595 2 3 595 593 0591 Sheetk J 2 04 24 A Sort Filter 1 Adjustable 2 Adjustable 2 Adjustable 4 Adjustable 3 Adjustable 1 Adjustable 5 Adjustable 3 Adjustable 4 Adjustable 3 Adjustable 2 Adjustable 2 Adjustable 1 Adjustable 4 Adjustable 3 Adjustable 5 Adjustable 2 Adjustable 1 Adjustable 4 Adjustable 2 Adjustable 4 Adjustable 1 Adjustable 1 Adjustable 3 Adjustable 3 Adjustable 5 Adjustable 4 Adjustable 4 Adjustable 2 Adjustable 2 Adjustable 4 Adjustable 1 Adjustable 4 Adjustable 3 Adjustable Advustable 05 + N on O 8- Us Home Get Data 066 37 38 39 90 01 92 03 34 35 96 97 98 99 Excel File Edit View Insert 2. C... Insert Draw Page Layout V Refresh Data from Picture All 8 00 101 102 203 104 105 106 107 108 109 110 111 112 A 86 Carter 87 Carter 88 Carter 89 Rose 90 Carter 91 Marty 92 Isaacs 93 Carter 94 Peterson 95 Peterson 96 Marty 97 Peterson 98 Marty 99 Isaacs 100 Carter 101 Peterson 102 Isaacs 103 Marty 104 Peterson 105 Peterson Format Tools Data Window Help Formulas Data Review View Stocks Deography 1 1 0 0 1 0 1 1 1 1 0 1 0 Queries & Connections Properties Edit Links E F fx C D 392904 3400 200928 1840 537900 4890 258120 2390 558342 6160 302720 3440 240115 2220 793656 6530 218862 1930 383081 3510 351520 3380 841491 7030 336300 2850 312863 3750 275033 3060 229990 2110 195257 2130 194238 1650 348528 2740 241920 2240 3 2 2 1.5 4 6 3 6 2.5 4 4 2.5 2 15 7 S 2 1.5 3 2 3 2 6 4 3 2.5 6 4 3 2 2 2 1.5 1.5 1.5 4 3 2 1.5 2 PRO G 1 1 0 1 1 1 0 H 0 1 1 1 1 1 0 40 36 23 23 24 38 39 1 53 0 58 1 27 1 35 1 50 28 12 27 37 11 30 27 34 1 0 1 1 0 0 1 1 1 Final Excel (1).xls Tell me 23 J Sort Filter 2 Adjustable 4 Adjustable 1 Adjustable 1 Adjustable 3 Adjustable 3 Adjustable 5 Adjustable 4 Adjustable 4 Adjustable 2 Adjustable 2 Adjustable 4 Adjustable 1 Adjustable 4 Adjustable 3 Adjustable 3 Adjustable 5 Adjustable 2 Adjustable 5 Adjustable 5 Adjustable + Compatibility Mode Clear Reapply Advanced Text to Columns L N M 618 3 618 7 614 6 614 7 613 3 609 1 609 3 605 1 604 6 601 8 599 8 596 6 595 2 595 3 593 6 591 8 591 7 590 3 584 8 583 8 0 4. This data set contains all the sales made in 2019 at Beaver Pride Real Estate. After reviewing the type of mortgage home buyers choose, the realty owner believes that those who ended up with fixed mortgage have higher FICO scores than those who went with adjustable mortage. Sort the relevant columns and organize the FICO scores by fixed and adjunstable.From national data, assume that the variances are known as 3000 for the fix rate borrowers and 1500 for the adjustable rate borrowers. At significance level .05, can the realtor conclude that the fixed rate mortgage home buyers have higher credit scores? 15. Using the same data set from Q4, the average home sale price in Beltraver County is $350,000 with a standard deviation of $150,000. Assuming the distribution of home sale price follows the 3 normal distribution. At significant level 0.05, is Beaver Price realtors closing deals lower than the 4 Beltraver average? 1 record Agent 2 1 Marty 3 2 Rose 3 Carter 4 Peterson 5 Carter 6 Peterson 7 Carter 8 Isaacs 9 Peterson 10 Isaacs 11 Rose 12 Peterson. 13 Marty 14 Rose 15 Rose 16 Isaacs 17 Carter 18 Peterson 19 Rose 20 Rose 21 Marty 22 Rose 23 Carter 24 Isaacs 25 Carter 26 Isaacs 27 Carter 28 Marty 29 Isaacs 30 Marty 31 Isaacs 32 Isaacs 33 Carter 34 Carter 4 5 6 7 8 9 10 11 12 13 14 15: 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Price Bedrooms Baths Pool (yes is 1) 2 1.5 3 2 4 3 3 2.5 6 4.5 3 4 2.5 5 3.5 5 3.5 6 4 6 4 4 3 3 2.5 2 1.5 4 3 6 4 5 3.5 5 3.5 3 2 4.5 6 2 1.5 2 1.5 4 3 2.5 3 4 3 5 3.5 5 3.5 4 3 3 2 2 2 4 4 2 Size 206424 1820 3010 346150 372360 3210 310622 3330 496100 4510 294086 3440 228810 384420 4470 2630 416120 4040 487494 4380 448800 5280 388960 4420 335610 2970 276000 2300 346421 2970 453913 3660 376146 3290 694430 5900 251269 2050 547596 4920 214910 1950 188799 1950 459950 4680 264160 2540 393557 3180 478675 4660 384020 4220 313200 3600 274482 2990 167962 1920 175823 1970 226498 2520 316827 3150 189984 1550 644 in 5 ~ M 1.5 1.5 3 3 1.5 1 0 0 1 0 1 0 0 0 1 0 0 0 0 1 1 1 1 1 1 1 1 1 0 1 1 0 0 1 1 1 1 1 Garage (Yes is 1) 1 OH 0 1 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0 1 0 1 1 0 Days 33 36 21 26 13 31 39 26 26 32 35 50 25 34 17 12 28 36 38 37 20 52 31 40 54 26 23 31 37 31 28 28 22 22 Township Mortgage type 2 Fixed 4 Fixed 2 Fixed 3 Fixed 4 Fixed 4 Fixed 4 Adjustable 2 Fixed 4 Fixed 3 Fixed 4 Fixed 2 Adjustable 3 Adjustable 1 Fixed 3 Adjustable 3 Fixed 2 Adjustable 3 Adjustable 3 Fixed S Fixed 4 Fixed 1 Fixed 4 Fixed 1 Fixed 1 Fixed 5 Adjustable 4 Adjustable 3 Fixed 3 Fixed 5 Fixed 5 Adjustable 3. Fixed 4 Fixed 2 Fixed FICO 2 824 9 820 18 819 17 817 17 816 19 813 10 813 6 812 810 808 6 8 806 9 805 9 801 798 795 792 792 788 10 16 786 785 784 10 782 8 781 780 776 9 773 9 772 19 772 769 769 9 766 763 759 2 17 758 Years 888986269 20 103 1000 10 18 18 20 9956 86 6 7 8 9 0 $1 2 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 34 Carter 35 Marty 36 Isaacs 37 Isaacs 38 Rose 39 Carter 40 Peterson 41 Rose 42 Rose 43 Peterson 44 Rose 45 Marty 46 Marty 47 Marty 48 Rose 49 Isaacs 50 Isaacs 51 Isaacs 52 Isaacs 53 Peterson 54 Peterson 55 Rose 56 Carter 57 Isaacs 58 Carter 59 Carter 60 Rose 61 Peterson. 62 Peterson 63 Isaacs 64 Isaacs 65 Marty 66 Isaacs 67 Peterson 189984 1550 366350 3090 416160 4080 308000 3500 294357 2620 337144 2790 299730 2910 4370 445740 410592 4200 667732 5570 523584 336000 3360 5050 202598 2270 326695 2830 321320 2770 246820 2870 546084 5910 6800 174528 1600 793084 392554 3970 263160 3060 237120 1900 225750 2150 848420 7190 371956 3110 404538 3290 250090 2810 369978 3830 209292 1630 190032 1850 216720 2520 323417 3220 316210 3070 226054 2090 2 1.5 3 2 4 3 4 4 3 4 3 3 2 4 3 4 3 5 3.5 6 4 3 2 3 2 3 2.5 3 2 4 3 6 4 8 5.5 2 1.5 4 3 3 2 2 1.5 2 1.5 6 5 3.5 4 3.5 5 4 3 4 25 2 1.5 15 3 2.5 4 3 3 2 2 1.5. 2 3 1 1 0 0 1 1 0 0 1 1 1 0 1 1 0 0 1 1 1 1 0 1 1 0 1 1 0 11 1 1 0 1 0 0 1 1 1 1 1 0 1 1 1 1 0 0 0 1 1 1 1 0 1 1 0 1 1 1 1 1 1 0 1 0 1 0 1 22 23 25 37 15 19 31 19 27 29 19 32 28 30 23 27 35 27 39 30 26 14 27 49 29 24 18 27 18. 30 2 22 30 28 2 Fixed 3 Fixed 4 Fixed 2 Fixed 4 Fixed 3 Fixed 2 Fixed 3 Fixed 1 Adjustable 5 Fixed 5 Adjustable 3 Fixed 1 Fixed 4 Fixed 4 Fixed 5 Fixed 5 Adjustable 4 Fixed 2 Fixed 4 Fixed 3 Fixed 3 Fixed 2 Fixed 1 Fixed 5 Fixed 2 Fixed 5 Fixed 4 Fixed 3 Fixed 4 Adjustable 4 Adjustable 4 Adjustable 1 Adjustable 1 Adjustable $ 17 758 5 754 12 753 18 752 10 751 15 749 13 748 5 746 9 741 4 740 10 739 6 737 10 737 8 736 6 736 13 735 10 731 6 729 728 726 10 726 18 723 15 715 710 710 14 707 11 704 10. 703 10 701 675 5 674 2 673 1 673 6 670 NOOHH35 15 17 8 Home Get Data 066 58 59 70 21 8 67 Peterson 68 Marty 69 Rose 70 Isaacs 71 Rose 72 Peterson 73 Rose 74 Rose 75 Marty 76 Marty 77 Carter 78 Marty 79 Marty 80 Peterson 81 Rose 82 Marty 84 83 Carter 85 84 Carter 86 85 Peterson 87 86 Carter 81 87 Carter 89 88 Carter 90 89 Rose 91 90 Carter 92 91 Marty 93 92 Isaacs 94 93 Carter 95 94 Peterson 96 95 Peterson 96 Marty 97 98 97 Peterson 99 98 Marty 100 99 Isaacs 101 100 Carter 102 01 Peterson 72 73 74 75 76 Excel FIL Insert 27 78 79 80 81 82 83 A Data from Picture x 01 COIL view 2. C... Draw Page Layout Refresh All fx 10015 Formulas Data Queries & Connections Properties Edit Links C D E 226054 2090 183920 2090 * 248400 2300 466560 5760 667212 6110 362710 4370 265440 3160 706596 6600 293700 3300 199448 2330 369533 4230 230121 2030 169000 1690 190291 2040 393584 4660 363792 2860 360960 3840 310877 3180 919480 7670 392904 3400 200928 1840 537900 4890 258120 2390 558342 6160 302720 3440 240115 2220 793656 6530 218862 1930 383081 3510 351520 3380 841491 7030 336300 2850 312863 3750 275033 3060 229990 2110 Sheet2 02 F 1.5 2 3 2 3 2.5 5 3.5 6 4 4 2.5 5 3.5 7 5 3 2 2 1.5 3 4 2 2 1.5 1.5 1.5 2 4 3 3 2.5 6 4.5 2 8 5.5 3 2 2 1.5 4 6 3 6 2.5 4 4 2.5 1.5 5 2 7 2 3 1.5 2 3 2 6 4 3 2.5 4 2 Sheet3 G 1 0 1 0 1 0 1 1 0 1 1 1 0 1 1 1 0 1 1 1 1 0 0 1 0 1 1 1 1 0 1 0 1 1 Review Stocks Q3 H Heip View Tell me Geography 1 1 0 1 28 30 50 42 21 24 22 40 14 1 25 1 32 0 21 0 20 1 31 1 34 1 48 1 32 1 40 1 30 0 40 1 36 1 23 1 23 1 24 1 38 0 39 1 53 0 58 1 27 1 35 1 50 0 28 1 12 1 27 Sheet4 1 1 1 1 1 0 Final Excel (1).xls- Compatibility Mode Clear Reapply Advanced Text to Columns U M 6 670 8 669 4 667 3 665 8 662 2 656 3 653 7 652 7 647 644 5 2 642 3 639 7 639 6 631 7 630 3 626 5 626 6 624 1 623 8 618 3 618 7 614 6614 3 7 613 609 1 609 3 605 1 604 6 601 8 599 H 596 6 595 2 3 595 593 0591 Sheetk J 2 04 24 A Sort Filter 1 Adjustable 2 Adjustable 2 Adjustable 4 Adjustable 3 Adjustable 1 Adjustable 5 Adjustable 3 Adjustable 4 Adjustable 3 Adjustable 2 Adjustable 2 Adjustable 1 Adjustable 4 Adjustable 3 Adjustable 5 Adjustable 2 Adjustable 1 Adjustable 4 Adjustable 2 Adjustable 4 Adjustable 1 Adjustable 1 Adjustable 3 Adjustable 3 Adjustable 5 Adjustable 4 Adjustable 4 Adjustable 2 Adjustable 2 Adjustable 4 Adjustable 1 Adjustable 4 Adjustable 3 Adjustable Advustable 05 + N on O 8- Us Home Get Data 066 37 38 39 90 01 92 03 34 35 96 97 98 99 Excel File Edit View Insert 2. C... Insert Draw Page Layout V Refresh Data from Picture All 8 00 101 102 203 104 105 106 107 108 109 110 111 112 A 86 Carter 87 Carter 88 Carter 89 Rose 90 Carter 91 Marty 92 Isaacs 93 Carter 94 Peterson 95 Peterson 96 Marty 97 Peterson 98 Marty 99 Isaacs 100 Carter 101 Peterson 102 Isaacs 103 Marty 104 Peterson 105 Peterson Format Tools Data Window Help Formulas Data Review View Stocks Deography 1 1 0 0 1 0 1 1 1 1 0 1 0 Queries & Connections Properties Edit Links E F fx C D 392904 3400 200928 1840 537900 4890 258120 2390 558342 6160 302720 3440 240115 2220 793656 6530 218862 1930 383081 3510 351520 3380 841491 7030 336300 2850 312863 3750 275033 3060 229990 2110 195257 2130 194238 1650 348528 2740 241920 2240 3 2 2 1.5 4 6 3 6 2.5 4 4 2.5 2 15 7 S 2 1.5 3 2 3 2 6 4 3 2.5 6 4 3 2 2 2 1.5 1.5 1.5 4 3 2 1.5 2 PRO G 1 1 0 1 1 1 0 H 0 1 1 1 1 1 0 40 36 23 23 24 38 39 1 53 0 58 1 27 1 35 1 50 28 12 27 37 11 30 27 34 1 0 1 1 0 0 1 1 1 Final Excel (1).xls Tell me 23 J Sort Filter 2 Adjustable 4 Adjustable 1 Adjustable 1 Adjustable 3 Adjustable 3 Adjustable 5 Adjustable 4 Adjustable 4 Adjustable 2 Adjustable 2 Adjustable 4 Adjustable 1 Adjustable 4 Adjustable 3 Adjustable 3 Adjustable 5 Adjustable 2 Adjustable 5 Adjustable 5 Adjustable + Compatibility Mode Clear Reapply Advanced Text to Columns L N M 618 3 618 7 614 6 614 7 613 3 609 1 609 3 605 1 604 6 601 8 599 8 596 6 595 2 595 3 593 6 591 8 591 7 590 3 584 8 583 8 0 4. This data set contains all the sales made in 2019 at Beaver Pride Real Estate. After reviewing the type of mortgage home buyers choose, the realty owner believes that those who ended up with fixed mortgage have higher FICO scores than those who went with adjustable mortage. Sort the relevant columns and organize the FICO scores by fixed and adjunstable.From national data, assume that the variances are known as 3000 for the fix rate borrowers and 1500 for the adjustable rate borrowers. At significance level .05, can the realtor conclude that the fixed rate mortgage home buyers have higher credit scores? 15. Using the same data set from Q4, the average home sale price in Beltraver County is $350,000 with a standard deviation of $150,000. Assuming the distribution of home sale price follows the 3 normal distribution. At significant level 0.05, is Beaver Price realtors closing deals lower than the 4 Beltraver average

Answer & Explanation Solved by verified expert

See Answer