BSB123: Allocations and bookings in maternity ward - Data Analysis Assignment

Internal Code: MAS3591

Data Analysis Assignment:

Management at the hospital is interested in being able to better manage room allocations and bookings in their maternity ward. They are keen to identify mothers at risk of having low birth weight babies who may require additional hospital resources during their stay in the hospital. The hospital has collected data for a number of previous births at the hospital. The data contains information on the variables outlined in the table above. As a consultant, they have approached you and asked if you could analyse this dataset. Questions: Part 1: 1. Past records (2004) show that the average birthweight was 3500 grams. Test at 5% if the average birthweight in 2015 has increased with the improvement in general nutrition. 2. Perform a two-sample t-test for each of the following tasks. (a) Determine if there is evidence that on average the weight of a baby of a mother who smokes is less than that of a mother who does not. (b) Determine if being indigenous is a disadvantage in terms of birthweight. 3) (a) Interpret the regression coefficients of all six (6) independent variables in the model obtained in Step 6, and comment on the statistical significance of each. (b) Use Excel to obtain the correlation matrix for the following variables: Gestation, Pre-pregnancy Weight, Height, Age and Birthweight. Do you think multi-collinearity is a problem in the regression model? Are the correlation coefficients consistent with the regression coefficients obtained in the model in Step 6? Discuss briefly. (c) Focusing on Steps 3 and 4, discuss fully how the introduction of Height in Step 4 affects the regression coefficient of Pre-pregnancy Weight. (d) Based on the results in (a) to (c), explain which independent variables should be included or excluded to formulate the final model. State the final model (e) Comment on the overall adequacy of the final model. (f) Consider an indigenous mother who is a smoker, 20 years of age, and 160cm tall with a pre-pregnancy weight of 58kg and gestational age of 267 days. What is the expected weight of the child, using the final model you have developed in (d)?