The status of
counties is important. There are more than 3,000 US counties. The median
household income (in dollars), average years of schooling, average
lifespan (in years), and average number of people per household of 100
chosen counties are provided.
Data collected for a sample of 100 counties in 20XX are contained in the attached excel file named Counties. Use all 100 data points.
a report (see below) using the numerical methods of descriptive
statistics to learn how each of the variables contributes to the success
of a county. Be sure to include the following three (3) items in your
- Descriptive statistics (mean, median, range, and
standard deviation) for each of the four variables along with an
explanation of what the descriptive statistics tell us about the
- Use the z-score to determine which counties, if any,
should be considered outliers in each of the four variables. If there
are any outliers in any category, please list them and state for which
category they are an outlier. Describe which method you used to make
- Descriptive statistics (correlation
coefficient) showing the relationship between median household income
(in dollars), and each of the other three variables. Thus, that makes a
total of three correlation coefficients. Evaluate the relationships
between median household income (in dollars) and each of the other three
variables. Use tables, charts, graphs, or visual dashboards to support
Write a report that adheres to APA format
using in text citations and a reference page. The grading rubric and an
example paper are also attached.
The report must contain the following:
- A title page in APA style.
- An introduction that summarizes the problem.
body of the paper should answer the questions posed in the problem by
communicating the results of your analysis. Include results of
calculations, as well as charts and graphs, where appropriate.
- A conclusion paragraph that addresses your findings and what you have determined from the data and your analysis.