BSB123 Data Analysis Assessment Item 2 Research Report (2017 S1)

The file: Birthweights.xlsx contains data on the following variables for a sample of 1000 births recorded in a large local hospital in 2015:

Variable Description
Birthweight Birthweight in grams
Gestation Length of pregnancy in days
Smoke Whether the mother is a smoker or not
Pre-pregnancy weight Mother’s pre-pregnancy weight in kilograms
Height Mothers height in centimetres
Status Mother’s indigenous status
Age Mother’s age in years

Background
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.

Tasks

Part 1 - Analysis (80%)

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.
   (Include all six steps for hypothesis testing.) 2 marks)
2. Perform a two-sample t-test for each of the following tasks. (Include all six steps for hypothesis testing in each.)
   (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. ( = 5%) (2 marks)
   (b) Determine if being indigenous is a disadvantage in terms of birthweight. ( = 5%) (2 marks)
   The hospital management is particularly interested in whether you can develop a regression model to help them to predict the birthweight of a baby based on the variables in the data supplied. The model could then be used to predict birthweight to identify babies at risk in future.

3. By using the forward stepwise method, develop a multiple regression model to predict the birthweight.

   Step 1: Gestation only
   Step 2: Gestation and Smoke
   Step 3: Gestation, Smoke and Pre-pregnancy Weight
   Step 4: Gestation, Smoke, Pre-pregnancy Weight and Height
   Step 5: Gestation, Smoke, Pre-pregnancy Weight, Height and Status
   Step 6: Gestation, Smoke, Pre-pregnancy Weight, Height, Status and Age
   (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. (3 marks)
   (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. (3 marks)
   (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. (3 marks)
   (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.
   (2 marks)
   (e) Comment on the overall adequacy of the final model. (2 marks)
   (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)? (2 marks)

4. Compute the difference in the average birthweight of babies of indigenous and non-indigenous mothers (called the birthweight difference, for simplicity). Discuss fully if there is any discrepancy between the regression coefficient of Status obtained in the regression model and the birthweight difference. (3 marks)
    
   Part 2 – Report (20%)
   You are required to submit a concise report (word limit: 400) presenting any important features or relationships in the data. The content of your report should be based on, but not restricted to, insights gleaned from your analyses conducted in Part 1. (6 marks)

Notes:

Part 1 - Analysis

• For presentation and ease of marking, it is advisable to include relevant Excel output in your answer to each question in this part instead of placing them in appendices.
• There is no word limit in Part 1.
Part 2 - Report
• The report is primarily based on the data provided. If, however, you wish to include, and refer to, additional information, you can use any referencing system as long as it is used consistently.
• You can include relevant charts and Excel objects in your report.
• Use 1 & ½ spacing and font size of 11.
• The word limit of 400 (with a tolerance of 10%) is exclusive of words in tables, appendices and reference list (if any).

Submission
• You should submit your response to both parts as a single pdf document saved in the format:
BSB123 Report_StudentName.pdf
• After uploading your research report, it is your responsibility to go back to the Assignment Upload page to check that your report was properly uploaded.
• Due: 11:59 pm 28 May 2017 (Sunday) via Blackboard

For any assistance with this project, contact MyMathLab homework Help

Data Analysis Using Minitab
(Using Minitab Answer the following) Consider a manufacturing plant that produces high-quality products primarily using skilled labor. They are concerned about defects found in the surface coating for their product and have been exploring potential improvement strategies. Note that each prompt below may require more than one visualization and/or analysis to fully answer.

1. Previous study showed that there is a difference in Quality ratings based on the Team. Considering this, they would like to test four potential factors (Line, Method, Temperature, and Humidity) while controlling for the effect of Team. Using the provided data, create a 2k factorial model by restructuring the Method factor as two, two-level factors and treating Team as a four-level blocked variable. Use Minitab to generate a 25-2 model blocked by replicates and extract the relevant data from the provided dataset to complete the analysis. Discuss the validity, fit, and reliability of the model and interpret the results including addressing any important aliased relationships.
2. Identify the treatment combinations that would be needed to complete the full fold-over for this design and briefly discuss how the fold-over model would help to interpret the results from Part 2. Complete the full fold-over, discuss the validity, fit, and reliability of the model, and interpret the results.
3. Use a general full factorial DOE model to evaluate the original five factors using their defined levels (a mixed-level design). Discuss the validity, fit and reliability of the model and interpret the results.

Option 4: Conduct an Oral History

For this assignment, you will have an opportunity to conduct an oral history with someone to learn about their immigration experience.
Find someone who you think be a good storyteller. You may interview someone you know or who you are related to if you like, but it may be easier to come up with questions for (and ask questions of) a person you don’t know as well. You must select someone willing to have their interview transcribed and published – so be transparent about the assignment and you intentions.

Background research:

You will need to know some basic facts about the country from which they immigrated as well as the time period in which they came to the US, both to create a good list of questions as well as provide a little context for their story, so do some research on dates and events. Use trusted academic sources (reference texts, academic books, academic journals), not Wikipedia, newspapers, magazines, or blogs. You will be citing your sources in a bibliography.

Create a list of interview questions

:
After conducting your background research, create a list of about 15-20 questions. Aim for a few simple questions, with the majority being open-ended questions (i.e., Ones that cannot be answered with simply a “yes”, or “no”).

Conduct and record the Interview

Aim for 20-30 minutes Less and you may not have much work with, more and you may have too much. Too much is good; not enough is bad. If this is someone you have safe access to and thus can interview them in persona, bring a backup method for recording just in case your first one fails. Otherwise, try to use something like Zoom or different software that gives you a comparable “face to face’ experience. If possible, also take some handwritten notes during the interview, recording things that might not otherwise be apparent via audio (such as facial expressions, body language, etc.) – this type of visual information is also important.

Transcribe the Interview:

Type up both your questions and interviewee’s answers word-for-word. It is tedious. It is time-consuming. It is also necessary!

Write the “story” or narrative

Provide a short introduction, briefly explaining who was interviewed and any background information you think is necessary to understand the story (including details about the individual or historical facts). Then, using your interview transcription, tell this immigration story as completely as you can in the interviewee’s own words. Your goal is to crat a narrative that is mostly about the interviewee and their experience, so use a lot of direct quotes from the interview

Entering TWO-WAY Data in SPSS

Statistics and maths anxiety are common and affect people's performance on maths and stats assignments; women, in particular, can lack confidence in mathematics (Field, 2010). Zhang, Schmader, & Hall, (2013) did an intriguing study, in which students completed a maths test in which some put their own name on the test booklet, whereas others were given a booklet that already had either a male or female name on it. Participants in the latter two conditions were told that they would use this other person's name for the purpose of the test. Women who completed the test using a different name performed better than those who completed the test using own name. (There were no such effects for men). The data below are a random subsample of Zhang et al.'s data. Enter them into SPSS and save the files as Zhang (2013) subsample.sav

If you need help entering data in SPSS , then our statistic experts will be ready to facilitate you with that.

Using Standard Normal Table to Find Probability

Qn23.
Provide an appropriate response. Use the Standard Normal Table to find the probability.
Assume that blood pressure readings are normally distributed with mu = 120, and sigma = 8. A blood pressure reading of 145 or more may require medical attention. What percent of people have a blood pressure reading greater than 145?

Possible answers; 11.09%, 0.09%, 99.91%, 6.06%

Qn24.
Seventy-five percent of adults want to live to age 100. You randomly select five adults and ask them whether they want to live to age 100. The random variable represents the number of adults who want to live to age 100. Complete parts (a) through (c) below.

b) Graph the binomial distribution using a histogram and describe its shape.

What is the shape of the histogram?
c) What values of the random variable X would you consider unusual?