Scribd
Upload
21 views7 pages

REGRESION

Uploaded by

Yeffren Yasir Soto

The document contains population pyramid data for urban and rural areas of Huancavelica, Peru from 2000 to 2027. It shows population numbers broken down by age group and sex. It also includes a linear regression analysis to project the total population for the years 2020 to 2024. The regression analysis uses population data from 2010 to 2019 to estimate the trend line equation and population numbers in the coming years.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt

REGRESION

Uploaded by

Yeffren Yasir Soto
21 views7 pages
The document contains population pyramid data for urban and rural areas of Huancavelica, Peru from 2000 to 2027. It shows population numbers broken down by age group and sex. It also includes a linear regression analysis to project the total population for the years 2020 to 2024. The regression analysis uses population data from 2010 to 2019 to estimate the trend line equation and population numbers in the coming years.

Original Title

REGRESION.xlsx

Copyright

© © All Rights Reserved

Available Formats

XLSX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

The document contains population pyramid data for urban and rural areas of Huancavelica, Peru from 2000 to 2027. It shows population numbers broken down by age group and sex. It also includes a linear regression analysis to project the total population for the years 2020 to 2024. The regression analysis uses population data from 2010 to 2019 to estimate the trend line equation and population numbers in the coming years.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
21 views7 pages

REGRESION

Uploaded by

Yeffren Yasir Soto
The document contains population pyramid data for urban and rural areas of Huancavelica, Peru from 2000 to 2027. It shows population numbers broken down by age group and sex. It also includes a linear regression analysis to project the total population for the years 2020 to 2024. The regression analysis uses population data from 2010 to 2019 to estimate the trend line equation and population numbers in the coming years.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 7

EDAD URBANA RURAL

< de 1 -1775.00 3969


[0-4] -7788.00 18183
[5-9] -10265.00 23773
[10-14] -10930.00 28746 PIRAMIDE POBLACIONAL DE HUAN
[15-19] -10619.00 24686 -7105.00 26245
[65 a mas
[20-24] -9941.00 16460 [60-64] -2871.00 9190
[25-29] -8813.00 13760 [55-59] -3707.00 10850
[30-34] -8440.00 14288 [50-54] -4617.00 12398
[35-39] -7383.00 13512 [45-49] -5245.00 12369
[40-44] -6363.00 13348 [40-44] -6363.00 13348
[45-49] -5245.00 12369 [35-39] -7383.00 13512
[30-34] -8440.00 14288
[50-54] -4617.00 12398
[25-29] -8813.00 13760
[55-59] -3707.00 10850
[20-24] -9941.00 16460
[60-64] -2871.00 9190 -10619.00 24686
[15-19]
[65 a mas -7105.00 26245 [10-14] -10930.00 28746
[5-9] -10265.00 23773
[0-4] -7788.00 18183
< de 1 -1775.00
3969

URBANA RURAL
POBLACIONAL DE HUANCAVELICA
.00 26245
871.00 9190
707.00 10850
17.00 12398
45.00 12369
3.00 13348
00 13512
00 14288
0 13760
16460
24686
28746
0 23773
00 18183
1775.00
3969

URBANA RURAL
Pob(2017) = pob(2007) (1+tc)^n
4381 4114 (1+tc)^n 2074 2307
VARONES MUJERES
tc = 0.00630793 0.0041430057 0.00829893
tc = 0.63079335 0.4143005725 0.82989344

VARONES
Pob(2018) = Pob(2017) (1+tc)^1 2082.5925939
4381
Pob(2018) = 4409 2083 2326
Pob(2019) = 4436 2091 2345
Pob(2020) = 4464 2100 2365
Pob(2021) = 4493 2109 2385
Pob(2022) 4521 2117 2404
Pob(2023) 4549 2126 2424
Pob(2024) 4578 2135 2444
Pob(2025) 4607 2144 2465
Pob(2026) 4636 2153 2485
Pob(2027) 4665 2162 2506
1.24419401
AÑO X Y (X- Ẍ) (Y- Ȳ) ∑(X- Ẍ)(Y- Ȳ) ∑(X- Ẍ)2
2010 -9 74 -7 -23.8 166.6 49
2011 -8 78 -6 -19.8 118.8 36
2012 -7 85 -5 -12.8 64 25
2013 -6 95 -4 -2.8 11.2 16
2014 -5 100 -3 2.2 -6.6 9
2015 -4 103 -2 5.2 -10.4 4
2016 -3 110 -1 12.2 -12.2 1
2017 -2 111 0 13.2 0 0
2018 -1 114 1 16.2 16.2 1
2019 0 108 2 10.2 20.4 4
2020 1
2021 2
2022 3
2023 4
2024 5
SUMA 368 145

SUMA -30 978


PROMEDIO -2 97.8
B1= 2.53793103
B0= 102.875862
Ŷ = a + b*X AÑO Y Ŷ = a + b*X
80 2010 74 80
83 2011 78 83
85 2012 85 85
88 2013 95 88
90 2014 100 90
93 2015 103 93
95 2016 110 95
98 2017 111 98
100 2018 114 100
103 2019 108 103
105 2020 105
108 2021 108
110 2022 110
113 2023 113
116 2024 116
PROYECCION CON REGRESION L
140

120

100

80

60

40

20

0
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 20

Y Ŷ = a + b*X
ION CON REGRESION LINEAL

2015 2016 2017 2018 2019 2020 2021 2022 2023 2024

Y Ŷ = a + b*X

You might also like