6 analysis report that will help the manager in each district office evaluate ho

Question

6 analysis report that will help the manager in each district office evaluate house sales. 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 4 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 9 City Selling Agent Asking Price Selling Price % of Asking Price Listing Date Sale Date Days on Market 0 89.0%4/1/2018 6/16/2018 97.1% 4/1/2018 5/15/2018 2 11 West Oak Circle 65750 South Apple Way Amercan Fork Goodrich 7 618 West Cedar Drive 1 10 1971 Glenview Road 95.0% 4/12/2018 6/12/2018 98.5% 4/12/2018 5/30/2018 93.3% 4/12/2018 11/1/2018 964% 4/12/2018 7/3/2018 7 1514 16 15 143 North Mountain View 29 East Oak Circle American Fork Carey 5 90.1% 4/13/2018 10/15/2018

Explanation / Answer

Move selling agents to rows

Move Days on Market to Values , Right click on Days on Market and select value settings and then select "average" to see the average values

This would create a pivot that tells us the avergae days of market for each sales agent. Select the one with the lowest average

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.