Question

Instructions:

You must use Excel or a similar statistical software package, such as SPSS, for your assignment.

Tasks:

1.Select thirty stocks (at least 3 different industries) that are listed on the Toronto Stock Exchange.

2.Track each stock’s closing price at the end of the trading day. These closing prices will appear on the Internet. Collect the stock closing price data from January 2017 to December 2019.

4. For each stock, use your data to calculate and interpret: (show calculations)

a)the mean price

b)the median price

c) the standard deviation

d) the range

e) the interquartile range

f)the coefficient of variation

g) 90% confidence interval of mean price using t as the sampling distribution

Answer 1

1.

Symbol	Value
BBD.B	2192926
ACB	3980134
AC	51648153
SU	50007633
MFC	39422375
TD	1.21E+08
ABX	53614527
CNQ	27623788
BTE	635699.4
ENB	76614244
CPG	1918041
CVE	4900995
XIU	32554663
K	9926848
IPL	13638751
BTO	6258014
PPL	39026541
WCP	1251906
AQN	18058138
TECK.B	11682180
TOG	630674.3
BIR	775210
FM	7769553
BNS	56614868
BPY.UN	11670734
RY	78418795
MEG	1370604
BCE	44793831
REI.UN	13576221
HSE	2900126

2.

Symbol	Close
BBD.B	0.48
ACB	1.06
AC	17.9
SU	19.11
MFC	16.7
TD	58.9
ABX	27.06
CNQ	14.23
BTE	0.355
ENB	40.52
CPG	1.03
CVE	2.84
XIU	20.09
K	6.63
IPL	10.13
BTO	5.16
PPL	31.34
WCP	1.17
AQN	17.03
TECK.B	10.97
TOG	0.62
BIR	0.74
FM	7.14
BNS	56.74
BPY.UN	12.57
RY	84.91
MEG	1.5
BCE	53.51
REI.UN	15.5
HSE	3.57

4.

mean	2,61,51,976.809167
median	1,26,29,200.120000
sample standard deviation	2,96,79,901.464332
minimum	630674.26
maximum	121083133.1
range	120452458.9
interquartile range	4,02,80,838.892500
coefficient of variation (CV)	113.49%
confidence interval 90.% lower	1,69,44,774.726309
confidence interval 90.% upper	3,53,59,178.892025
margin of error	92,07,202.082858
t(df = 29)	1.699

Please give me a thumbs-up if this helps you out. Thank you!