Share
Explore BrainMass

Excel problem for Alice Barr Realty housing sale data.

You are an intern with the Regional Realty Service 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 three months' sales by Alice Barr Realty. You are going to determine the percent of asking price for each home sold that month. Determiine which sales people have the most total sales and determine how many sales are made within the city of Miami. You will prepare an attractively formatted summary report for your boss and a chart showing the total sales by sales person.

Complete a worksheet that lists home sales for three months.

View attached MS Excel spreadsheets.

Attachments

Solution Summary

You are an intern with the Regional Realty Service 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 three months' sales by Alice Barr Realty. You are going to determine the percent of asking price for each home sold that month. Determiine which sales people have the most total sales and determine how many sales are made within the city of Miami. You will prepare an attractively formatted summary report for your boss and a chart showing the total sales by sales person.

$2.19