The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 New to Origin, need assistance		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

22feder

2 Posts
Posted - 03/24/2024 :  02:09:12 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello, I've been introduced to this app by my college and have been instructed to group 600 items from a spreadsheet in 20 groups of 30 items each, and to take specific data from them.
I can take the data, I've learned that. Luckily, we were told there was a way not to create 20 different sheets for every group, but they did not specify how and all they said was "Use group statistics".
I've been searching through the options for nearly an hour and haven't found what I was looking for, anyone who could help me out?

YimingChen

1594 Posts
Posted - 03/25/2024 :  08:31:11 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Could you be more specific on your question? it would be better to share your project file here. When you mention having 600 items, do you mean 600 rows in the worksheet? And you want to organize the rows into 20 groups? Please clarify. Thank you.

James
Go to Top of Page

22feder

2 Posts
Posted - 03/25/2024 :  6:28:51 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Well, I have 600 items in a column and have to divide them in 20 groups of 30 and then take the mean, SD and SE of each group and place them in a new table for comparison.

https://my.originlab.com/ftp/forum_and_kbase/Images/Shine-Intervals.opj
Go to Top of Page

YimingChen

1594 Posts
Posted - 03/26/2024 :  08:30:05 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You could manually add a group column and use the Stats on Columns tool to calculate the statistics of each group. Please refer to the video below.



James
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000