## `geom_smooth()` using formula = 'y ~ x'

Correlation Plots Comparing FI Steer Slaughter w/ Fed, Feeder, and Corn Prices -

The following below graphics are here for representation of what the series look like over time and if anything can be deduced from the relationships posed. Correlations are towards the bottom of the document.

In the below two charts, there is a spike in commercial slaughter that is much more dramatic than in federally inspected, which may help to explain the spike in 1996.

Now looking at the difference between FI steer slaughter and commercial all cattle slaughter, we can further see that there is a big difference between the two in 1996. It also appears to help explain the dip 2015-16 when the difference plummeted. The one thing that is interesting though is the two are inverse of one another in 2007 when FI steer slaughter spiked and the difference between commercial cattle and FI steer decreased. Additionally, in the 80s there was large variability and differences in the two, this may help explain why there was little variability in the FI steer slaughter series during that time.

Looking at the composition between heifer and steer slaughter, there’s substantially less variability in heifers, which makes sense.

The difference between steer and heifer slaughter, below, appears to show that when we have spikes in steer slaughter, its because we’re offsetting reductions of heifer slaughter.

Correlation Plot Between Commercial and FI Slaughter ‘Types’

Correlation Plot Between FI Steer Slaughter and Changes in Slaughter based on ‘Type’

Correlation Plot Between FI Steer Slaughter and the Difference between Comm Cattle and FI Steer Slaughter

Correlation Plot Between FI Steer Slaughter and Cattle Trade based on ‘Type’

Correlation Plot Between FI Steer Slaughter and Changes in Cattle Trade based on ‘Type’

Regression Models

Model 1 (Trend, Dummies, and Sltr Days) -

## 
## Slaughter Model 1
## ===============================================
##                         Dependent variable:    
##                     ---------------------------
##                             fi_str_sltr        
## -----------------------------------------------
## trend                       -108.824***        
##                              (21.590)          
##                                                
## FebDummy                  -75,827.260***       
##                            (16,668.790)        
##                                                
## MarDummy                  -44,814.400***       
##                            (16,462.020)        
##                                                
## AprDummy                    -1,353.121         
##                            (16,001.590)        
##                                                
## MayDummy                  135,631.900***       
##                            (15,993.170)        
##                                                
## JunDummy                  162,082.100***       
##                            (16,006.990)        
##                                                
## JulDummy                  119,280.800***       
##                            (15,990.120)        
##                                                
## AugDummy                   98,746.200***       
##                            (16,439.290)        
##                                                
## SepDummy                   65,488.400***       
##                            (16,351.640)        
##                                                
## OctDummy                    -2,300.691         
##                            (16,508.740)        
##                                                
## NovDummy                   -37,395.510**       
##                            (16,475.000)        
##                                                
## DecDummy                  -41,965.330***       
##                            (16,099.240)        
##                                                
## sltr_days                  49,025.250***       
##                             (4,340.820)        
##                                                
## Constant                  341,921.400***       
##                            (93,100.730)        
##                                                
## -----------------------------------------------
## Observations                    525            
## R2                             0.637           
## Adjusted R2                    0.628           
## Residual Std. Error    74,962.140 (df = 511)   
## F Statistic          69.048*** (df = 13; 511)  
## ===============================================
## Note:               *p<0.1; **p<0.05; ***p<0.01

Comparison of all models…

