anexos de safra 2019

Wordcloud, representação da quantidade de cargas das variedades de uva

Heatmap do calendário de colheita da safra 2018/19.

Heatmap - Cronograma do recebimento de Cadernos de Campo na safra 2018/19.

Heatmap - Cronograma nas Filiais do recebimento de Cadernos de Campo na safra 2018/19.

## The following objects are masked from dados3:
## 
##     DIAS_DA_SEMANA, MES_ORDEM, N_CC, SEMANA, SEMANA_NO_MES

Teste t pareado cargas ~ kg_recebido ~ kg_previsto

Resultado:

A diferença média entre o peso da carga recebido na cooperativa na safra (kg_recebido) e o peso agendado (kg_previsto) foi de -14.01634 kg. H0: não há menos kg_recebidos do que kg_previsto

kg_recebido (kg)= 1171 + 0.7638(kg_previsto)

##        ua            filial          carga        nucleo   
##  Min.   :   15   Min.   :1.000   Min.   :   1.0   FC:1079  
##  1st Qu.: 7471   1st Qu.:1.000   1st Qu.: 727.8   JC:1209  
##  Median :12092   Median :1.000   Median :1546.0   NP: 776  
##  Mean   :28282   Mean   :3.942   Mean   :1544.2   PB:1834  
##  3rd Qu.:71412   3rd Qu.:7.000   3rd Qu.:2345.0   SG: 906  
##  Max.   :73001   Max.   :9.000   Max.   :3299.0   SV: 316  
##            local       kg_previsto     kg_recebido   
##  LAGOA_BELA   :3087   Min.   :    0   Min.   :   60  
##  LINHA_JACINTO:2867   1st Qu.: 3500   1st Qu.: 3370  
##  LIVRAMENTO   :  87   Median : 4500   Median : 4560  
##  SAO_PEDRO    :  79   Mean   : 5018   Mean   : 5003  
##                       3rd Qu.: 6000   3rd Qu.: 6370  
##                       Max.   :40000   Max.   :15430
## Loading required package: carData

## 
##  Paired t-test
## 
## data:  kg_recebido and kg_previsto
## t = -0.63428, df = 6119, p-value = 0.263
## alternative hypothesis: true difference in means is less than 0
## 95 percent confidence interval:
##      -Inf 22.33713
## sample estimates:
## mean of the differences 
##               -14.01634
## 
##  Paired t-test
## 
## data:  kg_recebido and kg_previsto
## t = -0.63428, df = 6119, p-value = 0.5259
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
##  -57.33618  29.30350
## sample estimates:
## mean of the differences 
##               -14.01634
## 
## Call:
## lm(formula = kg_recebido ~ kg_previsto)
## 
## Residuals:
##      Min       1Q   Median       3Q      Max 
## -23804.2   -754.8     -6.3    786.0  10569.0 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 1.171e+03  4.615e+01   25.37   <2e-16 ***
## kg_previsto 7.638e-01  8.217e-03   92.95   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1623 on 6118 degrees of freedom
## Multiple R-squared:  0.5855, Adjusted R-squared:  0.5854 
## F-statistic:  8640 on 1 and 6118 DF,  p-value: < 2.2e-16

## 
## Call:
## lm(formula = kg_recebido ~ kg_previsto)
## 
## Residuals:
##      Min       1Q   Median       3Q      Max 
## -23804.2   -754.8     -6.3    786.0  10569.0 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 1.171e+03  4.615e+01   25.37   <2e-16 ***
## kg_previsto 7.638e-01  8.217e-03   92.95   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1623 on 6118 degrees of freedom
## Multiple R-squared:  0.5855, Adjusted R-squared:  0.5854 
## F-statistic:  8640 on 1 and 6118 DF,  p-value: < 2.2e-16