Quantitative Analysis – Hire Academic Expert

Quantitative Analysis Report (20% of overall assessment)
Research Question:
The purpose of this report is to practice the statistical analysis procedure and techniques you have
learned in this course. You can download from iLearn a dataset containing the financial statement
and stock return data for S&P500 stocks from 2010 to 2020. Using this dataset, you are required
to carry out the following analyses as mentioned below in the “specific requirements”. You are
provided with a number of variables in the dataset, but you do not have to use all the variables
provided in the dataset. Rather, you can only use a subset of variables that you believe are relevant
to your hypotheses. Therefore, you need to identify the variables that you want to examine and
then establish the conceptual associations between them (i.e., propose hypotheses) that you later
test and report on.
General requirements:
1. Prepare a written Report of no more than 2000 words in length. PLEASE DO NOT
EXCEED THE WORD LIMIT. A PENALTY MAY APPLY IF THE WORD LIMIT IS
EXCEEDED (this requirement is to help establish fair assessments). The word length
includes headings but does not include the reference list at the end, statistical tables or
appendices. Please keep appendices to a minimum.
2. Upload the soft copy of the written report on the Turnitin link provided on iLearn. The
report will be scanned with the university’s anti-plagiarism software.
3. No extension is available.
4. Penalties: There will be a deduction of 10% of the total available marks made from the
total awarded mark for each 24 hour period or part thereof that the submission is late (for
example, 25 hours late in submission – 20% penalty). Late submissions will only be
accepted upto 96 hours after the due date and time. See iLearn for further penalties
regarding plagiarism.
5. The criteria for marking (Rubrics) are provided on iLearn.
To conduct your research, you may find it helpful to consult the internet and professional or
academic journals. Write your report in a professional manner with sub-headings and clearly
defined sections. Be succinct and clear. Don’t waste any words. Don’t copy lengthy quotes.
Reports must be neatly presented and double spaced. Please keep a copy of your assignment.
Please be aware of PENALTIES for PLAGIARISM (see the Unit iLearn for details).
Specific requirements:
You are required to answer the following research questions using relevant examples and evidence.
Refer to relevant research articles to support your arguments. The structure of your report can
include the following relevant sections: (1) introduction to the topic; (2) relevant literature review

and research hypotheses; (3) research method(s); (4) results and discussion; and (5) summary and
conclusions.
The assessment tasks required in the report are:
1. Define a research question and develop a hypothesis
Describe the research issue you wish to explore
Provide at least one reference paper for this research issue
Formulate a research hypothesis or research hypotheses (but not exceeding 2 hypotheses).
2. Describe the sample
Present descriptive statistics table of the variables used in your analysis, where the table
should report number of observations, mean, standard deviation, first quantile, median,
third quantile
Discuss the distribution of the variables in your sample. Do you observe any skewness
and kurtosis associated with these variables’ distribution?
3. Perform univariate analysis
Identify the dependent variable and the key independent variable in your analysis
Carry out a two-sample t-test
Carry out a nonparametric rank sum test
Interpret the findings
4. Perform multivariate analysis
Propose an ordinary least squares regression or a logit/probit model and explain why it is
a suitable choice
Propose a set of control variables and explain why they are relevant
Report the estimation of the model
Interpret the findings
5. Conclusion
Summarise your findings
Discuss the economic meaning of your findings
The marking criteria and guideline:
Define a research question and develop hypotheses (20%)
o Make conceptual sense of the proposed hypotheses
o Clearly explain why there is a causal relation between two variables (i.e., why the change
in the value of a variable would increase or decrease the value of another variable).
Describe the sample (20%)
o Provide all the required statistics
o Provide a discussion on the distribution of the used variables.
Perform univariate analysis (20%)
o Successfully perform the univariate analysis
o Provide a well-structured report for the analysis of the results
o Clearly interpret the finding, linking the analysis result to their hypothesis.
Perform multivariate analysis (20%)
o Justify the choice of the choice of model
o Justify the choice of control variables
o Provide a well-structured report of the analysis results
o Clearly interpret the finding, linking the analysis result to their hypothesis.
Conclusion (20%)
o Provide a well-structured summary of the findings
o Provide a logical discussion on the economic meaning of the findings
Data variables
Variable Description
CUSIP CUSIP – Firm identifier

FYEAR
AT
FYEAR – Fiscal Year
Total assets
SIC2 Industry classification – 2-digit SIC code
CHE Cash and Short-Term Investments
CEQ Common/Ordinary Equity
PPENT Property, Plant and Equipment
DLC Debt in Current Liabilities
DLTT Long-Term Debt
Sale Sales
DP Depreciation and Amortization
OIBDP Operating Income Before Depreciation
EBIT Earnings Before Interest and Taxes
NI Net Income
XRD Research and Development Expense
XAD Advertising Expense
XSGA Selling, General and Administrative Expense
XINT Interest and Related Expense
CAPX Capital Expenditures
AQC Acquisitions cash outflow
OANCF Operating Activities Net Cash Flow
CSHO Common Shares Outstanding
DV Cash Dividends
WCAP Working Capital
Ret Annual stock return
Stdret Annual stock volatility
Volume Annual trading volume (in million shares)
Prc
firmAge
Year-end stock price
Firm age

 

Comments are closed.