Please create your own subset

Jersey_Shore_Realtors_2 Rental ($) Bedrooms Age Blocks Month 875 2 12 3 June 900 2 June 900 15 2 June 1090 13 1.5 June 1175 12 3 June 1250 11 2.5 June 1400 A W WA W OWING 5 1.5 June 1400 8 2 June 1500 2 June 1600 6 2 June 1700 11 1.5 June 1800 7 3 June 1900 20 2 June 2000 5 3 June 2000 9 1.5 June 2200 4 1.5 June 2300 12 2.5 June 2500 10 2 June 2600 5 1 June 3000 14 2 June 3200 10 1.5 June 3500 9 1.5 June 4000 10 2 June 4500 9 1 June 5000 5 1.5 June 7000 14 0.5 June 1475 6 2 July 1900 18 1 July 2250 3 1.5 July 2300 11 2.5 July 2525 9 3 July 2700 8 2 July 2700 4 2.5 July 2800 11 2 July 2900 15 1.5 July 3000 13 1 July 3000 9 2.5 July 3400 13 2.5 July 3600 11 2 July 3700 6 1 July 4000 11 1 July 4300 9 1.5 July 4700 3 1.5 July 4900 11 1.5 July 5000 9 2 July 5200 16 1 July 5700 17 1.5 July 6000 3 2 July 6500 11 1 July 7000 9 1.5 July 7200 17 1 July 7600 12 1 July Page 1Jersey_Shore_Realtors_2 8000 5 13 1 July 9000 21 0.5 July 10000 17 1 July 12900 10 0.5 July 1300 15 3 August 1700 10 2.5 August ADDWWWNOOO 1800 16 1.5 August 1900 11 2 August 2000 9 2.5 August 2100 6 3 August 2200 11 1.5 August 2400 5 1.5 August 2800 6 2 August DD . 2900 13 2 August 3000 11 3 August 3200 11 2.5 August 3400 6 1 August 3500 8 2 August 3600 10 2 August 3700 14 1.5 August 4000 10 1.5 August 4100 20 2 August 4250 8 1 August 4500 2 1 August 4500 12 2 August 4500 13 2.5 August 4800 1 1.5 August 5000 9 2 August 5400 14 2 August 5770 10 1.5 August 6000 1 2 August 7800 12 1 August 8000 13 1.5 August 9000 16 0.5 August 10500 21 1.5 August 12000 A 2 0.5 August Page 22. Jersey Shore Realtors would like to develop a regression model to help it set weekly rental rates for beach properties during the summer season in New Jersey. The independent variables for this model are the number of bedrooms a property has, its age, the number of blocks away from the ocean it is, and the rental month (June, July, or August). These data can be found in the le \"Jersey Shore Realtors 2\" in the d21. As demonstrated in the lecture, please create a subset data of size 78 and perform your statistical analysis for the subset data. Please note that the subset data should be a random sample of the given data. (a) Is the number of bedrooms a signicant predictor? Show details of the hypothesis test. Use a = 0.5. (b) Is the multiple linear regression model signicant? Show details. Use a = 0.05. (0) Provide the detailed interpretations of the coeicients of the slopes of the regression model in the context of the problem. ((1) Use your estimated regression equation to predict the average weekly rental rate during the month of July for a three-bedroom house that is 10 years old and two blocks from the ocean