Data Collection and Business Report
Added on 2022-12-15
16 Pages3225 Words430 Views
|
|
|
DATA COLLECTION AND
BUSINESS REPORT
BUSINESS REPORT
![Data Collection and Business Report_1](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2Fae%2F0c3f116346cd437ab404f92572c13f04.jpg&w=3840&q=10)
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...........................................................................................................................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
![Data Collection and Business Report_2](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2Fgi%2F5d6dc23ded0f414d99e4498cbad2c889.jpg&w=3840&q=10)
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
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
![Data Collection and Business Report_3](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2Foy%2Fc5807cb505594eee9cfd6ee11c02103e.jpg&w=3840&q=10)
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
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
![Data Collection and Business Report_4](/_next/image/?url=https%3A%2F%2Fdesklib.com%2Fmedia%2Fimages%2Fur%2F4abe42c7dacd40108283f2c7aef07f50.jpg&w=3840&q=10)
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents