Steps: :: 1) Plot the values of X and Y on the scatter chart using
2) use the Trendline to understand the direction of the c
3) Find correlation using correl function
X Y (x-xbar) (y-ybar) (x-xbar)^2(y-ybar)^2
8 5 -4 -4 16 16
10 7 -2 -2 4 4
12 9 0 0 0 0
11 8 -1 -1 1 1
9 6 -3 -3 9 9
7 4 -5 -5 25 25
13 10 1 1 1 1
14 11 2 2 4 4
15 12 3 3 9 9
17 14 5 5 25 25
16 13 4 4 16 16
12 9 0 0 110 110
X-X Bar Y-Y Bar
Q2
HEIGHT - FATHER HEIGHT - SON (x-xbar) (y-ybar) (x-xbar)^2(y-ybar)^2
X Y
65 68
63 66
67 68
64 65
68 69
62 66
70 68
66 65
68 71
67 67
69 68
71 70
\
Q3 x y (x-xbar) (y-ybar) (x-xbar)^2(y-ybar)^2
2 10 -5.875 4.375 34.51563 19.14063
3 7 -4.875 1.375 23.76563 1.890625
5 8 -2.875 2.375 8.265625 5.640625
6 5 -1.875 -0.625 3.515625 0.390625
9 6 1.125 0.375 1.265625 0.140625
11 2 3.125 -3.625 9.765625 13.14063
12 5 4.125 -0.625 17.01563 0.390625
15 2 7.125 -3.625 50.76563 13.14063
7.875 5.625 0 0 148.875 53.875
Q4 English Score Science Score
2 18
10 12
18 6
4 3
9 11
7 20
18 4
19 17
3 7
10 2
Q5
Time (minutes) Temprature Degree
0 95
1 89
2 81
4 76
5 72
8 55
10 45
X and Y on the scatter chart using insert menu
to understand the direction of the correlation
using correl function
(x-xbar)(y-ybar)
16
4 INTERPRETATION
0
1
9
25 correlation 1
1
4
9
25 rank correlation 1
16
110 COVARIANCE 10
rank correlation
(x-xbar)(y-ybar)
INTERPRETATION
correlation
Covariance
rank correlation
(x-xbar)(y-ybar)
-25.703125
y
-6.703125 INTERPRETATION
12
10
8
6
y
12
-6.828125
10
1.171875
8
0.421875
6
-11.328125 correlation -0.8640
4
-2.578125
2
-25.828125 HIGH degree negative correlation
-77.375 INSERT THE TRENDLINE 0
0 2 4 6 8 10 12
INTERPRETATION
correlation
INSERT THE TRENDLINE
INTERPRETATION
Values are not scattered, they lie in a straight line
This indicates the correlation is linear
correlation
INSERT THE TRENDLINE N TELL US ABOUT CORRELATION
y
y
4 6 8 10 12 14 16
Regression Steps: :: R1) Find out Intercept and Slope using the function or using da
R2) Find the values of Estimated Y
Q1 R3) Plot the value of X and Y, Estimated Y on the Scatter Diagra
X Y Estimated Y
8 5 5
10 7 7 Intercept -3
12 9 9
11 8 8
9 6 6 Slope 1
7 4 4
13 10 10 Y=a+bX
14 11 11 Line of Best Fit
15 12 12 Regression Line
17 14 14
16 13 13
Q2
HEIGHT - FATHER HEIGHT - SON Estimated Y
X Y Intercept 35.8248031496063
65 68 66.7893701
63 66 65.8366142
67 68 67.742126 Slope 0.476377952755906
64 65 66.3129921
68 69 68.2185039 Y=a+bX
62 66 65.3602362 Line of Best Fit
70 68 69.1712598 Regression Line
66 65 67.265748
68 71 68.2185039
67 67 67.742126
69 68 68.6948819
71 70 69.6476378
Q3 x y Estimated Y
2 10
3 7 Intercept
5 8
6 5
9 6 Slope
11 2
12 5 Y=a+bX
15 2 Line of Best Fit
Regression Line
Q4 English Score Science Score Estimated Y
2 18 0
10 12 0 Intercept
18 6 0
4 3 0
9 11 0 Slope
7 20 0
18 4 0 Y=a+bX
19 17 0 Line of Best Fit
3 7 0 Regression Line
10 2 0
Q5
Time (minutes) Temprature DegreeEstimated Y
0 95 0
1 89 0 Intercept
2 81 0
4 76 0
5 72 0 Slope
8 55 0
10 45 0 Y=a+bX
Line of Best Fit
Regression Line
pe using the function or using data analysis
Estimated Y on the Scatter Diagram
Y
16
14
12
10
0
6 8 10 12 14 16 18
Chart Title
72
71
70
69
68
67
66
65
64
63
62
60 62 64 66 68 70 72
ORIGINAL CHIANGE IN ORIGIN
Q1 x y X
2 10 6
3 7 7
5 8 9
6 5 10
9 6 13
11 2 15
12 5 16
15 2 19
CORRELATION -0.863965 -0.86396496821726
REGRESSION INTERCEPT 9.717884 INTERCEPT 15.7968094038623
SLOPE -0.519731 SLOPE -0.51973131821998
LEARNINGS
1 CHANGE IN ORIGIN
CORRELATION is independent of change in origin INDEPENDENT
REGRESSION is independent on change in origin DEPENDENT
2 CHANGE IN SCALE
CORRELATION is independent of change in scale INDEPENDENT
REGRESSION is depenent on change in scale DEPENDENT
CHANGE IN SCALE
Y X Y
14 10 50
11 15 35
12 25 40
9 30 25
10 45 30
6 55 10
9 60 25
6 75 10
-0.863965
INTERCEPT 48.58942
SLOPE -0.519731
time seriesusing least square
X YEAR PRICES Estimated Y
0 2000 698.90 720.18 Intercept 720.180434782609
1 2001 704.50 720.07
2 2002 712.90 719.95
3 2003 727.50 719.84 Slope -0.114426877470355
4 2004 731.25 719.72
5 2005 736.00 719.61
6 2006 725.45 719.49
7 2007 718.40 719.38
8 2008 710.05 719.27
9 2009 727.35 719.15
10 2010 720.75 719.04
11 2011 723.15 718.92
12 2012 730.85 718.81
13 2013 721.05 718.69
14 2014 723.40 718.58
15 2015 722.25 718.46
16 2016 720.95 718.35
17 2017 717.55 718.24
18 2018 720.30 718.12
19 2019 709.85 718.01
20 2020 711.20 717.89
21 2021 707.10 717.78
22 2022 714.50 717.66
26 2026 717.21
