Business Council of Australia (BCA)

The Business Council of Australia (BCA) provides a forum for Australian business leaders to
contribute directly to public policy debates. One of the issues that BCA is currently working on
is the debate on gender pay gap at Australian executives. You are a business analyst working in
the Research Department of the BCA. As part of your job requirement, you are asked to
submit a report on the gender pay gap of Chief Executive Officers (CEOs) to your Head of your
Department so that it can be discussed at the next meeting of BCA board of directors.
There are 10 industry sectors within the Australian market. They are Consumer Discretionary,
Consumer Staples, Energy, Financials, Health Care, Industrials, Information Technology,
Materials, Telecommunication Services, and Utilities. To address the requirement of the
business report (below questions), you choose 4 non-industrial sectors that traditionally have
more women representation, i.e. Consumer Discretionary, Consumer Staples, Financials and
Health Care. The information on CEO total compensation and CEO characteristics of all firms
in each industry sector for the year 2017 are collected and stored in the Excel file
(ACCT5008_BR_2018_s1_datafile.xlxs) in the following ways:
Column A: Firm ID
• To describe the ID of each firm in the sample, ranging from Firm 1 to Firm 277
Column B: Industry sector
• There are 4 industry sectors in the sample. They are Consumer Discretionary,
Consumer Staples, Financials and Health Care.
Column C: CEO Total compensation
• Report the total compensation figures for CEO of each firm in the year 2017.

ACCT5008 – Business Report Semester 1, 2018

Page 2 of 5
Column D: CEO with financial background
• Indicate the financial background of the CEO of each company
o Y = CEO has background in the financial accounting area
o N = CEO does not have background in the financial accounting area

There are four questions need to be addressed in the business report:
1. Are there differences in CEO gender and CEO financial accounting background?
2. Is the proportion of female CEOs that have financial accounting background
different from that of male CEOs? How can you calculate the p-value of the test?
Without calculation, can you tell the range of the p-value in this case, explain why?
3. Is CEO total compensation different among the four chosen industry sectors?
4. Is there a gender pay gap, i.e., do male CEOs earn more than female CEOs?

• You should submit your report in the unit Blackboard website. It is located in
Assessments \ Business report. The link is open for submission from Friday 4th May 2018.
• This is the Turnitin assignment, designed to prevent plagiarism. Further information
about Turnitin can be found on the university website:
https://academicintegrity.curtin.edu.au/students/Turnitin_student.cfm

If assignments are not submitted by the due date, a penalty of 10% per calendar day will be
deducted from the assessment mark and after seven (7) days a zero mark will be recorded.

ACCT5008 – Business Report Semester 1, 2018

Page 3 of 5

FUTHER INSTRUCTIONS
• The report covers hypothesis tests from Module 5 to Module 8. However, Module 4
which contains data collection and sampling should be discussed in your report.
• The report should have the following structure: Introduction, Statistical Analyses
(where you perform hypothesis tests for each of the four questions) and Conclusions
(where you summarize the findings and discuss the limitations)

• Your report should also include technique identification and any underlying assumptions
required (with checking for the required assumptions).
o Why do you use a particular technique? Consider the types of data –
quantitative, qualitative or ranked? How many samples? Are these samples
independent?
o What are the underlying assumptions? Have you checked the assumptions?
 If checking for normal distribution, consider to put up the histogram and
discuss the shape.
 If you found it is not normally distributed, keep doing the test with the
underlying assumption, but need to discuss this as one of your
limitations in the overall conclusion.

• The parameter of interests and populations must be clearly defined.
• Checking normal distributions by observing histograms
o Histograms can be obtained from Excel
o Excel automatically produce the histogram with gap (default at 150%). You need
to reduce the gap to 0% (right click to the histogram, then choose Format Data
Series, then reduce the Gap Width to 0%)

• For each of the tests, you need to have a discussion about the significance level of the
test (only consider significance level at 1%, 5% and 10%1)
o If the null hypothesis is rejected, what should be the lowest significance level to
reject the null?

1 For the F-test, only need to consider 2 significance levels: 1% and 5%

ACCT5008 – Business Report Semester 1, 2018

Page 4 of 5

o If the null hypothesis is not rejected, what should be the highest significance
level to accept the null?

