Case: While quantitative characteristics such as PRICE and SQFT are critical decision factors, Super Maxx Realty would like to gain insight into the qualities (e.g. styles, number of bedrooms, view) of homes sold in this area to provide reliable buying and selling advice for their clients. Super Max Realty knows that the two most prominent qualities home buyers are interested is the quality of view and style of home. To advise buyers on what to look for they wish to understand what the current market looks like in terms of these qualities.

1.From the file HOMES.xlsx create a Summary table, Pie chart, and Bar chart for the variable STYLE.

(Use this link to refer to data and make charts)

https://hawaii0-my.sharepoint.com/:x:/g/personal/white6_hawaii_edu/ES7cOvGVbE9Hl7vZGvt1y-oBehpAYkhubCXmCMbv06IKGg?e=ApN4Iy)

2.

Row Labels Count of STYLE Count of STYLE2 Count of STYLE3 ranch 44 40.74% 40.74% trilevel 39 36.11% 76.85% twostory 25 23.15% 100.00% Grand Total 108 100.00%Create Pivot Table ? X Choose the data that you want to analyze O Select a table or range Table/Range: DATA!SAS1:5M$109 O Use an external data source Choose Connection... Connection name: Use this workbook's Data Model Choose where you want the PivotTable report to be placed O New Worksheet O Existing Worksheet Location: Choose whether you want to analyze multiple tables Add this data to the Data Model OK CancelC PivotTable Fields Row Labels ~ Count of STYL13 Count of STYLE 4 ranch 14 40.745 5 36.11% Much Inanal Grand Tolal 140.404 LOTSRE 10 The Field Sellings STYLE GARAGE POOL SAD Sol Column Toll Dung Weich between areas below Ill Columns 31 12 Count ofSTY. 30 Court el STYLE - 35 ETT Defer Layout Update Update COOL .\f