DATA ANALYSIS PROJECT: Low Birth Weights

All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below. Format the document professionally so it flows well. Include a table of contents.

* Choose any published database from the internet or Bethel library (such as those from the Census Bureau or any financial sites). You may opt to use one of the data files provided by the instructor if applicable.

* Get advanced approval from the instructor on your chosen database.

* If the file is large, randomly choose 200 of the observations from the data.

* Explain each variable in the file that you are analyzing. Be sure your file includes at least 3 scale variables and at least 2 nominal variables.

* Conduct a descriptive analysis on any 2 interval / ratio variables you wish usingDescriptive_Statistics.xlsandFrequency_Distribution.xls. Explain the output.

* Conduct 3 different hypothesis tests of your choice using appropriate variables from the file (note: you must use 3 different tests and not run one test on 3 different variables). In each case, state the variables being tested as well as the hypothesis, decision and conclusion. Use 3 of the following(1-Sample Test for Means, 1-Sample Test for Proportions, 2-Sample Test for Means Independent Samples, 2-Sample Test for Means Paired Samples, 2-Sample Test for Proportions, Analysis of Variance, Chi Square Goodness of Fit Test, Chi Square Test of Independence, Correlation Test).

* Develop a model to predict an interval / ratio variable using at least 2 other variables. UseMultiple_Regression.xlsand state the regression model and which variables are or are not significant. Also, use the model to make a prediction by making up values for each of the independent variables.

* Write a one to two page summary of your findings. Include the data file in the appendix.

