U2 Catalog: Take the Survey! - Page 10 - U2 Feedback

Go Back   U2 Feedback > Your Blue Room > Everything You Know Is Wrong
Click Here to Login
Reply
 
Thread Tools Search this Thread Display Modes
 
Old 01-17-2018, 08:48 PM   #136
Vocal parasite
 
Axver's Avatar
 
Join Date: Jun 2003
Location: 1853
Posts: 152,146
Local Time: 06:19 AM
Quote:
Originally Posted by LuckyNumber7 View Post
Ax you've got a friend - Dave also reordered the form.

Luckily, I got dat VLOOKUP() function down pat. Because, yeah, well, tbh it's not exactly perfect in alphabetical order. It's in wikipediorder.

I couldn't even do it alphabetically. I needed to rank album by album and scrolling was a pain in the arse so I re-sorted it.
__________________

__________________
"Mediocrity is never so dangerous as when it is dressed up as sincerity." - Søren Kierkegaard

Ian McCulloch the U2 fan:
"Who buys U2 records anyway? It's just music for plumbers and bricklayers. Bono, what a slob. You'd think with all that climbing about he does, he'd look real fit and that. But he's real fat, y'know. Reminds me of a soddin' mountain goat."
"And as for Bono, he needs a colostomy bag for his mouth."

U2gigs: The most comprehensive U2 setlist database!
Gig pictures | Blog
Axver is offline   Reply With Quote
Old 01-17-2018, 09:02 PM   #137
ONE
love, blood, life
 
LuckyNumber7's Avatar
 
Join Date: Sep 2010
Location: Washington, DC
Posts: 13,099
Local Time: 03:19 PM
Quote:
Originally Posted by Axver View Post
I couldn't even do it alphabetically. I needed to rank album by album and scrolling was a pain in the arse so I re-sorted it.


In the future, you can highlight the entire thing and add a data filter. It preserves the original format but allows you to enable all rows featuring a certain item in it. For example, since we had an album column, you can add a data filter to temporarily show all rows that have "Boy" in the album column.
__________________

LuckyNumber7 is online now   Reply With Quote
Old 01-25-2018, 11:26 PM   #138
Acrobat
 
shika's Avatar
 
Join Date: Mar 2006
Location: Sydney, Australia
Posts: 353
Local Time: 06:19 AM
What’s the latest?
shika is offline   Reply With Quote
Old 01-26-2018, 02:03 AM   #139
Blue Crack Distributor
 
Headache in a Suitcase's Avatar
 
Join Date: Jul 2000
Location: Stateless
Posts: 58,908
Local Time: 04:19 PM
I actually think doing it album by album skews the results... you're more likely to give songs on albums you like higher grades and vice versa... whereas alphabetically it's a little more likely you'll simply just the song on its own merits.
Headache in a Suitcase is online now   Reply With Quote
Old 01-26-2018, 05:11 AM   #140
ONE
love, blood, life
 
LuckyNumber7's Avatar
 
Join Date: Sep 2010
Location: Washington, DC
Posts: 13,099
Local Time: 03:19 PM
Quote:
Originally Posted by shika View Post
What’s the latest?

I'm on break for graduation. Will resume with the numbers when I get back to Texas.
LuckyNumber7 is online now   Reply With Quote
Old 01-26-2018, 05:19 AM   #141
ONE
love, blood, life
 
LuckyNumber7's Avatar
 
Join Date: Sep 2010
Location: Washington, DC
Posts: 13,099
Local Time: 03:19 PM
Quote:
Originally Posted by Headache in a Suitcase View Post
I actually think doing it album by album skews the results... you're more likely to give songs on albums you like higher grades and vice versa... whereas alphabetically it's a little more likely you'll simply just the song on its own merits.


A number of things can skew the results. For example, everyone sharing their results in this thread could have led incomplete submissions to believe their results should look like other results.

I agree that changing the order will probably skew your results, but since there's no way on an open sheet that I can't stop people from just ctrl+F'ing the results in whatever order they want...

Basically, if there's no way to guarantee something, better to just account for it. For example, I could not guarantee that everyone finished their entire survey. So instead, practice is to throw it away if it's incomplete. That I can do, concretely. But I can't tell if someone listened to the songs in entirety, or in what order. So instead, narrowest rules ended up pretty broad.

Same goes for the conversation in here. Since you guys aren't a "random" sample, there's no sense in trying to bar conversation. Just account for it in the results by stating that everyone was in fact allowed to talk about how they chose to answer the survey.
LuckyNumber7 is online now   Reply With Quote
Old 01-26-2018, 05:39 AM   #142
ONE
love, blood, life
 
LuckyNumber7's Avatar
 
Join Date: Sep 2010
Location: Washington, DC
Posts: 13,099
Local Time: 03:19 PM
Also I wrote that while trying to wake up. Hopefully it makes at least 5 sense.
LuckyNumber7 is online now   Reply With Quote
Old 02-20-2018, 02:13 AM   #143
ONE
love, blood, life
 
LuckyNumber7's Avatar
 
Join Date: Sep 2010
Location: Washington, DC
Posts: 13,099
Local Time: 03:19 PM
Good people of the interwebs, I've finally returned to normal life after moving and starting a new job and graduating and I've also finally learned a new data toolkit. This project has encouraged me to expand my programming - data will be available by the weekend I hope!
LuckyNumber7 is online now   Reply With Quote
Old 02-20-2018, 02:15 AM   #144
Vocal parasite
 
Axver's Avatar
 
Join Date: Jun 2003
Location: 1853
Posts: 152,146
Local Time: 06:19 AM
Ha, I was just thinking this morning if the results had come out and I had missed them, or if you were still busy.

Look forward to it.
__________________
"Mediocrity is never so dangerous as when it is dressed up as sincerity." - Søren Kierkegaard

Ian McCulloch the U2 fan:
"Who buys U2 records anyway? It's just music for plumbers and bricklayers. Bono, what a slob. You'd think with all that climbing about he does, he'd look real fit and that. But he's real fat, y'know. Reminds me of a soddin' mountain goat."
"And as for Bono, he needs a colostomy bag for his mouth."

U2gigs: The most comprehensive U2 setlist database!
Gig pictures | Blog
Axver is offline   Reply With Quote
Old 02-20-2018, 02:02 PM   #145
Blue Crack Distributor
 
corianderstem's Avatar
 
Join Date: Dec 2002
Location: Seattle
Posts: 64,360
Local Time: 01:19 PM
Yay!

(Congrats on graduating!)
corianderstem is offline   Reply With Quote
Old 03-03-2018, 07:30 PM   #146
ONE
love, blood, life
 
LuckyNumber7's Avatar
 
Join Date: Sep 2010
Location: Washington, DC
Posts: 13,099
Local Time: 03:19 PM
Almost folks. Almost. I swear this time. I have the ranking done in ASCII style ready for here, plus plots and hypothesis testings across demographics. Still working on album breakdowns and scatters.
LuckyNumber7 is online now   Reply With Quote
Old 03-04-2018, 04:54 AM   #147
ONE
love, blood, life
 
LuckyNumber7's Avatar
 
Join Date: Sep 2010
Location: Washington, DC
Posts: 13,099
Local Time: 03:19 PM
Results:

U2 Catalog: Results Here

Go there. Comment there. Leave this place.
__________________

LuckyNumber7 is online now   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 03:19 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Design, images and all things inclusive copyright © Interference.com