Statistical Analysis of Australian Real Estate Data: A Case Study

Desklib provides solved assignments and past papers to help students understand statistical concepts and techniques.

Stats

Contents
Introduction....................................................................................................................................................3
Q1...................................................................................................................................................................4
(a)...............................................................................................................................................................4
(b)...............................................................................................................................................................8
(c).............................................................................................................................................................10
Q2.................................................................................................................................................................14
(a) & (b)...................................................................................................................................................14
(c).............................................................................................................................................................21
(d).............................................................................................................................................................22
Q3.................................................................................................................................................................23
(a).............................................................................................................................................................24
(b).............................................................................................................................................................24
(c).............................................................................................................................................................25
Q4.................................................................................................................................................................25
(a)(i).........................................................................................................................................................26
(a)(ii)........................................................................................................................................................26
(b)(i).........................................................................................................................................................26
(b)(i).........................................................................................................................................................27
(b)(ii)........................................................................................................................................................27
Q5.................................................................................................................................................................29
(a).............................................................................................................................................................29
(b).............................................................................................................................................................30
Conclusion...................................................................................................................................................31

Introduction
The assignment involves understanding and application of various statistical tools and functions in the
formula which eventually will lead to better understanding and help in arriving at a conclusion and
solution. This solution will allow the user to understand different aspects of the statistical data. A detailed
knowledge of the subject matter will be required to understand the issues and hence analyse the data and
arrive at conclusion.

Q1
(a)
RMD
Yea
r
Month Average of Open
values
Month
Available
2019 Jan, Feb Mar 78.16 Jan, Feb Mar
2019 Apr, May,
June
105.86 Apr May
2018 Jan, Feb Mar 94.3 Jan, Feb Mar
2018 Apr, May,
June
101.115 Apr, May, June
2018 Jul, Aug, Sep 109.26 Jul, Aug, Sep
2018 Oct, Nov,
Dec
107.157 Oct, Nov, Dec
2017 Jan, Feb Mar 68.89 Jan, Feb Mar
2017 Apr, May,
June
71.38 Apr, May, June
2017 Jul, Aug, Sep 76.47 Jul, Aug, Sep
2017 Oct, Nov,
Dec
82.47 Oct, Nov, Dec
2016 Jan, Feb Mar 56.52 Jan, Feb Mar
2016 Apr, May,
June
58.8 Apr, May, June
2016 Jul, Aug, Sep 66.52 Jul, Aug, Sep
2016 Oct, Nov,
Dec
61.25 Oct, Nov, Dec
2015 Jan, Feb Mar 64.7 Jan, Feb Mar
2015 Apr, May,
June
63.14 Apr, May, June
2015 Jul, Aug, Sep 53.88 Jul, Aug, Sep
2015 Oct, Nov,
Dec
56.23 Oct, Nov, Dec
2014 Jan, Feb Mar 44.86 Jan, Feb Mar
2014 Apr, May,
June
49.47 Apr, May, June
2014 Jul, Aug, Sep 50.88 Jul, Aug, Sep
2014 Oct, Nov,
Dec
52.08 Oct, Nov, Dec
2013 Jan, Feb Mar 44.13 Jan, Feb Mar
2013 Apr, May,
June
47.48 Apr, May, June

