final assignment

profilemrsladyhawk
TPG.AX3.xlsx

TPG.AX

Date Open Date High Date Low Close Adj Close Volume
1/1/19 6.44 1/1/19 7.35 1/1/19 6.25 6.99 6.459268 24263022 median 6.4823575 23460163
2/1/19 7 2/1/19 7.365 2/1/19 6.52 6.66 6.154323 29023635 mean 6.7798151667 25584759.3333333
3/1/19 6.66 3/1/19 7.265 3/1/19 6.56 6.95 6.422305 29485759 SD 0.7022006102 10059731.7384683
4/1/19 6.9 4/1/19 7.12 4/1/19 6.69 6.74 6.228249 18600089
5/1/19 6.73 5/1/19 7.26 5/1/19 5.94 6.29 5.828953 42629618
6/1/19 6.27 6/1/19 6.85 6/1/19 6.23 6.44 5.967958 21081093
7/1/19 6.51 7/1/19 7.25 7/1/19 6.42 6.98 6.468377 22657304
8/1/19 6.99 8/1/19 7.07 8/1/19 6.335 6.66 6.171832 20096329
9/1/19 6.6 9/1/19 7.14 9/1/19 6.04 6.94 6.431309 25531296
10/1/19 6.89 10/1/19 7.09 10/1/19 6.5 6.54 6.060628 16758572
11/1/19 6.5 11/1/19 7.15 11/1/19 6.45 6.99 6.496338 13578088
12/1/19 6.98 12/1/19 7.03 12/1/19 6.63 6.71 6.236114 14610955
1/1/20 6.71 1/1/20 7.575 1/1/20 6.67 7.48 6.951733 17239547
2/1/20 7.38 2/1/20 8.78 2/1/20 7.047031 7.319192 6.802281 32470203
3/1/20 7.085911 3/1/20 8.125956 3/1/20 5.929226 6.697109 6.224133 55441227
4/1/20 6.74571 4/1/20 7.746874 4/1/20 6.726269 7.153951 6.648711 20984968
5/1/20 7.027591 5/1/20 8.339797 5/1/20 6.667949 8.262036 7.711141 25395823
6/1/20 8.184276 6/1/20 9.25 6/1/20 7.610793 8.9 8.306566 42593601
7/1/20 9.7 7/1/20 9.7 7/1/20 7.49 8.04 7.952861 26137035
8/1/20 7.9 8/1/20 8.41 8/1/20 7.07 8.23 8.140801 37121971
9/1/20 8.1 9/1/20 8.25 9/1/20 7.01 7.3 7.220881 26139036
10/1/20 7.31 10/1/20 7.68 10/1/20 6.97 7.18 7.102182 16010625
11/1/20 7.11 11/1/20 8.23 11/1/20 6.93 7.67 7.586872 19226562
12/1/20 7.64 12/1/20 7.75 12/1/20 7.02 7.22 7.141748 16957866
max 8.306566
min 5.828953
Class limit bin
5.5-6.0 6
6.1-6.5 6.5
6.6-7.0 7
7.1-7.5 7.5
7.6-8.0 8
8.1-8.5 8.5
bin Frequency
6 2
6.5 11
7 3
7.5 3
8 3
8.5 2
More 0
max 55441227
min 13578088
Class limits bin
20000000
30000000
40000000
50000000
60000000
bin Frequency
20000000 8
30000000 11
40000000 2
50000000 2
60000000 1
More 0
Low 43466 43497 43525 43556 43586 43617 43647 43678 43709 43739 43770 43800 43831 43862 43891 43922 43952 43983 44013 44044 44075 44105 44136 44166 6.25 6.52 6.56 6.69 5.94 6.23 6.42 6.335 6.04 6.5 6.45 6.63 6.67 7.0470309999999996 5.9292259999999999 6.7262690000000003 6.6679490000000001 7.6107930000000001 7.49 7.07 7.01 6.97 6.93 7.02

Time in Months

Stock Prices in AUD

High Stock price

High 43466 43497 43525 43556 43586 43617 43647 43678 43709 43739 43770 43800 43831 43862 43891 43922 43952 43983 44013 44044 44075 44105 44136 44166 7.35 7.3650000000000002 7.2649999999999997 7.12 7.26 6.85 7.25 7.07 7.14 7.09 7.15 7.03 7.5750000000000002 8.7799999999999994 8.1259560000000004 7.746874 8.3397970000000008 9.25 9.6999999999999993 8.41 8.25 7.68 8.23 7.75

Time in Months

Stock Prices in AUD

Frequency 6 6.5 7 7.5 8 8.5 More 2 11 3 3 3 2 0

Ranges of Adjusted closing stock prices

Frequency

Frequency 20000000 30000000 40000000 50000000 60000000 More 8 11 2 2 1 0

Ranges of Stock volume

Frequency