Scenario Questions

Anonymous
timer Asked: Nov 5th, 2016

Question description

Please refer to Attached File.

MBA 6300 online Homework Assignment #2 - Regression Models Instructions: After the student calculates the answers to this homework he/she must submit the answers by placing them in the Assignment # _ Submittal Link in Bb by midnight of the date shown in the Course Roadmap and Syllabus. The Instructor does not allow late submissions therefore a score of zero (0) will be recorded for the assignment if submitted after midnight Eastern Time of the due date. Solutions for the assignment will be released in Bb the morning after the due date for access by students. Total points for the assignment is 205 points. Note: There is no partial credit given; either the answer is correct or incorrect. Instructions for Homework Assignment: Use Excel to construct a spreadsheet for each of the four models (Scenario 1-7) then answer Question 40 based upon your calculations. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Birth Length (in) of Newborn Infants 22.0 23.5 24.0 24.7 18.7 22.1 23.0 24.3 22.3 22.1 20.3 24.2 21.9 23.4 26.1 22.5 21.1 22.6 21.9 19.6 19.6 22.5 21.6 24.1 22.8 Height of Mother (in) 61 64 64 59 59 64 62 64 66 65 63 64 65 62 64 63 61 63 63 60 61 64 65 66 63 Height of Father (in) 70 72 74 71 60 62 73 76 74 72 71 76 72 78 77 72 73 69 68 61 64 66 73 72 68 Dr. Mike’s MBA 6300 HW# 2 Page 1 Birth Weight of Nearest Sibling (lb) 6.5 6.1 7.3 5.8 5.9 6.7 6.8 7.2 5.9 6.1 6 7.4 6.2 6.7 7.1 6.8 6.5 6.7 6.2 5.9 5.8 6.2 6.5 7.1 7.1 After you have submitted your answers in the Assignment #_ Submission Link, upload the Excel file (provided you by the Instructor) containing your answers and calculations into the Home Work #_ Supporting Documentation Submission link prior to the due date and time. As stated in the syllabus a score of zero will be awarded for the assignment if this Excel file is not submitted. Scenario: As a researcher studying how inherited traits influence newborn babies. You have gathered genetic data on newborns’, parents and sibling as shown in the table above. Scenario 1: Perform a simple linear regression analysis to predict a newborn’s birth length (in inches) using the father’s height as a predictor variable. Conduct your analysis using a 95% level of confidence. Question 1: Does the regression model confirm a correlation between the dependent variable and the independent variable? How do you know? (5 points) Question 2: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points) Question 3: Is the statistical significance of the linear relationship between the dependent and independent variable acceptable for a 95% level of confidence? How do you know? (5 points) Question 4: What is the regression equation for the model? (5 points) Question 5: What is the predicted birth length of a newborn whose father is 75.3 inches tall? (5 points) Scenario 2: Perform a simple linear regression analysis to predict a newborn’s birth length (in inches) using the mother’s height as a predictor variable. Conduct your analysis using a 95% level of confidence. Question 6: Does the regression model confirm a correlation between the dependent variable and the independent variable? How do you know? (5 points) Question 7: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points) Question 8: Is the statistical significance of the linear relationship between the dependent and independent variable acceptable for a 95% level of confidence? How do you know? Question 9: What is the regression equation for the model? (5 points) Question 10: What is the predicted birth length of a newborn whose mother is 61.5 inches tall? (5 points) Scenario 3: Perform a simple linear regression analysis to predict a newborn’s birth length (in inches) using the nearest (in age) sibling’s birth weight as a predictor variable. Conduct your analysis using a 95% level of confidence. Question 11: Does the regression model confirm a correlation between the dependent variable and the independent variable? How do you know? (5 points) Question 12: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points) Question 13: Is the statistical significance of the linear relationship between the dependent and independent variable acceptable for a 95% level of confidence? How do you know? (5 points) Question 14: What is the regression equation for the model? (5 points) Question 15: What is the predicted birth length of a newborn whose nearest sibling weighs 7.0 lbs.? (5 points) Dr. Mike’s MBA 6300 HW# 2 Page 2 Scenario 4: Perform a multiple linear regression analysis to predict a newborn’s birth length (in inches) using both the mother’s height (X1) and the father’s height (X2) as the predictor variables. Conduct your analysis using a 95% level of confidence. Question 16: Does the regression model confirm a correlation between the dependent variable and the independent variables? How do you know? (5 points) Question 17: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points) Question 18: What is the Critical Value of F associated with this regression model? Question 19: What is the regression equation for the model? (5 points) Question 20: Are both independent variables in this model significant? How do you know? (5 points) Question 21: What is the predicted birth length of a newborn whose mother is 59.6 inches tall and the father’s height of 75.1 inches? (5 points) Scenario 5: Perform a multiple linear regression analysis to predict a newborn’s birth length (in inches) using the father’s height (X1) and the birth weight of the nearest sibling (X2) as the predictor variables. Conduct your analysis using a 95% level of confidence. Question 22: Does the regression model confirm a correlation between the dependent variable and the independent variables? How do you know? (5 points) Question 23: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points) Question 24: What is the value of F associated with this regression model? (5 points) Question 25: What is the regression equation for the model? (5 points) Question 26: Are both independent variables in this model significant? How do you know? (5 points) Question 27: What is the predicted birth length of a newborn whose father’s height of 73.6 inches tall and the nearest sibling’s birth weight is 6.25 lbs? (5 points) Dr. Mike’s MBA 6300 HW# 2 Page 3 Scenario 6: Perform a multiple linear regression analysis to predict a newborn’s birth length (in inches) using the mother’s height (X1), and the birth weight of the nearest sibling (X2) as the predictor variables. Conduct your analysis using a 95% level of confidence. Question 28: Does the regression model confirm a correlation between the dependent variable and the independent variables? How do you know? (5 points) Question 29: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points) Question 30: What is the value of F associated with this regression model? (5 points) Question 31: What is the regression equation for the model? (5 points) Question 32: Are both of the independent variables in this model significant? How do you know? (5 points) Question 33: What is the predicted birth length of a newborn whose mother’s height is 58.5 inches and the nearest sibling’s birth weight is 6.9 lbs? (5 points) Scenario 7: Perform a multiple linear regression analysis to predict a newborn’s birth length (in inches) using the mother’s height (X1), the father’s height (X2) and the birth weight of the nearest sibling (X3) as the predictor variables. Conduct your analysis using a 95% level of confidence. Question 34: Does the regression model confirm a correlation between the dependent variable and the independent variables? How do you know? (5 points) Question 35: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points) Question 36: What is the value of F associated with this regression model? (5 points) Question 37: What is the regression equation for the model? (5 points) Question 38: Are all three independent variables in this model significant? How do you know? (5 points) Question 39: What is the predicted birth length of a newborn whose mother’s height is 58.5 inches, a father’s height of 71.6 inches and the nearest sibling’s birth weight is 6.4 lbs? (5 points) Question 40: Which of the seven regression models is the preferred model, and why? This is not an “opinion” answer; please reference your data to validate your answer. (10 points) The following table may help you organize your answers. Scenario 1 2 3 4 5 6 7 r r2 Adj. r2 Sig. F p-value Dr. Mike’s MBA 6300 HW# 2 Page 4 p-value p-value

Tutor Answer

(Top Tutor) Studypool Tutor
School: UC Berkeley
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors