You are an intern with the Regional Realty Association and are analyzing the claim made by Alice Barr Realty that “we get your price.” You have prepared a spreadsheet that shows data relating to 3 months’ sales by Alice Barr Realty. You are going to determine the percent of asking price for each home sold and analyze the sales data to determine the true track record of the company in selling homes for the asking price.
Turn in one workbook titled lab3_yourlastname to the Dropbox. When submitting the workbook, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.
You must open a workbook that lists home sales for 3 months.
If you have any questions, please post in the Q & A Forum or contact your instructor.
Back to TopA formula is used to calculate the percent of asking price, and this formula is applied to all listed sales. You will format the list in an attractive and useful manner.
Your Sales Data worksheet will look something like this:
You determine that one measure of how well the company “gets your price” is to set a scale. Excellent performance is at or above the asking price. Good performance is between 95% and 100%. Below 95% is average performance. You will create conditional formatting rules to display graphically the performance level for each sale. Make a copy of the original sales data chart. Name the new sheet Conditional Format.
Download the
Now that you have sorted, subtotaled, filtered, and conditionally formatted the data, you have a few more questions to answer. You want to see average percentage of selling price by agent and by city. This will allow you to see whether there are any patterns based on the city or based on the salesperson. To do this kind of comparison, you decide to create a pivot table.
On the Documentation Sheet, add a section called Analysis. Based on your data analysis, do you believe that Barr Realty should be allowed to advertise that they “Get your price?” Justify your answer by referring to the data analysis you have just completed.