9.8 Model fitting
Engage with the data and the results when model fitting. Do not use automated processes  you have to keep thinking.
Three things are important to keep looking at:
 what is the assocication between a particular variable and the outcome (OR and 95%CI);
 how much information is a variable bringing to the model (change in AIC and cstatistic);
 how much influence does adding a variable have on the effect size of another variable, and in particular my variable of interest (a rule of thumb is a greater than 10% change in the OR of the variable of interest is important).
We’re going to start by including the variables from above which we think are relevant.
library(finalfit)
dependent = "mort_5yr"
explanatory = c("ulcer.factor", "age", "sex.factor", "t_stage.factor")
fit2 = melanoma %>%
finalfit(dependent, explanatory, metrics = TRUE)
Dependent: 5year survival  No  Yes  OR (univariable)  OR (multivariable)  

Ulcerated tumour  Absent  105 (91.3)  10 (8.7) 


Present  55 (61.1)  35 (38.9)  6.68 (3.1815.18, p<0.001)  3.21 (1.328.28, p=0.012)  
Age (years)  Mean (SD)  51.7 (16.0)  55.3 (18.8)  1.01 (0.991.03, p=0.202)  1.00 (0.981.02, p=0.948) 
Sex  Female  105 (83.3)  21 (16.7) 


Male  55 (69.6)  24 (30.4)  2.18 (1.124.30, p=0.023)  1.26 (0.572.76, p=0.558)  
Tstage  T1  52 (92.9)  4 (7.1) 


T2  49 (92.5)  4 (7.5)  1.06 (0.244.71, p=0.936)  0.77 (0.163.58, p=0.733)  
T3  36 (70.6)  15 (29.4)  5.42 (1.8020.22, p=0.005)  2.98 (0.8612.10, p=0.098)  
T4  23 (51.1)  22 (48.9)  12.43 (4.2146.26, p<0.001)  4.98 (1.3421.64, p=0.021) 
Number in dataframe = 205, Number in model = 205, Missing = 0, AIC = 188.1, Cstatistic = 0.798, H&L = Chisq(8) 3.92 (p=0.864) 
The model metrics have improved with the AIC decreasing from 192 to 188 and the cstatistic increasing from 0.717 to 0.798.
Let’s consider age
.
We may expect age to be associated with the outcome become is so commonly is.
But there is weak evidence of an association in the univariable analysis.
We have shown above that the relationship of age to the outcome is not linear, therefore we need to act on this.
We can either convert age to a cateogorical variable or include it with a quadratic term (\(x^2 + x\), remember parabolas from school?).
melanoma = melanoma %>%
mutate(
age.factor = cut(age,
breaks = c(0, 25, 50, 75, 100)) %>%
ff_label("Age (years)"))
# Add this to relevel:
# fct_relevel("(50,75]")
melanoma %>%
finalfit(dependent, c("ulcer.factor", "age.factor"), metrics = TRUE)
Dependent: 5year survival  No  Yes  OR (univariable)  OR (multivariable)  

Ulcerated tumour  Absent  105 (91.3)  10 (8.7) 


Present  55 (61.1)  35 (38.9)  6.68 (3.1815.18, p<0.001)  6.28 (2.9714.35, p<0.001)  
Age (years)  (0,25]  10 (71.4)  4 (28.6) 


(25,50]  62 (84.9)  11 (15.1)  0.44 (0.121.84, p=0.229)  0.54 (0.132.44, p=0.400)  
(50,75]  79 (76.0)  25 (24.0)  0.79 (0.243.08, p=0.712)  0.81 (0.223.39, p=0.753)  
(75,100]  9 (64.3)  5 (35.7)  1.39 (0.287.23, p=0.686)  1.12 (0.206.53, p=0.894) 
Number in dataframe = 205, Number in model = 205, Missing = 0, AIC = 196.6, Cstatistic = 0.742, H&L = Chisq(8) 0.20 (p=1.000) 
There is no strong relationship between the categorical representation of age and the outcome. Let’s try a quadratic term.
In base R, a quadartic term is added like this.
##
## Call:
## glm(formula = mort_5yr ~ ulcer.factor + I(age^2) + age, family = binomial,
## data = melanoma)
##
## Deviance Residuals:
## Min 1Q Median 3Q Max
## 1.3253 0.8973 0.4082 0.3889 2.2872
##
## Coefficients:
## Estimate Std. Error z value Pr(>z)
## (Intercept) 1.2636638 1.2058471 1.048 0.295
## ulcer.factorPresent 1.8423431 0.3991559 4.616 3.92e06 ***
## I(age^2) 0.0006277 0.0004613 1.361 0.174
## age 0.0567465 0.0476011 1.192 0.233
## 
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## (Dispersion parameter for binomial family taken to be 1)
##
## Null deviance: 215.78 on 204 degrees of freedom
## Residual deviance: 185.98 on 201 degrees of freedom
## AIC: 193.98
##
## Number of Fisher Scoring iterations: 5
It can be done in Finalfit
in a similar manner.
Note with default univariable model settings, the quadratic and linear term are considered in separate models, which doesn’t make much sense.
library(finalfit)
dependent = "mort_5yr"
explanatory = c("ulcer.factor", "I(age^2)", "age")
melanoma %>%
finalfit(dependent, explanatory, metrics = TRUE)
Dependent: 5year survival  No  Yes  OR (univariable)  OR (multivariable)  

