\$20 Bonus + 25% OFF

# BSB123 Data Analysis

0 Download3 Pages / 607 Words Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

## Question:

1. (a) Construct a side-by-side boxplot of GPA for male and female science students, and compare their distributions (central location, spread and skewness).

(b) Recent research showed that in mathematics “on average for 15-year-old Australian students, females achieved at a significantly lower level than male students” (p.2, Buckley 2016)[1] . However, there is also research evidence that, “despite the stereotype that boys do better in math and science, girls have made higher grades than boys throughout their school years for nearly a century” (APA 2014)[2]. So it is not certain if one gender performs better than the other at university. Test if there is any difference in GPA on average between male and female students in the Science Department at the level of significance of 5%.

1. Education literature has shown that students with higher socio-economic status (SES) tend to have stronger academic achievement.
• Test at the level of significance of 5% whether students whose parents have a post-graduate qualification have a higher GPA than students whose parents have only an undergraduate qualification.
• Test at the level of significance of 5% if students whose parents have an undergraduate qualification have a higher GPA than students whose parents have only a secondary or below qualification.

Note: When conducting a test in Q1 and Q2, you should discuss briefly whether it is a one or two tail test, the test statistics, any assumptions made and draw a conclusion based on Excel output.

You plan to develop a regression model to further investigate how various factors influence students’ GPA in the Science Department.

1. 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 direction and strength of linear associations between GPA and other quantitative variables (viz. HS_SCI, HS_ENG, HS_MATH and ATAR).
2. Based on the correlation matrix obtained in Question 3, would you say that:
• HS_SCI is a predictor of GPA
• HS_ENG is a predictor of GP
• HS_MATH is a predictor of GPA
• ATAR is a predictor of GPA

Conduct simple regression to support your answers to questions (i) to (iv).

1. You conduct a stepwise regression according to the following procedure:

Step 1: HS_SCI only

Step 2: HS_SCI and HS_ENG

Step 3: HS_SCI, HS_ENG and HS_MATH

Step 4: HS_SCI, HS_ENG, HS_MATH and PARENT EDUC

Step 5: HS_SCI, HS_ENG and HS_MATH, PARENT EDUC AND GENDER

Step 6: HS_SCI, HS_ENG and HS_MATH, PARENT EDUC, GENDER and ATAR

Present the regression output for each of the six steps.

Choice of reference category: It is recommended that you choose U (undergraduate education) as the reference category for the categorical variable: PARENT EDUC.

1. For each of the independent variables contained in the regression model in Step 5, fully interpret the regression (slope) coefficients and comment on their statistical significance.

In discussing statistical significance of a regression coefficient, you have to justify your choice of a one or two tail test.

1. In stepwise regression Step 6 you noticed that the regression coefficient of ATAR is negative (!). Does this result surprise you, given the correlation of ATAR and GPA? Why/Why not? Does the inclusion of ATAR improve overall model fit? Discuss fully.

As the chief project officer, you are asked to write a summary report (300 words) detailing all the findings from your data analysis. The issues you can discuss in your report should include (but are not limited to) the following:

• There has been research evidence that SES and academic achievement are closely related[3]. Based on your analysis in this study, critically examine education researchers’ claim that student SES has an impact on their academic performance.
• Do you think there is any gender difference in academic achievement of Science students?
• In stepwise regression from Steps 1 to 3 where HS_SCI, HS_ENG and HS_MATH are added to the model progressively, observe the changes to the regression (slope) coefficient of the independent variable, HS_SCI. Do you think HS_SCI is a good predictor of students’ GPA?
• Is ATAR a good predictor of GPA? Should ATAR be included in the model?
• Based on this study, what is the final model you would recommend to the Head of the Science Department?
• Comment on the overall adequacy of the final model.
• Are there any other important factors influencing academic performance that were not included in this study? What are they.

### Cite This Work

My Assignment Help (2021) Data Analysis [Online]. Available from: https://myassignmenthelp.com/free-samples/bsb123-data-analysis/statistical-significance.html
[Accessed 22 April 2021].

My Assignment Help. 'Data Analysis' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/bsb123-data-analysis/statistical-significance.html> accessed 22 April 2021.

My Assignment Help. Data Analysis [Internet]. My Assignment Help. 2021 [cited 22 April 2021]. Available from: https://myassignmenthelp.com/free-samples/bsb123-data-analysis/statistical-significance.html.

### Latest Database Samples

#### CSE 283 Data Communications And Networks

Answer A USB Type-C connection is a port which is available on the MacBook which has mandatory headphone jack; it is responsible for taking care of power, data transfers and display output. Thunderbolt was developed with a promise of leaving behind the USB ports. Because according to the developers of Intel and Apple it was must fatter and the data transfer rate was faster than USBs (Intel, 2015). Along with this, it helps users to connect to ...

#### ITECH3224 WWW Technology

Answer: The database given was normalized to achieve a better database. Normalization of the database involved following the following steps; Ensuring no entity has any repeating groups to normalize the relations to 1NF. Ensuring all entities achieved as a result of normalization to 1NF have no partial dependencies thus normalizing them to 2NF. This involves making sure that an entity has only one candidate key that the other keys depend o...

#### CSC72001 Database Systems

Answer:   The database should be able to store the details of all the courses in the system and each course in the system should be identified with a unique identity that would be helpful in distinguishing the different entries in the tables. The database should be able to store the details of all the students each data should be identified by a unique identification key. The database should be able to store the details of the enro...

#### ENG4195 Systems Analysis And Design

Answer: Part 1: Use Case Realisation for the ‘Record New Tour’ Use Case 1.1 Analysis Class Diagram:  In the paradigm of software engineering, the class diagram is a part of UML that represents the static structure of an application. The class diagram, as the name suggests, represents the classes of the application. These classes has attributes and operations. The class diagram are mainly used for describing the element...

#### ICT701 Relational Database Systems

Answer: Assumption: - A APPLIED_STAFF has many QUALIFICATION_DETAIL and a QUALIFICATION_DETAIL is related to many APPLIED_STAFF. Here many too many relationships occur. So I create a new table that is STAFF_QUALIFICATION. Here a staff has one or many STAFF_QUALIFICATION and each STAFF_QUALIFICATION is related to one and only one APPLIED_STAFF. A qualification is related to one or many STAFF_QUALIFICATION and each STAFF_QUALIFICATION is ...

Next

### Save Time & improve Grade

Just share requirement and get customized Solution.

Orders

Overall Rating

Experts

### Our Amazing Features

#### On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

#### Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

#### 24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

#### Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

#### Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

### Our Experts

5/5

453 Order Completed

98% Response Time

### Howard Asuncion

#### London, United Kingdom

5/5

1592 Order Completed

96% Response Time

### Jane Sima

#### Singapore, Singapore

5/5

1692 Order Completed

98% Response Time

### Alfred Dodd

#### Wellington, New Zealand

4/5

1309 Order Completed

100% Response Time

### FREE Tools

#### Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

#### Essay Typer

Get different kinds of essays typed in minutes with clicks.

#### Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

#### Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

## Refer Just 5 Friends to Earn More than \$2000

1

1

1

### Live Review

Our Mission Client Satisfaction

Not Graded yet. The assignment was proper and exactly as required. It was provided on time and thank you and it was a great experience.

Australia

Australia

#### User Id: 233928 - 21 Apr 2021

Australia

Nice work and deliver on time. The work is professional and plagiarism free. Thank you.

Australia

## Order on the go!

Say hello to our new app