Managerial report

Anonymous
timer Asked: Apr 23rd, 2017

Question description

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.

Managerial Report
Prepare 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 report.

  1. 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 counties.
  2. 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 your determination.
  3. 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 your conclusions.

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

Tutor Answer

(Top Tutor) Studypool Tutor
School: UCLA
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors