Listing Price SQfeet # bedrooms / # bokworms 160,500 Carepurge 919 Zip Code 2 120, 500 NO NO 93727 1085 2 NO NO 85, 0UD 93706 - NO 4370% 1, 936 yes 93720 259, 500 2, HIB yes NO NO 93711 699, 500 NO 5354 INJAWN 93702 yes yes 9370 4 179,580 yes NO 937DH 1,908 Yes NO 93711 145, 55 7 Yes NO 1734 9 3720 65, 080 728 NO 95727 2, 346 Yes NO 73727 2/ 012 yes yes NVNI 93722 14 55, BOD 2,085 Yes NO 93727 1 786 4 Yes NO 447, 900 93711 3 NO NO 385, 50 0 1394 93704 349, 500 1, 736 2 Yes NO 73704 310, 50 0 3 ND NO 73705 LIB4, 700 3 82% 5 yos 73702 1850 2 3 yes 239, DVD 93721 2 NO 224, 050 93711 13122 NO MO 275, DTD 73706 1155 NO NO 397, 950 93650 1, 465 NO NO 725, DVD 95720 NWIV WWNP 31408 yes 4 43, GOD yes 93711 2, 169 yes NNPPNNIP - - 93730 78 61 yes NO 357, 490 1363 93722 331, 970 NO ND 1: 373 93730 2 339 600 NO NO L 332 3730 330, 510 ND 1 1475 NO 93705 rob NO $3705Listing Price Pq- Feet Hy Bedrooms | IF of Bathrooms | Car gurange |Jamming Pool Zip Code 215000 2 29, 0DO 14-06 2 NO 199, 888 872 93704 816 ND 4 85, 050 2 NO 93725 2,275 NO NO 715, 600 93710 2 965 2 yes yes 2 13737 180, 500 31787 yes yes 93720 1858 2 yes yes 43703 1787 2 Yes yes 93720 21046 3 yes S yes 93727 450, 060 1635 3 yes 350, OTD 1797 Yes 43727 NO 1773 yes NO 93723 724, 883 2 920 560, OOD yes 93720 NO 2, 218 yes yes 45705 398, GUD 46 30 3 yes yes 19371 1 290 030 1/056 yes NO 93720 3 539, 955 NO 93723 NO 2,536 525, 370 Yes 93705 2445 yes 415, 0DO Yes 43722 $707 Yes 359, 070 93722 WWWI yes 1,354 294 400 1578 Yes NO 43710 290 030 1,223 Yes NO 93722 2 125, 500 1512 NO AJC 93725 395, 500 NO NO 1550 93703 yes NO 319 010 93725 1 876 yes AD 93704 LO H74, 20 yes 93722 2153 yes 93720 385, 650 1887 Yes yes 95701 349 750 1750 Yes NO 93722 1735 yes NO 244 900 Yes NO 73727 1 169 W W W 93 722 1,620 Yes NO 93703 yes NO 93720The following instructions, Items 1-11, are the tasks required to complete Project 1: 1. (15 points) Collect residential real-estate data from 60 houses in California for the following variables: A. Listing price in US dollar B. House size in square feet C. Number of bedrooms D. Number of bathrooms E. Car garage (Yes if there is a car garage, and No if there is not a car garage) F. Swimming pool (Yes if there is a swimming pool, and No if there is not a swimming pool) G. 5-digit zip code You can collect the data from any online sources such as MLS.com, Zillow.com, Century21.com, remax.com, etc. 2. (10 points) Organize your collected data in a table as your dataset. 3. (10 points) Identify all the variables in the dataset as either a qualitative variable or a quantitative variable. 4. (5 points) Identify the level of measurement for each of variables-nominal, ordinal, interval, or ratio. 5. Select one qualitative variable from your dataset and create its: A. (5 points) frequency table B. (5 points) relative frequency table These two tables can be combined into one table 6. Using the answer from No.5, create: A. (5 points) a bar chart for the frequency table B. (5 points) a pie chart for the relative frequency table If you have problems creating either or both charts in MS Excel, please let me know one or two days before the project due date so I can help you. 7. Select one quantitative variable and create its: A. (10 points) Grouped frequency distribution Use 6 as the number of classes. You must compute the class interval based on your dataset using i 2 (H-L)/k where H is the highest value in your dataset; L is the lowest value in your dataset; k = 6. Watch the lecture video of "Descriptive Statistics: Frequency Distribution" to refresh your memory how to create a grouped FD in 5 steps. B. (5 points) relative frequency distribution You can combine the frequency distribution and the relative frequency distribution into one distribution (table). 8. Using the answer from No.7, create A. (5 points) a histogram for the frequency distribution B. (5 points) a frequency polygon for the frequency distribution (hint: use the midpoint value)midpoint value) 9. From your selected quantitative variable, compute the following statistical figures: A. (5 points) Mean, mode, and median B. (10 points) Range, variance, and standard deviation 10. (Extra credit: 1 point to 10 points depending on the quality of your explanation) Explain your computed: A. Mean, median, and mode using your own words B. Range, variance, and standard deviation using your own word. 11. Upload your Project 1 using the Submit link of Project 1. There is an example of steps required to complete Project 1 using MS Excel. This example is using a different dataset and posted on Canvas Announcement page. There are three worksheets in the Excel file-Questions 2-8A, Questions 8B, and Questions 9A-9C