Group already grouped data

Discuss statistics related things
Post Reply
istratos
Posts: 2
Joined: Fri Oct 23, 2020 7:33 pm

Group already grouped data

Post by istratos »

Hi
I have a dataset, that looks in a simplified form like this:

Age (in years)___ Number of people (N) for factor 1
0-5____ ________30
6-10___________40
11-15__________28
16-20__________21
...
...
...
91-95_________4
96-100_________2

The dataset contains over 100 columns!

1. Is it possible to group (in larger groups) the already grouped data?
like:
Age
0-20
21-40
41-60
...

2. Is it possible with jamovi to perform "simple" tests (t-test - Chi Square) on the grouped data?

3. I solve the "grouping" issue by calculating the new groups in Excel - I wanted to know if there is in jamovi an automated procedure to summarize the groups.

Thanks
John
sbalci
Posts: 124
Joined: Sat Jan 06, 2018 10:25 pm
Contact:

Re: Group already grouped data

Post by sbalci »

Please check these:
https://blog.jamovi.org/2018/10/23/transforming-variables.html
https://blog.jamovi.org/2017/11/28/jamovi-formulas.html
User avatar
MAgojam
Posts: 421
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

Re: Group already grouped data

Post by MAgojam »

Hi, John.
Sbalci has already suggested you take a look at some useful links,
but if i understand your requests i think the next tips can help you.
istratos wrote: 2. Is it possible with jamovi to perform "simple" tests (t-test - Chi Square) on the grouped data?
Jamovi does many things, and these have increased with the use of modules that have been added over time and one of these (Rj) is a real wildcard for doing things with R code, which at the moment are not accessible in a simple way directly jamovi.
A t-test with data grouped in class (like yours), you can't find it and you could do it with r code in Rj.
A chi-square test of independence is very quick to do in jamovi, organizing the data as in the screenshot example:
chi2_ind.PNG
chi2_ind.PNG (102.57 KiB) Viewed 3533 times
istratos wrote: 1. Is it possible to group (in larger groups) the already grouped data?
Using the data from the previous example, I answer your question by attaching two screenshots.
The age_class variable (8 classes) is TRANSFORMED into a new variable with only 3 classes.
Ricorda di selezionare prima la variabile da trasformare che sarà identificata con $source.
Trasform.png
Trasform.png (93.11 KiB) Viewed 3533 times
Trasform_zoom.png
Trasform_zoom.png (78.46 KiB) Viewed 3533 times
Cheers,
Maurizio
istratos
Posts: 2
Joined: Fri Oct 23, 2020 7:33 pm

Re: Group already grouped data

Post by istratos »

thank you very much for your reply
it was very helpful!
Post Reply