Ulcerated tumour  Absent  105 (91.3)  10 (8.7) 


Present  55 (61.1)  35 (38.9)  6.68 (3.1815.18, p<0.001)  6.31 (2.9814.44, p<0.001)  
Age (years)  Mean (SD)  51.7 (16.0)  55.3 (18.8)  1.01 (0.991.03, p=0.202)  0.94 (0.861.04, p=0.233) 
NA  NA  NA  NA  1.00 (1.001.00, p=0.101)  1.00 (1.001.00, p=0.174) 
Number in dataframe = 205, Number in model = 205, Missing = 0, AIC = 194, Cstatistic = 0.748, H&L = Chisq(8) 5.24 (p=0.732) 
The AIC is worse when adding age either as a factor or with a quadratic term to the base model.
One final method to visualise the contribution of a particular variable is to remove it from the full model.
This is convenient in Finalfit
.
library(finalfit)
dependent = "mort_5yr"
explanatory = c("ulcer.factor", "age.factor", "sex.factor", "t_stage.factor")
explanatory_multi = c("ulcer.factor", "sex.factor", "t_stage.factor")
melanoma %>%
finalfit(dependent, explanatory, explanatory_multi,
keep_models = TRUE, metrics = TRUE)
Dependent: 5year survival  No  Yes  OR (univariable)  OR (multivariable)  OR (multivariable reduced)  

Ulcerated tumour  Absent  105 (91.3)  10 (8.7) 



Present  55 (61.1)  35 (38.9)  6.68 (3.1815.18, p<0.001)  3.06 (1.257.93, p=0.017)  3.21 (1.328.28, p=0.012)  
Age (years)  (0,25]  10 (71.4)  4 (28.6) 



(25,50]  62 (84.9)  11 (15.1)  0.44 (0.121.84, p=0.229)  0.37 (0.081.80, p=0.197) 


(50,75]  79 (76.0)  25 (24.0)  0.79 (0.243.08, p=0.712)  0.60 (0.152.65, p=0.469) 


(75,100]  9 (64.3)  5 (35.7)  1.39 (0.287.23, p=0.686)  0.61 (0.094.04, p=0.599) 


Sex  Female  105 (83.3)  21 (16.7) 



Male  55 (69.6)  24 (30.4)  2.18 (1.124.30, p=0.023)  1.21 (0.542.68, p=0.633)  1.26 (0.572.76, p=0.559)  
Tstage  T1  52 (92.9)  4 (7.1) 



T2  49 (92.5)  4 (7.5)  1.06 (0.244.71, p=0.936)  0.74 (0.153.50, p=0.697)  0.77 (0.163.58, p=0.733)  
T3  36 (70.6)  15 (29.4)  5.42 (1.8020.22, p=0.005)  2.91 (0.8411.82, p=0.106)  2.99 (0.8612.11, p=0.097)  
T4  23 (51.1)  22 (48.9)  12.43 (4.2146.26, p<0.001)  5.38 (1.4323.52, p=0.016)  5.01 (1.3721.52, p=0.020) 


The AIC improves when age is removed (186 from 190) at only a small loss in discrimination (0.794 from 0.802). Looking at the model table and comparing the full multivariable with the reduced multivariable, there has been a small change in the OR for ulceration, with some of the variation accounted for by age now being taken up by ulceration. This is to be expected, given the association (albeit weak) that we saw earlier between age and ulceration. Given all this, we will decide not to include age in the model.
Now what about the variable sex. It has a significant association with the outcome in the univariable analysis, but much of this is explained by other variables in multivaribale anlysis. Is it contributing much to the model?
library(finalfit)
dependent = "mort_5yr"
explanatory = c("ulcer.factor", "sex.factor", "t_stage.factor")
explanatory_multi = c("ulcer.factor", "t_stage.factor")
melanoma %>%
finalfit(dependent, explanatory, explanatory_multi,
keep_models = TRUE, metrics = TRUE)
Dependent: 5year survival  No  Yes  OR (univariable)  OR (multivariable)  OR (multivariable reduced)  

Ulcerated tumour  Absent  105 (91.3)  10 (8.7) 



Present  55 (61.1)  35 (38.9)  6.68 (3.1815.18, p<0.001)  3.21 (1.328.28, p=0.012)  3.26 (1.358.39, p=0.011)  
Sex  Female  105 (83.3)  21 (16.7) 



Male  55 (69.6)  24 (30.4)  2.18 (1.124.30, p=0.023)  1.26 (0.572.76, p=0.559) 


Tstage  T1  52 (92.9)  4 (7.1) 



