Refer to the North Valley Real Estate data and prepare a report on the sales prices...

Transcribed Image Text:

Refer to the North Valley Real Estate data and prepare a report on the sales prices of the homes. Be sure to answer the following questions in your report. Click here for the Excel Data File Required: a-1. What is the mean sales price? What is the median sales price? (Round your answers to the nearest whole dollar amount.) Mean sales price Median sales price a-2. Is one measure more representative of the typical sales prices than the others? O Yes O No b-1. What is the range of sales prices? What is the standard deviation? (Round your answers to the nearest whole dollar amount.) Range of sales price Standard deviation b-2. About 95% of the sales prices are between what two values? (Round your answers to the nearest whole dollar amount.) About 95% of the sales prices are between and O Yes O No values. b-3. Is the standard deviation a useful statistic for describing the dispersion of sales price? c-1. What is the mean FICO score? What is the median FICO score? (Round your answers to the nearest whole number.) Mean FICO score Median FICO score c-2. Is one measure more representative of the typical FICO score than the others? O Yes No c-3. What is the range of FICO score? What is the standard deviation? (Round your answers to the nearest whole number.) Range of FICO score Standard deviation c-4. About 95% of the FICO scores are between what two values? (Round your answers to the nearest whole number.) The FICO scores are between and O Yes O No values. c-5. Is the standard deviation a useful statistic for describing the dispersion of FICO score? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 92 19 20 21 22 23 24 25 26 27 28 29 30 31 32 B A record Agent 1 Marty 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 с Price D E F G Size Bedrooms Baths Pool (yes is 1) 206424 1820 346150 3010 372360 3210 310622 3330 496100 4510 294086 3440 228810 2630 384420 4470 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 2 1.5 3 2 4 3 3 2.5 4.5 4 3 4 2.5 5 3.5 5 3.5 4 4 01 6 LO 6 6 4 3 3 2.5 2 1.5 4 3 6 4 5 3.5 5 3.5 3 2 4.5 2 1.5 2 1.5 3 2.5 4 3 5 3.5 5 3.5 3 4 3 2 2 1.5 2 1.5 01 LL 6 4 3 st 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 H I Garage (Yes is 1) Days 1 33 36 21 0 26 1 13 1 31 1 39 1 26 1 26 1 32 1 35 1 50 1 25 34 1 17 1 12 1 28 1 36 1 38 1 37 0 20 0 52 1 31 1 40 1 54 1 26 1 1 0 1 0 1 0 0 K J 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 5 Fixed 4 Fixed 1 Fixed 4 Fixed 1 Fixed 1 Fixed 5 Adjustable 4 Adjustable 3 Fixed 3 Fixed 5 Fixed 5 Adjustable 23 31 37 31 28 LM N Years FICO Default (Yes is 1) 2 824 0 9 820 18 819 17 817 17 816 19 813 10 813 6 3 6 808 8 806 9 805 9 801 20 798 10 795 18 792 9 792 10 788 16 786 2 785 6 784 10 782 8 781 18 780 20 776 9 773 9 772 19 772 5 769 6 769 9 766 812 810 O 0 0 0 0 0 0 O 0 1 1 1 0 0 O 1 0 OO 0 OO 0 0 0 0 0 0 0 1 OO 0 0 0 1 33 34 35 36 37 38 39 40 41 42 43 44 GB 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 86 60 61 ~~ 62 63 64 32 Isaacs 33 Carter 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 226498 2520 316827 3150 189984 1550 366350 3090 416160 4080 308000 3500 294357 2620 337144 2790 299730 2910 445740 4370 410592 4200 667732 5570 523584 5050 336000 3360 202598 2270 326695 2830 321320 2770 246820 2870 546084 5910 793084 6800 174528 1600 392554 3970 263160 3060 237120 1900 225750 2150 848420 7190 371956 3110 404538 3290 250090 2810 369978 3830 209292 1630 190032 1850 4 st 4 2 3 st 4 4 4 4 3 3 3 3 3 2 3 4 3 5 3.5 6 4 3 2 4 3 3 1.5 2 st 3 2 3 2.5 3 2 4 3 6 4 8 5.5 2 1.5 4 3 3 2 2 1.5 1.5 2 6 5 3.5 4 5 3.5 4 3 4 2.5 2 1.5 2 1.5 st 1 1 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 1 1 1 1 1 0 1 23 1 25 1 37 1 15 1 19 0 31 1 19 1 27 1 29 1 19 0 32 0 28 30 23 27 35 27 39 30 26 0 14 1 27 1 49 1 29 1 24 1 18 1 0 1 0 1 1 1 1 2 22 0 1 1 28 22 27 18 30 3 Fixed 4 Fixed 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 8 763 2 759 17 758 5 754 12 753 18 752 10 15 13 751 749 748 5 746 9 741 4 740 10 739 6 737 10 737 8 736 6 736 13 735 10 731 6 729 15 728 17 726 10 726 18 723 15 715 5 710 8 710 14 707 11 704 10 703 10 701 2 675 1 1 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 63 Isaacs 64 Isaacs 65 Marty 66 Isaacs 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 83 Carter 84 Carter 85 Peterson 86 Carter 87 Carter 88 Carter 89 Rose 90 Carter 91 Marty 92 Isaacs 93 Carter 94 Peterson 95 Peterson 97 96 Marty 98 97 Peterson 99 98 Marty 100 99 Isaacs 101 100 Carter 102 101 Peterson 103 102 Isaacs 104 103 Marty 105 104 Peterson 106 105 Peterson 107 190032 1850 216720 2520 323417 3220 316210 3070 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 195257 2130 194238 1650 348528 2740 241920 2240 2 1.5 WN 3 2.5 4 3 3 2 2 1.5 3 2 3 2.5 5 3.5 6 4 4 2.5 5 3.5 7 5 3 2 2 1.5 4 3 2 1.5 2 1.5 1.5 2 4 3 3 2.5 6 4.5 3 2 8 5.5 3 2 2 1.5 6 4 3 2.5 6 4 4 2 7 2 2.5 1.5 2 2 5 1.5 2 2 3 3 6 4 3 2.5 6 4 3 2 2 1.5 1.5 1.5 4 3 2 1.5 1 0 1 0 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 0 1 1 1 0 1 0 30 2 22 30 28 30 1 50 1 42 1 21 1 24 1 22 1 40 14 25 32 1 0 1 0 0 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 1 21 20 0 40 36 31 34 48 32 0 0 1 1 1 40 30 23 23 24 38 39 53 58 27 35 50 0 28 1 12 1 27 37 11 30 27 34 4 Adjustable 4 Adjustable 4 Adjustable 1 Adjustable 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 3 Adjustable 5 Adjustable 2 Adjustable 5 Adjustable 5 Adjustable 2 675 5 674 2 673 1 673 6 670 8 669 4 667 3 665 8 662 2 656 3 653 7 652 7 647 5 644 2 642 3 639 7 639 6 631 7 630 3 626 5 626 6 624 1 623 8 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 0 1 0 0 0 1 0 0 1 0 0 1 1 1 0 0 0 0 0 0 1 0 1 0 1 1 1 1 0 0 1 1 Refer to the North Valley Real Estate data and prepare a report on the sales prices of the homes. Be sure to answer the following questions in your report. Click here for the Excel Data File Required: a-1. What is the mean sales price? What is the median sales price? (Round your answers to the nearest whole dollar amount.) Mean sales price Median sales price a-2. Is one measure more representative of the typical sales prices than the others? O Yes O No b-1. What is the range of sales prices? What is the standard deviation? (Round your answers to the nearest whole dollar amount.) Range of sales price Standard deviation b-2. About 95% of the sales prices are between what two values? (Round your answers to the nearest whole dollar amount.) About 95% of the sales prices are between and O Yes O No values. b-3. Is the standard deviation a useful statistic for describing the dispersion of sales price? c-1. What is the mean FICO score? What is the median FICO score? (Round your answers to the nearest whole number.) Mean FICO score Median FICO score c-2. Is one measure more representative of the typical FICO score than the others? O Yes No c-3. What is the range of FICO score? What is the standard deviation? (Round your answers to the nearest whole number.) Range of FICO score Standard deviation c-4. About 95% of the FICO scores are between what two values? (Round your answers to the nearest whole number.) The FICO scores are between and O Yes O No values. c-5. Is the standard deviation a useful statistic for describing the dispersion of FICO score? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 92 19 20 21 22 23 24 25 26 27 28 29 30 31 32 B A record Agent 1 Marty 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 с Price D E F G Size Bedrooms Baths Pool (yes is 1) 206424 1820 346150 3010 372360 3210 310622 3330 496100 4510 294086 3440 228810 2630 384420 4470 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 2 1.5 3 2 4 3 3 2.5 4.5 4 3 4 2.5 5 3.5 5 3.5 4 4 01 6 LO 6 6 4 3 3 2.5 2 1.5 4 3 6 4 5 3.5 5 3.5 3 2 4.5 2 1.5 2 1.5 3 2.5 4 3 5 3.5 5 3.5 3 4 3 2 2 1.5 2 1.5 01 LL 6 4 3 st 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 H I Garage (Yes is 1) Days 1 33 36 21 0 26 1 13 1 31 1 39 1 26 1 26 1 32 1 35 1 50 1 25 34 1 17 1 12 1 28 1 36 1 38 1 37 0 20 0 52 1 31 1 40 1 54 1 26 1 1 0 1 0 1 0 0 K J 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 5 Fixed 4 Fixed 1 Fixed 4 Fixed 1 Fixed 1 Fixed 5 Adjustable 4 Adjustable 3 Fixed 3 Fixed 5 Fixed 5 Adjustable 23 31 37 31 28 LM N Years FICO Default (Yes is 1) 2 824 0 9 820 18 819 17 817 17 816 19 813 10 813 6 3 6 808 8 806 9 805 9 801 20 798 10 795 18 792 9 792 10 788 16 786 2 785 6 784 10 782 8 781 18 780 20 776 9 773 9 772 19 772 5 769 6 769 9 766 812 810 O 0 0 0 0 0 0 O 0 1 1 1 0 0 O 1 0 OO 0 OO 0 0 0 0 0 0 0 1 OO 0 0 0 1 33 34 35 36 37 38 39 40 41 42 43 44 GB 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 86 60 61 ~~ 62 63 64 32 Isaacs 33 Carter 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 226498 2520 316827 3150 189984 1550 366350 3090 416160 4080 308000 3500 294357 2620 337144 2790 299730 2910 445740 4370 410592 4200 667732 5570 523584 5050 336000 3360 202598 2270 326695 2830 321320 2770 246820 2870 546084 5910 793084 6800 174528 1600 392554 3970 263160 3060 237120 1900 225750 2150 848420 7190 371956 3110 404538 3290 250090 2810 369978 3830 209292 1630 190032 1850 4 st 4 2 3 st 4 4 4 4 3 3 3 3 3 2 3 4 3 5 3.5 6 4 3 2 4 3 3 1.5 2 st 3 2 3 2.5 3 2 4 3 6 4 8 5.5 2 1.5 4 3 3 2 2 1.5 1.5 2 6 5 3.5 4 5 3.5 4 3 4 2.5 2 1.5 2 1.5 st 1 1 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 1 1 1 1 1 0 1 23 1 25 1 37 1 15 1 19 0 31 1 19 1 27 1 29 1 19 0 32 0 28 30 23 27 35 27 39 30 26 0 14 1 27 1 49 1 29 1 24 1 18 1 0 1 0 1 1 1 1 2 22 0 1 1 28 22 27 18 30 3 Fixed 4 Fixed 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 8 763 2 759 17 758 5 754 12 753 18 752 10 15 13 751 749 748 5 746 9 741 4 740 10 739 6 737 10 737 8 736 6 736 13 735 10 731 6 729 15 728 17 726 10 726 18 723 15 715 5 710 8 710 14 707 11 704 10 703 10 701 2 675 1 1 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 63 Isaacs 64 Isaacs 65 Marty 66 Isaacs 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 83 Carter 84 Carter 85 Peterson 86 Carter 87 Carter 88 Carter 89 Rose 90 Carter 91 Marty 92 Isaacs 93 Carter 94 Peterson 95 Peterson 97 96 Marty 98 97 Peterson 99 98 Marty 100 99 Isaacs 101 100 Carter 102 101 Peterson 103 102 Isaacs 104 103 Marty 105 104 Peterson 106 105 Peterson 107 190032 1850 216720 2520 323417 3220 316210 3070 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 195257 2130 194238 1650 348528 2740 241920 2240 2 1.5 WN 3 2.5 4 3 3 2 2 1.5 3 2 3 2.5 5 3.5 6 4 4 2.5 5 3.5 7 5 3 2 2 1.5 4 3 2 1.5 2 1.5 1.5 2 4 3 3 2.5 6 4.5 3 2 8 5.5 3 2 2 1.5 6 4 3 2.5 6 4 4 2 7 2 2.5 1.5 2 2 5 1.5 2 2 3 3 6 4 3 2.5 6 4 3 2 2 1.5 1.5 1.5 4 3 2 1.5 1 0 1 0 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 0 1 1 1 0 1 0 30 2 22 30 28 30 1 50 1 42 1 21 1 24 1 22 1 40 14 25 32 1 0 1 0 0 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 1 21 20 0 40 36 31 34 48 32 0 0 1 1 1 40 30 23 23 24 38 39 53 58 27 35 50 0 28 1 12 1 27 37 11 30 27 34 4 Adjustable 4 Adjustable 4 Adjustable 1 Adjustable 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 3 Adjustable 5 Adjustable 2 Adjustable 5 Adjustable 5 Adjustable 2 675 5 674 2 673 1 673 6 670 8 669 4 667 3 665 8 662 2 656 3 653 7 652 7 647 5 644 2 642 3 639 7 639 6 631 7 630 3 626 5 626 6 624 1 623 8 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 0 1 0 0 0 1 0 0 1 0 0 1 1 1 0 0 0 0 0 0 1 0 1 0 1 1 1 1 0 0 1 1