Stats II

Author

Jacob M. Souch

Quarto

Quarto enables you to weave together content and executable code into a finished document. To learn more about Quarto see https://quarto.org.

Running Code

library(ipumsr)

ddi <- read_ipums_ddi("usa_00013.xml")
data <- read_ipums_micro(ddi)
Use of data from IPUMS USA is subject to conditions including that users should
cite the data appropriately. Use command `ipums_conditions()` for more details.
library(tidyverse)
Warning: package 'tidyverse' was built under R version 4.2.3
Warning: package 'ggplot2' was built under R version 4.2.3
Warning: package 'tibble' was built under R version 4.2.3
Warning: package 'readr' was built under R version 4.2.3
Warning: package 'forcats' was built under R version 4.2.3
Warning: package 'lubridate' was built under R version 4.2.3
── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
✔ dplyr     1.0.10     ✔ readr     2.1.4 
✔ forcats   1.0.0      ✔ stringr   1.5.0 
✔ ggplot2   3.4.2      ✔ tibble    3.2.1 
✔ lubridate 1.9.2      ✔ tidyr     1.3.0 
✔ purrr     1.0.1      
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()
ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
data <- data %>% filter( SEX== 2) 
cleaneddata <- data %>% filter(FERTYR %in%  c(0,1,2) & MIGRATE1 %in% c(0,1,2,3,4))

proportions(table(cleaneddata$FERTYR, cleaneddata$MIGRATE1, cleaneddata$STATEFIP)) 
, ,  = 1

   
               0            1            2            3            4
  0 1.404395e-04 8.210467e-03 6.085713e-04 1.327678e-04 1.816163e-05
  1 0.000000e+00 5.179197e-03 8.559452e-04 2.182527e-04 2.066669e-05
  2 0.000000e+00 2.591164e-04 6.904552e-05 1.252526e-05 1.722224e-06

, ,  = 2

   
               0            1            2            3            4
  0 3.162629e-05 9.021321e-04 7.170714e-05 2.332830e-05 3.131316e-06
  1 0.000000e+00 7.003188e-04 1.296365e-04 4.587378e-05 6.419198e-06
  2 0.000000e+00 4.994449e-05 1.393436e-05 3.287882e-06 6.262632e-07

, ,  = 4

   
               0            1            2            3            4
  0 2.127729e-04 1.049257e-02 9.702383e-04 3.276922e-04 5.072732e-05
  1 0.000000e+00 6.750491e-03 1.361183e-03 3.793589e-04 5.996470e-05
  2 0.000000e+00 3.596316e-04 1.011415e-04 2.332830e-05 4.227277e-06

, ,  = 5

   
               0            1            2            3            4
  0 8.924250e-05 4.928535e-03 4.175610e-04 9.018190e-05 7.358593e-06
  1 0.000000e+00 3.020311e-03 5.728743e-04 1.282274e-04 1.174243e-05
  2 0.000000e+00 1.456062e-04 4.869196e-05 8.611119e-06 6.262632e-07

, ,  = 6

   
               0            1            2            3            4
  0 1.161405e-03 5.605995e-02 4.474651e-03 4.479347e-04 2.739901e-04
  1 0.000000e+00 4.310742e-02 7.404936e-03 8.642432e-04 4.690711e-04
  2 0.000000e+00 2.182997e-03 5.371773e-04 4.524752e-05 2.458083e-05

, ,  = 8

   
               0            1            2            3            4
  0 1.756668e-04 7.962623e-03 6.840360e-04 1.921062e-04 2.332830e-05
  1 0.000000e+00 5.617424e-03 1.189117e-03 3.679296e-04 5.213641e-05
  2 0.000000e+00 2.930912e-04 8.141422e-05 1.581315e-05 2.974750e-06

, ,  = 9

   
               0            1            2            3            4
  0 9.331322e-05 6.109511e-03 3.724700e-04 8.376270e-05 2.097982e-05
  1 0.000000e+00 4.054584e-03 5.221469e-04 1.715961e-04 3.522730e-05
  2 0.000000e+00 1.808335e-04 3.240912e-05 8.924250e-06 1.565658e-06

, ,  = 10

   
               0            1            2            3            4
  0 2.614649e-05 1.553133e-03 7.922229e-05 4.900509e-05 4.696974e-06
  1 0.000000e+00 9.439352e-04 1.199294e-04 6.012127e-05 8.924250e-06
  2 0.000000e+00 4.650004e-05 7.515158e-06 1.878790e-06 1.565658e-07