• Show all the necessary steps and calculations for your tests.
o This is not a computing assignment, manual calculations must be
presented for all of the above tests
 Formula and manual calculation should be presented in the report
 The critical values of the tests should be obtained from the Appendix B
of the textbook.
 With ANOVA test, you can have SST and SSE figures from Excel
(ANOVA test can be obtained from Data\Data Analysis. An example of
how to perform ANOVA test in Excel will be discussed in the class).
• The rest of ANOVA calculation (MST, MSE, F-stat, rejection
region) should be done manually.

o For descriptive statistics (e.g. mean and standard deviation), Excel calculation is
acceptable, no need to show the formula, just state the calculated figure.

• Please type your report.
o Formulae can be copied from the lecture powerpoint slides.
• Consider Appendices for data and other information to support your calculation.
• The report (including tables, calculations and histograms) must not exceed 16 pages;
marks will be deducted for exceeding the limit. Pages must be correctly numbered
throughout.
• For each question above, perform separate statistical tests to answer the questions. This
assignment should be presented in a professional manner and you need to
demonstrate that considerable thought has gone into the analysis of data.

ACCT5008 – Business Report Semester 1, 2018

Page 5 of 5

• The marking criteria for each of the question should be as follows:

 Technique identification: why should you use a certain technique?
 Define the populations and parameters of interest
 Checking the conditions of the chosen technique: If a certain condition
is not met, you keep doing the test as usual but need to discuss the
limitation in the Conclusions part
 Following 6 steps in the hypothesis testing procedure
 Decision to reject or accept the null hypothesis must be referred to all
3 significance levels, that is, 1%, 5% and 10%.

Mark Allocation:
• The total mark for the assignment is 50 (account for 25% of your final mark)
• Each question from 1) to 4) is worth 10 marks
• 4 marks for presentation
o Your report should be clear for reading, presented in a good format with
separate sections for (original) Introduction, Statistical Analyses and
Conclusions.

• 6 marks for an overall summary of your results, interpretations and any limitations.
o The summary should be an evaluative response of the results of significant
differences found amongst the variables conducted in the tests and any qualifying
statements made about the nature of the testing data used.
o Limitations of the tests should be discussed.

Category:

Description

The Business Council of Australia (BCA) provides a forum for Australian business leaders to
contribute directly to public policy debates. One of the issues that BCA is currently working on
is the debate on gender pay gap at Australian executives. You are a business analyst working in
the Research Department of the BCA. As part of your job requirement, you are asked to
submit a report on the gender pay gap of Chief Executive Officers (CEOs) to your Head of your
Department so that it can be discussed at the next meeting of BCA board of directors.
There are 10 industry sectors within the Australian market. They are Consumer Discretionary,
Consumer Staples, Energy, Financials, Health Care, Industrials, Information Technology,
Materials, Telecommunication Services, and Utilities. To address the requirement of the
business report (below questions), you choose 4 non-industrial sectors that traditionally have
more women representation, i.e. Consumer Discretionary, Consumer Staples, Financials and
Health Care. The information on CEO total compensation and CEO characteristics of all firms
in each industry sector for the year 2017 are collected and stored in the Excel file
(ACCT5008_BR_2018_s1_datafile.xlxs) in the following ways:
Column A: Firm ID
• To describe the ID of each firm in the sample, ranging from Firm 1 to Firm 277
Column B: Industry sector
• There are 4 industry sectors in the sample. They are Consumer Discretionary,
Consumer Staples, Financials and Health Care.
Column C: CEO Total compensation
• Report the total compensation figures for CEO of each firm in the year 2017.

ACCT5008 – Business Report Semester 1, 2018

Page 2 of 5
Column D: CEO with financial background
• Indicate the financial background of the CEO of each company
o Y = CEO has background in the financial accounting area
o N = CEO does not have background in the financial accounting area

There are four questions need to be addressed in the business report:
1. Are there differences in CEO gender and CEO financial accounting background?
2. Is the proportion of female CEOs that have financial accounting background
different from that of male CEOs? How can you calculate the p-value of the test?
Without calculation, can you tell the range of the p-value in this case, explain why?
3. Is CEO total compensation different among the four chosen industry sectors?
4. Is there a gender pay gap, i.e., do male CEOs earn more than female CEOs?

