Scenario: You work at the home office of Buena Vista Realty. There are six distr

ID: 3870743 • Letter: S

Question

Scenario: You work at the home office of Buena Vista Realty. There are six district offices across the state. You are asked to create a standard analysis report that will help the manager in each district office evaluate house sales. 6 Below are some example sales data in a spreadsheet format. On the following pages are questions to answer by designing a pivot table. will you design the pivot table (also known as a data analysis cube) for each question? How Below each question use the grid to show your pivot table design. Write the field(s) you would put in each grid: filters, columns, rows, values. NOTE: For the "values" section, indicate what calculation(s) will be done, such as SUM(Selling Price), AVERAGE(Asking Price), MINIMUM(Days on City Selling Agent Asking Price Selling Price % of Asking Price Listing Date Sale Date Days on Market 890% 4/1/2018 6/16/2018 97.1% 4/1/2018 5/15/2018 2 11 West Oak Circle 6 5 750 South Apple Way American Fork Goodrich 100.0% 4/1/2018 4/30/2013 930% 4/3/2018 6/10/2018 an 95.0% 4/12/2018 6/12/2018 98.5% 4/12/2018 5/30/2018 93.3% 4/12/2018 11/1/2018 96.4% 4/12/2018 7/3/2018 96 796 4/13/2018 8/5/2018 90.1% 4/13/2018 10/15/2018 American Fork Hernandez$325,000 S 320,000 1514 143 North Mountain View American Fork Carey 16 15 29 East Oak Circle 5

Explanation / Answer

To Create a pivot table.

To see the agent Goodrich's performance

Choose Selling Agent: Goodrich

Filters

Selling Agency

Columns

Values

Rows

Number
Address
City
Listing Date
Sale Date

Values

Sum of Selling Price
Average of Asking Price
Average % of Asking Price
Min of Days of Market