+61480015851
BSB123: Statistics - Data Analysis - Histogram, Boxplot and T-tests - Regression Analysis - Research Report Assignment Help
Download Solution
Order New Solution
Subject Code: BSB123
Task 1 (Histogram, Boxplot and t-tests)
(a) Construct a side-by-side boxplot of Result for male and female students, and compare their distributions (central location, spread and skewness).
(b) Test if there is any difference in Results on average between male and female students at the 5% level of significance
(c) One would expect that students that are involved in a romantic relationship may not perform as well as their peers. Test at the level of significance of 5% if students who are involved in a romantic relationship have a lower result than the students who are not.
Task 2 (Regression Analysis)
You plan to develop a regression model to further investigate how various factors influence students’ Result.
(a) Before you conduct any regression analysis, you use Excel to construct a correlation matrix of all the quantitative variables in the dataset. Based on the correlation matrix, comment briefly on the linear associations between Result and other quantitative variables (viz. Age, Lectures and Tutorials) and whether these variables are a predictor of result.
(b) Conduct a simple regression on:
(i) Age is a predictor of Result?
(ii) Lectures is a predictor of Result?
(iii) Tutorial is a predictor of Result? Does this support your answers to Task 2 (a)?
(c) So that the categorical variables Gender, Medu and Relationship can be used in the regression, create appropriate dummy variables. Note that we use one less dummy than the number of categories for any categorical variable.
(d) You conduct a stepwise regression according to the following procedure: Step 1: Gender(F=1), Age, Medu(U=1), Medu(PG=1), Relationship (Yes=1) and Lectures Step 2: Gender(F=1), Age, Medu(U=1), Medu(PG=1), Relationship (Yes=1), Lectures and Tutorials Present the regression output for both steps.
(e) For each of the independent variables contained in the regression model in Step 1, test their statistical significance. In testing statistical significance of a regression coefficient, you have to justify your choice of one or two-tail test.
Task 3 (Summary Report)
Given your results you are asked to write a summary report detailing all the findings from your data analysis. The issues you can discuss may include (but are not limited to):
• Do you think there is any gender difference in the academic achievement of the students?
• Is there evidence that being in a romantic relationship affects results?
• In Step 1 regression interpret how each variable is related to Results and report its significance.
• Is there a variable whose result is different to what you would generally have expected?
• Based on this study, what is the final model you would recommend?
• Based on your final model, predict the Result of a female student who is 18, whose mother has post-graduate qualifications, is not involved in a romantic relationship and attended all classes.
• Are there any variables that influence academic performance that are omitted in this study?
Data Analysis - Research Report Assignment Help
Assignment Task: BSB123 A researcher is interested in the factors that may explain the academic achievement of first year Business students. With the university’s support, the researcher developed a standardised test that was to be undertaken by a random sample of students. The test contained questions related to the core business units of accountancy, marketing, management and statistics, and was administered towards the end of the each students first year of study. In addition to answering the test, the students were asked questions on their gender, age, mother’s highest level of education, whether the student was currently in a ‘romantic’ relationship. Students were also asked to report the number of instances where they did not attend either a lecture or a tutorial. In total, 649 students sat the test and a portion of the dataset1,2 is presented below:
Task 1 (Histogram, Boxplot and t-tests)
(a) Construct a side-by-side boxplot of Result for male and female students, and compare their distributions (central location, spread and skewness).
(b) Test if there is any difference in Results on average between male and female students at the 5% level of significance
(c) One would expect that students that are involved in a romantic relationship may not perform as well as their peers. Test at the level of significance of 5% if students who are involved in a romantic relationship have a lower result than the students who are not.
Task 2 (Regression Analysis)
You plan to develop a regression model to further investigate how various factors influence students’ Result.
(a) Before you conduct any regression analysis, you use Excel to construct a correlation matrix of all the quantitative variables in the dataset. Based on the correlation matrix, comment briefly on the linear associations between Result and other quantitative variables (viz. Age, Lectures and Tutorials) and whether these variables are a predictor of result.
(b) Conduct a simple regression on:
(i) Age is a predictor of Result?
(ii) Lectures is a predictor of Result?
(iii) Tutorial is a predictor of Result? Does this support your answers to Task 2 (a)?
(c) So that the categorical variables Gender, Medu and Relationship can be used in the regression, create appropriate dummy variables. Note that we use one less dummy than the number of categories for any categorical variable.
(d) You conduct a stepwise regression according to the following procedure: Step 1: Gender(F=1), Age, Medu(U=1), Medu(PG=1), Relationship (Yes=1) and Lectures Step 2: Gender(F=1), Age, Medu(U=1), Medu(PG=1), Relationship (Yes=1), Lectures and Tutorials Present the regression output for both steps.
(e) For each of the independent variables contained in the regression model in Step 1, test their statistical significance. In testing statistical significance of a regression coefficient, you have to justify your choice of one or two-tail test.
Task 3 (Summary Report)
Given your results you are asked to write a summary report detailing all the findings from your data analysis. The issues you can discuss may include (but are not limited to):
• Do you think there is any gender difference in the academic achievement of the students?
• Is there evidence that being in a romantic relationship affects results?
• In Step 1 regression interpret how each variable is related to Results and report its significance.
• Is there a variable whose result is different to what you would generally have expected?
• Based on this study, what is the final model you would recommend?
• Based on your final model, predict the Result of a female student who is 18, whose mother has post-graduate qualifications, is not involved in a romantic relationship and attended all classes.
• Are there any variables that influence academic performance that are omitted in this study?
This Statistics Assignment has been solved by our Statistics experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.