Home Insert Page Layout Formulas Datal Review View [A Paste Calibri (Body) BI U 11 ' ' Wrap Text & A Merge & Center birthweight full dataset (1) Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Renew Microsoft 365 to Create and Edit Your account (null) has an expired Microsoft 365 subscription. fx General $%9 1 7 Conditional Format Cell Formatting as Table Styles g Share AutoSum Fill Insert Delete Format Clear v Sort & Filter Find & Select Yes No Renew V40 A B D E F G H . K L M N 0 P Q R T U V W X Y Z AA AB AC AD 1 ID Lanath Birthweighy Head Gestation smoker mage mnocig mhaight mpp feclys Troci Theight lowtwi magu35 2 21 53 3.55 33 41 1 37 25 161 ch 45 16 1/5 a 1 3 57 51 3.32 35 39 1 23 17 157 48 32 12 25 169 0 4 223 50 3.87 33 1 28 25 163 54 30 16 0 183 0 5 272 52 3.86 35 30 1 30 25 170 78 40 16 50 178 0 0 6 . 46 2.05 32 35 1 11 3 16 57 33 14 25 175 1 1 7 321 48 3.11 33 37 0 ZB 158 54 39 10 0 171 o 0 365 52 3.53 37 40 1 26 25 170 62 30 10 25 181 0 0 9 431 48 192 30 33 1 20 7 161 50 20 10 35 180 1 0 10 462 58 4.1 39 41 35 172 58 31 16 25 185 0 1 11 510 47 2.06 33 35 1 20 35 170 57 23 12 50 186 1 0 12 532 53 3.59 34 40 1 31 12 163 49 41 12 50 191 0 13 553 54 3.94 37 42 0 24 175 66 30 12 0 184 0 14 560 50 2.51 35 1 22 3 150 52 23 14 25 200 1 0 15 575 50 2.78 30 37 1 19 7 105 00 20 14 100 183 0 0 16 619 52 3.41 33 39 1 23 25 181 69 23 16 2 181 0 17 697 48 3.03 35 39 0 27 162 62 27 14 0 178 0 18 752 49 3.32 35 40 1 27 12 152 48 33 12 25 170 0 19 755 53 3.2 33 41 100 21 155 55 25 14 25 183 0 20 792 53 3.64 38 40 1 20 2 170 59 24 12 12 185 0 0 21 808 48 292 33 34 0 26 167 64 25 12 25 175 0 22 820 52 3.77 34 40 0 24 157 50 31 16 0 173 0 0 23 822 50 342 35 10 20 157 18 22 11 10 179 0 0 24 1015 53 4.32 35 40 0 19 171 62 19 12 0 183 0 0 25 1023 52 3 35 38 1 30 12 165 64 3B 14 50 180 0 0 26 1058 53 3.15 34 40 0 29 0 167 60 30 16 25 182 0 0 27 1001 303 38 10 18 0 172 501 20 12 7 172 10 28 1085 51 3.27 35 40 0 24 168 53 29 16 0 181 0 29 1107 52 3.23 35 38 0 31 164 57 35 16 0 183 0 30 1187 53 4.07 38 44 0 20 174 68 25 14 25 189 0 0 $1 1191 53 305 22 10 21 155 61 21 10 25 185 10 32 1262 53 3.19 34 41 1 27 35 163 51 31 16 25 185 0 33 1272 53 2.75 32 40 1 37 50 168 61 31 16 0 173 0 1 34 1313 43 2.65 32 33 0 24 0 140 45 25 16 0 169 1 0 85 1:160 50 4.35 34 44 10 201 157 57 23 10 15 179 10 36 1363 48 237 30 37 1 20 7 163 47 20 10 35 185 1 0 37 1369 49 3.18 34 38 1 31 25 162 57 32 16 50 194 0 38 1388 51 3.14 33 41 1 22 7 150 53 24 16 12 176 0 1522 540 2.74 1 21 15 150 53 24 12 7 179 a 40 1600 53 2.9 34 39 0 19 16G 57 23 14 2 193 0 41 1635 51 3.93 38 38 0 29 0 165 61 31 16 0 180 0 0 42 1683 53 3.35 33 41 0 27 164 62 37 14 0 170 0 43 17b4 588 4.57 39 41 1 32 12 173 711 3K 14 25 1801 10 64 45 46 Ready Birthweight reduced kg R + # 87% Part 2: Data Exploration and Relationships Download the Birthweight data file. This file contains data on the birth weight, length, and head circumference of 42 infants, along with data about the habies' parents. The following table contains a description of the variables in the data set. ID length Birthweight headcirumference Gestation smoker motherage maneig mheight mppwt fage fedyrs Baby number Length of baby (cm) Weight of haby (kg) Head Circumference Gestation (weeks) Scale Scale Scale Scale Mother smokes -smoker 0-non-smoker Binary Maternal age Scale Number of cigarettes smoked per day by mother Scale Mother's height (cm) Scale Mother's pre-pregnancy weight (kg) Scale Father's age Father's years in education Scale Scale Number of cigarettes smoked per day by father Scale Father's height (kg) Scale Low birth weight, 0= No and 1 = yes Binary Mother over 35,0 No and 1=yes Binary fheight lowbwr mage35 Relationship between quantitative variables In this portion of the project, we explore whether there is any suggestion of relationship between Birthweight and other variables. Choose another quantitative (discrete or continuous, but not binary) variable. Create a scatterplot for the variable you chose, plotting your chosen variable on the horizontal axis and Birthweight on the vertical axis. Format your plot with an appropriate title and axis labels. Find the correlation coefficient between your chosen variable and Birthweight. Describe the relationship between your chosen variable and Birthweight. Comment on the strength, direction, and overall shape. Do you believe the variable you chose is a good predictor of Birthweight? Why or why not? Repeat parts (a) through (e) with a second quantitative variable. Relationship between qualitative (categorical) variables Is there any relationship between smoking and low birth weight? Use the variables smoker and lowbat, and conduct a chi-squared test to answer. State the value of the test statistic, the value and degrees of freedom. Make a conclusion hased on the value and interpret it in the context of the research question. Hypothesis testing Suppose that, prior to the collection of data in this file, researchers had hypothesized that babies whose mother was a smoker might have a different head circumference from babies whose mother was not a smoker. Test this hypothesis at the level. State the value of the test statistic, the value and degrees of freedom, if applicable. Make a conclusion based on the value and interpret it in the context of the research