2013 Jul, Aug, Sep 48.56 Jul, Aug, Sep
2013 Oct, Nov,
Dec
50.66 Oct, Nov, Dec
2012 Jan, Feb Mar 28.91 Jan, Feb Mar
2012 Apr, May,
June
31.8 Apr, May, June
2012 Jul, Aug, Sep 35.49 Jul, Aug, Sep
2012 Oct, Nov,
Dec
40.85 Oct, Nov, Dec
2011 Jan, Feb Mar 31.86 Jan, Feb Mar
2011 Apr, May,
June
31.54 Apr, May, June
2011 Jul, Aug, Sep 29.75 Jul, Aug, Sep
2011 Oct, Nov,
Dec
27.23 Oct, Nov, Dec
2010 Jan, Feb Mar 28.24 Jan, Feb Mar
2010 Apr, May,
June
31.87 Apr, May, June
2010 Jul, Aug, Sep 32.1 Jul, Aug, Sep
2010 Oct, Nov,
Dec
33.02 Oct, Nov, Dec
2009 Jan, Feb Mar 0 Jan, Feb Mar
2009 Apr, May,
June
19.38 May, June
2009 Jul, Aug, Sep 21.67 Jul, Aug, Sep
2009 Oct, Nov,
Dec
24.94 Oct, Nov, Dec
FPH
Yea
r
Month Average of Open
values
Month
Available
2019 Jan, Feb Mar 14.33 Jan, Feb Mar
2019 Apr, May,
June
15.81 Apr
2018 Jan, Feb Mar 13.32 Jan, Feb Mar
2018 Apr, May,
June
3.56 Apr, May,
June
2018 Jul, Aug,
Sep
15.21 Jul, Aug, Sep
2018 Oct, Nov,
Dec
13.32 Oct, Nov, Dec

2017 Jan, Feb Mar 9.16 Jan, Feb Mar
2017 Apr, May,
June
10.7 Apr, May,
June
2017 Jul, Aug,
Sep
11.84 Jul, Aug, Sep
2017 Oct, Nov,
Dec
13.53 Oct, Nov, Dec
2016 Jan, Feb Mar 9.14 Jan, Feb Mar
2016 Apr, May,
June
9.97 Apr, May,
June
2016 Jul, Aug,
Sep
10.02 Jul, Aug, Sep
2016 Oct, Nov,
Dec
8.57 Oct, Nov, Dec
2015 Jan, Feb Mar 6.55 Jan, Feb Mar
2015 Apr, May,
June
6.66 Apr, May,
June
2015 Jul, Aug,
Sep
7.28 Jul, Aug, Sep
2015 Oct, Nov,
Dec
8.32 Oct, Nov, Dec
2014 Jan, Feb Mar 4.11 Jan, Feb Mar
2014 Apr, May,
June
4.47 Apr, May,
June
2014 Jul, Aug,
Sep
4.97 Jul, Aug, Sep
2014 Oct, Nov,
Dec
5.77 Oct, Nov, Dec
2013 Jan, Feb Mar 2.52 Jan, Feb Mar
2013 Apr, May,
June
3.07 Apr, May,
June
2013 Jul, Aug,
Sep
3.56 Jul, Aug, Sep
2013 Oct, Nov,
Dec
3.77 Oct, Nov, Dec
2012 Jan, Feb Mar 2.16 Jan, Feb Mar
2012 Apr, May,
June
2.08 Apr, May,
June
2012 Jul, Aug,
Sep
2.12 Jul, Aug, Sep
2012 Oct, Nov,
Dec
2.46 Oct, Nov, Dec
2011 Jan, Feb Mar 3.1 Jan, Feb Mar
2011 Apr, May,
June
2.91 Apr, May,
June

2011 Jul, Aug,
Sep
2.42 Jul, Aug, Sep
2011 Oct, Nov,
Dec
2.38 Oct, Nov, Dec
2010 Jan, Feb Mar 3.33 Jan, Feb Mar
2010 Apr, May,
June
3.28 Apr, May,
June
2010 Jul, Aug,
Sep
2.97 Jul, Aug, Sep
2010 Oct, Nov,
Dec
3.09 Oct, Nov, Dec
2009 Jan, Feb Mar 3.22 Jan, Feb Mar
2009 Apr, May,
June
2.95 May, June
2009 Jul, Aug,
Sep
3.26 Jul, Aug, Sep
2009 Oct, Nov,
Dec
3.21 Oct, Nov, Dec
Minimum value of
RMD 0
Maximum value of
RMD 109.26
Minimum value of
FPH 2.08
Maximum value of
FPH 15.81
Stem
Leaves
of
RMD
Leaves
of FPH
1 9
2 1 4 7 8 9
3 1 2 3 5
4
0 4 7 8
9
5
0 2 3 6
8
6
1 3 4 6
8
7 1 6 8

