Description
Basically you have to Compare A to B and C. Part A of the city is saying they are paying higher taxes, etc. Read the questions that have to be answered. You can use Standard Deviation, Inter-Quartile Range (IQR), Range and Variance to compare A to B and C. All these functions can be done on Excel at the click of a button honestly. Just make sure to explain your reasoning when answering the questions. Project is pretty simple, just the reasoning has to justify why you used those methods to compare A to B and C.
*Open the excel file to access the information. There are 50 Numbers for A,B,C. You can do arrange the columns from smallest to largest if its easier. Standard deviation, average (mean), Variance all can de done on excel. Remember to explain which method you used to answer all the questions.
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

All done. I have also attached an excel file with all the workings
Running head: STATISTICS PROJECT
1
Statistics Project
Name
Institution
Date
STATISTICS PROJECT
2
How to investigate complaints from the homeowners who are unhappy about their taxes
The annual property taxes data collected from different areas within the city should be
analyzed to investigate the complaints from the unhappy homeowners. Since all homes are said
to be similar in value and size, then a comparison study using measures of spread would help in
describing any variability in the data.
The descriptive statistics that would best represent the data sets for the three areas in
responding to the complaints include:
a) Range – a measure of dispersion that is easy to compute and is
instrumental in describing the spread within a data as well as comparing
spread between datasets A, B and C.
b) Inter-quartile range (IQR) - this is the difference between the upper
quartile and lower quartile of an ordered dataset. IQR is ideal since it is
not affected by outliers.
c) Standard deviation – this is measure that summarizes the amount ...
