Devry BIS 155 Week 3 ilab
Purpose:
Analyze the claim made by Condos at Summit Ridge Mountain “we sell the condo at the price you sell” by analyzing the sales data.
Analysis:
Use the data analysis to provide reasoning for your position about the claim. Here is how I am thinking about it. The claim that states that ” We sell the condos at the price you set.” We aim to determine using their own sales data if that is a true statement.
Contents :
Condo sales data Original sales data statistics
Loan data Loan calculations and statistics
Sort data sorted data using subtotal feature by selling agent
Ask vs sell price chart chart comparing asking price vs sell price by agent
Filtered data Filtered data reflecting Langston for pagosa only
Conditional formatting data Data formatted and sorted in order by % of asking price
Pivot table Average % of Asking price by agent with conditional