- write a MySQL query - how to improve the performance of a query - excel functions - tests of statistical skills (i.e. Suppose you're on a game show, and you're given the choice of three doors: Behind one door is a car; behind the others, goats. You pick a door, say No. 1, and the host, who knows what's behind the doors, opens another door, say No. 3, which has a goat. He then says to you, "Do you want to pick door No. 2?" Is it to your advantage to switch your choice? ) - questions about gross/net costs and percentage
Sigiloso
I have to say that presenting the question now commonly known as the "Monty Hall Question" (three doors, cars, goats, etc.) is unfair, not to say downright stupid: * If the candidate DOES know the question, he should also know how to explain the logic behind it flawlessly. You can memorize the explanation rather well and pretend to know what you're talking about. * If the candidate DOESN'T know the question, coming up with the correct explanation on the spot, in interview settings (stressful, to say the least) isn't likely to happen. So, if the candidate answered the question, you can't really tell if he's memorizing or truly know the answer and can explain it, and if he doesn't, this question is not one you can analyze easily while interviewing. Drop this question and ask questions regarding YOUR COMPANY's statistical challenges.