question: you are given here a sample of 200 airbnb listings of apartments for rent in brooklyn

1 0 1 You are given here a sample of 200 airbnb Listings of apartments for rent in Brooklyn 1 0 1 0 1 1 1 1 1 124 115 160 75 110 89 134 190 225 100 160 Variable Definitions bedrooms - number of bedrooms in the apartment (O means a studio apartment) bathrooms - number of bathrooms in the apartment accommodates number of people the apartment accommodates Ostrict - 1 means cancellation policy is strict, O means not strict price - rental price per night in $ The regression output is given on the next sheet. 150 145 159 70 145 160 150 160 3 OOOOOOOOO a. Build a pivot table to find the average price of a 4-bedroom apartment. b. From the pivot table what is the average price for an apartment with 2 bedroom: c. Build a pivot table to find how many 3-bedroom apartments are in the sample. 2 3 3 3 5 4 2 6 5 4 105 115 95 140 180 290 119 164 240 165 204 UNA 1 1 1 1 0 1 You are given here a sample of 200 airbnb Listings of apartments for rent in Brooklyn 1 0 1 0 1 1 1 1 1 124 115 160 75 110 89 134 190 225 100 160 Variable Definitions bedrooms - number of bedrooms in the apartment (O means a studio apartment) bathrooms - number of bathrooms in the apartment accommodates number of people the apartment accommodates Ostrict - 1 means cancellation policy is strict, O means not strict price - rental price per night in $ The regression output is given on the next sheet. 150 145 159 70 145 160 150 160 3 OOOOOOOOO a. Build a pivot table to find the average price of a 4-bedroom apartment. b. From the pivot table what is the average price for an apartment with 2 bedroom: c. Build a pivot table to find how many 3-bedroom apartments are in the sample. 2 3 3 3 5 4 2 6 5 4 105 115 95 140 180 290 119 164 240 165 204 UNA 1 1 1