SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 


#Analytics
#SPSSStatistics
#Analyticstools
 View Only

  • 1.  Correlated Dataset Generator

    Posted 05/11/22 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 05/11/22 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
    ------------------------------



  • 3.  RE: Correlated Dataset Generator

    Posted 05/11/22 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.

    --





  • 4.  RE: Correlated Dataset Generator

    Posted 05/12/22 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
    ------------------------------



  • 5.  RE: Correlated Dataset Generator

    Posted 04/26/24 02:40 PM

    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
    ------------------------------



  • 6.  RE: Correlated Dataset Generator

    Posted 04/26/24 03:30 PM

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



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

    Original Message


  • 7.  RE: Correlated Dataset Generator

    Posted 3 days ago

    Please help with the password for this file



    ------------------------------
    Charles Were
    ------------------------------



  • 8.  RE: Correlated Dataset Generator

    Posted 3 days ago
    There is an extension command, STATS MAKE CASES, available via Extensions > Extension Hub that creates random datasets from a large number of distributions and provides for many different correlation patterns.

    It appears in the menus as File > New > Data with Cases.  Here's an example of the syntax generated from the menu

    STATS MAKE CASES
    DATASET=newdata NUMVARS=2 NUMCASES=1000
    DISTRIBUTION=NORMAL P1=0.0 P2=1.0
    /CORRELATIONS ORTHOG=NOFACTOR STRUCTURE=TOEPLITZ DISPLAY=YES.


    --



    Original Message


Related Content