I have the full spreadsheet (too long to post). If someone could just walk me through how to compute the answers to these questions using Excel (on a mac), I would really appreciate it. Thank you.

3. Find the average house price in each zip code. What is the absolute difference (in dollars - no need for a negative sign) between the average price of the "cheapest" zip code and the average price of the "most expensive" zip code. iround your answer to one decimal point - 874,978.56 should be entered as 874978.6) 4. Find the number of houses sold by zip code and your indicator variable for large_acreage. What is the difference between the number of large acreage houses and the number of small acreage houses that were sold in zip code 10306? 5. Run a regression in which the dependent variable is In_price and the independent variable is bed (number of bedrooms). What is the coefficient on the "bed" variable in the regression? (round your answer to TWO decimal points 0.089 should be entered as 0.09 ) 6. What is your interpretation of the results of this regression? Use the cutoff point of 10% P-value to interpret statistical significance. 7. Run a regression in which the dependent variable is In_price and the independent variables are "bed", "bath", "acre_lot", and "house_size". You may have to reorganize the columns so that your independent variables are next to one another. What is the coefficient on the "bed" variable in the regression? (round your answer to two decimal point 0.089 should be entered as 0.09 ) 3. Find the average house price in each zip code. What is the absolute difference (in dollars - no need for a negative sign) between the average price of the "cheapest" zip code and the average price of the "most expensive" zip code. iround your answer to one decimal point - 874,978.56 should be entered as 874978.6) 4. Find the number of houses sold by zip code and your indicator variable for large_acreage. What is the difference between the number of large acreage houses and the number of small acreage houses that were sold in zip code 10306? 5. Run a regression in which the dependent variable is In_price and the independent variable is bed (number of bedrooms). What is the coefficient on the "bed" variable in the regression? (round your answer to TWO decimal points 0.089 should be entered as 0.09 ) 6. What is your interpretation of the results of this regression? Use the cutoff point of 10% P-value to interpret statistical significance. 7. Run a regression in which the dependent variable is In_price and the independent variables are "bed", "bath", "acre_lot", and "house_size". You may have to reorganize the columns so that your independent variables are next to one another. What is the coefficient on the "bed" variable in the regression? (round your answer to two decimal point 0.089 should be entered as 0.09 )