## 
## Slaughter Model Results w/ All Cattle and Calves
## ==========================================================================================================================
##                                                              Dependent variable:                                          
##                     ------------------------------------------------------------------------------------------------------
##                                                                  fi_str_sltr                                              
##                             Model 2                   Model 3                   Model 4                   Model 5         
## --------------------------------------------------------------------------------------------------------------------------
## FebDummy                 -75,871.690***             -14,651.720               -14,395.530               -11,532.450       
##                           (16,739.080)             (13,106.410)              (13,131.360)              (11,925.080)       
##                                                                                                                           
## MarDummy                 -45,085.710***              1,942.533                 2,022.025                 4,758.760        
##                           (16,531.390)             (12,794.210)              (12,805.990)              (11,629.480)       
##                                                                                                                           
## AprDummy                   -1,690.324              43,689.960***             43,720.230***             47,341.510***      
##                           (16,068.940)             (12,433.060)              (12,443.340)              (11,302.590)       
##                                                                                                                           
## MayDummy                 135,204.700***           111,937.900***            111,713.000***            114,721.700***      
##                           (16,060.390)             (12,262.720)              (12,284.460)              (11,156.750)       
##                                                                                                                           
## JunDummy                 161,525.900***           126,833.200***            126,565.700***            129,468.900***      
##                           (16,074.130)             (12,344.850)              (12,371.440)              (11,235.430)       
##                                                                                                                           
## JulDummy                 118,634.600***           100,396.500***            100,351.900***            103,738.500***      
##                           (16,057.020)             (12,237.460)              (12,247.840)              (11,124.500)       
##                                                                                                                           
## AugDummy                 97,932.110***             77,228.740***             77,307.820***             79,681.900***      
##                           (16,507.920)             (12,589.260)              (12,600.890)              (11,442.570)       
##                                                                                                                           
## SepDummy                 64,664.770***             40,027.150***             39,973.620***             39,491.350***      
##                           (16,419.690)             (12,541.440)              (12,552.260)              (11,396.260)       
##                                                                                                                           
## OctDummy                   -3,155.366               -17,592.720               -17,503.530              -19,690.660*       
##                           (16,578.630)             (12,619.550)              (12,631.580)              (11,470.100)       
##                                                                                                                           
## NovDummy                 -38,258.790**             -30,177.790**             -30,159.070**            -32,166.210***      
##                           (16,544.520)             (12,578.520)              (12,588.790)              (11,430.950)       
##                                                                                                                           
## DecDummy                 -42,974.510***             -13,418.730               -13,273.030               -13,098.570       
##                           (16,167.100)             (12,379.250)              (12,394.190)              (11,252.670)       
##                                                                                                                           
## sltr_days                49,084.280***             13,889.050***             13,748.080***             13,023.470***      
##                           (4,359.144)               (3,778.206)               (3,796.299)               (3,447.348)       
##                                                                                                                           
## all_cttl_calves             2.145***                 -3.209***                 -3.228***                 -5.071***        
##                             (0.469)                   (0.451)                   (0.454)                   (0.448)         
##                                                                                                                           
## comm_cttl_sltr                                       0.350***                  0.351***                  0.360***         
##                                                       (0.018)                   (0.018)                   (0.017)         
##                                                                                                                           
## cttl_exp_mexico                                                                 -0.150                   -0.928***        
##                                                                                 (0.360)                   (0.335)         
##                                                                                                                           
## corn_price                                                                                            -19,390.590***      
##                                                                                                         (1,852.957)       
##                                                                                                                           
## Constant                  101,388.100             375,830.800***            377,111.600***            614,375.000***      
##                          (104,234.100)             (80,461.710)              (80,585.260)              (76,595.770)       
##                                                                                                                           
## --------------------------------------------------------------------------------------------------------------------------
## Observations                  525                       525                       525                       525           
## R2                           0.634                     0.789                     0.789                     0.827          
## Adjusted R2                  0.625                     0.783                     0.783                     0.821          
## Residual Std. Error  75,278.270 (df = 511)     57,201.300 (df = 510)     57,247.650 (df = 509)     51,975.040 (df = 508)  
## F Statistic         68.140*** (df = 13; 511) 136.370*** (df = 14; 510) 127.084*** (df = 15; 509) 151.384*** (df = 16; 508)
## ==========================================================================================================================
## Note:                                                                                          *p<0.1; **p<0.05; ***p<0.01
## 
## Slaughter Model Results w/ All Cattle and Calves Cont.
## ===========================================================================================================================
##                                                               Dependent variable:                                          
##                     -------------------------------------------------------------------------------------------------------
##                                                                   fi_str_sltr                                              
##                              Model 6                   Model 7                   Model 8                   Model 9         
## ---------------------------------------------------------------------------------------------------------------------------
## FebDummy                   -15,721.730               -13,406.880              -23,282.960*               -19,354.920       
##                           (13,103.710)              (12,015.450)              (12,903.410)              (11,938.520)       
##                                                                                                                            
## MarDummy                     40.812                   3,774.544                -10,692.450               -4,875.898        
##                           (12,830.250)              (11,768.530)              (12,729.220)              (11,786.500)       
##                                                                                                                            
## AprDummy                  43,631.350***             46,925.500***             36,298.490***             41,549.680***      
##                           (12,414.280)              (11,385.990)              (12,221.190)              (11,314.260)       
##                                                                                                                            
## MayDummy                 112,934.000***            116,029.500***            113,125.500***            116,436.500***      
##                           (12,260.030)              (11,244.070)              (11,971.830)              (11,075.400)       
##                                                                                                                            
## JunDummy                 130,141.700***            131,454.300***            136,433.200***            137,332.700***      
##                           (12,499.150)              (11,459.690)              (12,194.370)              (11,275.920)       
##                                                                                                                            
## JulDummy                 105,273.500***            104,674.600***            115,677.500***            114,290.500***      
##                           (12,595.030)              (11,546.970)              (12,311.170)              (11,384.480)       
##                                                                                                                            
## AugDummy                  82,996.990***             80,120.980***             92,583.130***             89,722.610***      
##                           (13,079.190)              (11,994.220)              (12,648.010)              (11,698.970)       
##                                                                                                                            
## SepDummy                  44,693.020***             40,685.380***             48,240.870***             45,607.220***      
##                           (12,859.000)              (11,795.790)              (12,346.030)              (11,419.220)       
##                                                                                                                            
## OctDummy                   -15,581.640              -19,708.090*               -16,892.160              -19,428.260*       
##                           (12,663.250)              (11,616.880)              (12,318.650)              (11,393.650)       
##                                                                                                                            
## NovDummy                 -34,712.890***            -32,975.880***            -45,188.100***            -42,552.810***      
##                           (12,876.740)              (11,806.390)              (12,622.080)              (11,674.400)       
##                                                                                                                            
## DecDummy                   -18,595.250               -14,905.620              -26,646.620**             -23,204.860**      
##                           (12,778.740)              (11,721.190)              (12,355.720)              (11,430.630)       
##                                                                                                                            
## sltr_days                 13,496.550***             13,822.430***             13,532.520***             13,643.630***      
##                            (3,780.486)               (3,466.015)               (3,688.547)               (3,410.630)       
##                                                                                                                            
## all_cttl_calves             -2.936***                 -4.792***                 -1.948***                 -3.855***        
##                              (0.482)                   (0.480)                   (0.504)                   (0.509)         
##                                                                                                                            
## comm_cttl_sltr              0.350***                  0.350***                  0.338***                  0.342***         
##                              (0.018)                   (0.017)                   (0.018)                   (0.016)         
##                                                                                                                            
## cttl_imp_mexico               0.104                     0.019                                                              
##                              (0.065)                   (0.060)                                                             
##                                                                                                                            
## corn_price                                         -18,168.520***                                      -17,033.190***      
##                                                      (1,838.980)                                         (1,822.601)       
##                                                                                                                            
## cttl_imp_ttl                                                                    0.257***                  0.180***         
##                                                                                  (0.050)                   (0.047)         
##                                                                                                                            
## Constant                 347,101.500***            586,691.200***            252,464.800***            491,907.300***      
##                           (82,330.720)              (79,278.940)              (82,141.740)              (80,157.220)       
##                                                                                                                            
## ---------------------------------------------------------------------------------------------------------------------------
## Observations                   525                       525                       525                       525           
## R2                            0.790                     0.824                     0.800                     0.829          
## Adjusted R2                   0.784                     0.819                     0.794                     0.824          
## Residual Std. Error   57,114.650 (df = 509)     52,361.330 (df = 508)     55,833.940 (df = 509)     51,626.770 (df = 508)  
## F Statistic         127.835*** (df = 15; 509) 148.692*** (df = 16; 508) 135.341*** (df = 15; 509) 153.863*** (df = 16; 508)
## ===========================================================================================================================
## Note:                                                                                           *p<0.1; **p<0.05; ***p<0.01
## 
## Slaughter Model Results w/ Beef Cows Calved
## ==========================================================================================================================
##                                                              Dependent variable:                                          
##                     ------------------------------------------------------------------------------------------------------
##                                                                  fi_str_sltr                                              
##                             Model 10                 Model 11                  Model 12                  Model 13         
## --------------------------------------------------------------------------------------------------------------------------
## FebDummy                 -75,860.460***             -21,156.700               -21,189.220               -15,991.970       
##                           (16,348.000)             (13,574.670)              (13,599.710)              (12,566.540)       
##                                                                                                                           
## MarDummy                 -45,095.070***             -3,113.695                -3,121.948                 1,426.899        
##                           (16,145.170)             (13,249.790)              (13,263.530)              (12,253.620)       
##                                                                                                                           
## AprDummy                   -1,692.197              38,834.470***             38,833.100***             44,224.800***      
##                           (15,693.520)             (12,875.940)              (12,888.570)              (11,911.690)       
##                                                                                                                           
## MayDummy                 135,206.100***           114,428.800***            114,459.300***            116,653.600***      
##                           (15,685.170)             (12,698.530)              (12,722.000)              (11,746.540)       
##                                                                                                                           
## JunDummy                 161,523.800***           130,533.600***            130,569.400***            132,226.600***      
##                           (15,698.590)             (12,784.100)              (12,811.750)              (11,828.400)       
##                                                                                                                           
## JulDummy                 118,635.700***           102,349.300***            102,354.400***            105,094.800***      
##                           (15,681.890)             (12,672.230)              (12,684.950)              (11,713.640)       
##                                                                                                                           
## AugDummy                 97,922.990***             79,411.060***             79,398.500***             80,997.120***      
##                           (16,122.250)             (13,036.710)              (13,051.290)              (12,049.420)       
##                                                                                                                           
## SepDummy                 64,672.960***             42,686.870***             42,692.880***             41,276.030***      
##                           (16,036.080)             (12,987.090)              (13,000.220)              (12,002.020)       
##                                                                                                                           
## OctDummy                   -3,535.189               -16,211.320               -16,224.870               -18,817.730       
##                           (16,191.460)             (13,067.170)              (13,082.080)              (12,079.770)       
##                                                                                                                           
## NovDummy                 -38,621.130**             -31,145.170**             -31,147.290**            -32,682.300***      
##                           (16,158.150)             (13,025.880)              (13,038.680)              (12,037.680)       
##                                                                                                                           
## DecDummy                 -43,343.310***             -16,702.170               -16,720.950               -15,250.190       
##                           (15,789.550)             (12,821.390)              (12,838.090)              (11,852.440)       
##                                                                                                                           
## sltr_days                49,094.580***             17,683.890***             17,701.650***             15,651.150***      
##                           (4,257.296)               (3,914.526)               (3,930.494)               (3,634.899)       
##                                                                                                                           
## beef_cows_calved            8.985***                 -4.814***                 -4.809***                -11.682***        
##                             (1.315)                   (1.345)                   (1.350)                   (1.443)         
##                                                                                                                           
## comm_cttl_sltr                                       0.312***                  0.312***                  0.334***         
##                                                       (0.019)                   (0.019)                   (0.018)         
##                                                                                                                           
## cttl_exp_mexico                                                                  0.021                   -0.743**         
##                                                                                 (0.372)                   (0.352)         
##                                                                                                                           
## corn_price                                                                                            -19,631.620***      
##                                                                                                         (2,077.679)       
##                                                                                                                           
## Constant                   15,769.390             245,193.700***            245,093.800***            518,904.900***      
##                          (101,040.600)             (82,563.240)              (82,662.280)              (81,626.260)       
##                                                                                                                           
## --------------------------------------------------------------------------------------------------------------------------
## Observations                  525                       525                       525                       525           
## R2                           0.651                     0.774                     0.774                     0.808          
## Adjusted R2                  0.642                     0.768                     0.767                     0.802          
## Residual Std. Error  73,519.560 (df = 511)     59,232.510 (df = 510)     59,290.470 (df = 509)     54,733.690 (df = 508)  
## F Statistic         73.342*** (df = 13; 511) 124.722*** (df = 14; 510) 116.179*** (df = 15; 509) 133.389*** (df = 16; 508)
## ==========================================================================================================================
## Note:                                                                                          *p<0.1; **p<0.05; ***p<0.01
## 
## Slaughter Model Results w/ Beef Cows Calved Cont.
## ===========================================================================================================================
##                                                               Dependent variable:                                          
##                     -------------------------------------------------------------------------------------------------------
##                                                                   fi_str_sltr                                              
##                             Model 14                  Model 15                  Model 16                  Model 17         
## ---------------------------------------------------------------------------------------------------------------------------
## FebDummy                  -22,891.440*               -18,328.930              -30,937.610**             -25,566.970**      
##                           (13,487.690)              (12,590.430)              (13,048.180)              (12,279.170)       
##                                                                                                                            
## MarDummy                   -6,448.066                 -900.082                 -18,473.170               -11,791.250       
##                           (13,201.290)              (12,328.780)              (12,850.550)              (12,103.270)       
##                                                                                                                            
## AprDummy                  38,917.560***             43,793.040***             30,294.990**              36,515.550***      
##                           (12,781.150)              (11,933.650)              (12,365.780)              (11,645.020)       
##                                                                                                                            
## MayDummy                 116,182.100***            118,345.300***            115,397.000***            117,965.200***      
##                           (12,619.190)              (11,772.250)              (12,137.100)              (11,410.030)       
##                                                                                                                            
## JunDummy                 136,539.000***            136,300.300***            142,241.000***            142,348.600***      
##                           (12,854.210)              (11,988.910)              (12,331.250)              (11,588.250)       
##                                                                                                                            
## JulDummy                 111,339.400***            109,626.200***            121,911.300***            120,421.300***      
##                           (12,947.270)              (12,077.250)              (12,427.220)              (11,679.830)       
##                                                                                                                            
## AugDummy                  90,051.250***             85,895.940***             99,019.770***             96,026.420***      
##                           (13,439.980)              (12,544.130)              (12,768.390)              (12,004.510)       
##                                                                                                                            
## SepDummy                  51,255.320***             45,951.050***             52,818.680***             49,760.610***      
##                           (13,218.580)              (12,343.500)              (12,495.620)              (11,748.540)       
##                                                                                                                            
## OctDummy                   -12,543.010               -17,172.160               -15,657.310               -18,358.880       
##                           (13,031.140)              (12,165.320)              (12,488.890)              (11,740.930)       
##                                                                                                                            
## NovDummy                 -39,558.440***            -36,918.710***            -50,631.460***            -48,051.050***      
##                           (13,244.570)              (12,356.610)              (12,754.490)              (11,990.040)       
##                                                                                                                            
## DecDummy                  -26,215.330**             -20,818.990*             -33,303.920***             -29,278.090**      
##                           (13,134.100)              (12,265.320)              (12,479.570)              (11,737.730)       
##                                                                                                                            
## sltr_days                 16,802.360***             15,931.660***             16,317.310***             15,402.150***      
##                            (3,897.314)               (3,636.301)               (3,746.270)               (3,522.283)       
##                                                                                                                            
## beef_cows_calved            -3.537**                 -10.315***                  -1.122                   -7.494***        
##                              (1.405)                   (1.521)                   (1.389)                   (1.516)         
##                                                                                                                            
## comm_cttl_sltr              0.314***                  0.327***                  0.306***                  0.320***         
##                              (0.019)                   (0.017)                   (0.018)                   (0.017)         
##                                                                                                                            
## cttl_imp_mexico             0.193***                    0.098                                                              
##                              (0.066)                   (0.062)                                                             
##                                                                                                                            
## corn_price                                         -18,065.090***                                      -16,519.990***      
##                                                      (2,056.981)                                         (1,998.008)       
##                                                                                                                            
## cttl_imp_ttl                                                                    0.337***                  0.269***         
##                                                                                  (0.048)                   (0.046)         
##                                                                                                                            
## Constant                  198,560.100**            470,082.200***              118,165.900             371,228.900***      
##                           (83,484.490)              (83,777.750)              (80,953.390)              (82,001.660)       
##                                                                                                                            
## ---------------------------------------------------------------------------------------------------------------------------
## Observations                   525                       525                       525                       525           
## R2                            0.778                     0.807                     0.794                     0.818          
## Adjusted R2                   0.771                     0.801                     0.788                     0.813          
## Residual Std. Error   58,796.290 (df = 509)     54,838.170 (df = 508)     56,610.070 (df = 509)     53,199.100 (df = 508)  
## F Statistic         118.713*** (df = 15; 509) 132.760*** (df = 16; 508) 130.731*** (df = 15; 509) 143.054*** (df = 16; 508)
## ===========================================================================================================================
## Note:                                                                                           *p<0.1; **p<0.05; ***p<0.01

Regression Graphics -