, ,  = 11

   
               0            1            2            3            4
  0 1.910103e-05 8.568846e-04 4.775257e-05 2.505053e-05 5.949500e-06
  1 0.000000e+00 8.157078e-04 1.462325e-04 1.755103e-04 2.458083e-05
  2 0.000000e+00 3.835862e-05 4.696974e-06 3.287882e-06 4.696974e-07

, ,  = 12

   
               0            1            2            3            4
  0 5.096217e-04 3.286207e-02 2.735204e-03 9.165362e-04 1.955507e-04
  1 0.000000e+00 1.941212e-02 3.677261e-03 8.542230e-04 2.176265e-04
  2 0.000000e+00 9.052634e-04 2.469043e-04 4.524752e-05 9.550514e-06

, ,  = 13

   
               0            1            2            3            4
  0 3.140710e-04 1.493481e-02 1.253309e-03 3.123488e-04 4.477782e-05
  1 0.000000e+00 1.064162e-02 2.007174e-03 5.091520e-04 7.750007e-05
  2 0.000000e+00 5.564348e-04 1.518688e-04 3.679296e-05 3.914145e-06

, ,  = 15

   
               0            1            2            3            4
  0 4.493438e-05 2.278815e-03 1.387173e-04 5.448490e-05 1.581315e-05
  1 0.000000e+00 1.470623e-03 1.808335e-04 1.033334e-04 2.692932e-05
  2 0.000000e+00 8.438897e-05 1.800507e-05 8.767685e-06 1.252526e-06

, ,  = 16

   
               0            1            2            3            4
  0 6.059096e-05 2.586154e-03 2.063537e-04 8.047482e-05 6.106066e-06
  1 0.000000e+00 1.592587e-03 3.029548e-04 1.153890e-04 7.358593e-06
  2 0.000000e+00 1.019243e-04 3.225255e-05 8.767685e-06 1.565658e-07

, ,  = 17

   
               0            1            2            3            4
  0 3.868741e-04 2.052593e-02 1.439153e-03 1.924194e-04 5.667682e-05
  1 0.000000e+00 1.433250e-02 2.269891e-03 3.967377e-04 1.131971e-04
  2 0.000000e+00 7.225512e-04 1.604799e-04 2.097982e-05 5.949500e-06

, ,  = 18

   
               0            1            2            3            4
  0 2.165305e-04 1.075998e-02 8.633038e-04 1.431011e-04 2.051012e-05
  1 0.000000e+00 7.126562e-03 1.335350e-03 2.509750e-04 4.211620e-05
  2 0.000000e+00 3.821771e-04 1.008284e-04 1.518688e-05 1.878790e-06

, ,  = 19

   
               0            1            2            3            4
  0 1.014546e-04 5.381166e-03 3.752882e-04 6.747986e-05 8.767685e-06
  1 0.000000e+00 3.179069e-03 5.677076e-04 1.301062e-04 1.659597e-05
  2 0.000000e+00 1.822426e-04 4.133337e-05 7.202027e-06 1.565658e-07

, ,  = 20

   
               0            1            2            3            4
  0 1.052122e-04 4.719363e-03 3.900054e-04 8.767685e-05 1.299496e-05
  1 0.000000e+00 2.899599e-03 5.332631e-04 1.385607e-04 2.458083e-05
  2 0.000000e+00 1.664294e-04 4.712631e-05 1.236870e-05 1.252526e-06

, ,  = 21

   
               0            1            2            3            4
  0 1.382476e-04 7.362037e-03 5.684904e-04 1.155456e-04 1.596971e-05
  1 0.000000e+00 4.675055e-03 8.426371e-04 2.004042e-04 2.536366e-05
  2 0.000000e+00 2.325002e-04 6.638390e-05 1.221213e-05 1.722224e-06

, ,  = 22

   
               0            1            2            3            4
  0 1.376213e-04 7.257764e-03 5.800763e-04 8.861624e-05 1.111617e-05
  1 0.000000e+00 4.620570e-03 8.005209e-04 1.631416e-04 2.505053e-05
  2 0.000000e+00 2.497224e-04 6.293945e-05 1.095961e-05 1.409092e-06

, ,  = 23

   
               0            1            2            3            4
  0 3.068690e-05 2.300734e-03 1.374648e-04 4.305559e-05 3.287882e-06
  1 0.000000e+00 1.325016e-03 2.060406e-04 6.340915e-05 6.575764e-06
  2 0.000000e+00 6.012127e-05 1.236870e-05 2.348487e-06 3.131316e-07

