Table 1.0: List Price, Sale Price and Days to Sell ApartmentsBlue Apartments Red ApartmentsList Price Sale Price Days to Sell List Price Sale Price Days to Sell1 495.0 475.0 130 217.0 217.0 1822 379.0 350.0 71 148.0 135.5 3383 529.0 519.0 85 186.5 179.0 1224 552.5 534.5 95 239.0 230.0 1505 334.9 334.9 119 279.0 267.5 1696 550.0 505.0 92 215.0 214.0 587 169.9 165.0 197 279.0 259.0 1108 210.0 210.0 56 179.9 176.5 1309 975.0 945.0 73 149.9 144.9 14910 314.0 314.0 126 235.0 230.0 11411 315.0 305.0 88 199.8 179.0 12012 885.0 800.0 282 210.0 192.0 6113 975.0 975.0 100 226.0 195.0 14614 329.0 445.0 56 149.9 212.0 13715 365.0 305.0 49 160.0 146.5 28116 332.0 330.0 48 322.0 160.0 6317 520.0 312.0 88 187.5 292.5 4818 425.0 495.0 161 247.0 179.0 5219 675.0 405.0 14920 409.0 669.0 142

Create a Pivot Table in a new sheet to show the Total Price Paid for each Town.

33.3% complete  A B C D E F  Region Style Ship Date Units Price Cost1 East Tee 1/31/2018 12 11.04 6.422 East Golf 1/31/2018 12 13 7.253 East Fancy 1/31/2018 10 11.96 6.74 West Tee 1/31/2018 15 11.04 6.425 West Golf 1/31/2018 12 13 7.256 West Fancy 1/31/2018 10 11.96 6.7QuestionQ. In which section of the table would you find information about the retail sales price?A.Column E, Rows 3 through 6 onlyB.Column E, Rows 1 through 6C.Column F, Rows 1 through 6D.Column F, Rows 3 through 6 only

The table below contains the value (in dollars) and the amount of annual rental income (in dollars) for a random sample of 45 houses.X, value Y, annual rental income289000 11648194000 11232140000 956877000 4576165000 13312125000 7904145000 8320310000 1248085000 707281000 665667500 6864155000 7488174000 10400225000 1248090000 6240270000 12896300000 12480130000 9776262000 10192200000 8320303000 12272244500 11232148000 8320121000 12064115000 7904240000 11648325000 12480135000 7488110000 7072170000 9568170000 12688165000 8528240000 12064208000 10400104000 790475000 7280190000 8320178000 11856240000 10192214000 8528200000 10608200000 12272126000 6240135000 8320200000 10400a) State the random variables.    rv X = of     rv Y = of b) The symbol and value of the correlation coefficient are as follows:    Round final answer to 3 decimal places.    =     Interpret this value:There is a strong relation between value and annual rental income for houses.c) The symbol and value of the coefficient of determination are as follows:    Round final answer to 3 decimal places.    =      Interpret this value:About % of the explained by the linear model with as its variable.

Suppose that the demand and supply schedules for rental apartments in the city of Gotham are as given in the table below.Instructions: Enter your answers as whole numbers.a. What is the market equilibrium rental price per month and the market equilibrium number of apartments demanded and supplied?     Market equilibrium rental price is $ per month.     Market equilibrium quantity is apartments.b. If the local government can enforce a rent-control law that sets the maximum monthly rent at $1,500, will there be a surplus or a shortage?     .     Of how many units?     apartments per month.     How many units will actually be rented each month?     apartments.c. Suppose that a new government is elected that wants to keep out the poor. It declares that the minimum rent that can be charged is $2,500 per month. If the government can enforce that price floor, will there be a surplus or a shortage?     .     Of how many units?     apartments per month.     How many units will actually be rented each month?     apartments.d. Start at the original (correct) equilibrium price and quantity in part a. Suppose that the government wishes to decrease the market equilibrium monthly rent by increasing the supply of housing. Assuming that demand remains unchanged, by how many units of housing would the government have to increase the supply of housing in order to get the market equilibrium rental price to fall to $1,500 per month?       units.     To $1,000 per month?     units.     To $500 per month?     units.

Diego is working as an intern at a vacation rental company. His task is to manage and analyze rental and booking data. The database admin has already created two tables, Rentals and Bookings. Diego needs to perform several operations on these tables based on specific conditions.Table Name: RentalsTable Name: BookingsSample Input Records:Tasks for DiegoInsert Records: Insert at least 5 records into the Rentals and Bookings tables with the values mentioned.Update Prices: Update the PricePerNight of rentals where PricePerNight is greater than $100Delete Bookings: Remove bookings from the Bookings table where the BookingDate is before '2024-01-01' and the RentalID is not equal to 101, 102, 103.Select Rentals: Retrieve all rentals located at 'Beach' where the PricePerNight is less than $150.