Get into Excel and load the data set.
Make a code book
Obtain descriiptive statistics of Taxes levied and millage rate by using Analysis Toolpak. Which one will you choose as the appropriate central tendency for
them?
Produce a histogram for millage rate by using Analysis Toolpak. What can you tell by the histogram?
Create a bar chart for city type. Describe the bar chart.
Create a pie chart for form of government. Describe the pie chart.
Use pivot table to create a contingency table to show the relationship between Tax rate and Form of government.
Use tab “city with pop over 6k”, obtain correlation coefficient between population and tax levied and draw a scatter plot. (optional)
Write a short paragraph describing what you learn from the tables and charts.
Be sure to provide a complete answer to each question, with printouts as indicated in the questions. ALWAYS give a complete narrative (with complete
sentences and correct grammar) on a separate sheet of paper. NEVER rely on only the printout to communicate your findings. Use page numbers throughout
your hand-in, and identify on which pages we can find the required printouts. In addition, highlight on the printouts where relevant information is to be found
that is also mentioned on your separate narrative. Always use the variable label in your write-up; Points are deducted for wrong answers as well as
incomplete write-ups, incomplete sentences, sloppy appearance/presentation. (For example, for question 2, state, “The descriiptive statistics of the variable
Taxes levied is provided on p. xx.”)
Provide a professional presentation. Please visit this webpage-https://www.aresearchguide.com/writing-with-descriiptive-statistics.html (Links to an external
site.) This can help you with how to write descriiptive analysis.