, ,  = 24

   
               0            1            2            3            4
  0 1.844345e-04 9.660893e-03 6.079450e-04 1.517123e-04 4.242933e-05
  1 0.000000e+00 6.780708e-03 9.115261e-04 3.121922e-04 7.014148e-05
  2 0.000000e+00 3.546215e-04 6.951521e-05 1.941416e-05 3.601013e-06

, ,  = 25

   
               0            1            2            3            4
  0 1.936719e-04 1.116283e-02 6.960915e-04 1.186769e-04 4.008084e-05
  1 0.000000e+00 8.041533e-03 1.273506e-03 3.998690e-04 1.182072e-04
  2 0.000000e+00 3.590054e-04 8.016169e-05 1.471719e-05 3.914145e-06

, ,  = 26

   
               0            1            2            3            4
  0 2.941871e-04 1.666784e-02 1.167198e-03 1.560961e-04 3.350508e-05
  1 0.000000e+00 1.050322e-02 1.800350e-03 2.368841e-04 5.808591e-05
  2 0.000000e+00 5.212075e-04 1.244698e-04 1.581315e-05 4.696974e-06

, ,  = 27

   
               0            1            2            3            4
  0 1.665860e-04 9.008953e-03 5.706823e-04 9.049503e-05 2.113638e-05
  1 0.000000e+00 5.676919e-03 8.537533e-04 1.684648e-04 3.460104e-05
  2 0.000000e+00 3.234649e-04 6.074753e-05 7.828290e-06 1.565658e-06

, ,  = 28

   
               0            1            2            3            4
  0 9.409604e-05 4.939651e-03 3.768539e-04 7.342936e-05 6.888895e-06
  1 0.000000e+00 3.213513e-03 5.091520e-04 1.113183e-04 9.550514e-06
  2 0.000000e+00 1.656466e-04 4.164650e-05 8.297987e-06 3.131316e-07

, ,  = 29

   
               0            1            2            3            4
  0 1.958638e-04 1.005215e-02 8.429503e-04 1.564092e-04 1.628284e-05
  1 0.000000e+00 6.412465e-03 1.222622e-03 2.905861e-04 3.131316e-05
  2 0.000000e+00 3.352074e-04 9.002533e-05 1.346466e-05 1.878790e-06

, ,  = 30

   
               0            1            2            3            4
  0 2.771215e-05 1.685274e-03 1.144496e-04 3.914145e-05 2.661619e-06
  1 0.000000e+00 9.494150e-04 1.643941e-04 6.200006e-05 6.732329e-06
  2 0.000000e+00 5.104045e-05 9.863645e-06 1.565658e-06 0.000000e+00

, ,  = 31

   
               0            1            2            3            4
  0 6.513137e-05 3.132412e-03 2.331265e-04 4.743944e-05 6.262632e-06
  1 0.000000e+00 1.898830e-03 3.530559e-04 8.157078e-05 1.048991e-05
  2 0.000000e+00 1.135102e-04 3.193942e-05 5.323237e-06 3.131316e-07

, ,  = 32

   
               0            1            2            3            4
  0 8.438897e-05 4.049887e-03 3.932933e-04 1.548436e-04 1.440405e-05
  1 0.000000e+00 2.825073e-03 5.365510e-04 1.849042e-04 2.348487e-05
  2 0.000000e+00 1.503032e-04 3.835862e-05 1.456062e-05 2.661619e-06

, ,  = 33

   
               0            1            2            3            4
  0 3.350508e-05 2.249537e-03 1.238435e-04 4.884853e-05 3.757579e-06
  1 0.000000e+00 1.423966e-03 1.944547e-04 8.282331e-05 1.252526e-05
  2 0.000000e+00 6.481824e-05 8.611119e-06 2.974750e-06 1.565658e-07

, ,  = 34

   
               0            1            2            3            4
  0 2.553588e-04 1.479202e-02 8.130462e-04 1.622022e-04 6.200006e-05
  1 0.000000e+00 1.047253e-02 1.122107e-03 3.048336e-04 1.020809e-04
  2 0.000000e+00 5.273136e-04 8.470210e-05 1.894446e-05 5.323237e-06

, ,  = 35

   
               0            1            2            3            4
  0 6.669703e-05 3.239190e-03 2.091719e-04 7.452532e-05 7.358593e-06
  1 0.000000e+00 1.997466e-03 2.874548e-04 9.519201e-05 1.377779e-05
  2 0.000000e+00 1.110052e-04 2.458083e-05 6.419198e-06 9.393948e-07

