𝑥_𝑖 𝑦_𝑖 (𝑥_(𝑖 − (𝑦_(𝑖 − (𝑌(𝑥_(𝑖

) ̅ )) − 𝑋 ̅ )) 〖 (𝑥_(𝑖 〖 (𝑦_(𝑖 − 𝑦 ̂ 〖 (𝑦_(𝑖 −〖 𝑌 ̂

(𝑌 ̂"
) ")"
−" 〗𝑌 ̅"
^2
𝑋 ̅ )) (𝑦_(𝑖 − − 𝑋 ̅ )) 〗 (𝑌 ) ̅ ) ") " ) " 〗 ^2
5 12 -30.00 -30.38 (𝑌 ) ̅911.54
)) ^2900.00 〗 ^2 923.22 10.18 3.33 1037.41
10 18 -25.00 -24.38 609.62 625.00 594.61 15.54 6.03 720.42
15 2 -20.00 -40.38 807.69 400.00 1630.92 20.91 357.67 461.07
20 30 -15.00 -12.38 185.77 225.00 153.38 26.28 13.84 259.35
25 36 -10.00 -6.38 63.85 100.00 40.76 31.65 18.94 115.27
30 42 -5.00 -0.38 1.92 25.00 0.15 37.02 24.84 28.82
35 47 0.00 4.62 0.00 0.00 21.30 42.38 21.30 0.00
40 50 5.00 7.62 38.08 25.00 57.99 47.75 5.05 28.82
45 54 10.00 11.62 116.15 100.00 134.92 53.12 0.77 115.27
50 58 15.00 15.62 234.23 225.00 243.84 58.49 0.24 259.35
55 63 20.00 20.62 412.31 400.00 424.99 63.86 0.73 461.07
60 67 25.00 24.62 615.38 625.00 605.92 69.23 4.95 720.42
65 72 30.00 29.62 888.46 900.00 877.07 74.59 6.73 1037.41
35.00 42.38 4885.00 4,550.00 5,709.08 551.00 464.41 5244.66

𝑏_1= (∑▒ 〖 (𝑥_(𝑖 𝑏_0=𝑦 ̅ − 𝑏_1 𝑦 ̂= 𝑏_0+ 𝑏_1 x

𝑋 ̅
− 𝑋 ̅ ))" " (𝑦_(𝑖 𝑥 ̅ 𝑦 ̂ = 4.81+1.07x
− (𝑌 4885.00
) ̅ ) ")
𝑏_0=
35.00
𝑌 ̂
ERE

"
𝑏_1=
42.38 4.80769231 Ecuación de regresión estimada

𝑏_0=
〗 )/(∑▒ 〖〖 (𝑥_(𝑖
4,550.00 4.81

− 𝑋 ̅ ))
𝑏_1= 〗 ^2 "
" 〗)
1.07

𝑟^(2 )=
SCR= ∑▒ 〖〖 (𝑌 ̂" 𝑆𝑇𝐶= ∑▒ 〖 (𝑦_(𝑖 − (𝑌 ) ̅ ) ") " 〗 ^2 𝑆𝐶𝑅/
− " 𝑌 ̅" ) " 〗 ^2 𝑆𝑇𝐶
𝑟^ 5244.66484
"" 〗 2=
SCR= 5244.66484 STC= 5709.07692307692
5709.07692

𝑟^
2=
0.92
𝑥_𝑖 𝑦_𝑖 (𝑥_(𝑖 − (𝑦_(𝑖 − (𝑌(𝑥_(𝑖
) ̅ )) − 𝑋 ̅ )) 〖 (𝑥_(𝑖 〖 (𝑦_(𝑖 − 𝑦 ̂ 〖 (𝑦_(𝑖 −〖 𝑌 ̂
(𝑌 ̂"
) ")"
−" 〗 𝑌 ̅"
^2
𝑋 ̅ )) (𝑦_(𝑖 − − 𝑋 ̅ )) 〗 (𝑌 ) ̅ ) ") " ) " 〗 ^2
5 12 -30 -30.38 (𝑌 ) ̅911.54
)) ^2900.00 〗 ^2923.22 8.45 12.5674146 1151.22252868
10 18 -25 -24.38 609.62 625.00 594.61 14.11 15.132955 799.460089361
15 2 -20 -40.38 807.69 400.00 1630.92 19.76 315.589368 511.654457191
20 30 -15 -12.38 185.77 225.00 153.38 0.00 900 0
25 36 -10 -6.38 63.85 100.00 40.76 0.00 1296 0
30 42 -5 -0.38 1.92 25.00 0.15 0.00 1764 0
35 47 0 4.62 0.00 0.00 21.30 0.00 2209 0
40 50 5 7.62 38.08 25.00 57.99 #VALUE! #VALUE! #VALUE!
45 54 10 11.62 116.15 100.00 134.92 0.00 2916 0
50 58 15 15.62 234.23 225.00 243.84 #VALUE! #VALUE! #VALUE!
55 63 12.62 20.62 260.07 159.15 424.99 3801.09 13973351.8 14448320.7249
60 67 60 24.62 1476.92 3600.00 605.92 0.00 4489 #VALUE!
65 72 65 29.62 1925.00 4225.00 877.07 #VALUE! #VALUE! #VALUE!
35 42.38 C$2,968.85 C$2,625.00 C$3,801.09 #VALUE! #VALUE! #VALUE!

𝑏_1= (∑▒ 〖 (𝑥_(𝑖 𝑏_0=𝑦 ̅ − 𝑏_1 𝑦 ̂= 𝑏_0+ 𝑏_1 x

𝑋 ̅ − 𝑋 ̅ ))" " (𝑦_(𝑖 − 𝑥 ̅ 𝑦 ̂ = 131.1 + 1.7
(𝑌 ) ̅ ) ") "
𝑏_0=
35
𝑌 ̂
ERE

𝑏_1= 2968.84615
x Ecuación de regresión estimada

〗 )/(∑▒ 2625〖〖 (𝑥_(𝑖

42.38 143-1.7(7)

𝑏_0=
− 𝑋 ̅ )) 〗 ^2 " " 〗 )
2.8

𝑏_1= 1.13

𝑟^(2 )=
SCR= ∑▒ 〖〖 (𝑌 ̂" 𝑆𝑇𝐶= ∑▒ 〖 (𝑦_(𝑖 − (𝑌 ) ̅ ) ") " 〗 ^2 𝑆𝐶𝑅/
− " 𝑌 ̅" ) " 〗 ^2 " " 𝑆𝑇𝐶
𝑟^ #VALUE!
〗 2=
SCR= #VALUE! STC= 3801.09467455621
3801.09467

𝑟^
2=
#VALUE!
 ECUACION DE REGRESION ESTIMADA / COEFICIENTE DE DETERMINACION

𝑏_1= (∑▒ 〖 (𝑥_(𝑖 −

𝑋 ̅ ))" " (𝑦_(𝑖 −
(𝑌 ) ̅ ) ") "
〗𝑏_0=𝑦 ̅
)/(∑▒ 〖〖 − (𝑥_(𝑖
𝑏_1 𝑥 ̅
−𝑦 ̂=
𝑋 ̅𝑏_0+
)) 〗 𝑏_1
^2 x"Ecuación
" 〗 )de regresión estimada

SCR= ∑▒ 〖〖 (𝑌 ̂"Suma − " delos Cuadrados debido a la Regresión

𝑌 ̅" ) " 〗 ^2 " " Suma〗 de Cuadrados de los Totales
𝑆𝑇𝐶=
∑▒ 〖 (𝑦_(𝑖 −
𝑆𝐶𝐸=
(𝑌 ) ̅ ) ")
∑▒
" 〗 ^2〖 (𝑦_(𝑖 − 𝑌 ̂ )
Suma de Cuadrados debido al ERROR

𝑟^(2 )=
" 〗 ^2
𝑆𝐶𝑅/𝑆𝑇𝐶
")

REGRESION Y CORRELACION LINEAL

𝑆_𝑋= √(∑▒ 〖〖 (𝑋 −
𝑥 ̅) 〗 ^2 " " 〗 )/(𝑛−1) r = (∑▒ 〖 (𝑥_(𝑖 −
𝑋 ̅ ))" " (𝑦_(𝑖 − (𝑌 ) ̅ )
") " 〗 )/( (𝑛−1)
𝑆_𝑦= √(∑▒ 〖〖 (𝑦 𝑆_𝑋 𝑆_𝑦 )
−𝑦 ̅ ) 〗 ^2 " " 〗 )/(𝑛−1)
𝑥_𝑖 𝑦_𝑖 (𝑥_(𝑖 − (𝑦_(𝑖 − (𝑌(𝑥_(𝑖
) ̅ )) − 𝑋 ̅ )) 〖 (𝑥_(𝑖 〖 (𝑦_(𝑖 − 𝑦 ̂ 〖 (𝑦_(𝑖 − 𝑌 ) ")""- "〗𝑌
〖 ( ̂𝑌 ̂ ^2
𝑋 ̅ )) (𝑦_(𝑖 − (𝑌 ) ̅ )) (𝑌 ) ̅ ) ") " 〗 ^2
 ̅" )

𝑋 ̅ )) 9〗 ^2 " 〗 ^2
−
4 134 -3 -9 27 81 137.9 15.21 26.01
6 145 -1 2 -2 1 4 141.3 13.69 2.89
8 149 1 6 6 1 36 144.7 18.49 2.89
10 144 3 1 3 9 1 148.1 16.81 26.01

7 143 34 20 122 572 64.2 57.8

𝑏_1= (∑▒ 〖 (𝑥_(𝑖 𝑏_0=𝑦 ̅ − 𝑏_1 𝑦 ̂= 𝑏_0+ 𝑏_1 x

𝑋 ̅ − 𝑋 ̅ ))" " (𝑦_(𝑖 − 𝑥 ̅ 𝑦 ̂ = 131.1 + 1.7
(𝑌 ) ̅ ) ")34"
𝑏_0=
7
𝑌 ̂
ERE

𝑏_1=
x Ecuación de regresión estimada

〗 )/(∑▒ 20 〖〖 (𝑥_(𝑖
143 143-1.7(7)

𝑏_0=
− 𝑋 ̅ )) 〗 ^2 " " 〗 )
131.1

𝑏_1= 1.7

SCR= ∑▒ 〖〖 (𝑌 ̂" 𝑆𝑇𝐶= ∑▒ 〖 (𝑦_(𝑖 − (𝑌 ) ̅ ) ") " 〗 ^2 𝑟^(2 )=

− " 𝑌 ̅" ) " 〗 ^2 𝑆𝐶𝑅/
"SCR=
" 〗 𝑆𝑇𝐶57.8
𝑟^
2=
57.8 STC= 122
122

𝑟^
2=
0.47
 〖 (𝑌 ̂" - " 𝑌 ̅" )
" 〗 ^2

Ecuación de regresión estimada