8 2
9 4
10 5 7 9 0 1 3 5

(b)
RMD FPH
Year Average of
Open
values of
RMD
Average of
Open
values of
FPH
2019 78.16 14.33
2019 105.86 15.81
2018 94.3 13.32
2018 101.115 3.56
2018 109.26 15.21
2018 107.157 13.32
2017 68.89 9.16
2017 71.38 10.7
2017 76.47 11.84
2017 82.47 13.53
2016 56.52 9.14
2016 58.8 9.97
2016 66.52 10.02
2016 61.25 8.57
2015 64.7 6.55
2015 63.14 6.66
2015 53.88 7.28
2015 56.23 8.32
2014 44.86 4.11
2014 49.47 4.47
2014 50.88 4.97
2014 52.08 5.77
2013 44.13 2.52
2013 47.48 3.07
2013 48.56 3.56
2013 50.66 3.77
2012 28.91 2.16
2012 31.8 2.08
2012 35.49 2.12
2012 40.85 2.46
2011 31.86 3.1
2011 31.54 2.91
2011 29.75 2.42
2011 27.23 2.38

2010 28.24 3.33
2010 31.87 3.28
2010 32.1 2.97
2010 33.02 3.09
2009 0 3.22
2009 19.38 2.95
2009 21.67 3.26
2009 24.94 3.21
2019
2018
2017
2017
2016
2015
2014
2014
2013
2012
2011
2011
2010
2009
0
20
40
60
80
100
120
Average of Open values of RMD
Average of Open values of FPH

(c)
Ansell Ltd. (ANN)
Date Close Volume
1/31/2018 26.25 16782958
2/28/2018 25.26 11564608
3/31/2018 26.08 8023953
4/30/2018 26.25 9732498
5/31/2018 27.19 11381705
6/30/2018 28.81 12801315
7/31/2018 25.10 19458053
8/31/2018 25.25 13083058
9/30/2018 23.18 18068859
10/31/2018 22.81 12449315
11/30/2018 22.04 13940334
12/31/2018 23.42 13355096
Healthscope Ltd. (HSO)
Date Close Volume
1/31/2018 1.89 123705653
2/28/2018 1.94 121755726
3/31/2018 2.43 221375333
4/30/2018 2.35 223616986
5/31/2018 2.21 101143872
6/30/2018 2.18 79894117
7/31/2018 2.19 81126693
8/31/2018 2.10 114700407
9/30/2018 2.11 183191132
10/31/2018 2.26 459301663
11/30/2018 2.23 184369066
12/31/2018 2.36 131200382
CSL Limited (CSL)
Date Close Volume
1/31/2018 163.17 19260555
2/28/2018 155.46 17990165
3/31/2018 170.36 16255332

4/30/2018 185.85 19482747
5/31/2018 192.62 17870542
6/30/2018 196.61 16696090
7/31/2018 227.31 20097239
8/31/2018 201.11 19573139
9/30/2018 188.00 23465143
10/31/2018 177.40 22401738
11/30/2018 185.16 17492873
12/31/2018 194.72 15310369
Cochlear Limited (COH)
Date Close Volume
1/31/2018 183.9
0
4255071
2/28/2018 181.6
2
3098313
3/31/2018 194.0
6
2310559
4/30/2018 196.1
5
3117462
5/31/2018 200.1
7
4422066
6/30/2018 203.3
6
3168984
7/31/2018 215.8
1
4433293
8/31/2018 200.6
4
3345400
9/30/2018 177.5
8
4827646
10/31/2018 169.2
8
5359640
11/30/2018 173.5
7
3092136
12/31/2018 193.4
2
2768713
Sonic Healthcare Ltd. (SHL)
Date Close Volume
1/31/2018 24.5 23031232
2/28/2018 22.88 19465493
3/31/2018 23.62 13873740