+ Reply to Thread
Results 1 to 1 of 1

macros for automatization of crosstab

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    Tel-aviv
    MS-Off Ver
    2010
    Posts
    5

    macros for automatization of crosstab

    Please help me solve this problem about automatic description of crosstabs results.
    For example, this one of result crosstab, calculated in SPSS software
    I attached.
    Automatization must follow the next pattern of description ,according to the principle:
    Initially we describe the largest number. In this instance: 11 people (information taken from the cell E6), which belong to the second group , on the first question (it first, cause there is digit 1 standing in this column I) gave the answer 1, middle number of people, namely 4 answered 2 and 3 respectively (cause we have the same number of people who have put a different answer, sometimes it happens)
    After that, macros will describe the first group large, middle ,minimum,by similar way: at the same time in first group:9 people answered 3, and so on/
    Of cause I don’t know how, but macros must see ,what digit maybe large and what middle ,and what minimum
    It’s necessarily that After each describing of tables macros should specify that differences are stat.significally and these data (chi-square = 16.557, p ≤ 0.05), taken from the corresponding cell
    Well, after describing a first table macros begins describe to the next.
    In practice it must be so
    (introduction words )in the study of the relationship between several quality characteristics we discover that :
    the largest number of people which belong to second group, namely 11 people on first question answered 1, middle number of people , namely 4 answered 2 and 3 respectively! At the same time(introduction words), the largest number of those who belong to the first group namely 9 people on the first question answered 3 and so on. These differences were statistically significant (chi-square = 16.557 , p ≤ 0.05)

    italics is introductory words which must be written in structure of macros
    the bold type is information which we see in our tables

    in fact, my colleagues and I often deal with qualitative variables, such as people, and we can work with hundreds of similar or much more complex tables, and we spend a lot of precious time on their description, it is a routine work which must be made easier to avoid wasting time.
    Please help.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. multi-variable Crosstab
    By mmlinar in forum Excel General
    Replies: 1
    Last Post: 06-10-2012, 08:45 PM
  2. Replies: 1
    Last Post: 03-08-2011, 12:31 PM
  3. Amend crosstab display
    By BennyBoy01 in forum Excel General
    Replies: 2
    Last Post: 02-12-2010, 12:17 PM
  4. Looping through crosstab worksheet
    By jpendegraft in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2006, 07:26 PM
  5. [SOLVED] Need crosstab function in excel
    By patrick in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-26-2005, 09:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1