SPSS Statistics

 View Only

  • 1.  Correlated Dataset Generator

    Posted Wed May 11, 2022 04:11 PM
    I have developed a macro-enabled Excel program that creates datasets of variables with user-specified correlations. The program accommodates normal random variates, scale variables with specified mean, standard deviation, etc. and/or binomial variables. It is freely available; please share it with others.

    Correlated Dataset Generator

    ------------------------------
    Clarence Burns
    ------------------------------

    #SPSSStatistics


  • 2.  RE: Correlated Dataset Generator

    Posted Wed May 11, 2022 04:42 PM
    Thanks for sharing!

    BTW, you might want to check out the SPSS procedure SIMULATE (along with SIMRUN), which also does that, as well as other things.

    To design a simulation without a predictive model

    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------

    Original Message


  • 3.  RE: Correlated Dataset Generator

    IBM Champion
    Posted Wed May 11, 2022 05:00 PM
    That will be useful.  It reminds me to point out a different take on a similar problem.
    The file makeCases.zip, which can be downloaded from here
    provides a data generator using Statistics code.  From the dialog help...

    This dialog creates a new dataset containing variables with values drawn from any of a set of probability distributions plus an ID variable. The generated variables are optionally transformed to produce correlated variables according to various correlation structures.

    All the variables have the same distribution, bu there are 23 distributions to choose from.  Correlations are simply generated by linear transformations, so, if used, nonnormal distributions will be distorted.

    --



    Original Message


  • 4.  RE: Correlated Dataset Generator

    Posted Thu May 12, 2022 06:03 PM
    To add more to the thread...
    !KO_mvnorm generates random data from normal population with specified covariances/correlations.
    !KO_tocov brings data at hand to covariate/correlate exactly as you want.
    Both functions (which are SPSS macros) are found in "MATRIX – END MATRIX functions" collection on my web-page https://www.spsstools.net/en/macros/KO-spssmacros/

    ------------------------------
    Kirill Orlov
    ------------------------------

    Original Message


  • 5.  RE: Correlated Dataset Generator

    Posted 16 days ago

    Hello.

    I'm not sure, but the Excel file seems to be under password plock. Could you please share it with us? Thanks



    ------------------------------
    Artem Meuwl
    ------------------------------

    Original Message


  • 6.  RE: Correlated Dataset Generator

    IBM Champion
    Posted 16 days ago

    I had no trouble downloading the zip file and extracting and using the Excel file.



    ------------------------------
    Jon Peck
    ------------------------------

    Original Message