Easy statistics project, should take no longer than an hour or even less

User Generated




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

A B 1,005 721 850 690 838 717 848 931 740 985 852 1,070 691 815 529 712 739 1,092 821 900 716 943 974 902 824 1,069 921 798 795 814 829 765 905 695 812 772 779 816 835 683 811 819 C 934 773 660 887 620 911 731 629 605 801 732 929 765 787 828 682 1,143 723 849 760 723 1,091 1,041 886 756 679 693 635 753 866 865 581 947 853 953 644 896 1,065 918 707 772 652 757 679 753 725 718 540 776 777 722 673 870 758 862 940 1,096 854 767 785 1,069 990 1,049 1,027 958 884 683 814 718 690 873 723 939 978 921 1,150 849 788 825 834 917 945 794 850 898 912 937 752 910 839 929 785 705 792 704 745 743 807 510 461 939 716 641 827 816 719 840 777 City administrators received several complaints from homeowners in a particular area of the city who feel that their property taxes are much higher compared to other parts of the city. To investigate the homeowner's taxes, you gather the data provided as Data-Group Project.xls. Area A represents the city where the homeowners are unhappy about their taxes. The data represent the annual taxes paid by a random sample of 150 homeowners in Area A and two other areas of the same city. Assume all homes represented are similar in size and value. 1. How would you do it? a. How would you investigate the complaints from the homeowners who are unhappy about their annual taxes? b. Which descriptive statistics (select maximum three) do you think would best represent the data sets for the three areas in responding to the complaint? Why? c. Calculate the descriptive statistics measures you selected in part (b) above for all three areas. 2. Graphing the data a. What type of graph would you choose to display the data? Explain your reasoning? b. Construct the graphs. c. Based on your graphs, does it appear that the annual taxes in Area A are higher than in the other areas? Explain. 3. Measuring the data a. What other statistical measures (select maximum two) could you use to analyze the taxes! b. Calculate the measures you selected in part (a) above. c. Compare the measures with the graphs from part 2 above. Do the measures support your conclusion in part 2? Explain. 4. Discussing the data a. Do you think the complaints in Area A are legitimate? How do you think the City should address the complaints? b. What reasons might you give as to why the homeowners' taxes vary among the different areas of the city? 5. Include statement indicating which part of the group project was done by whom.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

All done. I have also attached an excel file with all the workings



Statistics Project




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 ...

Really great stuff, couldn't ask for more.


Related Tags