Question

1 Approved Answer

Posted on Jul 02, 2024

Part 1 Find a dataset from a field of your interest. The dataset must consist of at least 2 variables and at least 50 observations.

Part 1 Find a dataset from a field of your interest. The dataset must consist of at least 2 variables and at least 50 observations. At least one of the variables should be categorical and at least one quantitative. 1. (5 points) Create an introductory paragraph were you describe the data set in detail, types of variables, number of observations, what group does it represent, where did you obtain the data set, and what type of calculations can you perform on the data. If your data set has more than 5 variables in your data set focus on a few of your choice but ensure that you have at least one quantitative and one qualitative variable. 2. (4 points) Make an appropriate graph of a categorical variable in your data and explain what information you get from the graph and what it tells you about the individuals it represents. 3. (4 points) Make a histogram for a quantitative variable in your data, explain what information you get from the graph and what it tells you about the individuals it represents. 4. (4 points) Compute appropriate sample statistics for a quantitative variable in your data and explain what information you get from these values. 5. (12 points) For a variable in your dataset, compute a confidence interval, either for the population proportion of some property or for the population mean. a. Identify your confidence level for the interval and explain what the confidence level means. b. Identify the appropriate critical value (z* or t*) and determine its value. c. Give the computation of the margin of error. d. Interpret the results of your confidence interval. 6. (3 points) Explain any concerns you have about your data and cautions about some of the conclusions you made. Public Health Serisic Prata care in Chicago by year 1999_200911) editedExcit View Vidip Tell me what you want to do Home insert Page Layout Formules Share GSS 326 56 71.1 D G 1 CommunisCommunity Area Nam Trimester Prenatal Car Births 1999 Percent 1999 Percent 1999 Lower I Percent 1999 Upper CI Births 2000 Percent 2 Percent 2C Percent 20 Births 2001 2 1 ROGERS PARK 1ST TRIMESTER 726 58.9 56.2 61.6 692 54.6 3 51.9 573 731 1 ROGERS PARK 2ND TRIMESTER 259 21 18.7 23.3 25.7 23.3 4 28.1 245 1 ROGERS PARK 3RD TRIMESTER 90 7.3 s.a 8.8 96 7.6 6.1 9.1 O 5 1 ROGERS PARK NO PRENATAL CARE 79 6.4 5 7.8 60 4.7 3.5 1 ROGERS PARK 59 38 NOT GIVEN 79 6.4 5 7. 93 7.3 5.9 8.7 113 7 2 WEST RIDGE IST TRIMESTER 882 71.9 59,4 74.4 826 65.1 62.5 67.7 806 2 WEST RIDGE 2ND TRIMESTER 180 14.7 12.7 16.7 262 20.7 18.5 22.9 2 WEST RIDGE 211 3RD TRIMESTER 52 3.1 53 80 63 5 7.6 62 10 2 WEST RIDGE NO PRENATAL CARE 33 2.7 1.8 16 27 2.1 11 2.9 12 11 2 WEST RIDGE NOT GIVEN BD 0.5 5.1 79 73 5. 4.5 7.1 3 UPTOWN 126 1ST TRIMESTER 65.7 62.5 689 599 68 647 13 649 UPTOWN 2ND TRIMESTER 136 161 13.6 18. 162 18.4 15.8 14 3 UPTOWN 21 BAD TRIMESTER 45 53 3.8 6.8 35 2.7 5.3 15 31 3 UPTOWN NO PRENATAL CARE 29 2.2 46 31 3.5 16 3 UPTOWN 11 NOT GIVEN 4.7 BO 9.5 7.5 115 54 6.1 4.5 17 4 UNCOLN SQUARE 7.7 86 IST TRIMESTER 480 70.1 66.7 73.5 456 6.a 65.3 18 72.3 448 4 LINCOLN SQUARE 2ND TRIMESTER 112 10.4 13.6 19.2 125 18.9 15.9 21.9 19 77 18 MONTCLARE NO PRENATAL CARE 2 1.1 7 12 2 1 20 0 4 LINCOLN SQUARE 3RD TRIMESTER 36 5.3 3.6 7 36 5.4 3.7 10 21 4 LINCOLN SQUARE 71 NO PRENATAL CARI 25 3.6 2.2 5 16 2.4 1.2 3.6 5 22 4 LINCOLN SQUARE NOT GIVEN 32 4.7 3.1 63 30 4.5 6.1 23 5 NORTH CENTER 1ST TRIMESTER 390 79.1 75.5 82.7 471 80.8 22.6 455 24 5 NORTH CENTER 2ND TRIMESTER 40 8.1 5.7 10.5 68 11.7 9.1 14.3 25 S NORTH CENTER 3RD TRIMESTER 14 2.8 1.3 4.3 13 2.2 1 3.4 26 S NORTH CENTER NO PRENATAL CARE 14 1.3 4.3 6 ! 0.2 1.8 Sheet Sheet2 Public Health Statistics Pren Excel Esther Public Health Statistics. Pronatal care in Chiago by year_9999_2009 (1) edited View Hop Tell me what you want to do Home Insert Page Layout Formu Data GSS 1.3 1.3 4.8 8L 4.5 0.3 1 6.3 85.3 3 4.3 4.3 9.4 85.6 7.5 1.5 2.6 9.7 197 5.8 1 0.2 2.7 85.5 49 03 0.3 3.2 85.5 4.6 02 3.4 1.8 5.9 89.5 7.9 13 13 5.6 89.9 28 1.7 2 3 30 898 53 12 2 20 761 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 40 49 50 D 5 NORTH CENTER 3RD TRIMESTER 5 NORTH CENTER NO PRENATAL CARE 5 NORTH CENTER NOT GIVEN 6 LAKE VIEW 1ST TRIMESTER G LAKEVIEW 2ND TRIMESTER 6 LAKEVIEW 3RD TRIMESTER 6 LAKE VIEW NO PRENATAL CARE 6 LAKE VIEW NOT GIVEN 7 LINCOLN PARK 1ST TRIMESTER 7 LINCOLN PARK 2ND TRIMESTER 7 UNCOLN PARK 3RD TRIMESTER 7 LINCOLN PARK NO PRENATAL CARE 7 UNCOIN PARK NOT GIVEN 8 NEAR NORTH SIDE IST TRIMESTER 8 NEAR NORTH SIDE 2ND TRIMESTER 8 NEAR NORTH SIDE 3RD TRIMESTER & NEAR NORTH SIDE NO PRENATAL CARE 8 NEAR NORTH SIDE NOT GIVEN 9 EDISON PARK IST TRIMESTER 9 EDISON PARK 2NO TRIMESTER EDISON PARK 3RD TRIMESTER EDISON PARK NOT GIVEN 10 NORWOOD PARK 1ST TRIMESTER 10 NORWOOD PARK 2ND TRIMESTER 10 NORWOOD PARK 3RD TRIMESTER 10 NORWOOD PARK NO PRENATAL CARE Sheet Shetta Public Health Statistics Pren 14 14 35 851 61 9 18 82 744 37 2 2 65 497 101 26 5 106 124 7 0 1 182 12 1 5 2.8 2.8 7.1 83.3 6 0.9 1.8 8 87.5 4.4 0.2 0.2 7.6 67.5 13.7 35 08 14.4 92.5 5.2 0 22 89.9 7.5 0.7 12 2.2 1 43 87.6 6.4 08 OB 44 87.7 6.2 1 as 4.7 693 15 5.6 13 88 93.8 4.1 07 S. 64.1 11.2 2.2 0.2 11.9 881 1.4 13 6 25 927 68 8 8 42 733 52 R 4 39 534 116 43 10 00 136 6 1 2 368 30 5 2 9.4 70.9 16.2 48 14 16.9 06.0 3.3 66 12.5 4 as 6. 89.9 09 6.1 726 17.5 7.2 21 10.8 97.7 7.3 7 3 41 589 119 26 10 08 112 9 7 1 378 37 845 90.2 02.8 30 87.6 9 12 0.5 0 Part 1 Find a dataset from a field of your interest. The dataset must consist of at least 2 variables and at least 50 observations. At least one of the variables should be categorical and at least one quantitative. 1. (5 points) Create an introductory paragraph were you describe the data set in detail, types of variables, number of observations, what group does it represent, where did you obtain the data set, and what type of calculations can you perform on the data. If your data set has more than 5 variables in your data set focus on a few of your choice but ensure that you have at least one quantitative and one qualitative variable. 2. (4 points) Make an appropriate graph of a categorical variable in your data and explain what information you get from the graph and what it tells you about the individuals it represents. 3. (4 points) Make a histogram for a quantitative variable in your data, explain what information you get from the graph and what it tells you about the individuals it represents. 4. (4 points) Compute appropriate sample statistics for a quantitative variable in your data and explain what information you get from these values. 5. (12 points) For a variable in your dataset, compute a confidence interval, either for the population proportion of some property or for the population mean. a. Identify your confidence level for the interval and explain what the confidence level means. b. Identify the appropriate critical value (z* or t*) and determine its value. c. Give the computation of the margin of error. d. Interpret the results of your confidence interval. 6. (3 points) Explain any concerns you have about your data and cautions about some of the conclusions you made. Public Health Serisic Prata care in Chicago by year 1999_200911) editedExcit View Vidip Tell me what you want to do Home insert Page Layout Formules Share GSS 326 56 71.1 D G 1 CommunisCommunity Area Nam Trimester Prenatal Car Births 1999 Percent 1999 Percent 1999 Lower I Percent 1999 Upper CI Births 2000 Percent 2 Percent 2C Percent 20 Births 2001 2 1 ROGERS PARK 1ST TRIMESTER 726 58.9 56.2 61.6 692 54.6 3 51.9 573 731 1 ROGERS PARK 2ND TRIMESTER 259 21 18.7 23.3 25.7 23.3 4 28.1 245 1 ROGERS PARK 3RD TRIMESTER 90 7.3 s.a 8.8 96 7.6 6.1 9.1 O 5 1 ROGERS PARK NO PRENATAL CARE 79 6.4 5 7.8 60 4.7 3.5 1 ROGERS PARK 59 38 NOT GIVEN 79 6.4 5 7. 93 7.3 5.9 8.7 113 7 2 WEST RIDGE IST TRIMESTER 882 71.9 59,4 74.4 826 65.1 62.5 67.7 806 2 WEST RIDGE 2ND TRIMESTER 180 14.7 12.7 16.7 262 20.7 18.5 22.9 2 WEST RIDGE 211 3RD TRIMESTER 52 3.1 53 80 63 5 7.6 62 10 2 WEST RIDGE NO PRENATAL CARE 33 2.7 1.8 16 27 2.1 11 2.9 12 11 2 WEST RIDGE NOT GIVEN BD 0.5 5.1 79 73 5. 4.5 7.1 3 UPTOWN 126 1ST TRIMESTER 65.7 62.5 689 599 68 647 13 649 UPTOWN 2ND TRIMESTER 136 161 13.6 18. 162 18.4 15.8 14 3 UPTOWN 21 BAD TRIMESTER 45 53 3.8 6.8 35 2.7 5.3 15 31 3 UPTOWN NO PRENATAL CARE 29 2.2 46 31 3.5 16 3 UPTOWN 11 NOT GIVEN 4.7 BO 9.5 7.5 115 54 6.1 4.5 17 4 UNCOLN SQUARE 7.7 86 IST TRIMESTER 480 70.1 66.7 73.5 456 6.a 65.3 18 72.3 448 4 LINCOLN SQUARE 2ND TRIMESTER 112 10.4 13.6 19.2 125 18.9 15.9 21.9 19 77 18 MONTCLARE NO PRENATAL CARE 2 1.1 7 12 2 1 20 0 4 LINCOLN SQUARE 3RD TRIMESTER 36 5.3 3.6 7 36 5.4 3.7 10 21 4 LINCOLN SQUARE 71 NO PRENATAL CARI 25 3.6 2.2 5 16 2.4 1.2 3.6 5 22 4 LINCOLN SQUARE NOT GIVEN 32 4.7 3.1 63 30 4.5 6.1 23 5 NORTH CENTER 1ST TRIMESTER 390 79.1 75.5 82.7 471 80.8 22.6 455 24 5 NORTH CENTER 2ND TRIMESTER 40 8.1 5.7 10.5 68 11.7 9.1 14.3 25 S NORTH CENTER 3RD TRIMESTER 14 2.8 1.3 4.3 13 2.2 1 3.4 26 S NORTH CENTER NO PRENATAL CARE 14 1.3 4.3 6 ! 0.2 1.8 Sheet Sheet2 Public Health Statistics Pren Excel Esther Public Health Statistics. Pronatal care in Chiago by year_9999_2009 (1) edited View Hop Tell me what you want to do Home Insert Page Layout Formu Data GSS 1.3 1.3 4.8 8L 4.5 0.3 1 6.3 85.3 3 4.3 4.3 9.4 85.6 7.5 1.5 2.6 9.7 197 5.8 1 0.2 2.7 85.5 49 03 0.3 3.2 85.5 4.6 02 3.4 1.8 5.9 89.5 7.9 13 13 5.6 89.9 28 1.7 2 3 30 898 53 12 2 20 761 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 40 49 50 D 5 NORTH CENTER 3RD TRIMESTER 5 NORTH CENTER NO PRENATAL CARE 5 NORTH CENTER NOT GIVEN 6 LAKE VIEW 1ST TRIMESTER G LAKEVIEW 2ND TRIMESTER 6 LAKEVIEW 3RD TRIMESTER 6 LAKE VIEW NO PRENATAL CARE 6 LAKE VIEW NOT GIVEN 7 LINCOLN PARK 1ST TRIMESTER 7 LINCOLN PARK 2ND TRIMESTER 7 UNCOLN PARK 3RD TRIMESTER 7 LINCOLN PARK NO PRENATAL CARE 7 UNCOIN PARK NOT GIVEN 8 NEAR NORTH SIDE IST TRIMESTER 8 NEAR NORTH SIDE 2ND TRIMESTER 8 NEAR NORTH SIDE 3RD TRIMESTER & NEAR NORTH SIDE NO PRENATAL CARE 8 NEAR NORTH SIDE NOT GIVEN 9 EDISON PARK IST TRIMESTER 9 EDISON PARK 2NO TRIMESTER EDISON PARK 3RD TRIMESTER EDISON PARK NOT GIVEN 10 NORWOOD PARK 1ST TRIMESTER 10 NORWOOD PARK 2ND TRIMESTER 10 NORWOOD PARK 3RD TRIMESTER 10 NORWOOD PARK NO PRENATAL CARE Sheet Shetta Public Health Statistics Pren 14 14 35 851 61 9 18 82 744 37 2 2 65 497 101 26 5 106 124 7 0 1 182 12 1 5 2.8 2.8 7.1 83.3 6 0.9 1.8 8 87.5 4.4 0.2 0.2 7.6 67.5 13.7 35 08 14.4 92.5 5.2 0 22 89.9 7.5 0.7 12 2.2 1 43 87.6 6.4 08 OB 44 87.7 6.2 1 as 4.7 693 15 5.6 13 88 93.8 4.1 07 S. 64.1 11.2 2.2 0.2 11.9 881 1.4 13 6 25 927 68 8 8 42 733 52 R 4 39 534 116 43 10 00 136 6 1 2 368 30 5 2 9.4 70.9 16.2 48 14 16.9 06.0 3.3 66 12.5 4 as 6. 89.9 09 6.1 726 17.5 7.2 21 10.8 97.7 7.3 7 3 41 589 119 26 10 08 112 9 7 1 378 37 845 90.2 02.8 30 87.6 9 12 0.5 0