• You should submit your report in the unit Blackboard website. It is located in
Assessments \ Business report. The link is open for submission from Friday 4th May 2018.
• This is the Turnitin assignment, designed to prevent plagiarism. Further information
about Turnitin can be found on the university website:
https://academicintegrity.curtin.edu.au/students/Turnitin_student.cfm

If assignments are not submitted by the due date, a penalty of 10% per calendar day will be
deducted from the assessment mark and after seven (7) days a zero mark will be recorded.

ACCT5008 – Business Report Semester 1, 2018

Page 3 of 5

FUTHER INSTRUCTIONS
• The report covers hypothesis tests from Module 5 to Module 8. However, Module 4
which contains data collection and sampling should be discussed in your report.
• The report should have the following structure: Introduction, Statistical Analyses
(where you perform hypothesis tests for each of the four questions) and Conclusions
(where you summarize the findings and discuss the limitations)

• Your report should also include technique identification and any underlying assumptions
required (with checking for the required assumptions).
o Why do you use a particular technique? Consider the types of data –
quantitative, qualitative or ranked? How many samples? Are these samples
independent?
o What are the underlying assumptions? Have you checked the assumptions?
 If checking for normal distribution, consider to put up the histogram and
discuss the shape.
 If you found it is not normally distributed, keep doing the test with the
underlying assumption, but need to discuss this as one of your
limitations in the overall conclusion.

• The parameter of interests and populations must be clearly defined.
• Checking normal distributions by observing histograms
o Histograms can be obtained from Excel
o Excel automatically produce the histogram with gap (default at 150%). You need
to reduce the gap to 0% (right click to the histogram, then choose Format Data
Series, then reduce the Gap Width to 0%)

• For each of the tests, you need to have a discussion about the significance level of the
test (only consider significance level at 1%, 5% and 10%1)
o If the null hypothesis is rejected, what should be the lowest significance level to
reject the null?

1 For the F-test, only need to consider 2 significance levels: 1% and 5%

ACCT5008 – Business Report Semester 1, 2018

Page 4 of 5

o If the null hypothesis is not rejected, what should be the highest significance
level to accept the null?

• Show all the necessary steps and calculations for your tests.
o This is not a computing assignment, manual calculations must be
presented for all of the above tests
 Formula and manual calculation should be presented in the report
 The critical values of the tests should be obtained from the Appendix B
of the textbook.
 With ANOVA test, you can have SST and SSE figures from Excel
(ANOVA test can be obtained from Data\Data Analysis. An example of
how to perform ANOVA test in Excel will be discussed in the class).
• The rest of ANOVA calculation (MST, MSE, F-stat, rejection
region) should be done manually.

o For descriptive statistics (e.g. mean and standard deviation), Excel calculation is
acceptable, no need to show the formula, just state the calculated figure.

• Please type your report.
o Formulae can be copied from the lecture powerpoint slides.
• Consider Appendices for data and other information to support your calculation.
• The report (including tables, calculations and histograms) must not exceed 16 pages;
marks will be deducted for exceeding the limit. Pages must be correctly numbered
throughout.
• For each question above, perform separate statistical tests to answer the questions. This
assignment should be presented in a professional manner and you need to
demonstrate that considerable thought has gone into the analysis of data.

ACCT5008 – Business Report Semester 1, 2018

Page 5 of 5

• The marking criteria for each of the question should be as follows:

 Technique identification: why should you use a certain technique?
 Define the populations and parameters of interest
 Checking the conditions of the chosen technique: If a certain condition
is not met, you keep doing the test as usual but need to discuss the
limitation in the Conclusions part
 Following 6 steps in the hypothesis testing procedure
 Decision to reject or accept the null hypothesis must be referred to all
3 significance levels, that is, 1%, 5% and 10%.

Mark Allocation:
• The total mark for the assignment is 50 (account for 25% of your final mark)
• Each question from 1) to 4) is worth 10 marks
• 4 marks for presentation
o Your report should be clear for reading, presented in a good format with
separate sections for (original) Introduction, Statistical Analyses and
Conclusions.

• 6 marks for an overall summary of your results, interpretations and any limitations.
o The summary should be an evaluative response of the results of significant
differences found amongst the variables conducted in the tests and any qualifying
statements made about the nature of the testing data used.
o Limitations of the tests should be discussed.