Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

BSB123 : Data Analysis

tag 0 Download 12 Pages / 2,799 Words tag 09-10-2020

Question:

Task 1 (Boxplots and t-tests)

 

1).(a) Construct separateboxplots of salaries for male and female academics, and compare their distributions (central location, spread and skewness).

(b) Test if male academics on average earn more than their female counterparts at 1%.

 

2.(a) Considering assistant professors only, test if male assistant professors on average earn more than female assistant professors at 1%.

(b) Considering associate professors only, test if male associate professors on average earn more than female associate professors at 1%.

(c) Considering professors only, test if male professors on average earn more than female professors at 1%.

 

Task 2 (Regression Analysis)

You plan to develop a regression model to investigate how various factors influence academic salaries.

3).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 associations between Salary and other quantitative variables.

 

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

Step 1: Gender only

Step 2: Gender and School

Step 3: Gender, School and Rank

Step 4: Gender, School, Rank and Years of Service

Step 5: Gender, School, Rank, Years of Service and Age

Choice of reference variable: It is recommended that you choose Health and ASSO as the reference variables for the categorical variables: School and Rank.

Present the regression output for each of the five steps.

 

5).Based on the regression output obtained in Step 4, answer the following:

a).Which summary measure in the regression output is used to assess the overall adequacy of the model? Comment on the overall adequacy of the model obtained in Step 4.

b). For eachof the four independent variables, fully interpret the regression coefficients and comment on their statistical significance. (In discussing statistical significance of a regression coefficient, you have to justify your choice of one or two tail test.)

 

6).Based on the correlation between Age and Salary, did you expect Age to have a statistically significant effect on Salary? In Step 5, is the statistical significance of the regression coefficient of Age as expected? Discuss fully.

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.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 12 pages

Cite This Work

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

My Assignment Help. (2020). BSB123 : Data Analysis. Retrieved from https://myassignmenthelp.com/free-samples/bsb123-data-analysis.

"BSB123 : Data Analysis." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/bsb123-data-analysis.

My Assignment Help (2020) BSB123 : Data Analysis [Online]. Available from: https://myassignmenthelp.com/free-samples/bsb123-data-analysis
[Accessed 27 January 2023].

My Assignment Help. 'BSB123 : Data Analysis' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/bsb123-data-analysis> accessed 27 January 2023.

My Assignment Help. BSB123 : Data Analysis [Internet]. My Assignment Help. 2020 [cited 27 January 2023]. Available from: https://myassignmenthelp.com/free-samples/bsb123-data-analysis.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
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

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.