cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Translate the entire conversation x

Matrix

Lauret1234
2-Explorer
2-Explorer
‎Dec 07, 2017 04:57 PM
‎Dec 07, 2017 04:57 PM

Matrix

Hello. I really need help. Can somebody tell or show me, how to sort data from matrix (10x10) into one row from smallest number to largest? Or how to calculate frequency from this matrix into a row? I was looking information for hours, tried to sort data with excel, and tried to use sort function  in mathcad but that didin't work... 

Labels:
data.zip
0 Kudos
Notify Moderator
2 REPLIES 2
LucMeekes
23-Emerald III
23-Emerald III
(To:Lauret1234)
‎Dec 07, 2017 06:09 PM
‎Dec 07, 2017 06:09 PM

See attached.

 

Success!
Luc

LM_20171208_DataSort.mcd
Notify Moderator
Werner_E
25-Diamond I
25-Diamond I
(To:Lauret1234)
‎Dec 08, 2017 08:44 AM
‎Dec 08, 2017 08:44 AM

In addition to what Luc already wrote, as you also asked for frequency counts, you could use the hist and histogram function to do so. See here for exemple with 10 intervals:

Bild.png

Notify Moderator
Announcements

Contact Community Management
Top Tags