T2  49 (92.5)  4 (7.5)  1.06 (0.244.71, p=0.936)  0.77 (0.163.58, p=0.733)  0.75 (0.163.45, p=0.700)  
T3  36 (70.6)  15 (29.4)  5.42 (1.8020.22, p=0.005)  2.99 (0.8612.11, p=0.097)  2.96 (0.8611.96, p=0.098)  
T4  23 (51.1)  22 (48.9)  12.43 (4.2146.26, p<0.001)  5.01 (1.3721.52, p=0.020)  5.33 (1.4822.56, p=0.014) 


By removing sex we have improved the AIC a little (184.4 from 186.1) with a small change in the cstatistic (0.791 from 0.794).
Looking at the model table, the variation has been taken up mostly by stage 4 disease and a little by ulceration. But there has been little change overall. We will exclude sex from our final model as well.
As a final we can check for a first order interaction between ulceration and Tstage. Just to remind us what this means, a significant interaction would mean the effect of, say, ulceration on 5year mortality would differ by Tstage. For instance, perhaps the presence of ulceration confers a much greater risk of death in advanced deep tumours compared with earlier superficial tumours.
library(finalfit)
dependent = "mort_5yr"
explanatory = c("ulcer.factor", "t_stage.factor")
explanatory_multi = c("ulcer.factor*t_stage.factor")
melanoma %>%
finalfit(dependent, explanatory, explanatory_multi,
keep_models = TRUE, metrics = TRUE)
label  levels  No  Yes  OR (univariable)  OR (multivariable)  OR (multivariable reduced) 

Ulcerated tumour  Absent  105 (91.3)  10 (8.7) 



Present  55 (61.1)  35 (38.9)  6.68 (3.1815.18, p<0.001)  3.26 (1.358.39, p=0.011)  4.00 (0.1841.34, p=0.274)  
Tstage  T1  52 (92.9)  4 (7.1) 



T2  49 (92.5)  4 (7.5)  1.06 (0.244.71, p=0.936)  0.75 (0.163.45, p=0.700)  0.94 (0.125.97, p=0.949)  
T3  36 (70.6)  15 (29.4)  5.42 (1.8020.22, p=0.005)  2.96 (0.8611.96, p=0.098)  3.76 (0.7620.80, p=0.104)  
T4  23 (51.1)  22 (48.9)  12.43 (4.2146.26, p<0.001)  5.33 (1.4822.56, p=0.014)  2.67 (0.1225.11, p=0.426)  
UlcerPresent:T2  Interaction 




0.57 (0.0221.55, p=0.730) 
UlcerPresent:T3  Interaction 




0.62 (0.0417.39, p=0.735) 
UlcerPresent:T4  Interaction 




1.85 (0.0994.20, p=0.716) 
There are no significant interaction terms.
Our final model table is therefore:
library(finalfit)
dependent = "mort_5yr"
explanatory = c("ulcer.factor", "age.factor",
"sex.factor", "t_stage.factor")
explanatory_multi = c("ulcer.factor", "t_stage.factor")
melanoma %>%
finalfit(dependent, explanatory, explanatory_multi, metrics = TRUE)
Dependent: 5year survival  No  Yes  OR (univariable)  OR (multivariable)  

Ulcerated tumour  Absent  105 (91.3)  10 (8.7) 


Present  55 (61.1)  35 (38.9)  6.68 (3.1815.18, p<0.001)  3.26 (1.358.39, p=0.011)  
Age (years)  (0,25]  10 (71.4)  4 (28.6) 


(25,50]  62 (84.9)  11 (15.1)  0.44 (0.121.84, p=0.229) 


(50,75]  79 (76.0)  25 (24.0)  0.79 (0.243.08, p=0.712) 


(75,100]  9 (64.3)  5 (35.7)  1.39 (0.287.23, p=0.686) 


Sex  Female  105 (83.3)  21 (16.7) 


Male  55 (69.6)  24 (30.4)  2.18 (1.124.30, p=0.023) 


Tstage  T1  52 (92.9)  4 (7.1) 


T2  49 (92.5)  4 (7.5)  1.06 (0.244.71, p=0.936)  0.75 (0.163.45, p=0.700)  
T3  36 (70.6)  15 (29.4)  5.42 (1.8020.22, p=0.005)  2.96 (0.8611.96, p=0.098)  
T4  23 (51.1)  22 (48.9)  12.43 (4.2146.26, p<0.001)  5.33 (1.4822.56, p=0.014) 
Number in dataframe = 205, Number in model = 205, Missing = 0, AIC = 184.4, Cstatistic = 0.791, H&L = Chisq(8) 0.43 (p=1.000) 
9.8.1 Odds ratio plot
dependent = "mort_5yr"
explanatory_multi = c("ulcer.factor", "t_stage.factor")
melanoma %>%
or_plot(dependent, explanatory_multi,
breaks = c(0.5, 1, 2, 5, 10, 25),
table_text_size = 3.5,
title_text_size = 16)
## Warning: Removed 2 rows containing missing values (geom_errorbarh).
We can conclude that there is evidence of an association between tumour ulceration and 5year survival which is independent of the tumour depth as captured by Tstage.