, ,  = 36

   
               0            1            2            3            4
  0 5.797632e-04 3.234618e-02 1.816633e-03 2.198184e-04 1.142930e-04
  1 0.000000e+00 2.292327e-02 3.081528e-03 6.594551e-04 2.472174e-04
  2 0.000000e+00 1.127274e-03 2.094850e-04 2.285861e-05 9.393948e-06

, ,  = 37

   
               0            1            2            3            4
  0 2.960659e-04 1.598349e-02 1.175183e-03 3.644852e-04 3.835862e-05
  1 0.000000e+00 1.042963e-02 1.922002e-03 5.349853e-04 6.654046e-05
  2 0.000000e+00 5.208944e-04 1.304193e-04 3.381821e-05 3.914145e-06

, ,  = 38

   
               0            1            2            3            4
  0 2.614649e-05 1.235461e-03 7.280310e-05 1.863133e-05 2.191921e-06
  1 0.000000e+00 7.006319e-04 1.161718e-04 4.368186e-05 3.914145e-06
  2 0.000000e+00 4.289903e-05 8.924250e-06 1.878790e-06 0.000000e+00

, ,  = 39

   
               0            1            2            3            4
  0 3.701215e-04 1.981732e-02 1.527143e-03 1.977426e-04 3.569700e-05
  1 0.000000e+00 1.254718e-02 2.336901e-03 3.624498e-04 6.246975e-05
  2 0.000000e+00 6.434854e-04 1.703436e-04 2.035355e-05 2.661619e-06

, ,  = 40

   
               0            1            2            3            4
  0 1.193031e-04 5.902687e-03 5.140055e-04 1.014546e-04 1.048991e-05
  1 0.000000e+00 3.849170e-03 7.602835e-04 1.564092e-04 1.706567e-05
  2 0.000000e+00 2.068234e-04 7.170714e-05 1.064647e-05 9.393948e-07

, ,  = 41

   
               0            1            2            3            4
  0 1.081870e-04 6.327294e-03 5.609753e-04 1.443537e-04 1.643941e-05
  1 0.000000e+00 4.045660e-03 8.467078e-04 2.573942e-04 3.397478e-05
  2 0.000000e+00 1.886618e-04 5.354550e-05 1.346466e-05 1.252526e-06

, ,  = 42

   
               0            1            2            3            4
  0 3.505508e-04 2.190027e-02 1.254405e-03 2.141820e-04 4.399499e-05
  1 0.000000e+00 1.382711e-02 1.973355e-03 4.762732e-04 7.311623e-05
  2 0.000000e+00 6.633693e-04 1.355860e-04 2.442426e-05 3.914145e-06

, ,  = 44

   
               0            1            2            3            4
  0 2.833841e-05 1.785789e-03 1.131971e-04 2.990407e-05 6.575764e-06
  1 0.000000e+00 1.190213e-03 1.590709e-04 8.360614e-05 1.487375e-05
  2 0.000000e+00 5.620712e-05 1.127274e-05 2.974750e-06 6.262632e-07

, ,  = 45

   
               0            1            2            3            4
  0 1.448234e-04 8.066113e-03 5.698995e-04 1.875658e-04 2.113638e-05
  1 0.000000e+00 5.045333e-03 8.675311e-04 3.096871e-04 2.990407e-05
  2 0.000000e+00 2.674144e-04 6.419198e-05 1.424749e-05 2.191921e-06

, ,  = 46

   
               0            1            2            3            4
  0 3.115659e-05 1.422557e-03 9.707079e-05 2.818184e-05 1.878790e-06
  1 0.000000e+00 8.066270e-04 1.343335e-04 4.477782e-05 5.636369e-06
  2 0.000000e+00 5.683338e-05 1.299496e-05 2.974750e-06 0.000000e+00

, ,  = 47

   
               0            1            2            3            4
  0 1.888184e-04 1.069360e-02 8.208745e-04 2.173133e-04 1.957072e-05
  1 0.000000e+00 7.019628e-03 1.210723e-03 3.359902e-04 3.835862e-05
  2 0.000000e+00 3.550912e-04 9.127786e-05 1.863133e-05 1.722224e-06

