+ Reply to Thread
Results 1 to 15 of 15

Thread: What test can I use to compare categorical and continuous variables?

  1. #1
    Points: 1,876, Level: 25
    Level completed: 76%, Points required for next Level: 24

    Posts
    31
    Thanks
    1
    Thanked 0 Times in 0 Posts

    What test can I use to compare categorical and continuous variables?




    Hello guys:

    I have two sets of data, actual outcome (live vs. dead), which is categorical, and a risk adjustment predicted outcome, which is represented in continuous variables, i.e. percentages.
    Now the actual mortality is 20% in a population of 100 subjects and the predicted mortality is 30% for the same population.
    What statistical test can I use to compare the actual mortality with the predicted one to see if there is a significant difference between the actual and predicted values.

    Thanks in advance guys.

  2. #2
    TS Contributor
    Points: 8,362, Level: 61
    Level completed: 71%, Points required for next Level: 88

    Location
    Crete, Greece
    Posts
    717
    Thanks
    0
    Thanked 35 Times in 34 Posts

    Re: What test can I use to compare categorical and continuous variables?

    You have only 20 out of 100 dead and predicted 30 and that's it? or you have more data?

  3. #3
    Points: 1,876, Level: 25
    Level completed: 76%, Points required for next Level: 24

    Posts
    31
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: What test can I use to compare categorical and continuous variables?

    Please forgive me if my last post was confusing, English is a second language to me.

    Allow me to elaborate; I have a predicted APACHE IV mortality score for every patient in my cohort. So I have 100 predicted mortality rates. Also, the actual outcome after patient follow-up was documented. So in the duration of follow-up I have the actual outcome of all 100 enrolled patients (live vs. dead).

    The 30% represents the median predicted mortality score, since the predicted mortality was not normally distributed, I calculated the median and IQR.

    I want to see if there is a statically significant difference between these two variables.
    Since one is categorical and the other is continuous, I don't know which test to use.

    Could any please tell me what test is appropriate here?

    Thanks in advance and sorry for the confusion.

  4. #4
    TS Contributor
    Points: 8,362, Level: 61
    Level completed: 71%, Points required for next Level: 88

    Location
    Crete, Greece
    Posts
    717
    Thanks
    0
    Thanked 35 Times in 34 Posts

    Re: What test can I use to compare categorical and continuous variables?

    Ok, let me get this straight, you are not Apache, but you calculated something with Apache. Ok.
    You have 100 patients, some of them died and some of them are still alive. But you also made predictions about them dying or living. An you also have 100 APACHE IV mortality rates. And you want to see whether the predicted apache scores are close to the observed apache scores. Correct?
    Then I suggest you do G=Sum{[(exp-obs)^2]/exp } and compare it with chi-square at 99 degrees of freedom at 95%.

  5. #5
    Points: 1,876, Level: 25
    Level completed: 76%, Points required for next Level: 24

    Posts
    31
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: What test can I use to compare categorical and continuous variables?

    Let me give you an example of my data maybe that will elaborate:

    Patient out come --- APACHE predicted mortality rate

    live --- 13.4
    deceased --- 15.2
    live --- 9.7
    live --- 10.7
    live --- 9.7
    deceased --- 18.7

    The overall mortality rate in my cohort is 20%. The median APACHE predicted mortality rate is 30%.
    What test should I use to assess the variance between these two variables?
    Again I am very sorry for the confusion and thank you very much for the prompt replies.

  6. #6
    TS Contributor
    Points: 8,362, Level: 61
    Level completed: 71%, Points required for next Level: 88

    Location
    Crete, Greece
    Posts
    717
    Thanks
    0
    Thanked 35 Times in 34 Posts

    Re: What test can I use to compare categorical and continuous variables?

    A ok, I see now. Ok, this is logistic regression. the patient outcome is the response variable, the dependent and the apache the independent, right?
    do you know SPSS or R?

  7. #7
    Points: 1,876, Level: 25
    Level completed: 76%, Points required for next Level: 24

    Posts
    31
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: What test can I use to compare categorical and continuous variables?

    Yes I have SPSS V-16.

    I did the logistic regression both using SPSS and Excel (using XLSTAT).

    In SPSS, the dependant variable was patient outcome; the covariates were the predicted scores.
    The SPSS gave me a lot of tables where can I find the significance (P-value)?

    On XLSTAT, in the ''Evaluating the goodness of fit of the model'' table; R=0.065, and Pr. > L.R. Chi-square=0.007.
    In the ''Estimates of the parameters of the model (maximum likelihood)'' Pr. > Chi-square< 0.0001

    How can I interrupt these results?

  8. #8
    TS Contributor
    Points: 8,362, Level: 61
    Level completed: 71%, Points required for next Level: 88

    Location
    Crete, Greece
    Posts
    717
    Thanks
    0
    Thanked 35 Times in 34 Posts

    Re: What test can I use to compare categorical and continuous variables?

    in spss the significance is in the significance column of the table with estimates of the parameters. XLSTAT no idea. But R^2=0.065 is very bad.

  9. The Following User Says Thank You to Masteras For This Useful Post:

    scerab (08-09-2011)

  10. #9
    Points: 1,876, Level: 25
    Level completed: 76%, Points required for next Level: 24

    Posts
    31
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: What test can I use to compare categorical and continuous variables?

    So according to this table, from SPSS, the difference between the actual and predicted rates are insignificant, right?

    Omnibus Tests of Model Coefficients:

    ---Chi-square ---df --- Sig.
    Step -124.810---112---.192
    Block -124.810---112---.192
    Model -124.810---112---.192

  11. #10
    TS Contributor
    Points: 8,362, Level: 61
    Level completed: 71%, Points required for next Level: 88

    Location
    Crete, Greece
    Posts
    717
    Thanks
    0
    Thanked 35 Times in 34 Posts

    Re: What test can I use to compare categorical and continuous variables?

    ? can you tell me how you performed the logistic regression? the steps i mean. But i think yes, insignificant.

  12. #11
    Points: 1,876, Level: 25
    Level completed: 76%, Points required for next Level: 24

    Posts
    31
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: What test can I use to compare categorical and continuous variables?

    1-analysis
    2-regression
    3-Binary logistic
    4-I selected hospital outcome (live vs. dead) as the ''dependant'' variable.
    5-APACHE IV predicted mortality rate added to the covariates.
    6-options ----> (selected) classification plot.
    7-finally, click ''ok''.
    In the output sheet I got a number of tables:
    * Block 0: Beginning block
    a- Variables in the equation
    b- Variables not in the equation
    * Block 1: Method = Enter:
    a- Omnibus Tests of Model Coefficients
    b- Model summery
    c- Classification table
    d- Variables in the equation

    Was my protocol correct?
    Thank you very much for you assistance.

  13. #12
    TS Contributor
    Points: 8,362, Level: 61
    Level completed: 71%, Points required for next Level: 88

    Location
    Crete, Greece
    Posts
    717
    Thanks
    0
    Thanked 35 Times in 34 Posts

    Re: What test can I use to compare categorical and continuous variables?

    Now i do not have spss in front of me, but i think try another thing also. I remeber there was something different with this approach.
    Analyze? generalised linear models? generalized linear models and then select binomial distribution, response (dependent) variable is binary (0-1) and link function logit. Go to model and choose independent in the covariate(s) white box and then then model transfer the independent variable on the right hand side. Then press ok and see what you get.

  14. #13
    Points: 1,876, Level: 25
    Level completed: 76%, Points required for next Level: 24

    Posts
    31
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: What test can I use to compare categorical and continuous variables?

    Thank you very much for the directions.

    I tried them but, did not get any results at all.

    Were the steps I followed on SPSS not correct?

  15. #14
    Points: 940, Level: 16
    Level completed: 40%, Points required for next Level: 60

    Location
    Vancouver
    Posts
    18
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: What test can I use to compare categorical and continuous variables?

    ''Evaluating the goodness of fit of the model'' table; R=0.065, and Pr. > L.R. Chi-square=0.007.
    In the ''Estimates of the parameters of the model (maximum likelihood)'' Pr. > Chi-square< 0.0001


    what is R^2 for logistoc regression?

  16. #15
    TS Contributor
    Points: 8,362, Level: 61
    Level completed: 71%, Points required for next Level: 88

    Location
    Crete, Greece
    Posts
    717
    Thanks
    0
    Thanked 35 Times in 34 Posts

    Re: What test can I use to compare categorical and continuous variables?


    I think you did something wrong then. As i said i do not have spss now. I remeber there was something with the approach you followed, but I do not remember what. Probably you did something wrong. The binary variable is scale like the apache right?

+ Reply to Thread

           




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats