Weekly Round-Up: The Importance of Excel, Data Scientist Interview Questions, Predicting Oscar Winners, and Analyzing Porn Stars

Welcome back to the round-up, an overview of the most interesting data science, statistics, and analytics articles of the past week. This week, we have 4 fascinating articles ranging in topics from Excel and interview questions to The Oscars and porn stars. In this week's round-up:

  • The Importance of Excel
  • 66 Interview Questions for Data Scientists
  • Microsoft, Big Data Pick Oscar Winners
  • Deep Inside: A Study of 10,000 Porn Stars

The Importance of Excel

James Kwak, the author of White House Burning, published an interesting blog post this week about the strengths and perils of Microsoft Excel. We data scientists, while using our more advanced statistical analysis tools, sometimes forget that the vast majority of business is still done based off of analysis and models put together in Excel. This blog post drives that point home and sparked an interesting thread of conversation both in the over 100 comments the post has received and on Hacker News.

66 Interview Questions for Data Scientists

Data Science Central published a list of 66 job interview questions to ask data scientists. The questions cover topics such as the size of data they've worked with and the differences between the tools and programming languages they use as well as some less technical questions. If you're looking for a job as a data scientist, you should be prepared to answer these questions and if you're looking to hire some analytical talent, you can use some of these questions to get a sense of what kind of experience your candidates have.

Microsoft, Big Data Pick Oscar Winners

This ReadWriteWeb article takes a look at the approaches taken by two parties - Microsoft Research's David Rothschild and analyst firm Brandwatch - in predicting the outcomes of the Oscars. The article compares Rothschild to Nate Silver and has some quotes from him about the statistical models he is using to generate the predictions. It also describes a little about Brandwatch's model, which focuses more on social media mentions and sentiment. The article has links to each party's predictions on their respective websites.

Deep Inside: A Study of 10,000 Porn Stars

This is an interesting analysis published on Jon Millward's blog. He analyzed a data set of 10,000 porn stars and this blog post summarizes some of his findings - everything from names, ethnicity, hair color, birthplace, and contents of their films.

That's it for this week. Make sure to come back next week when we’ll have some more interesting articles! If there's something we missed, feel free to let us know in the comments below.

Read Our Other Round-Ups