, ,  = 48

   
               0            1            2            3            4
  0 8.733240e-04 3.817278e-02 3.456660e-03 5.554955e-04 1.686214e-04
  1 0.000000e+00 2.749843e-02 5.297091e-03 8.661220e-04 2.459649e-04
  2 0.000000e+00 1.572390e-03 4.471519e-04 5.949500e-05 2.238891e-05

, ,  = 49

   
               0            1            2            3            4
  0 1.377779e-04 4.215534e-03 3.399043e-04 8.611119e-05 1.722224e-05
  1 0.000000e+00 3.215079e-03 6.428592e-04 1.802072e-04 3.319195e-05
  2 0.000000e+00 2.166871e-04 6.904552e-05 1.189900e-05 1.565658e-06

, ,  = 50

   
               0            1            2            3            4
  0 1.503032e-05 1.126178e-03 5.135358e-05 1.988386e-05 1.878790e-06
  1 0.000000e+00 6.830966e-04 8.595462e-05 5.088388e-05 6.575764e-06
  2 0.000000e+00 2.536366e-05 3.444448e-06 2.505053e-06 0.000000e+00

, ,  = 51

   
               0            1            2            3            4
  0 2.567679e-04 1.301923e-02 8.891372e-04 2.409548e-04 5.636369e-05
  1 0.000000e+00 9.097882e-03 1.585385e-03 4.869196e-04 1.091264e-04
  2 0.000000e+00 4.563893e-04 1.019243e-04 3.146973e-05 5.792935e-06

, ,  = 53

   
               0            1            2            3            4
  0 2.184093e-04 1.108032e-02 9.880868e-04 2.259244e-04 5.041419e-05
  1 0.000000e+00 7.471633e-03 1.529961e-03 3.838993e-04 9.346978e-05
  2 0.000000e+00 3.873438e-04 1.059950e-04 2.536366e-05 3.757579e-06

, ,  = 54

   
               0            1            2            3            4
  0 4.368186e-05 3.171867e-03 1.803638e-04 4.963136e-05 3.131316e-06
  1 0.000000e+00 1.861098e-03 2.702326e-04 8.564149e-05 7.045461e-06
  2 0.000000e+00 8.266674e-05 2.176265e-05 6.419198e-06 0.000000e+00

, ,  = 55

   
               0            1            2            3            4
  0 1.759800e-04 9.917347e-03 6.292379e-04 1.048991e-04 1.456062e-05
  1 0.000000e+00 6.086339e-03 9.744655e-04 1.701870e-04 2.739901e-05
  2 0.000000e+00 3.084346e-04 6.747986e-05 1.252526e-05 4.696974e-07

, ,  = 56

   
               0            1            2            3            4
  0 1.753537e-05 9.159099e-04 6.685360e-05 2.865154e-05 2.348487e-06
  1 0.000000e+00 5.550258e-04 1.080304e-04 4.180307e-05 4.383842e-06
  2 0.000000e+00 3.037376e-05 8.297987e-06 2.818184e-06 6.262632e-07
summary <- data %>%
group_by(STATEFIP, Moving = haven::as_factor(MIGRATE1D, level ="values"), FERTYR)%>%
summarize(n = sum(PERWT)) %>%
mutate(pct = n / sum(n),
       moved = 1-pct)
`summarise()` has grouped output by 'STATEFIP', 'Moving'. You can override
using the `.groups` argument.
Moving <- summary %>% filter(Moving ==1)
x <- summary %>% filter(FERTYR==2 & Moving==24)
library(usmap)

x$fips <- x$STATEFIP

plot_usmap(regions = "states", values = "pct", data = x)+
  scale_fill_continuous(
    low = "white", high = "red", label = scales::comma)+
    ggtitle("")+
  theme(legend.position = "right")+
  ggtitle("Different house, moved within state, between PUMAs")

x <- summary %>% filter(FERTYR==2 & Moving==23)

library(usmap)

x$fips <- x$STATEFIP

plot_usmap(regions = "states", values = "pct", data = x)+
  scale_fill_continuous(
    low = "white", high = "red", label = scales::comma)+
    ggtitle("")+
  theme(legend.position = "right")+
  ggtitle("Different house, moved within state, within PUMAs")

x <- summary %>% filter(FERTYR==2 & Moving==22)

library(usmap)

x$fips <- x$STATEFIP

plot_usmap(regions = "states", values = "pct", data = x)+
  scale_fill_continuous(
    low = "white", high = "red", label = scales::comma)+
    ggtitle("")+
  theme(legend.position = "right")+
  ggtitle("Different house, moved within state, between PUMAs")