Séance 2 : comparaison de moyenne, corrélations et régression

Master 2 siren 2023

Author

Christophe Benavent

Published

April 24, 2023

Data

Code
library(tidyverse)
df <- read_csv("MusicPlateform2.csv")%>%
  rename(ID=1,
         Rock=2,
         PopInter=3,
         HipHop=4,
         World=5,
         Salsa=6,
         Classique=7,
         Techno=8,
         HardRock=9,
         Baroque=10,
         Folk=11,
         Reggae=12,
         ChansonFrançaise=13,
         RockAlt=14,
         Dance=15,
         Jazz=16,
         AfroPop=17,
         Opera=18,
         Arabic=19,
         Blues=20,
         JK_pop=21,
         Rap=22,
         SoulFunk=23,
         S_travail=24,
         S_Live=25,
         S_Voiture=26,
         S_Menage=27,
         S_Ami=28,
         S_Bars=29,
         S_Transport=30,
         S_Lire=31,
         S_Douche=32,
         D_Vynil=33,
         D_Streaming=34,
         D_smartphone=35,
         D_concert=36,
         D_laptop=37,
         D_ecouteurs=38,
         D_mix=39,
         D_radiotv=40,
         P_Youtube=42,
         P_Spotify=43,
         P_Deezer=44,
         P_Souncloud=45,
         P_Bandcamp=46, 
         P_Discog=47,
         P_Tidal=48,
         P_Amazon=49,
         P_Mixcloud=50,
         P_AppleM=51,
         P_Qobuz=52,
         P_Pandora=53,
         P_Netease=54,
         Time=68,
         Spending=69,
         Value=70, 
         Age=71,
         Genre=72)


df$Age<-factor(df$Age, ordered = TRUE, 
                                levels = c("moins de 18 ans", "de 18 à 20 ans",
                                           "de 21 à 25 ans", "de 26 à 30 ans",
                                           "de 31 à 40 ans", "de 41 à 60 ans",
                                           "plus de 60 ans"))
#color palette
col<-c("Coral","Pink","Gold","Orange")

Comparaisaon de moyenne

Code
table(df$Time)

 Entre 2 et 4h  Entre 4 et 8h Entre 8 et 16h    Moins de 2h    Plus de 16h 
            32             40             41             29             33 
Code
df$Time2<-NA
df$Time2[df$Time=="Moins de 2h"]<-1
df$Time2[df$Time=="Entre 2 et 4h"]<-3
df$Time2[df$Time=="Entre 4 et 8h"]<-6
df$Time2[df$Time=="Entre 8 et 16h"]<- 12
df$Time2[df$Time=="Plus de 16h"]<- 24

moyenne_time<-round(mean(df$Time2, na.rm=TRUE), 2)
moyenne_time<-round(sd(df$Time2, na.rm=TRUE), 2)


ggplot(df, aes(x=Time2))+
  geom_histogram()+
  labs(title = "distribution des durée d'écoute",
       subtitle = paste0("Moyenne : ",moyenne_time))

Code
foo <- df %>% group_by(Age)%>%
  summarise(n =n(),
            temps_moyen=mean(Time2, na.rm=TRUE),
            temps_sd=sd(Time2, na.rm=TRUE),
            sd=temps_sd/sqrt(n)) 
foo
# A tibble: 7 × 5
  Age                 n temps_moyen temps_sd    sd
  <ord>           <int>       <dbl>    <dbl> <dbl>
1 moins de 18 ans     5        6        3.67 1.64 
2 de 18 à 20 ans      4        7.5      5.20 2.60 
3 de 21 à 25 ans     95       10.7      8.20 0.842
4 de 26 à 30 ans      8        9.38     9.77 3.45 
5 de 31 à 40 ans     14        9.64     8.71 2.33 
6 de 41 à 60 ans     37        7.86     7.79 1.28 
7 plus de 60 ans     14        5.93     5.92 1.58 
Code
fit<-lm(Time2 ~ Age,data=df)
anova(fit)
Analysis of Variance Table

Response: Time2
           Df  Sum Sq Mean Sq F value Pr(>F)
Age         6   497.5  82.911    1.31 0.2553
Residuals 168 10633.2  63.293               
Code
ggplot(foo, aes(x=Age, y=temps_moyen, group=1))+
  geom_line(size=2, color="green")+
  geom_errorbar(aes(ymin=temps_moyen-sd, ymax=temps_moyen+sd), 
                width=.2, position=position_dodge(.9)) +
  coord_flip()

Correlations

Code
table(df$Spending)

           0 euros  0 euros, 10 euros           10 euros 10 euros, 20 euros 
                36                  1                 93                  2 
         100 euros           20 euros 20 euros, 50 euros          200 euros 
                 5                 22                  1                  1 
 200 euros et plus           50 euros 
                 4                 12 
Code
df$SpendingMax<-NA
df$SpendingMax[df$Spending=="0 euros"] <-0
df$SpendingMax[df$Spending=="0 euros, 10 euros"] <-10
df$SpendingMax[df$Spending=="10 euros"] <-10
df$SpendingMax[df$Spending=="10 euros, 20 euros"] <-20
df$SpendingMax[df$Spending=="20 euros"] <-20
df$SpendingMax[df$Spending=="50 euros"] <-50
df$SpendingMax[df$Spending=="100 euros"] <-100
df$SpendingMax[df$Spending=="200 euros"] <-200
df$SpendingMax[df$Spending=="200 euros et plus"] <-400

table(df$SpendingMax)

  0  10  20  50 100 200 400 
 36  94  24  12   5   1   4 
Code
moyenne_Spending<-round(mean(df$SpendingMax, na.rm=TRUE), 2)
moyenne_Spending<-round(sd(df$SpendingMax, na.rm=TRUE), 2)

foo<-df %>% 
  select(Time2,SpendingMax) %>%
  drop_na()

r<-cor(foo$Time2,foo$SpendingMax)

res<-cor.test(foo$Time2,foo$SpendingMax, method="pearson")
res

    Pearson's product-moment correlation

data:  foo$Time2 and foo$SpendingMax
t = 3.2837, df = 172, p-value = 0.001241
alternative hypothesis: true correlation is not equal to 0
95 percent confidence interval:
 0.09764282 0.37799582
sample estimates:
      cor 
0.2428844 
Code
ggplot(foo,aes(Time2, SpendingMax))+geom_point()+
  geom_smooth()+
  geom_smooth(method="lm", color="red")+scale_y_log10()

Correlation entre plus de 3 variables

Code
table(df$ValueMax)
< table of extent 0 >
Code
df$ValueMax[df$Value=="moins de 50 euros"] <-50
df$ValueMax[df$Value=="moins de 50 euros, 100 euros"] <-100
df$ValueMax[df$Value=="100 euros"] <-100
df$ValueMax[df$Value=="200 euros"] <-200
df$ValueMax[df$Value=="500 euros"] <-500
df$ValueMax[df$Value=="1000 euros"] <-1000
df$ValueMax[df$Value=="2000 euros"] <-2000
df$ValueMax[df$Value=="200 euros, 2000 euros"] <-2000

df$ValueMax[df$Value=="2000 euros, 5000 euros et plus"] <-5000
df$ValueMax[df$Value=="5000 euros et plus"] <-5000

ggplot(df, aes(x=ValueMax))+geom_bar()+coord_flip()

Code
foo<-df %>% 
  select(Time2,SpendingMax, ValueMax) %>%
  drop_na()

r<-cor(foo)

r
                Time2 SpendingMax  ValueMax
Time2       1.0000000   0.2413880 0.3666272
SpendingMax 0.2413880   1.0000000 0.3156296
ValueMax    0.3666272   0.3156296 1.0000000
Code
library(ggcorrplot)

ggcorrplot(r, hc.order = TRUE, type = "lower",
   outline.col = "white",
   ggtheme = ggplot2::theme_gray,
   colors = col, 
    lab = TRUE)

Linear model

Code
fit <-lm(SpendingMax~Time2+ValueMax+Age,df)
summary(fit)

Call:
lm(formula = SpendingMax ~ Time2 + ValueMax + Age, data = df)

Residuals:
   Min     1Q Median     3Q    Max 
-80.01 -17.20  -5.79   3.21 384.71 

Coefficients:
              Estimate Std. Error t value Pr(>|t|)   
(Intercept)   5.031068   8.785804   0.573  0.56768   
Time2         1.266388   0.628763   2.014  0.04563 * 
ValueMax      0.010005   0.003384   2.957  0.00357 **
Age.L        -5.912690  21.574689  -0.274  0.78439   
Age.Q         5.260556  20.179553   0.261  0.79466   
Age.C       -21.883899  19.378383  -1.129  0.26042   
Age^4        -2.232052  21.832024  -0.102  0.91869   
Age^5        -2.305212  16.906468  -0.136  0.89171   
Age^6         6.125545  17.419866   0.352  0.72556   
---
Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

Residual standard error: 59.46 on 164 degrees of freedom
  (4 observations effacées parce que manquantes)
Multiple R-squared:   0.13, Adjusted R-squared:  0.08754 
F-statistic: 3.063 on 8 and 164 DF,  p-value: 0.003063
Code
library(jtools)
summ(fit)
MODEL INFO:
Observations: 173 (4 missing obs. deleted)
Dependent Variable: SpendingMax
Type: OLS linear regression 

MODEL FIT:
F(8,164) = 3.06, p = 0.00
R² = 0.13
Adj. R² = 0.09 

Standard errors: OLS
--------------------------------------------------
                      Est.    S.E.   t val.      p
----------------- -------- ------- -------- ------
(Intercept)           5.03    8.79     0.57   0.57
Time2                 1.27    0.63     2.01   0.05
ValueMax              0.01    0.00     2.96   0.00
Age.L                -5.91   21.57    -0.27   0.78
Age.Q                 5.26   20.18     0.26   0.79
Age.C               -21.88   19.38    -1.13   0.26
Age^4                -2.23   21.83    -0.10   0.92
Age^5                -2.31   16.91    -0.14   0.89
Age^6                 6.13   17.42     0.35   0.73
--------------------------------------------------
Code
effect_plot(fit,pred=Age,interval = TRUE)

Code
effect_plot(fit,pred=Time2,interval = TRUE, plot.points = TRUE, 
            jitter = 0.05)