Top 12
Prep plan
Updated weekly · Last refresh Oct 17

Castleton Commodities International Data Analyst Interview Questions

The questions to prepare for a Castleton Commodities International Data Analyst interview. Questions from real interview reports rank first. Updated daily.

12questions
~2htotal time
Track your progressSign up free to work through all 12 questions and resume where you left off.
Start practicing free →
1
Statistics & ProbabilityStart here. 8 questions · ~72 min
Explain a Machine Learning TechniqueMedium

Evaluates your understanding of core machine learning techniques and their appropriate use cases.

Machine LearningCastleton Commodities International
Probability: Same-Color FourHard

Tests advanced probability calculation and careful reasoning about combinatorics.

combinatoricsExpected ValueConditional ProbabilityCastleton Commodities International
Probability: Same-Color PairMedium

Tests your probability fundamentals and ability to compute conditional outcomes.

combinatoricsExpected ValueConditional ProbabilityCastleton Commodities International
Interpreting a P-ValueEasy

Tests your understanding of statistical significance and correct interpretation of p-values.

Hypothesis TestingStatistical SignificanceP-ValuesCastleton Commodities International
More Statistics & Probability questions with a free account
2
SQL & Data Manipulation4 questions + 2 drills · ~56 min
Pandas for a Dataframe Coding ChallengeHard

Tests your ability to translate coding tasks into Pandas operations and validate outputs.

JoinsData WranglingAggregationsCastleton Commodities International
Preprocess Data Before AnalysisMedium

Tests your end-to-end data preparation approach and awareness of analysis pitfalls.

Data WranglingETLQualityCastleton Commodities International
Pandas DataFrame ManipulationEasy

Tests your practical Pandas skills for transforming data into analysis-ready form.

JoinsData WranglingAggregationsCastleton Commodities International
Handling Missing DataEasy
Practice

Replace missing sales fields with defined defaults and return a consistently ordered dataset.

missing valuesdata cleaningnull handlingCastleton Commodities International
SQL Top Five CustomersEasy
Practice
Practice drill

Find Farallon Capital Management's top five customers by aggregated sales volume using filtering, GROUP BY, ORDER BY, and LIMIT.

RankingGroup ByAggregationsFarallon Capital ManagementMacquarie GroupNyc Staffing
7-Day Moving Average SQLMedium
Practice
Practice drill

Calculate seven-day rolling commodity price averages for each market exchange using PostgreSQL window functions.

Window FunctionsDate Functionsfinancial dataCastleton Commodities International

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 12 questions plus 2 hands-on drills to finish this plan.