CR046_ ECON1030_A3_report+data analysis

Assessment 3: Individual Written Report2022/10/19 11’21
Assessment 3: Individual Written Report
Start Assignment
Due Wednesday by 23:59
Points 40
Submitting a text entry box or a file upload
Assessment Details:
Given a data set that replicates the industry/world, students will be required to perform a wide range of
statistical analysis covered in the course, with focus on the analysis of relationships between variables.
The response to the assignment must be provided in the form of a business report with no more than 10
pages (excluding cover page). The structure of your business report must include:
1. A Title
2. An Executive Summary
3. An Introduction
4. Analysis
5. Conclusions
Group Project Data:
Individual Assignment Instructions – 2022.docx
(h!ps://rmit.instructure.com/courses/91574/files/27370757/download?download_frd=1)
IndividualBusStats.xlsx
Report Template.docx
(h!ps://rmit.instructure.com/courses/91574/files/27370826/download?download_frd=1)
(h!ps://rmit.instructure.com/courses/91574/files/25929161/download?download_frd=1)
HE_Assignment_cover_sheet.docx
(h!ps://rmit.instructure.com/courses/91574/files/25929163/download?
download_frd=1)
Submission:
The assignment is due on Wednesday 26 October 2022 at 23:59 PM (Melbourne Time). Hard copies will
not be accepted. Your work should be submitted via Canvas using Turnitin.
You can submit the documents separately (cover sheet, Report, Excel), or you can combine the coversheet
and the word document into one single document, and submit together with the Excel file.
Applying for extension: If you are seeking an extension of seven (7) calendar days or less (from the original
due date), you must apply and submit this form by at least one (1) working day before the assessment
deadline using the following online form (https://forms.office.com/Pages/ResponsePage.aspx?
id=cTYy0b7NF0S01L2yS1Exax335T8jyWlNql7Rw3WTZCNUQzdPWFBRT0E4TlJYSklaQUpaNDRHMDY4Uy4u) . In this
instance, the assessment task is due on Wednesday 26 October 2022 by 23:59 PM therefore any assessment
https://rmit.instructure.com/courses/91574/assignments/728938
⻚页码：1/4
Assessment 3: Individual Written Report
2022/10/19 11’21
extensions must be submitted by 23:59 PM Tuesday 25 October 2022. If you need an extension of time
beyond seven (7) days or if you have missed the one (1) working day requirement to submit this request, you
should apply for SPECIAL CONSIDERATION https://www.rmit.edu.au/students/studentessentials/assessment-and-results/special-consideration (https://www.rmit.edu.au/students/studentessentials/assessment-and-results/special-consideration) . No exceptions are possible to this requirement. If you
apply to the Special Consideration Unit please advise them that you are not eligible for an extension via your
Course Coordinator and the reason (application date has passed, applying for more than 7 days, or extension
application was not granted). Eligibility is focused on unexpected circumstances that have significantly
impacted your ability to complete the assessment task by the prescribed date. You can only apply for
extension if you satisfy the eligibility criteria. Your application will be strengthened by documentary evidence of
your circumstances.
Late work will be penalised using RMIT protocols as noted in the ECON1030 course guide.
I declare that in submitting all work for this assessment I have read, understood and agree to the content and
expectations of the Assessment declaration. (https://www.rmit.edu.au/students/student-essentials/assessmentand-exams/assessment/assessment-declaration)
Common Queries on Assignment
General:
What are the relevant lecture topics covered in the final assessment?
This assessment focuses on the relationship between variables. Thus, the relevant lecture topics are: the 2nd
half of Topic 9, Topic 10 and Topic 11. You also need skills you learned in Topic 1.
Before starting with the Excel:
There are two worksheets (public and private) in the dataset, you need to first create a dummy variable for
public (1) and private (0) in the new column and combine these two worksheets into a new worksheet;
There are three categorical variables (gender, degree, married) in the dataset, you need to create dummy
variables “0” and “1” for each of the variable. Please view the video for how to create dummy variable below:
0:00 / 13:20
Do I need to format a number on Excel that appears in exponential notation?
You don’t have to, but you are more likely to interpret the exponential notation correctly if you convert it to a
number.
https://rmit.instructure.com/courses/91574/assignments/728938
⻚页码：2/4
Assessment 3: Individual Written Report
2022/10/19 11’21
To convert an exponential notation to a number:
Select the cell with the numbers and right-click on them and click Format Cells
Go to the Number tab and click ok.
For example,
2.00E+05 =2×10^5=200000
2.00E-05
=2×10^(-5)= 0.00002 ~ 0
Do I need to remove outliers from the dataset?
No, you will not remove outliers.
How do I read t-value from Table E.3/E.4 if the degree of freedom (df) is larger than 120?
For any df>120, read t-values from the last row eg ∞.
Rubric
Rubric_Individual_2021S1_V1
Criteria
Ratings
Pts
Statistical
32 to >28.0 Pts
28 to >24.0 Pts
24 to >19.0 Pts
19 to >15.5 Pts
15.5 to >0 Pts
Analysis and
Outstanding
Very Good
Good
Pass
Unsatisfactory
The statistical
The statistical
The statistical
The statistical
The statistical
analysis is
analysis is
analysis are
analysis are
analysis are
accurate and
mostly accurate
partially
partially
mostly
complete (using
appropriate
but with minor
flaws. The
accurate with
some flaws.
accurate with
some major
incorrect with
significant
formula and
interpretation of
The
flaws for sub-
flaws.
inference
theory).
Interpretation of
statistical
findings are
precise, and
understandable
in Statistical
and English
language. A
balanced
display of
numbers,
graphs, and
words,
organized in a
clear and
readable way.
statistical
findings are
mostly correct
but with minor
gaps, and
understandable
in Statistical
and English
language. A
balanced
display of
statistical
numbers,
graphs, and
words, but with
minor flaws in
clarity and
coherence.
interpretation of
statistical
findings is
partially
appropriate, but
some gaps in
both
interpretation
and results
communication.
An appropriate
display of
statistical
numbers,
graphs, and
words, but with
some flaws in
clarity and
questions. The
interpretation of
statistical
findings is
partially
appropriate, but
some gaps in
both
interpretation
and results
communication.
An display of
statistical
numbers,
graphs, and
words, but with
some apparent
flaws in clarity
Interpretation
of statistical
findings is
irrelevant to
statistical
theories and
incorrect. An
unbalanced
display of
statistical
numbers,
graphs, and
words and
poorly
organised.
Interpretation
(32 pts)
https://rmit.instructure.com/courses/91574/assignments/728938
32 pts
⻚页码：3/4
Assessment 3: Individual Written Report
2022/10/19 11’21
coherence.
and coherence.
Professional
2.5 to >2.0 Pts
2 to >1.5 Pts
1.5 to >1.0 Pts
1 to >0 Pts
Report –
Outstanding/Very
Good
Pass
Unsatisfactory
Executive
Summary
Good
Demonstrated a
Demonstrated
Failed to
Demonstrated
good understanding
adequate
demonstrate
thorough and in-depth
of an overview of
understanding an
elemental
understanding of an
key essential
overview of key
understanding an
overview of key
information
essential
overview of key
essential information
comprising a report:
information
essential information
comprising a report:
context to the topic,
comprising a report:
comprising a report:
context to the topic,
scope of the
scope of the
investigation,
context to the topic,
scope of the
context to the topic,
scope of the
investigation,
methodology, and
investigation,
investigation,
methodology, and key
key findings and
methodology, and
methodology, and
findings and
recommendations.
key findings and
key findings and
recommendations.
recommendations.
(2.5 pts)
recommendations.
Professional
2.5 to >2.0 Pts
2 to >1.5 Pts
1.5 to >1.0 Pts
1 to >0 Pts
Report-
Outstanding/Very
Good
Pass
Unsatisfactory
Introduction
(2.5 pts)
Good
Demonstrated good
Demonstrated
Failed to
Demonstrated
understanding of
adequate
demonstrate
thorough and in-depth
three key areas:
understanding of
understanding of
understanding of three
context of the topic;
three key areas:
three key areas:
key areas: context of
what the topic is &
context of the topic;
context of the topic;
the topic; what the
why it is important;
what the topic is &
what the topic is &
topic is & why it is
the aims/objectives
why it is important;
why it is important;
important; the
aims/objectives of the
report.
of the report.
the aims/objectives
of the report.
the aims/objectives
of the report.
Professional
Report Format (3
pts)
3 to >2.0 Pts
Outstanding/Very Good
2 to >1.5 Pts
Good
1.5 to >1.0 Pts
Pass
1 to >0 Pts
Unsatisfactory
Properly formatted with page
numbering, informative heading and
sub-headings, labelled graphs and
tables (with proper titles)
Minor flaws in
formatting
Some flaws in
formatting
Poorly
formatted
2.5 pts
2.5 pts
3 pts
Total points: 40
https://rmit.instructure.com/courses/91574/assignments/728938
⻚页码：4/4
Cover sheet for submission of
work for assessment
SCHOOL:
Office use only
Program name
Program code
Course/unit name
Course/unit code
School date stamp
Assignment no.
Due date
Name of lecturer/teacher
Campus
Class day/time
Tutor/marker’s name
STUDENT/S
Family name
Given name
Student number
(1)
(2)
(3)
DECLARATION AND STATEMENT OF AUTHORSHIP
1. I/we hold a copy of this work which can be produced if the original is lost/damaged.
2. This work is my/our original work and no part of it has been copied from any other student’s work or from any other source except where due
acknowledgement is made.
3. No part of this work has been written for me/us by any other person except where such collaboration has been authorised by the lecturer/teacher
concerned.
4. I/we have not previously submitted this work for this or any other course/unit.
5. I/we give permission for this work to be reproduced, communicated, compared and archived for the purpose of detecting plagiarism.
6. I/we give permission for a copy of my/our marked work to be retained by the school for review and comparison, including review by external
examiners.
I/we understand that:
7. Plagiarism is the presentation of the work, idea or creation of another person as though it is my/our own. It is a form of cheating and is a very serious
academic offence that may lead to exclusion from the University. Plagiarised material can be drawn from, and presented in, written, graphic and
visual form, including electronic data and oral presentations. Plagiarism occurs when the origin of the material used is not appropriately cited.
8. Plagiarism includes the act of assisting or allowing another person to plagiarise or to copy my/our work.
Student signature/s
I/we declare that I/we have read and understood the declaration and statement of authorship.
(1)
(2)
(3)
Further information relating to the penalties for plagiarism, which range from a notation on your student file to expulsion from the University, is contained
in Regulation 6.1.1 Student Discipline and the Plagiarism Policy which are available on the Policies and Procedures website at
www.rmit.edu.au/policies.
Copies of this form can be downloaded from the student forms web page at www.rmit.edu.au/students/forms.
Cover sheet for submission of work for assessment
1111 page 1 of 1
RMIT Classification: Trusted
BUSINESS STATISTICS
Assessment 3: Individual Assignment
Instructions:
This is an individual assignment with a total of 40 marks. The allocation of marks is as follows:
Statistical Analysis with Excel File:
32
Professional Report:
8
Total:
40
Report Structure
The response must be provided in the form of a professional report with no more than 10
pages (excluding the cover page).
The structure of your professional report must include:
• A Title,
• An Executive Summary,
• An Introduction,
• Analysis, and
• Conclusions.
Submission
•
You must submit an electronic copy of your assignment on Canvas. See the attached
Template of your submission for more details.
Excel Work
This assignment requires the use of Microsoft Excel. Using Data Analysis Tool-Pack will
assist tremendously in getting through the assignment requirements.
You need to submit the Excel file along with your report. The excel file needs to be clear and
carefully organized and must show all workings underlying the Professional report and
associated statistical analysis. It will be treated as an appendix to your report, i.e., not included
in the page count.
1
RMIT Classification: Trusted
DO NOT leave references to the excel workbook within the Professional report as
responses to the questions. You will need to take relevant results from your Excel workbook
and incorporate them into your report. The report needs to be standalone.
Presentation Instructions:
Your written professional report should comply with the following presentation standards:
1) Typed using a standard professional font type (e.g. Times Roman), 12-point font size.
2) 1.5-line spacing, numbered pages, and clear use of titles and section headings.
3) Delivered as a Word (.doc or .docx) or PDF (.pdf) file.
4) Checked for spelling, typographical and grammatical errors. Where relevant, round to 3
decimal places.
5) With all relevant tables and charts, the report should be no more than 10 pages long.
Problem Description:
This is a further analysis of the public-private pay gap for individuals with similar productive
characteristics in the Australian population. Mahuteau et al. (2017) report that (1) on average
public sector workers earn about 5.1% more hourly wages than those in the private sector and
(2) that this wage premium (comparatively higher wages in public sector) is slightly higher for
females than males. Systematic remuneration differences for employees with similar
productive capabilities potentially has both efficiency and equity consequences.
In order to estimate the extent of discrimination in the job market where public servants with
the identical labour market characteristics as their private counterparts receive different wages,
you will estimate a set of linear regression models.
Since this is an additional analysis on the public-private pay gap, the content in the Introduction
section of your report may overlap with the one in the Group Assignment submitted earlier.
However, you are encouraged to develop/source new background materials.
You will use the same dataset as in Assignment 2. The data are drawn from the 2019
Household, Income and Labour Dynamics in Australia (HILDA) survey. The sample used for
analysis comprises 219 full-time Australian workers in the age group 21-65.
The dataset values can be interpreted and be used to create appropriate variables as follows:
1. Worker’s Wages: the variable wage records hourly earnings in AU dollars of full-time
workers [note the unit of measurement]
2. Sector: Public and private sector identification data can be converted into a dummy
variable named as “public”, with 1 representing public employee else 0 for private
employee.
3. Gender: using the gender identification data, create a dummy variable male that
identifies male employee as 1 and female as 0.
4. Educational attainment: the dummy variable degree = Yes (1) if the individual has a
bachelor’s degree or higher qualification, and = No (0) for lower than degree
qualifications.
2
RMIT Classification: Trusted
5. Age: is the numerical data type reflecting the age of an employee.
6. Marital Status: the dummy variable married = Yes (1) if the individual is married and
No (0), otherwise.
Locate the data file (IndividualBusStats.xls) on CANVAS.
REQUIREMENT:
1. Before estimating the regression equation, conduct an overall preliminary analysis of the
relationship between workers’ wages and
a.
b.
c.
d.
e.
sector,
gender,
educational attainment,
age and
marital status.
Use tables and/or appropriate graphs for the categorical variables (male, public, degree,
married) and the numerical variable (age).
Interpret your findings by comparing the earnings of the counterparts based on each of
these dummy variables and also explain the kind of relationship you observe between
workers’ earnings and age?
(5 marks)
2. Use a simple linear regression to estimate the relationship between workers’ earnings and
the variable public (Model A). You may use the Data Analysis Tool Pack. Based on the
Excel regression output:
a) Write down the estimated regression equation,
b) Carry out any relevant two-tailed hypothesis test of the slope coefficient using the
critical value approach, at the 5% significance level, showing the step-by-step
workings/diagram in your report.
c) Interpret your hypothesis test results.
(3 marks)
3. Use the following multiple regression model to explore the relationship of workers’
earnings with variables related to sector, gender, educational attainment, age and marital
status
Model B: 𝐖𝐚𝐠𝐞𝐬 = 𝜷𝟎 + 𝜷𝟏 𝒑𝒖𝒃𝒍𝒊𝒄 + 𝜷𝟐 𝒎𝒂𝒍𝒆 + 𝜺
Model C: 𝐖𝐚𝐠𝐞𝐬 = 𝜷𝟎 + 𝜷𝟏 𝒑𝒖𝒃𝒍𝒊𝒄 + 𝜷𝟐 𝒎𝒂𝒍𝒆 + 𝜷𝟑 𝒂𝒈𝒆 + 𝜺
Model D: 𝐖𝐚𝐠𝐞𝐬 = 𝜷𝟎 + 𝜷𝟏 𝒑𝒖𝒃𝒍𝒊𝒄 + 𝜷𝟐 𝒎𝒂𝒍𝒆 + 𝜷𝟑 𝒂𝒈𝒆 + 𝜷𝟑 𝒆𝒅𝒖𝒄𝒂𝒕𝒊𝒐𝒏 + 𝜺
Model E: 𝐖𝐚𝐠𝐞𝐬 = 𝜷𝟎 + 𝜷𝟏 𝒑𝒖𝒃𝒍𝒊𝒄 + 𝜷𝟐 𝒎𝒂𝒍𝒆 + 𝜷𝟑 𝒂𝒈𝒆 + 𝜷𝟒 𝒆𝒅𝒖𝒄𝒂𝒕𝒊𝒐𝒏 +
𝜷𝟓 𝒎𝒂𝒓𝒓𝒊𝒆𝒅 + 𝜺
a) Based on the Excel regression outputs, select the best model and explain why it is
the best.
b) Write down the estimated equation for the best model and interpret the slope
coefficients,
3
RMIT Classification: Trusted
c) Based on the best model, carry out any relevant two-tailed hypothesis tests for each
individual slope coefficient using the p-value approach, at the 5% significance
level.
d) Carry out an overall significance test using the p-value approach.
e) Carefully interpret your hypothesis test results in c) and d).
f) Are your regression findings with regards to public-private wage gap broadly
consistent with those reported in the study of Mahuteau et al. (2017)?
(9 marks)
4. Compare the coefficients of public variable in Model A and Model E. Explain carefully
why the results are different, relating your discussion to sector wage discrimination.
(4 marks)
5. Based on the Model E, predict the earnings of a 40-year-old male, university qualified and
married public worker. Next, predict the earnings of a female worker with the same
characteristics.
(2.5 marks)
6. Based on the result in Question 5, how will your result in Question 5 change if the
male/female worker is 50 years old? Explain without any calculation.
(2.5 marks)
7. Another conclusion from Mahuteau et al. (2017) is that the wage premium (comparatively
higher wages) for the workers in the public sector is slightly higher for females than males.
Conduct appropriate regression analyses to examine whether your findings based on 2019
data are broadly consistent with those reported in the study.
(4 marks)
8. If you could request additional data to study the factors that influence workers’ earnings,
what extra variables would you request? Discuss two such variables, explaining why you
choose them and how each of your proposed variables could be measured in the regression
model. [You could draw evidence from journal articles, newspapers, etc]
(2 marks)
(5 + 3 + 9 + 4 + 2.5 + 2.5 + 4 + 2 = 32 marks)
(Professional report = 8 marks)
Reference:
Mahuteau, S, Mavromaras, K, Richardson, S & Zhu, R 2017, ‘Public–private sector wage
differentials in Australia’, Economic Record, vol. 93, pp. 105-121.
4
Data overview:
The data set is a random sample of 219 employees from the public and private sectors in Australia in 2019.
The tab “public” includes the employees from the public sector.
The tab “private” includes the employees from the private sector.
Sources: the 2019 HILDA (Household, Income and Labour Dynamics in Australia) survey
Variable Definition:
gender
female or male
degree
Yes = with a university degree; No = without a university degree
married Yes = married; No = unmarried
wage
hourly wages measured in 2019 AU$
age
age of worker measured in years
ustralia in 2019.
gender
Female
Female
Male
Female
Male
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Male
Female
Male
Male
Male
Female
Female
Female
Male
Female
Male
Male
Female
Female
Female
Female
Male
Female
Female
Male
Female
Female
Male
Male
Male
Female
Female
Male
Female
Male
Female
age
45
23
44
27
28
24
31
28
39
22
27
64
44
25
22
28
27
54
45
28
46
43
61
38
26
30
28
28
34
25
32
48
24
29
41
37
57
32
31
31
51
32
33
45
53
32
wage
degree
20.5938 No
21.2813 No
22.5 No
22.9167 Yes
23.1053 No
23.2955 No
23.34 Yes
24.2368 Yes
25 Yes
26.3158 Yes
27.7778 Yes
28.5714 No
29.2222 Yes
29.25 Yes
30.6667 No
30.6667 No
30.85 No
30.9091 No
31.25 Yes
31.875 No
32.4324 No
33.575 Yes
33.625 No
33.75 No
34 Yes
35.5405 Yes
35.7143 No
35.7692 Yes
35.9737 No
36.4333 No
36.6444 Yes
37.2105 No
37.2533 Yes
37.3333 No
37.4889 Yes
37.5 Yes
37.5 No
39.4737 No
39.8 Yes
40 No
40.5405 No
41.0952 No
41.225 Yes
41.3667 No
41.6 No
42.1316 Yes
married
No
No
Yes
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
Yes
Yes
No
No
Yes
Yes
No
Yes
No
No
No
Yes
No
Yes
No
No
No
Yes
Yes
Yes
No
No
No
Yes
No
Yes
Yes
No
Yes
Male
Female
Male
Male
Female
Male
Male
Female
Male
Male
Male
Male
Male
Male
Male
Female
Male
Male
Female
Female
Female
Female
Female
Female
Female
Male
Male
Female
Male
Male
Female
Male
Male
Male
Male
Female
Male
Male
Female
Male
63
46
58
30
29
46
40
52
39
65
59
40
57
26
37
31
44
44
31
31
55
41
60
31
51
39
40
30
33
38
36
53
56
48
54
49
55
60
43
56
42.4242 Yes
43.05 No
45.1304 Yes
45.94 Yes
46.24 No
47.5 No
47.6744 Yes
47.7111 Yes
48.125 Yes
49.4737 No
50 No
50 Yes
50 No
50.35 Yes
50.875 Yes
51.3514 No
51.45 No
52.5 No
52.6316 Yes
52.75 Yes
54.6 Yes
55.5556 No
55.5946 Yes
55.6667 Yes
56.5263 Yes
57.1429 Yes
57.76 No
57.8684 No
58.0526 No
58.4524 Yes
61.3667 Yes
62.3 No
64.4737 No
64.48 No
64.7 Yes
64.725 Yes
67.6546 Yes
78.9143 Yes
82.8947 Yes
98.975 Yes
No
Yes
Yes
Yes
No
No
No
No
No
Yes
No
Yes
No
Yes
No
Yes
No
No
No
Yes
Yes
No
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
Yes
Yes
No
No
Yes
No
Yes
Yes
gender
Male
Male
Female
Female
Male
Female
Female
Male
Male
Female
Male
Female
Female
Female
Female
Female
Female
Male
Male
Female
Female
Female
Male
Female
Female
Female
Male
Female
Male
Male
Male
Male
Female
Male
Female
Female
Male
Male
Male
Male
Male
Female
Female
Male
Male
Female
age
36
61
25
22
23
27
27
21
21
31
27
41
26
31
23
28
63
24
52
27
27
49
47
43
31
27
27
60
52
22
22
60
41
39
39
48
30
22
26
22
32
46
47
31
60
53
wage
degree
3.00903 Yes
6.52174 No
9.2 No
10 No
10.56 No
13.5 Yes
14.5833 No
16.2667 No
16.4286 No
17.5 No
18 No
18.2 Yes
18.3421 No
19.18 No
19.1818 No
19.6744 No
19.9063 No
19.9833 No
20 No
20.1842 Yes
20.8333 No
21 No
21.4 No
21.4186 Yes
21.4889 Yes
21.5 Yes
21.8182 No
21.9048 No
22 No
22.275 No
22.5 No
22.6316 No
22.6415 No
23.08 No
24.56 No
24.5714 No
24.95 No
25 No
25.5667 Yes
25.6667 No
26 No
26.24 No
26.3158 No
26.9048 No
27.1667 No
27.1667 No
married
Yes
No
No
No
No
No
Yes
No
No
No
No
Yes
Yes
No
No
Yes
No
No
No
No
Yes
Yes
No
No
No
Yes
No
No
No
No
No
No
Yes
No
Yes
Yes
Yes
No
No
No
No
Yes
No
Yes
Yes
Yes
Female
Female
Male
Male
Female
Male
Female
Male
Male
Female
Female
Male
Male
Male
Female
Female
Male
Male
Female
Male
Female
Male
Female
Male
Male
Male
Female
Male
Female
Male
Male
Female
Male
Female
Male
Female
Female
Male
Male
Female
Female
Male
Female
Male
Female
Female
Male
25
35
63
28
42
44
28
24
27
26
59
23
40
22
50
65
28
30
37
32
25
32
51
35
27
38
64
26
34
27
37
33
23
30
37
41
27
26
35
29
55
42
22
30
61
41
29
27.3404 Yes
27.625 No
28 No
28 Yes
28.3333 Yes
28.3333 No
28.62 Yes
28.775 No
28.85 No
28.9211 Yes
29.0833 No
29.3091 No
29.6977 Yes
31 Yes
31.1111 No
31.125 Yes
31.2093 Yes
31.4286 Yes
31.6667 No
32.3438 No
32.4211 No
32.5 No
33.1861 No
33.3333 No
33.4 Yes
34.375 No
34.8727 No
34.92 Yes
37.093 No
37.4474 No
37.5 No
37.6 Yes
38.1579 No
38.35 No
38.35 No
38.4615 No
38.8 No
38.8519 No
39 Yes
39.5 No
39.85 Yes
39.95 No
40 No
40.0455 No
41.6667 Yes
41.8364 Yes
42.4419 No
No
No
Yes
No
No
No
No
No
No
No
Yes
No
Yes
No
Yes
No
No
No
Yes
No
No
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
Yes
No
No
No
Yes
No
No
Yes
No
No
Yes
No
No
No
No
No
Female
Male
Male
Male
Female
Male
Male
Male
Female
Male
Male
Male
Female
Female
Female
Female
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Female
Male
Male
Male
Male
Male
Male
Male
59
37
29
46
32
50
30
33
33
40
44
26
58
31
36
46
32
55
46
37
43
64
36
36
49
31
60
42
35
31
38
38
43
38
63
56
64
31
53
44
42.5135 No
43.0222 No
43.15 No
43.16 Yes
43.3429 Yes
43.8597 No
44.6 No
44.7556 No
44.8667 Yes
46.02 No
46.02 Yes
46.4211 Yes
47.95 Yes
48.075 No
48.2 Yes
48.9 Yes
49.0222 Yes
50.9286 Yes
52.94 Yes
56.25 Yes
56.4 No
57.525 No
61.38 Yes
61.5 No
61.7209 No
68.9474 Yes
70 No
70.2128 Yes
70.8333 Yes
73.1 No
73.64 Yes
78.26 Yes
79.6857 No
79.8889 Yes
80 Yes
87.5 No
91.1765 No
100 No
100 Yes
100.581 No
Yes
No
No
No
No
Yes
Yes
No
No
No
Yes
No
Yes
No
No
No
No
No
No
No
Yes
Yes
Yes
No
Yes
Yes
Yes
No
No
Yes
Yes
No
Yes
No
No
Yes
Yes
No
Yes
No
RMIT Classification: Trusted
>
Arial (18 points, Boldface)
Executive Summary
Here you present a one-paragraph succinct summary of the report. This summary should stand
alone (no reference to figures or tables in the text) and should provide a clear overview of the
essential information in the report: aim of the analysis, methodology used, and one or two key
findings and recommendations.
Introduction
In the “Introduction,” make sure that you orient the audience (here, the Taskforce) with
sufficient background to understand what the problem is and why the problem is important
(engage with audience). You also provide: a background of the issue being investigated (could
refer to media/newspaper articles, journal articles etc; make sure you cite them properly), the
aim(s) of the analysis, a description of research methods, and some highlights of the findings.
Analysis
Here you will answer the questions in the order they have been asked. Label the answers for
clarity.
Conclusions
This section summarizes the document and provides closure. The difference between this
summary and the executive summary is that the summary in the “Conclusion” for someone
who has read the report. You will again briefly state the objective of the analysis and the
methods used and provide some highlights of your main findings.
References
Need to provide a list of references if you have cited any article/website.
Other notes: a professional report also needs
•
•
•
•
•
Page numbering
Informative headings and sub-headings
Numbered answers
Labelled graphs and tables
Nice overall formatting and presentation/consistent font/no over- or under-sized
figures/tables