A realty company would like to develop a regression model to help it set weekly rental ratos for beach properties during the summer season in a particular area. The independent variables for this model are the number of bedrooms a property is s, its age, the number of blocks away from the ocean it is, and the rental month (June, July, or August). These data are shown in the accompanying table for randomly selected rental properties. Complete parts a through d below. Click the icon to view the data table. a. Using Excel, construct a regrestion model using all of the independent variables. (Let variable Mont be one of the dummy variables for the month. Assign a 1 to July for this variable. Let Mon2 be another dummy variable for the month. Assign a 1 to August for this variable.) Complete the regression equation for the model below, where y= Rent ($),x1= Bedrooms, x2= Age, x3=B locks, x4= Mon1, and x5= Mon2 y^=+x1+x2+1x3+1x4+x5 (Round to the nearest integer as needed.) Data Table