Scribd
Upload
7 views3 pages

Linear Regression Excel Test

The document presents a dataset with calculations related to the correlation between two variables, x and y, including means, deviations, and regression analysis. It shows a correlation coefficient (r) of 0.795, indicating a strong positive relationship, and provides a linear regression equation f(x) = 0.11737509x + 83.2673537 with an R² value of 0.632. The data is summarized in a table format with various statistical metrics calculated for each data point.

Uploaded by

magnus.li.hartono
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
7 views3 pages

Linear Regression Excel Test

The document presents a dataset with calculations related to the correlation between two variables, x and y, including means, deviations, and regression analysis. It shows a correlation coefficient (r) of 0.795, indicating a strong positive relationship, and provides a linear regression equation f(x) = 0.11737509x + 83.2673537 with an R² value of 0.632. The data is summarized in a table format with various statistical metrics calculated for each data point.

Uploaded by

magnus.li.hartono
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

x y xi - x bar (1) yi - y bar(2) xi - x bar * yi - y bar (1) (2) xi - x bar^2 yi - y bar^2

576 178 -136.666667 11.08333333 -1514.72222222222 18677.7777778 122.840278


370 138 -342.666667 -28.9166667 9908.77777777777 117420.444444 836.173611
612 94 -100.666667 -72.9166667 7340.27777777777 10133.7777778 5316.84028
1216 278 503.3333333 111.0833333 55911.9444444445 253344.444444 12339.5069
409 158 -303.666667 -8.91666667 2707.69444444444 92213.4444444 79.5069444
1502 258 789.3333333 91.08333333 71895.1111111111 623047.111111 8296.17361
946 198 233.3333333 31.08333333 7252.77777777778 54444.4444444 966.173611
998 188 285.3333333 21.08333333 6015.77777777778 81415.1111111 444.506944
189 98 -523.666667 -68.9166667 36089.3611111111 274226.777778 4749.50694
787 179 74.33333333 12.08333333 898.194444444446 5525.44444444 146.006944
210 138 -502.666667 -28.9166667 14535.4444444444 252673.777778 836.173611
737 98 24.33333333 -68.9166667 -1676.97222222222 592.111111111 4749.50694
712.666667 166.916667 209363.666666667 1783714.66667 38882.9167

r= 0,795
m= 0.11737509
c= 83.2673537
y
300

250 f(x) = 0.117375088392314 x + 83.267353672411


R² = 0.632001942956241

200

150

100

50

0
0 200 400 600 800 1000 1200 1400 1600
00 1600

You might also like