+ Reply to Thread
Results 1 to 4 of 4

Thread: Applying multiple regression results to new data SPSS

  1. #1
    Points: 4, Level: 1
    Level completed: 7%, Points required for next Level: 46

    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Applying multiple regression results to new data SPSS




    My study involves testing infants at multiple time points using a number of behavioural tests.

    I used a multiple regression to establish which behavioural variables could predict severity of outcome score at the end of the testing.

    So, I tested infants at 14 months and used a regression model to identify whether scores from any of the behavioural variables could predict better or worse scores at 24 months.

    my model works fine and 4 IV's significantly predicted severity of outcome. But now I want to use this regression model to see whether it can predict 24m outcomes from a new dataset with new infants - BUT they have been tested on the same IV's and DV's.


    Does anyone know how I might go about doing this in SPSS?


    Thank you

  2. #2
    Omega Contributor
    Points: 38,396, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    7,001
    Thanks
    398
    Thanked 1,186 Times in 1,147 Posts

    Re: Applying multiple regression results to new data SPSS

    Followed you all of the way up until your last sentences. I got confused because it sounded like you just wanted to repeat the whole process - which I would imagine you know how to do.
    Stop cowardice, ban guns!

  3. #3
    TS Contributor
    Points: 12,227, Level: 72
    Level completed: 45%, Points required for next Level: 223
    rogojel's Avatar
    Location
    I work in Europe, live in Hungary
    Posts
    1,470
    Thanks
    160
    Thanked 332 Times in 312 Posts

    Re: Applying multiple regression results to new data SPSS

    Hi,
    i do not know Spss but most statistics programs have "predict" function for such cases, that can be used once the model has been specified. For a simple multiple regression you could even use Excel - just implement the model formula in Excel and let it calculate the predictions for the new data.

    I hope this helps

  4. #4
    Points: 1,118, Level: 18
    Level completed: 18%, Points required for next Level: 82

    Posts
    44
    Thanks
    1
    Thanked 7 Times in 7 Posts

    Re: Applying multiple regression results to new data SPSS


    There are a couple of ways to do it at least. One way I know how to do it is to combine your two samples with all your IVs and keep the DV as missing data for you new sample. The data from sample 1 used for estimating the model will have values for the DV

    Then create the syntax for your regression and add
    /SAVE pred(prediction1) or select the save predicted option in the dialogs

    This will save the predicted values in a variable called prediction 1. SPSS will estimate the model based on the sample 1 cases which have values for the DV and will predict values for all cases for sample 1 and sample 2.

    A second manual way is just to use the TRANSFORM-COMPUTE VARIABLE function and manually create the formula with your coefficients.

    There is another way where you can save the derived regression model to an xml file and use an APPLY_MODEL function but I haven't used that.

    [EDITED to add syntax]

    To use a model XML you either save the model parameters to a file using the SAVE dialog or use the following syntax clause in your regression

    /OUTFILE=model('mymodelparametrs.xml')

    This will save the estimated model to an xml file.

    Then open your new sample and to use the parameters with your new sample.

    * Open the saved model.
    MODEL HANDLE NAME = mymodel file='mymodelparameters.xml'.

    * Compute predictions.
    COMPUTE myprediction= ApplyModel(mymodel,'predict').
    Last edited by statsanon; 12-06-2015 at 05:31 AM.

+ 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