set.seed(1007355141)
coords<-expand.grid(x=1:10,
y=1:12)
CBD<-c(rnorm(30,60,2),
rnorm(30,50,1.5),
runif(30,30,40),
rnorm(30,40,3));CBD
## [1] 58.78956 59.93965 60.10029 62.59060 59.98009 62.13517 57.34465 61.64193
## [9] 57.68583 58.98804 61.12674 59.37396 61.28387 57.72517 58.17340 57.44321
## [17] 61.72839 58.83681 59.99402 59.88482 61.34530 57.50246 64.15116 59.12774
## [25] 60.50127 54.61255 61.98738 58.65168 59.20183 56.63738 50.54898 52.75790
## [33] 46.60616 47.71437 49.23800 51.62073 50.83690 53.28721 48.71915 50.33189
## [41] 51.00709 50.59940 46.64245 50.23388 46.63812 49.98414 49.04254 48.92180
## [49] 52.00325 49.59966 51.23691 50.51886 50.76543 48.69077 46.94054 50.24352
## [57] 49.63330 49.91494 49.41885 49.20905 36.85008 37.82991 35.71252 39.71607
## [65] 33.89718 34.43725 38.96448 31.11166 32.65631 31.03818 38.99152 33.42717
## [73] 37.12643 31.84185 35.48942 33.46442 37.64634 39.53842 37.21001 38.97064
## [81] 38.00847 34.19722 32.81589 32.78877 37.43241 34.38809 35.54387 31.11546
## [89] 36.51418 32.53683 39.92675 35.94137 44.25427 45.75735 45.22681 37.26986
## [97] 36.19437 38.08939 43.78280 43.28802 40.31099 38.71304 39.96264 33.51157
## [105] 39.24624 42.83866 37.91353 40.69080 40.13765 41.34808 40.76795 40.84164
## [113] 41.50470 41.35002 39.30585 39.49688 40.62470 38.57651 41.13862 38.00354
Accesion<-gl(4,30,120, labels=c("A1","A2","A3","A4"))
df<-data.frame(x=coords$x, y=coords$y, CBD=CBD,
Accesion=Accesion); df
## x y CBD Accesion
## 1 1 1 58.78956 A1
## 2 2 1 59.93965 A1
## 3 3 1 60.10029 A1
## 4 4 1 62.59060 A1
## 5 5 1 59.98009 A1
## 6 6 1 62.13517 A1
## 7 7 1 57.34465 A1
## 8 8 1 61.64193 A1
## 9 9 1 57.68583 A1
## 10 10 1 58.98804 A1
## 11 1 2 61.12674 A1
## 12 2 2 59.37396 A1
## 13 3 2 61.28387 A1
## 14 4 2 57.72517 A1
## 15 5 2 58.17340 A1
## 16 6 2 57.44321 A1
## 17 7 2 61.72839 A1
## 18 8 2 58.83681 A1
## 19 9 2 59.99402 A1
## 20 10 2 59.88482 A1
## 21 1 3 61.34530 A1
## 22 2 3 57.50246 A1
## 23 3 3 64.15116 A1
## 24 4 3 59.12774 A1
## 25 5 3 60.50127 A1
## 26 6 3 54.61255 A1
## 27 7 3 61.98738 A1
## 28 8 3 58.65168 A1
## 29 9 3 59.20183 A1
## 30 10 3 56.63738 A1
## 31 1 4 50.54898 A2
## 32 2 4 52.75790 A2
## 33 3 4 46.60616 A2
## 34 4 4 47.71437 A2
## 35 5 4 49.23800 A2
## 36 6 4 51.62073 A2
## 37 7 4 50.83690 A2
## 38 8 4 53.28721 A2
## 39 9 4 48.71915 A2
## 40 10 4 50.33189 A2
## 41 1 5 51.00709 A2
## 42 2 5 50.59940 A2
## 43 3 5 46.64245 A2
## 44 4 5 50.23388 A2
## 45 5 5 46.63812 A2
## 46 6 5 49.98414 A2
## 47 7 5 49.04254 A2
## 48 8 5 48.92180 A2
## 49 9 5 52.00325 A2
## 50 10 5 49.59966 A2
## 51 1 6 51.23691 A2
## 52 2 6 50.51886 A2
## 53 3 6 50.76543 A2
## 54 4 6 48.69077 A2
## 55 5 6 46.94054 A2
## 56 6 6 50.24352 A2
## 57 7 6 49.63330 A2
## 58 8 6 49.91494 A2
## 59 9 6 49.41885 A2
## 60 10 6 49.20905 A2
## 61 1 7 36.85008 A3
## 62 2 7 37.82991 A3
## 63 3 7 35.71252 A3
## 64 4 7 39.71607 A3
## 65 5 7 33.89718 A3
## 66 6 7 34.43725 A3
## 67 7 7 38.96448 A3
## 68 8 7 31.11166 A3
## 69 9 7 32.65631 A3
## 70 10 7 31.03818 A3
## 71 1 8 38.99152 A3
## 72 2 8 33.42717 A3
## 73 3 8 37.12643 A3
## 74 4 8 31.84185 A3
## 75 5 8 35.48942 A3
## 76 6 8 33.46442 A3
## 77 7 8 37.64634 A3
## 78 8 8 39.53842 A3
## 79 9 8 37.21001 A3
## 80 10 8 38.97064 A3
## 81 1 9 38.00847 A3
## 82 2 9 34.19722 A3
## 83 3 9 32.81589 A3
## 84 4 9 32.78877 A3
## 85 5 9 37.43241 A3
## 86 6 9 34.38809 A3
## 87 7 9 35.54387 A3
## 88 8 9 31.11546 A3
## 89 9 9 36.51418 A3
## 90 10 9 32.53683 A3
## 91 1 10 39.92675 A4
## 92 2 10 35.94137 A4
## 93 3 10 44.25427 A4
## 94 4 10 45.75735 A4
## 95 5 10 45.22681 A4
## 96 6 10 37.26986 A4
## 97 7 10 36.19437 A4
## 98 8 10 38.08939 A4
## 99 9 10 43.78280 A4
## 100 10 10 43.28802 A4
## 101 1 11 40.31099 A4
## 102 2 11 38.71304 A4
## 103 3 11 39.96264 A4
## 104 4 11 33.51157 A4
## 105 5 11 39.24624 A4
## 106 6 11 42.83866 A4
## 107 7 11 37.91353 A4
## 108 8 11 40.69080 A4
## 109 9 11 40.13765 A4
## 110 10 11 41.34808 A4
## 111 1 12 40.76795 A4
## 112 2 12 40.84164 A4
## 113 3 12 41.50470 A4
## 114 4 12 41.35002 A4
## 115 5 12 39.30585 A4
## 116 6 12 39.49688 A4
## 117 7 12 40.62470 A4
## 118 8 12 38.57651 A4
## 119 9 12 41.13862 A4
## 120 10 12 38.00354 A4
\[H_0: \mu_{A1}=\mu_{A2}=\mu_{A3}=\mu_{A4}\] \[H_a: at~least~one~is~different \] ## Estadistica descriptiva
ggplot(df)+
aes(Accesion,CBD,fill=Accesion)+
geom_boxplot()+
geom_hline(yintercept = 5.2) #linea horizontal
library(dplyr)
## Warning: package 'dplyr' was built under R version 4.1.3
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
df %>%
group_by(Accesion) %>%
summarise(media=mean(CBD),
desv=sd(CBD),
cv=100*desv/media)
## # A tibble: 4 x 4
## Accesion media desv cv
## <fct> <dbl> <dbl> <dbl>
## 1 A1 59.6 2.04 3.41
## 2 A2 49.8 1.71 3.43
## 3 A3 35.4 2.73 7.73
## 4 A4 40.2 2.74 6.81
mod1=aov(CBD~Accesion,data=df)
s_mod1=summary(mod1)
p_valor=s_mod1[[1]][1,5]
ifelse(p_valor<0.05,"Rechazo H0", "No rechazo H0")
## [1] "Rechazo H0"
TukeyHSD(mod1,"Accesion")
## Tukey multiple comparisons of means
## 95% family-wise confidence level
##
## Fit: aov(formula = CBD ~ Accesion, data = df)
##
## $Accesion
## diff lwr upr p adj
## A2-A1 -9.852638 -11.431888 -8.273389 0
## A3-A1 -24.240797 -25.820046 -22.661547 0
## A4-A1 -19.415678 -20.994928 -17.836428 0
## A3-A2 -14.388158 -15.967408 -12.808908 0
## A4-A2 -9.563039 -11.142289 -7.983790 0
## A4-A3 4.825119 3.245869 6.404369 0
Con un nivel de significancia del 0.05, se tiene evidencia estadistica para concluir que se presentan diferencias significativas entre los cuatro genotipos.
##Normalidad
shapiro.test(mod1$residuals)
##
## Shapiro-Wilk normality test
##
## data: mod1$residuals
## W = 0.996, p-value = 0.9837
-Los residuales del modelo son normales
##Igualdad de varianzas
bartlett.test(mod1$residuals,df$Accesion)
##
## Bartlett test of homogeneity of variances
##
## data: mod1$residuals and df$Accesion
## Bartlett's K-squared = 8.8102, df = 3, p-value = 0.03192
-Las varianzas son diferentes
dist_matrix <- as.matrix(dist(cbind(df$Accesion,df$DBC)))#;dist_matrix
which.max(dist_matrix)
## [1] 91
max(dist_matrix) # Mayor valor
## [1] 3
min(dist_matrix) # Menor valor
## [1] 0
dim(df)
## [1] 120 4
dist_matrix_inv <- 1 / dist_matrix # Element wise #inversa distancia
dist_matrix_inv[is.infinite(dist_matrix_inv)]<-0
diag(dist_matrix_inv) <- 0
library(ape)
## Warning: package 'ape' was built under R version 4.1.3
Moran.I(df$CBD, dist_matrix_inv)
## $observed
## [1] -0.08761466
##
## $expected
## [1] -0.008403361
##
## $sd
## [1] 0.008130559
##
## $p.value
## [1] 1.987686e-22
library(writexl)
## Warning: package 'writexl' was built under R version 4.1.3
write_xlsx(df,"datosPAOLAOSPINA")