Group already grouped data

Discuss statistics related things

by istratos » Fri Oct 23, 2020 7:54 pm

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
istratos
 
Posts: 2
Joined: Fri Oct 23, 2020 7:33 pm

by sbalci » Sat Oct 24, 2020 8:43 am

Please check these:
https://blog.jamovi.org/2018/10/23/transforming-variables.html
https://blog.jamovi.org/2017/11/28/jamovi-formulas.html
sbalci
 
Posts: 47
Joined: Sat Jan 06, 2018 10:25 pm

by MAgojam » Sat Oct 24, 2020 11:28 am

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

Trasform_zoom.png
Trasform_zoom.png (78.46 KiB) Viewed 370 times


Cheers,
Maurizio
User avatar
MAgojam
 
Posts: 116
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

by istratos » Sat Oct 24, 2020 7:15 pm

thank you very much for your reply
it was very helpful!
istratos
 
Posts: 2
Joined: Fri Oct 23, 2020 7:33 pm


Return to Statistics

cron