$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

BSB123 Data Analysis

tag 0 Download7 Pages / 1,583 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT


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

2.Education literature has shown that students with higher socio-economic status (SES) tend to have stronger academic achievement.

(a)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.        

(b)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.

Task 2 (Regression Analysis)

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

4.Based on the correlation matrix obtained in Question 3, would you say that:

(i)HS_SCI is a predictor of GPA?

(ii)HS_ENG is a predictor of GPA?

(iii)HS_MATH is a predictor of GPA?

(iv)ATAR is a predictor of GPA?

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

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

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.      

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

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

Task 3 (Summary Report)

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[ For example, read: “10 Theories On The Relationship Between Socioeconomic Status & Academic Achievement” (2018)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?
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 7 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help (2021) Data Analysis [Online]. Available from:
[Accessed 07 March 2021].

My Assignment Help. 'Data Analysis' (My Assignment Help, 2021) <> accessed 07 March 2021.

My Assignment Help. Data Analysis [Internet]. My Assignment Help. 2021 [cited 07 March 2021]. Available from:

Are you looking for a perfect rhetorical analysis for the essay paper? Get in touch with for custom writing assistance on your paper. We assure to help you boost your grade. We have our own essay generator tool where you can generate an essay paper instantly at zero cost. However, for quality support on a huge range of essay topics, it is better to hire our PhD qualified experts at a nominal price.

Latest Management Samples

3212HSL Marketing And Sales For Tourism And Hotels

Download : 0 | Pages : 4

Answer: 5 Nights at the Four Star Hotel, Koh Samui for a Honeymooning Couple As stated under KohSamuiGeography (2010) the geographical location of koh Samui Island in Thailand enables the island to be a perfect tourism destination. Koh Samui  Island is geographically located on the South of china sea. Around it are other sixty islands along the coast of China sea. Despite the shallowness of the island, you will find a lot of commerc...

Read More arrow

HUM150 Introduction To Film Studies

Download : 0 | Pages : 7

Answer: A serial killer is a person who commits more than one or at least three murders over a month or a period of time with a break or a cool off in between the murders. Serial killers can be driven by different motives to kill according to their interests, state of mind, anger, financial gain or attention seeking. According to (Aken 4) serial murderers cannot be easily spotted, however, people are continuously scared and fascinated by the c...

Read More arrow Tags: United States Independence Management University of New South Wales 

FILM1001 Hollywood Art Industry Entertainment

Download : 0 | Pages : 6

Answer: Introduce the industry you are focusing on Entertainment industry also referred as show biz is a part of tertiary sector that connotes to all aspects of entertainment like music, art, theatre, film, radio and television. According to Kevin Westcott, the leader of US Media and Entertainment of Deloitte Consultancy LLP, content streaming and videos will bring revolutionary changes in the entertainment industry in 2018. Due to the increa...

Read More arrow

MGMT20140 Design Thinking For Managers

Download : 0 | Page : 1

Answer: Design mindset in the context of innovation According to Einsten, it is not possible to resolve the solution with same kind of thinking (Liedtka, 2015). Design mindset is the strategy that able  to signify and improve the tasks and the processes of work for needed outcomes (Dam, 2018). Process of Design Thinking Integration of Design Thinking: Benefits of Design Thinking Helps organizations to become more innovative (Johansson...

Read More arrow

MGT502 Organizational Behavior

Download : 0 | Pages : 11

Answer:  Perception  Perception is a method of collecting, organizing and interpreting the overall sensory impressions in context of the world. It has been seen that people give meaning by focusing on the perception. In the workplace, perception plays a great role as it gives impact on the individuals. Perception is related with the subjective judgment of the individual. For example: there are many employees in the workplace. Some o...

Read More arrow

Save Time & improve Grade

Just share requirement and get customized Solution.

We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here




Overall Rating



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, 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

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

752 Order Completed

100% Response Time

Hugh Cleave

Masters in Human Resource Management (MMgt, HRM)

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

285 Order Completed

99% Response Time

Eugene Baranowski

MBA in Supply Chain

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

453 Order Completed

98% Response Time

Howard Asuncion

LLM in Criminal Law

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2279 Order Completed

97% Response Time

Zachary Perez

PhD in Computer Science and Information System

Washington, United States

Hire Me

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.


GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.


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

Check your estimated earning as per your ability




Your Approx Earning

Live Review

Our Mission Client Satisfaction

It was delivered in time and I have had a good mark. I recommend this site and I am getting more assignments from them


User Id: 561404 - 06 Mar 2021


student rating student rating student rating student rating student rating

Awesome! If you could please provide me with accessible links for references because the ones were provided need to create an account. Regards


User Id: 614495 - 06 Mar 2021


student rating student rating student rating student rating student rating

Within a short time, the expert manages to complete the assignment beautifully! I scored well and I am very happy with it. Thanks


User Id: 567078 - 06 Mar 2021


student rating student rating student rating student rating student rating

It's amazing solution and still I will apply it in university system, hopefully it's got high score Thanks


User Id: 624294 - 06 Mar 2021


student rating student rating student rating student rating student rating
callback request mobile
Have any Query?