Question
5. This dataset (link posted below to open in google docs) contains information on a collection of houses. Please use pivot table to answer the
5. This dataset (link posted below to open in google docs) contains information on a collection of houses. Please use pivot table to answer the following questions.
a. among the different style of houses, which one has the highest average value? What is the percentage that this style of houses accounts for in relation to total number of houses? (0.5 point)
b. among the different style of houses, which one seems to be the most recent style?(0.5 point)
c. how many houses have one-car garage, in-ground pool, and fire place? And what is the average taxes among those house? (0.5 point)
https://drive.google.com/file/d/16ssCFLE028WHjrAuz7i-tpCFPFk-iKlN/view?usp=sharing
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started