Prepare a report (see below) using the numerical methods of descriptive statisti

ID: 3223138 • Letter: P

Question

Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module 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.

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.

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.

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.

County Median household income in dollars Average years of schooling Average lifespan in years Average number of people per household Alpine 42799 11.8 75.9 2.2 Andrews 56598 13.1 79.7 2.5 Angelina 41789 11.7 75.7 2.2 Appling 41593 11.7 75.5 2.6 Arapahoe 51925 12.5 78.1 3 Atlantic 35427 10.3 73 2.5 Austin 55470 13.1 79.5 2.2 Bailey 39152 11.4 74.6 2.4 Ballard 59512 14 80.1 2.8 Bastrop 39631 11.5 74.8 2.9 Baylor 43075 11.9 76.2 1.9 Bee 47985 12.2 77.5 2.7 Belmont 41175 11.7 75.2 2.7 Benewah 59839 13.9 78.9 3.2 Benton 41211 11.7 78.1 2.1 Borden 59620 14 80.9 2.5 Bosque 46873 12.1 77.2 2 Bowie 55241 12.9 78.9 2.7 Brazoria 43042 11.8 78.4 2.7 Brazos 42242 11.8 75.9 3.2 Brewster 55536 13.1 78.4 2.5 Briscoe 40064 11.6 75.2 2.9 Brooks 54202 12.6 78.5 2.2 Brown 50142 12.3 77.9 1.8 Burleson 58115 13.5 80.4 2.2 Butler 57472 13.5 80.3 2 Caldwell 39920 11.6 75 2.4 Calhoun 48539 12.2 77.7 2.6 Callahan 52155 12.5 78.1 2.3 Calumet 38453 11.1 73.9 1.9 Camp 56918 13.3 80.1 2.5 Carson 45745 12.1 76.8 2.4 Casey 35545 10.5 73.3 2.1 Castro 37647 10.8 73.5 2.6 Charles 51951 12.5 78.1 3.2 Cherry 54248 12.6 78.6 2.4 Chilton 56913 12.4 80.1 2.4 Clinton 42518 11.8 75.9 2.7 Cochise 39550 11.4 74.7 2.7 Coke 45753 12.1 76.9 3.2 Coleman 55344 13 79.2 2.9 Collin 57294 13.4 80.3 2.7 Collins 38916 11.2 74.2 2.7 Colorado 50008 12.3 77.8 2.4 Comal 47085 12.1 78.3 2.3 Concho 47703 12.2 77.4 2 Cone 39275 11.4 74.6 3.5 Cooke 53163 12.5 78.4 2.2 Cotton 3600 10.8 73 2 Coweta 40793 12 70.4 3 Craven 54863 12.7 78.8 2.2 Crockett 39582 11.4 74.8 2 Dakota 53529 12.6 78.5 2.3 Dale 38668 11.7 74.2 2.1 Dallam 39820 11.6 75 1.8 Dallas 56972 13.4 78.8 2.4 Daniels 48640 12.3 78 2.7 Dearborn 57777 13.5 80.4 2 Delaware 35831 10.7 73.3 2 Denton 51417 12.4 78.1 2.5 DeWitt 51311 12.4 78 2.9 Dickens 46677 12.1 77.1 2.7 Dimmit 36620 11.1 73.5 2.1 Durham 46660 12.1 77 1.8 Duval 54668 12.7 78.7 2.6 Eastland 55060 12.8 78.9 2.3 Ector 41648 11.7 75.7 2.8 Edward 45157 12 76.8 2.6 Erie 56785 13.3 79.7 2.8 Essex 43613 11.9 76.3 2.8 Gregg 54416 12.6 78.7 2.1 Grimes 53695 12.6 78.5 2.2 Guam 35968 10.8 73.3 2.8 Hale 38098 12.2 73.7 2.7 Hall 38375 11 73.8 2.7 Jones 55043 12.8 78.8 2.1 Kent 41928 11.8 75.8 3 Lincoln 57064 13.4 80.2 2.6 Marion 3900 11 73.8 2.5 Nevada 45455 12.1 76.8 2.7 Niagra 37975 9 73.6 2.5 Ontario 56027 13.1 79.7 2.6 Orange 35442 9.4 70 3.1 Oxford 55998 13.1 79.6 2.3 Putnam 41332 11.7 75.4 2.9 Queens 47582 12.2 77.4 2.1 Richmond 52193 12.5 78.1 1.8 Riverside 44685 12 76.7 2.4 Sullivan 37692 10.9 73.6 2.3 Sutter 47253 12.2 77.3 1.8 Tipton 53186 12.5 78.4 3.1 Trinity 50098 12.3 77.8 2 Union 58850 13.6 80.8 2.4 Wabash 58223 13.6 78.8 2 Washington 39193 12.2 74.6 3 Wells 51233 12.4 78 2.9 Wyoming 38956 11.3 74.4 2.9 Yates 41905 11.7 78.3 3 Yuba 39077 11.4 74.5 2.9 Ziebach 44500 12 76.4 2.4

Explanation / Answer

Mean

Median

Range

Standard Deviation

Median household income in dollars

7347.598

46775

56239

40292.95366

Average years of schooling

0.687

12.15

11.48179982

Average lifespan in years

2.0016

77.4

10.9

74.93081101

Average number of people per household

0.32166

2.5

1.7

2.20130454

The median household income varies vastly across the counties as the standard deviation tells us while there is not much variation in the average number of people per household while the other two lies in the between.

For Median household Income the incomes of Aolpine and Andrews county are outliers.

There is no outlier for average year of schooling.

There is no outlier for Average lifespan in years.

There is no outlier for Average number of people.

correlation between Median household income in dollars and Average years of schooling is

correlation between Median household income in dollars and Average lifespan is

correlation between Median household income in dollars and Average njmber of people in a household is

0.051734