420chan now has a web-based IRC client available, right here
Leave these fields empty (spam trap):
Name
You can leave this blank to post anonymously, or you can create a Tripcode by using the float Name#Password
Comment
[*]Italic Text[/*]
[**]Bold Text[/**]
[~]Taimapedia Article[/~]
[%]Spoiler Text[/%]
>Highlight/Quote Text
[pre]Preformatted & Monospace text[/pre]
1. Numbered lists become ordered lists
* Bulleted lists become unordered lists
File

Sandwich


Community Updates

420chan now supports HTTPS! If you find any issues, you may report them in this thread
Combine Data Sets Values Something by Doris Bemmlebanks - Mon, 02 Jan 2017 13:27:30 EST ID:RbgW2Zpy No.15304 Ignore Report Quick Reply
File: 1483381650547.jpg -(51347B / 50.14KB, 156x518) Thumbnail displayed, click image for full size. 51347
Suppose youve got 2 data sets but they're in completely different units and not on the same scale. What operation could you apply to each row in order to get an idea of their combined result.
Sum? Average? Multiply?
>>
Martin Hobbledock - Wed, 04 Jan 2017 19:58:10 EST ID:cHNY4zfv No.15307 Ignore Report Quick Reply
unit conversion factors nigga
>>
Matilda Chottinglod - Fri, 06 Jan 2017 00:42:22 EST ID:/4S1D94J No.15309 Ignore Report Quick Reply
depends on the data, i imagine you have some context to what the values represent
>>
Nigel Hibblefutch - Fri, 06 Jan 2017 13:41:45 EST ID:tgwdoW8d No.15310 Ignore Report Quick Reply
>>15309
Nah I just want to build a "score" from a bunch of different columns like this.

Maybe if you looked at the percentile of each row and averaged that.
>>
Reuben Bunford - Sat, 07 Jan 2017 04:28:59 EST ID:tgwdoW8d No.15311 Ignore Report Quick Reply
I figured it out!
Calculated the percentile rank of each row relative to its column, then averaged all the ranks across! Fuck yeah!
>>
break-a-bond !!D0XjIgKF - Sat, 07 Jan 2017 23:56:11 EST ID:tgwdoW8d No.15312 Ignore Report Quick Reply
>>15311
However!
This does not take into account weighting of each item if that matters at all.
So the forumula would become tedious
0.2*percentile1 + 0.8*percentile2
Then if you change that weighting from 20% -> 30% you're going to have to change every other weighting to add up to 1.
>>
Eugene Gubberfuck - Sun, 08 Jan 2017 18:08:26 EST ID:/4S1D94J No.15316 Ignore Report Quick Reply
>>15310
You cant build a score without context to what the data represents
>>
Edwin Semmlebury - Sun, 22 Jan 2017 22:28:09 EST ID:C8IBIGCT No.15327 Ignore Report Quick Reply
>>15316
Well he just did!
deal wit it


Report Post
Reason
Note
Please be descriptive with report notes,
this helps staff resolve issues quicker.