Scribd
Upload
6 views4 pages

Correlation Analysis and Regression Model

The document discusses statistical concepts such as mean, median, mode, trend lines, correlation, and coefficients. It provides a sample dataset with 12 data points showing a year and corresponding value. It then performs a linear regression on the data, finding a perfect correlation of 1, a slope of 11, and y-intercept of 45. It plots the linear trendline and data, showing a concentration above the mode. It notes that a smaller p-value and R^2 greater than 0.5 indicate a good model fit.

Uploaded by

ABHISHEK CHAKRABORTY
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
6 views4 pages

Correlation Analysis and Regression Model

The document discusses statistical concepts such as mean, median, mode, trend lines, correlation, and coefficients. It provides a sample dataset with 12 data points showing a year and corresponding value. It then performs a linear regression on the data, finding a perfect correlation of 1, a slope of 11, and y-intercept of 45. It plots the linear trendline and data, showing a concentration above the mode. It notes that a smaller p-value and R^2 greater than 0.5 indicate a good model fit.

Uploaded by

ABHISHEK CHAKRABORTY
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

skewnwss

kurtosis laptokurtic mesokurtic platykurticto check what is the conce


mean
median
mode
trend line
corelation (-1 to 1) relation btwn two arrays
coefficient (

1 56 2000
2 67 2001
3 78 2002
4 89 2003
5 100 2004
6 111 2005
7 122 2006
8 133 2007
9 144 2008
10 155 2009
11 166 2010
12 177 2011

correlation= 1

SUMMARY OUTPUT

Regression Statistics
Multiple R 1
R Square 1
Adjusted R Square 1
Standard Error 0
Observations 12

ANOVA
df SS MS F Significance F
Regression 1 17303 17303 #NUM! #NUM!
Residual 10 0 0
Total 11 17303

Coefficients Standard Error t Stat P-value Lower 95%


Intercept 45 0 65535 #NUM! 45
X Variable 1 11 0 65535 #NUM! 11
to check what is the concentration above the mode

200

180
f(x) = 11 x + 45
160 R² = 1

140

120

100 Column C
Linear (Column C)
80

60

40

20

0
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011

200
180
160
140
120
100
80 Column C

60
40
20
0
0 2 4 6 8 10 12 14

Significance F
how small the significant value will be the best is the good fit of the model

Upper 95%Lower 95.0%


Upper 95.0%
45 45 45
11 11 11
R^2= is greater than 0.5 then the model is a good fit
corelation coefficent

You might also like