LowBirthWt BirthWt (pounds) 5.56 5.62 5.63 5.71 5.73 5.78 5.81 5.81 5.87 5.87 6.00 6.02 6.06 6.06 6.10 6.10 6.12 6.13 6.18 6.21 6.24 6.24 6.25 6.31 6.34 6.34 6.40 6.43 6.43 6.43 6.43 6.49 6.49 6.56 6.56 6.56 6.56 6.59 6.62 6.68 6.70 6.74 6.74 6.74 6.78 6.78 6.78 6.81 6.81 6.81 6.83 6.84 6.90 LowBirthWt No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No AgeOfMom 19 33 20 21 18 21 22 17 29 26 19 19 22 30 18 18 15 25 20 28 32 31 36 28 25 28 17 29 26 17 17 24 35 25 25 29 19 27 31 33 21 19 23 21 18 18 32 19 24 22 22 23 22 Page 1 WeightOfMomAtLastMenstrPd 182 155 105 108 107 124 118 103 123 113 95 150 95 107 100 100 98 118 120 120 121 100 202 120 120 167 122 150 168 113 113 90 121 155 125 140 138 124 215 109 185 189 130 160 90 90 132 132 115 85 120 128 130 LowBirthWt 6.93 6.99 6.99 7.06 7.06 7.06 7.10 7.10 7.12 7.12 7.12 7.18 7.21 7.21 7.28 7.31 7.31 7.31 7.31 7.34 7.43 7.43 7.49 7.52 7.56 7.59 7.62 7.62 7.65 7.65 7.68 7.81 7.87 7.87 7.90 7.93 7.96 7.96 7.99 7.99 8.01 8.02 8.04 8.04 8.04 8.04 8.15 8.21 8.27 8.30 8.30 8.30 8.35 8.37 No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No 30 19 16 21 30 20 17 17 23 24 28 26 20 24 28 20 22 22 31 23 16 16 18 25 32 20 23 22 32 30 20 23 17 19 23 36 22 24 21 19 25 16 29 29 19 19 30 24 19 24 23 20 25 30 Page 2 95 115 110 110 153 103 119 119 119 110 140 133 169 115 250 141 158 112 150 115 112 135 229 140 134 121 190 131 170 110 127 123 120 105 130 175 125 133 134 235 95 135 135 154 147 147 137 110 184 110 110 120 241 112 LowBirthWt 8.43 8.49 8.50 8.50 8.56 8.56 8.62 8.68 8.68 8.68 8.74 8.77 8.80 8.80 8.93 8.93 9.06 9.15 9.18 9.19 9.33 10.12 10.99 1.56 2.25 2.50 2.93 3.25 3.50 3.50 3.75 3.81 3.94 4.00 4.15 4.17 4.18 4.25 4.25 4.25 4.26 4.34 4.53 4.53 4.59 4.59 4.59 4.63 4.68 4.68 4.82 4.82 4.87 4.90 No No No No No No No No No No No No No No No No No No No No No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 22 18 16 32 18 29 33 20 28 14 28 25 16 20 26 21 22 25 31 35 19 24 45 28 29 34 25 25 27 23 24 24 21 32 19 25 16 25 20 21 24 21 20 25 19 19 26 24 17 20 22 27 20 17 Page 3 169 120 170 186 120 130 117 170 134 135 130 120 95 158 160 115 129 130 120 170 120 116 123 120 130 187 105 85 150 97 128 132 165 105 91 115 130 92 150 200 155 103 125 89 102 112 117 138 130 120 130 130 80 110 LowBirthWt 4.93 4.93 5.03 5.06 5.06 5.07 5.12 5.18 5.18 5.21 5.24 5.24 5.24 5.28 5.31 5.31 5.32 5.34 5.37 5.38 5.40 5.43 5.43 5.43 5.50 5.50 5.50 5.50 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 25 20 18 18 20 21 26 31 15 23 20 24 15 23 30 22 17 23 17 26 20 26 14 28 14 23 17 21 Page 4 105 109 148 110 121 100 96 102 110 187 122 105 115 120 142 130 120 110 120 154 105 190 101 95 100 94 142 130 LowBirthWt Race Black Other White White White Other White Other White White Other Other Other Other White White Black White Other White Other White White Other Other White White White Black Black Black White Black White Black White White White White White Black White Black White White White White Other White Other White Other White SmokedAtPreg 0 0 1 1 1 0 0 0 1 1 0 0 0 0 1 1 0 1 0 1 0 0 0 0 0 0 1 0 1 0 0 1 1 0 0 1 1 1 1 1 1 0 0 0 1 1 0 0 0 1 0 0 1 PrematureLabor 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 5 HistoryOfHypertension 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 LowBirthWt White Other Other Other Other Other Other Other Other Other White Other Other Other Other White Black White Other Other Black White Black White White Black White White White Other Other Other Other Other White White White White Other White White White White White White White White White White Other White Other Black White 1 0 0 1 0 0 0 0 0 0 0 1 0 0 1 0 0 1 1 1 0 1 0 0 1 1 0 0 0 0 0 0 1 0 0 0 0 0 0 1 1 1 0 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 1 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 1 0 Page 6 LowBirthWt White White Black White Other White White White Other White Other White Other White Other White White White White White White White White Other White Black Other Other Other Other Black Other White White White Other Other White White Black White Other Other Other White White White White Other Black White Black Other White 0 1 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 1 0 0 0 0 0 0 1 1 1 0 0 1 1 0 1 0 0 0 0 1 1 0 1 1 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 0 1 0 0 0 1 0 0 0 0 0 1 0 0 1 0 0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 7 LowBirthWt Other Other Other Black White Other Other White White Black Black Black Other Other White White White White Black Other Other White Other White Other Other Black White 0 0 0 1 1 0 0 1 0 1 1 1 0 0 1 1 1 1 0 0 0 1 1 1 0 1 0 1 1 0 0 1 1 1 0 1 0 0 0 0 0 0 1 0 0 1 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 1 Page 8 LowBirthWt UterineIrritability 1 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 DrVisitsDuring1stTri 0 3 1 2 0 0 1 1 1 0 0 1 0 2 0 0 0 3 0 1 2 3 1 0 2 0 0 2 0 1 1 1 1 1 0 2 2 0 2 1 2 2 1 0 0 0 4 0 2 0 1 0 0 Page 9 NOTES for SmokedAtPreg, PrematureLabor, H 0 = NO, 1 = YES LowBirthWt 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 2 0 0 0 1 2 6 1 2 0 2 1 0 0 0 1 4 0 0 1 0 0 0 0 0 0 0 0 1 0 2 0 0 0 1 1 0 0 1 1 0 0 1 0 0 1 Page 10 LowBirthWt 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 1 1 1 0 0 2 4 2 1 2 1 0 1 0 0 2 1 1 0 1 0 2 2 1 0 1 1 0 2 0 0 0 0 1 1 0 1 0 0 0 1 0 2 2 0 0 0 1 2 0 0 0 0 3 1 0 0 0 Page 11 LowBirthWt 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 4 0 1 0 1 0 0 0 0 0 1 3 0 2 1 3 0 0 2 2 0 0 3 Page 12 LowBirthWt AtPreg, PrematureLabor, Hypertension, UterineIrritability Page 13 LowBirthWt Page 14 LowBirthWt Page 15 LowBirthWt Page 16