CountiesThe status of counties is important. There are more

CountiesThe status of counties is important. There are more than 3,000 UScounties. The median household income (in dollars), average years ofschooling, average lifespan (in years), and average number of people perhousehold of 100 chosen counties are provided.Data collected for a sample of 100 counties in 20XX are contained in the file named Counties, linked at the bottom of the page. Use all 100 data points.Managerial Report Prepare a report (see below)using the numerical methods of descriptive statistics presented in thismodule to learn how each of the variables contributes to the success of acounty. Be sure to include the following three (3) items in yourreport.Descriptive statistics (mean, median, range, and standarddeviation) for each of the four variables along with an explanation ofwhat the descriptive statistics tell us about the counties.Use the z-score to determine which counties, if any, should beconsidered outliers in each of the four variables. If there are anyoutliers in any category, please list them and state for which categorythey are an outlier. Describe which method you used to make yourdetermination.Descriptive statistics (correlation coefficient) showing therelationship between median household income (in dollars), and each ofthe other three variables. Thus, that makes a total of three correlationcoefficients. Evaluate the relationships between median householdincome (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 the Written AssignmentRequirements under the heading “Expectations for CSU-Global WrittenAssignments” found in the CSU-Global Guide to Writing and APA Requirements.As with all written assignments at CSU-Global, you should have in-textcitations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics, linked at the bottom of the page.Your 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 theproblem by communicating the results of your analysis. Include resultsof 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. Submit your Excel file in addition to your report.

CountiesThe status of counties is important. There are more

CountiesThe status of counties is important. There are more than 3,000 UScounties. The median household income (in dollars), average years ofschooling, average lifespan (in years), and average number of people perhousehold of 100 chosen counties are provided.Data collected for a sample of 100 counties in 20XX are contained in the file named Counties, linked at the bottom of the page. Use all 100 data points.Managerial Report Prepare a report (see below)using the numerical methods of descriptive statistics presented in thismodule to learn how each of the variables contributes to the success of acounty. Be sure to include the following three (3) items in yourreport.Descriptive statistics (mean, median, range, and standarddeviation) for each of the four variables along with an explanation ofwhat the descriptive statistics tell us about the counties.Use the z-score to determine which counties, if any, should beconsidered outliers in each of the four variables. If there are anyoutliers in any category, please list them and state for which categorythey are an outlier. Describe which method you used to make yourdetermination.Descriptive statistics (correlation coefficient) showing therelationship between median household income (in dollars), and each ofthe other three variables. Thus, that makes a total of three correlationcoefficients. Evaluate the relationships between median householdincome (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 the Written AssignmentRequirements under the heading “Expectations for CSU-Global WrittenAssignments” found in the CSU-Global Guide to Writing and APA Requirements.As with all written assignments at CSU-Global, you should have in-textcitations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics, linked at the bottom of the page.Your 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 theproblem by communicating the results of your analysis. Include resultsof 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. Submit your Excel file in addition to your report.