help > missing covariate value help
Showing 1-5 of 5 posts
Display:
Results per page:
Mar 7, 2015  05:03 PM | Fred Uquillas
missing covariate value help
Hi guys,
Wondering how I can specify a second level covariate (IQ), when I have a missing value.
And then, how would I define the contrast for second-level analyses?

I read somewhere you can remove with a 0, but for a continuous variable this doesn't make sense (say for example I'm trying to control for Beck Depression Inventory score, and many controls have a score of 0). Will Conn know I'm referring to IQ if my covariate title is named IQ and remove the person with a 0? What if I'm entering a covariate for a behavioral scale (BDI, etc) and someone has a score of zero?

Additionally, I don't want to remove/exclude a whole participant from an analysis, as explained in the Nov. 6th 2014 response from Prady Umma to Karolina , where she explains how to make an 'Exclude_subjects" covariate with 1s and 0s.

Thanks so much guys for any help you may be able to provide!

All the best,

Fred
Apr 6, 2015  08:04 PM | Alfonso Nieto-Castanon - Boston University
RE: missing covariate value help
Hi Fred,

There are three ways in CONN for removing one or several subjects from a particular second-level analysis (e.g. correlation of connectivity with IQ with some missing-data in the IQ variable):

1) first define a new set of second-level covariates where the missing subject data is filled with 0's in all of the covariates that are relevant to your analysis (e.g. create a new 'AllSubjects_valid' covariate and a new 'IQ_valid' covariate, where the values for the missing subject have been filled with 0). Then perform the standard second-level analysis using these new covariates (e.g. select 'AllSubjects_valid' and 'IQ_valid' and enter a contrast [0 1])

2) first define a new set of second-level covariates, one for each missing-data subject, dummy coding the corresponding subject(s) (e.g. create a new 'Subject1_missing' covariate that contains all 0's except for the missing subject where you enter a 1). Then perform the standard second-level analysis using the typical subject effects PLUS any newly create 'Subject_mising' covariate(s), for which you enter a 0 in the corresponding contrast definition value(s) (e.g. select 'AllSubjects', 'IQ', and 'Subject1_missing', and enter a contrast [0 1 0])

3) in release 15 you may also use a third approach where you can simply enter NaN for any values that are missing in your second-level covariate definitions (e.g. in your 'IQ' covariate simply enter NaN as the value for the missing-data subject(s)). Then perform the standard second-level analysis using the typical subject effects (e.g. select 'AllSubjects', and 'IQ', and enter a contrast [0 1])

All of these approaches are exactly equivalent, they will lead to exactly the same test, statistics, p-values, degrees of freedom, etc. You may simply choose the one that you find simpler to implement for your particular case. The reason why approach (1) works even for continuous variables like IQ or DMI, which may contain actually valid/meaningful 0 values, is that CONN will only remove subjects from consideration in your second-level analysis if they contain 0's in all of the included between-subject effects. An actual missing-DMI subject will contain 0's in both the 'AllSubjects_valid' as well as the 'DMI_valid' variables, while a valid-DMI subject may contain 0's in the 'DMI_valid' variable, but it will always contain 1's in the 'AllSubjects_valid' variable so they will not be removed from the analysis.

Hope this helps clarify
Alfonso

ps. regarding your last "I dont' want to remove/exclude a whole participant from an analysis" remark, I am not sure if I am underestanding or addressing that question correctly, could please elaborate what you mean there?

Originally posted by Fred Uquillas:
Hi guys,
Wondering how I can specify a second level covariate (IQ), when I have a missing value.
And then, how would I define the contrast for second-level analyses?

I read somewhere you can remove with a 0, but for a continuous variable this doesn't make sense (say for example I'm trying to control for Beck Depression Inventory score, and many controls have a score of 0). Will Conn know I'm referring to IQ if my covariate title is named IQ and remove the person with a 0? What if I'm entering a covariate for a behavioral scale (BDI, etc) and someone has a score of zero?

Additionally, I don't want to remove/exclude a whole participant from an analysis, as explained in the Nov. 6th 2014 response from Prady Umma to Karolina , where she explains how to make an 'Exclude_subjects" covariate with 1s and 0s.

Thanks so much guys for any help you may be able to provide!

All the best,

Fred
Apr 6, 2015  09:04 PM | Fred Uquillas
RE: missing covariate value help
Hi Alfonso, this is incredibly helpful! Thank you.
I'll try the NaN option this time for representing a missing continuous variable value for a particular participant.

