Data Collection and Business Report

DATA COLLECTION AND
BUSINESS REPORT

Table of Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
PART- A..........................................................................................................................................3
Question: 1 - Statement of Investment goal................................................................................3
Question: 2 – Calculations for weekly rate of return for the two companies..............................3
Question: 3 - Descriptive statistics of two company’s weekly rate of return..............................5
Question: 4 – Interpretation of statistics......................................................................................6
Question: 5 – Graphical representation of company’s weekly returns........................................7
Question: 6 – creating a box and whisker plot............................................................................8
Question:8 – interpretation of confidence interval......................................................................8
Part – B............................................................................................................................................8
Question: 1...................................................................................................................................8
Question: 2 – correlation analysis................................................................................................9
Question: 3 – regression analysis of ILU..................................................................................10
Question: 4 – regression analysis of BLD.................................................................................12
Question: 5 - Trends and conclusions........................................................................................13
REFERENCES..............................................................................................................................15

INTRODUCTION
Data collection and business report here includes the stock analysis of two companies on the
basis of historical closing prices of two companies based in Australia and listed on Australian
stock market (Ranganathan, Pramesh and Aggarwal, 2017). The companies chosen for this report
are Iluka Resources limited and Boral limited. Iluka is an Australian company specialized in
exploring mineral sands, project development, marketing and operations. On the other hand,
Boral limited is a MNC established manufacturer and supplier of building and construction
materials. The stocks of these two companies are among best performers of Australian Securities
Exchange’s index of top 200 shares. In this report, various statistical tools and techniques will be
applied to analyze and suggest which stock is better among the two.
MAIN BODY
PART- A
Question: 1 - Statement of Investment goal
 Planning for expenditure post retirement in order to meet old age expenses in an easier
way.
 Accumulation of wealth for achieving short terms goals such as buying a car within two
years and going on a vacation post marriage (Fagerland, Lydersen and Laake, 2017).
 For meeting any emergency expenses where immediate liquidity is necessary and the
same can be possible and facilitated through investment in stock market as stocks can be
easily liquidated at any point of time an investor wishes to do so.
 To build a corpus in order to meet increasing cost of higher education of children as stock
is considered as an inflation beating instrument suitable for meeting expenses that are
increasing continuously (Xia and Sun, 2017).
 Buying a dream house within five to ten years.
Question: 2 – Calculations for weekly rate of return for the two companies
Date Weekly rate of
return on ILU
weekly rate of return
on BLD stocks

stocks
1/1/2020 - -
1/8/2020 3.02 4.74
1/15/2020 0.31 2.67
1/22/2020 -6.88 0.00
1/29/2020 4.14 -2.40
2/5/2020 3.66 -2.67
2/12/2020 -47.71 1.27
2/19/2020 -2.34 -0.83
2/26/2020 -9.38 -6.93
3/4/2020 -3.49 -12.87
3/11/2020 -6.23 -26.94
3/18/2020 -9.31 -36.70
3/25/2020 2.35 14.85
4/1/2020 3.30 13.66
4/8/2020 7.35 15.02
4/15/2020 -5.17 -4.10
4/22/2020 -0.82 3.89
4/29/2020 1.65 1.50
5/6/2020 0.00 0.37
5/13/2020 7.30 -5.15
5/20/2020 4.66 12.02
5/27/2020 3.37 22.15
6/3/2020 8.03 8.22
6/10/2020 -4.96 -2.88
6/17/2020 -3.06 2.70
6/24/2020 -0.12 -0.52
7/1/2020 3.86 -1.32
7/8/2020 -0.68 0.00
7/15/2020 4.65 2.41
7/22/2020 1.63 2.09
7/29/2020 0.64 -5.63
8/5/2020 2.55 2.44
8/12/2020 2.17 -0.53
8/19/2020 2.13 0.80
8/26/2020 -1.88 1.85
9/2/2020 0.00 6.48
9/9/2020 -0.61 0.24
9/16/2020 -4.57 0.73
9/23/2020 -1.17 10.12
9/30/2020 -1.40 3.72
10/7/2020 5.03 3.59
10/14/202 1.04 -3.26