0% found this document useful (0 votes)
32 views9 pages

Stock Correlation Problem

Stock Correlation Problem

Uploaded by

Shalakha Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
32 views9 pages

Stock Correlation Problem

Stock Correlation Problem

Uploaded by

Shalakha Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Data on Company Returns (%) Analytical Insights

Year ABC Company XYZ Company Parameter


2017 5 5 Covariance
2018 12 15 Correlation
2019 -11 5
2020 10 7
2021 12 -10

Analytical Insights
Parameter
Covariance
Correlation
Average driving speed
Analytical Insights (km/hr)
Values 52
-5.80 60
-0.07 32
65
40
44
80
30
60
65

Analytical Insights
Values
-48.89
-0.97
Mileage (km/litre)
25
25
28
22
28
26
20
30
24
22
Compensation package offered (hundred thousand dollars per
annum)
7
9.4
11.5
13.8
14.2
15
16.6
102
Total students hired

MEAN
MEDIAN
MODE

IQR
Number of students who were offered this compensation
compensation
6 7
1 7
1 7
1 7
1 7
1 7
1 9.4
1 11.5
13 13.8
14.2
15
17.2692307692308 16.6
9.4 102
7

7.2
No.of students
1
2
3
4
5
6
1
1
1
1
1
1
1
Roll Number Section A Section B Section A Section B
Student 1 8.2 8.1 MEAN 8.075 8.030833
Student 2 7.2 7.9 STDDEV. 0.731282 0.124277
Student 3 6.5 8.2
Student 4 8.9 7.95
Student 5 8.1 8.08
Student 6 8 7.8
Student 7 7.7 7.9
Student 8 7.9 8.04
Student 9 8.1 8.08
Student 10 8.3 8.12
Student 11 9 8.2
Student 12 9 8
Employee Distance from office (kilometres or km)
A 0.5 MEDIAN 3
B 1.2 MODE 2.5
C 2.3
D 2.5
E 2.5
F 3
G 3.3
H 4
I 7
J 9
K 200
Day of the Week Blog Traffic E-commerce Website Traffic
Monday 1,354 1,235
Tuesday 1,646 1,756
Wednesday 1,432 1,678
Thursday 1,356 1,261
Friday 1,562 1,501
Saturday 1,370 111,200
Sunday 1,501 1,821

MEAN 1,460 17,207


MEDIAN 1,432 1,678
MODE #VALUE! #VALUE!
STDDEV 113.737165681 41447.4655874041
IQR 168.5 407.5

You might also like