So then, I'm testing the following between-subjects contrasts:
1) [-1 1], Exp group > Controls
2) [-1 1 0 0], where 0 is mean realignment and age, respectively
3) [-1 1 0 0 0], where 0 is mean realignment, age and IQ (with one NaN value), respectively
4) [-1 1 0 0 ], where 0 is mean realignment and IQ, respectively

-Decided to include IQ because there were significant differences in mean IQ between participant pools (exp. group N=12, control group N=12),
-We want to further include mean realignment at the between-groups comparison stage,
-Age is a covariate of interest.

We're then exploring graph (638x638) analysis metrics.

Thank you again Alfonso. So helpful.


Fred


Originally posted by Alfonso Nieto-Castanon:
Hi Fred,

There are three ways in CONN for removing one or several subjects from a particular second-level analysis (e.g. correlation of connectivity with IQ with some missing-data in the IQ variable):

1) first define a new set of second-level covariates where the missing subject data is filled with 0's in all of the covariates that are relevant to your analysis (e.g. create a new 'AllSubjects_valid' covariate and a new 'IQ_valid' covariate, where the values for the missing subject have been filled with 0). Then perform the standard second-level analysis using these new covariates (e.g. select 'AllSubjects_valid' and 'IQ_valid' and enter a contrast [0 1])

2) first define a new set of second-level covariates, one for each missing-data subject, dummy coding the corresponding subject(s) (e.g. create a new 'Subject1_missing' covariate that contains all 0's except for the missing subject where you enter a 1). Then perform the standard second-level analysis using the typical subject effects PLUS any newly create 'Subject_mising' covariate(s), for which you enter a 0 in the corresponding contrast definition value(s) (e.g. select 'AllSubjects', 'IQ', and 'Subject1_missing', and enter a contrast [0 1 0])

3) in release 15 you may also use a third approach where you can simply enter NaN for any values that are missing in your second-level covariate definitions (e.g. in your 'IQ' covariate simply enter NaN as the value for the missing-data subject(s)). Then perform the standard second-level analysis using the typical subject effects (e.g. select 'AllSubjects', and 'IQ', and enter a contrast [0 1])

All of these approaches are exactly equivalent, they will lead to exactly the same test, statistics, p-values, degrees of freedom, etc. You may simply choose the one that you find simpler to implement for your particular case. The reason why approach (1) works even for continuous variables like IQ or DMI, which may contain actually valid/meaningful 0 values, is that CONN will only remove subjects from consideration in your second-level analysis if they contain 0's in all of the included between-subject effects. An actual missing-DMI subject will contain 0's in both the 'AllSubjects_valid' as well as the 'DMI_valid' variables, while a valid-DMI subject may contain 0's in the 'DMI_valid' variable, but it will always contain 1's in the 'AllSubjects_valid' variable so they will not be removed from the analysis.

Hope this helps clarify
Alfonso

ps. regarding your last "I dont' want to remove/exclude a whole participant from an analysis" remark, I am not sure if I am underestanding or addressing that question correctly, could please elaborate what you mean there?

Originally posted by Fred Uquillas:
Hi guys,
Wondering how I can specify a second level covariate (IQ), when I have a missing value.
And then, how would I define the contrast for second-level analyses?

I read somewhere you can remove with a 0, but for a continuous variable this doesn't make sense (say for example I'm trying to control for Beck Depression Inventory score, and many controls have a score of 0). Will Conn know I'm referring to IQ if my covariate title is named IQ and remove the person with a 0? What if I'm entering a covariate for a behavioral scale (BDI, etc) and someone has a score of zero?

Additionally, I don't want to remove/exclude a whole participant from an analysis, as explained in the Nov. 6th 2014 response from Prady Umma to Karolina , where she explains how to make an 'Exclude_subjects" covariate with 1s and 0s.

Thanks so much guys for any help you may be able to provide!

All the best,

Fred
Mar 26, 2020  03:03 PM | mscahart
RE: missing covariate value help
Hi Alfonso,

Just a question about your below response on how to remove a participant (1)). Once I have filled my subject missing data with 0s in my covariates, do I need to redo any of the steps of the pre-processing or can I do the second-level analysis straight away?

Many thanks

Marie
Mar 26, 2020  09:03 PM | Alfonso Nieto-Castanon - Boston University
RE: missing covariate value help
Hi Marie,

No need to re-process any of the previous steps. After changing your second-level covariates you may simply re-run your second-level analyses using those new covariates without any problem.

Best
Alfonso
Originally posted by mscahart:
Hi Alfonso,

Just a question about your below response on how to remove a participant (1)). Once I have filled my subject missing data with 0s in my covariates, do I need to redo any of the steps of the pre-processing or can I do the second-level analysis straight away?

Many thanks

Marie