Senior Manager Analytics Interview Questions and Answers

Probability of raining given 3 friends with 2/3 truth probability saying it's raining.

• Use Bayes' theorem to calculate the probability

• P(Raining | All Friends Saying It's Raining) = P(All Friends Saying It's Raining | Raining) * P(Raining) / P(All Friends Saying It's Raining)

• P(All Friends Saying It's Raining | Raining) = 1

• P(Raining) = Prior probability of raining

• P(All Friends Saying It's Raining) = Probability of all friends saying it's raining

A 5cm wooden cube is cut into smaller 1cm cubes. Determine the number of cubes with different numbers of painted sides.

• The original cube has 125 smaller cubes (5x5x5)

• Each smaller cube has 6 faces, so there are 750 faces in total

• The cubes on the edges have 3 painted sides, the ones on the corners have 3 painted sides, and the rest have 2 painted sides

• There are 8 cubes on the corners, 12 on the edges, and 105 in the middle

• There are 8 cubes with 3 painted sides, 36 with 2 painte...read more

There are 18 zeroes in factorial 78.

• To find the number of zeroes in a factorial, we need to count the number of times 10 appears as a factor.

• Since 10 = 2 x 5, we need to count the number of times 2 and 5 appear as factors.

• Since there are more factors of 2 than 5 in factorial 78, we only need to count the number of times 5 appears as a factor.

• We can use the formula n/5 + n/25 + n/125 + ... to count the number of times 5 appears as a factor in n!

• Plugging in n = 78, we get 15 + ...read more

Demonstrate SQL skills in group by aggregation, joins, and ranking

• Use GROUP BY clause to aggregate data based on a specific column

• Utilize JOINs to combine data from multiple tables

• Use ranking functions like ROW_NUMBER() to assign a rank to each row