探索性与统计分析
Exploratory & statistical analysis
Wrangle, analyze and model data in notebooks to a checked answer.
20 条本项目编写的提案 · 分类 v1.1 · 新增基准运行 0 次。下方验证方式与部分得分规则是设计，不是执行结果。
- 典型应用
- Jupyter · pandas · R
- 小类 GUI 需求标签
CL· CLI 足够
任务提案 · 20
展开查看完整原文与建议检查方式；两种界面均保留提案英文原文。
R03.02.01.01-T01 Analyze an A/B test with CUPED variance reduction
原始指令
data/ab_checkout.parquet holds a 2-week checkout experiment (user, variant, revenue, pre-period revenue). In a Jupyter notebook, compute the relative lift in revenue per user with a 95% CI, unadjusted and CUPED-adjusted, check for sample-ratio mismatch, and write output/result.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Jupyter · pandas · SciPy
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Grader compares result.json to gold: lift ±0.001, CI bounds ±0.002, CUPED theta ±0.01, SRM p-value ±0.005 and srm_flag boolean exact. Notebook must execute top to bottom with nbconvert and reproduce the JSON.
建议部分得分
25% unadjusted lift/CI; 35% CUPED estimate/CI; 20% SRM check; 20% notebook reproduces
R03.02.01.01-T02 Estimate price elasticity with fixed effects
原始指令
Using data/store_weekly.parquet (SKU × store × week units and price), estimate own-price elasticity with a log-log regression including SKU, store and week fixed effects and clustered standard errors by store. Report the elasticity, SE and 95% CI in output/elasticity.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Jupyter · statsmodels · pandas
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
Gold from a reference fixest/linearmodels fit: elasticity ±0.005, clustered SE ±5%, CI consistent. Grader reruns the notebook on a hidden resample with known true elasticity −1.4: estimate within ±0.05.
建议部分得分
40% point estimate; 25% clustered SE; 15% CI; 20% hidden resample recovery
R03.02.01.01-T03 Compare time-to-churn by plan with survival analysis in R
原始指令
data/subscriptions.csv has start, end (censored if active) and plan. In R, fit Kaplan-Meier curves by plan, report median survival with 95% CI, run a log-rank test, fit a Cox model with plan and region, and check proportional hazards. Save output/survival.json and output/km.png.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- R · RStudio · survival
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
Gold from survival::survfit/coxph: medians ±1 day, CIs ±2 days, log-rank chi-square ±0.1, hazard ratios ±0.01, PH test p-values ±0.01. km.png must exist with 3 curves (VLM check, 10%).
建议部分得分
30% KM medians/CIs; 15% log-rank; 45% Cox HRs and PH check; 10% plot
R03.02.01.01-T04 Forecast 12 weeks of demand and beat a seasonal-naive baseline
原始指令
data/demand_weekly.csv has 4 years of weekly demand for 30 product families with holidays. Produce 12-week-ahead forecasts per family in output/forecast.csv. The last 12 weeks are held out by the grader.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Jupyter · statsmodels · pandas
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Grader computes weighted MAPE vs hidden actuals: pass at ≤0.85× the seasonal-naive WMAPE; partial credit linearly up to 1.0×. All 30×12 values present and non-negative.
建议部分得分
10% complete output; 90% WMAPE vs baseline (linear)
R03.02.01.01-T05 Detect and explain a Simpson's paradox in referral conversion
原始指令
Marketing claims referral leads convert worse than paid leads (data/leads_2025.csv). Determine whether this holds within each segment, identify the confounder, and report pooled and stratified conversion rates plus a Mantel-Haenszel odds ratio in output/answer.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Jupyter · pandas · statsmodels
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Grader checks: confounder named = 'company_size' (exact field), stratified rates ±0.001, MH OR ±0.01, and conclusion field 'reverses' true. Rates computed from data, not stated.
建议部分得分
25% confounder; 35% stratified rates; 25% MH odds ratio; 15% conclusion
R03.02.01.01-T06 Produce a descriptive statistics table to a reporting spec
原始指令
From data/patients.csv, produce the 'Table 1' in spec/table1.md: N, mean (SD) or median [IQR] per variable per arm, counts (%) for categorical variables, and p-values with the tests the spec names. Save output/table1.csv.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- R · pandas
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
Cell-by-cell comparison with gold: formatted strings exact (rounding per spec); p-values ±0.001.
建议部分得分
70% summary cells; 30% p-values
R03.02.01.01-T07 Handle missing data with multiple imputation and compare estimates
原始指令
data/wellbeing.csv has 28% missing income and 12% missing sleep, not missing at random by age. Fit the regression in spec/model.md with complete cases and with multiple imputation (m=20, chained equations, seed 7), pool with Rubin's rules, and report both in output/mi.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- R · mice
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
Gold from mice with the same seed: pooled coefficients ±0.01, SEs ±5%, fraction of missing information ±0.02; complete-case estimates exact. Hidden simulation check: the MI estimate is closer to the known truth than complete-case.
建议部分得分
25% complete-case fit; 45% pooled MI estimates/SEs; 15% FMI; 15% truth recovery
R03.02.01.01-T08 Estimate a policy effect with difference-in-differences
原始指令
data/county_panel.csv covers 2015–2024 for 400 counties; 60 adopted a wage policy in 2019 (staggered). Estimate the employment effect with a two-way FE DiD and the Callaway–Sant'Anna estimator, run an event-study pre-trend test, and report both in output/did.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- R · did · fixest
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
Gold: TWFE coefficient ±0.002; CS overall ATT ±0.003 with SE ±10%; pre-trend joint test p ±0.02; event-study coefficients for −3..+3 ±0.003.
建议部分得分
20% TWFE; 40% CS ATT/SE; 20% event study; 20% pre-trend test
R03.02.01.01-T09 Compute sample size for a two-proportion test
原始指令
Product wants to detect a lift from 4.2% to 4.6% conversion with 80% power at α=0.05 two-sided, with 3 variants vs control and Bonferroni correction. Compute per-arm sample size and days needed at 18k eligible users/day, writing output/power.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Python · statsmodels
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
Gold computed with statsmodels NormalIndPower (Cohen's h): per-arm n ±1%, total n and days (ceil) exact.
建议部分得分
60% per-arm n; 20% correction applied; 20% days
R03.02.01.01-T10 Segment customers with k-means under a fixed preprocessing spec
原始指令
Follow spec/segmentation.md on data/customers_rfm.csv: log-transform monetary, standardize, choose k in 2–10 by silhouette, fit k-means (seed 42, n_init 20), and write output/segments.csv with labels and output/profile.csv with per-segment means.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Jupyter · scikit-learn
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Grader: chosen k equals gold; ARI vs gold labels ≥0.98; profile means ±0.01. Notebook reruns deterministically.
建议部分得分
30% correct k; 50% label agreement; 20% profiles
R03.02.01.01-T11 Run a repeated-measures ANOVA in SPSS
原始指令
In SPSS Statistics, open data/reaction_times.sav (24 participants × 4 conditions) and run a repeated-measures ANOVA with Mauchly's test, Greenhouse–Geisser correction and Bonferroni post-hoc comparisons. Save the output viewer file to output/rm_anova.spv and the key statistics to output/anova.json.
- 平台
mac· macOSwin· Windows- 应用
- SPSS Statistics
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击vis· 视觉判断- 工作产物
WP12· 答案 / 决策- 条件
licensed· 授权专业软件- 提案难度
- 3 / 5
建议验证方式
Grader: anova.json F, df (GG-corrected), p, partial eta² ±0.01 vs gold; post-hoc pairs and adjusted p ±0.005. The .spv must contain the Mauchly and Tests of Within-Subjects Effects tables (parsed via SPSS output export).
建议部分得分
40% corrected F/df/p; 15% Mauchly; 30% post-hoc; 15% .spv saved
R03.02.01.01-T12 Fit a panel regression with clustered errors in Stata
原始指令
Using data/firms.dta, write output/analysis.do that fits a firm fixed-effects regression of log productivity on R&D intensity and controls with year dummies and SEs clustered by industry, then exports the table to output/table.csv via esttab.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Stata
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
licensed· 授权专业软件- 提案难度
- 3 / 5
建议验证方式
Grader runs the .do in batch Stata: coefficients ±1e-4 and clustered SEs ±1% of gold; N and within-R² exact; table.csv columns per spec.
建议部分得分
50% coefficients; 30% clustered SEs; 20% exported table
R03.02.01.01-T13 Repair a broken analysis notebook so it reproduces its figures
原始指令
notebooks/q3_review.ipynb fails at cell 14 (renamed columns, deprecated pandas API, a hidden-state variable defined in a deleted cell). Fix it so 'Restart & Run All' completes and reproduces the four numbers quoted in the markdown summary.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Jupyter · pandas
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP06· 代码 / 工程- 条件
hidden· 隐藏 / 过期状态- 提案难度
- 3 / 5
建议验证方式
Grader executes the notebook in a fresh kernel with nbclient: no errors; the 4 summary numbers recomputed by grader equal those printed in the notebook outputs and match the markdown values ±0.01.
建议部分得分
40% runs end to end; 40% numbers reproduce; 20% no hidden-state dependencies (cell order randomized test)
R03.02.01.01-T14 Attribute a week-over-week conversion drop to segments
原始指令
Conversion fell from 3.9% to 3.4% last week (data/funnel_daily.parquet). Decompose the change into mix effect and rate effect across device × channel × country, and name the top 3 contributing segments with their contributions in output/drop.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Jupyter · pandas
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Gold: total change −0.5 pp decomposed into mix and rate (±0.01 pp); top 3 segments exact and in order; contributions ±0.02 pp; contributions sum to the total.
建议部分得分
30% mix/rate split; 50% top segments; 20% sums consistent
R03.02.01.01-T15 Fit a hierarchical Bayesian model of store conversion
原始指令
Fit a hierarchical logistic model in PyMC for data/store_visits.csv (210 stores, many with few visits): store intercepts partially pooled within region. Report posterior mean and 94% HDI of each region's conversion, and the probability that store S-117 beats its region mean, in output/posterior.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- PyMC · ArviZ · Jupyter
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 5 / 5
建议验证方式
Grader checks convergence (R-hat ≤1.01, ESS ≥400) from the saved trace, region means ±0.002 and HDI bounds ±0.004 of the reference posterior, and P(S-117 > region) ±0.03.
建议部分得分
20% convergence; 40% region posteriors; 20% HDIs; 20% S-117 probability
R03.02.01.01-T16 Estimate a treatment effect with propensity score matching
原始指令
data/training_program.csv records which employees took a training program and their later promotion. Estimate the ATT on promotion using 1:1 nearest-neighbor propensity matching with caliper 0.2 SD of the logit, report balance (standardized mean differences) before and after, and the ATT with bootstrap CI.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- R · MatchIt
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
Gold via MatchIt with the same spec: matched N exact, SMDs after matching ±0.01 (all <0.1), ATT ±0.005, CI ±0.01. Hidden semi-synthetic version with known effect must be recovered ±0.02.
建议部分得分
20% matched sample; 25% balance table; 35% ATT/CI; 20% semi-synthetic recovery
R03.02.01.01-T17 Fit a mixed-effects model for repeated measures in R
原始指令
data/sleep_trial.csv has nightly sleep scores for 180 participants over 6 weeks in 3 arms. Fit an lme4 model with random intercepts and slopes by participant, test the arm × week interaction with a likelihood-ratio test, and report fixed effects and the LRT in output/mixed.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- R · lme4
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
Gold: fixed-effect estimates ±0.005, SEs ±3%, LRT chi-square ±0.1 and p ±0.005; random-effect variances ±5%. Model must be fit with REML false for the LRT.
建议部分得分
40% fixed effects; 20% random effects; 30% LRT; 10% correct REML setting
R03.02.01.01-T18 Compute bootstrap confidence intervals for ratio metrics
原始指令
For data/sessions.parquet, compute 95% BCa bootstrap CIs (10,000 resamples, seed 11, user-level clusters) for median session length and for revenue per session in each of 2 app versions, and the CI of their difference. Write output/boot.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Python · SciPy
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
Gold computed with the same seed and cluster resampling: point estimates exact, CI bounds ±1.5% (Monte Carlo tolerance). Session-level (non-clustered) resampling yields narrower CIs and fails.
建议部分得分
30% point estimates; 50% cluster BCa CIs; 20% difference CI
R03.02.01.01-T19 Control false discoveries across 200 experiment metrics
原始指令
data/metric_tests.csv lists 200 metrics with control/treatment sums and counts. Compute per-metric Welch t-test p-values, apply Benjamini–Hochberg at q=0.05 and Holm at 0.05, and list discoveries under each in output/fdr.json.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Python · statsmodels
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Gold p-values ±1e-4; discovery sets exact under both procedures.
建议部分得分
40% p-values; 35% BH set; 25% Holm set
R03.02.01.01-T20 Answer ten graded questions in a full EDA of a new dataset
原始指令
data/city_bikes/ has 2 years of trip, station and weather data. In a Jupyter notebook, clean it per docs/notes.md and answer the 10 questions in questions.md (e.g., weather-adjusted ridership trend, station imbalance, effect of rain), writing answers to output/answers.json with the specified units.
- 平台
lin· Linuxmac· macOSwin· Windows- 应用
- Jupyter · pandas · statsmodels
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP12· 答案 / 决策- 条件
long· 长流程- 提案难度
- 5 / 5
建议验证方式
Each answer compared to gold with per-question tolerance; the notebook must reproduce answers.json from raw data in ≤15 min. One question is ill-posed by design and must be answered 'insufficient data' with reason.
建议部分得分
72% nine answerable questions (8 pts each); 13% notebook reproduces; 15% ill-posed question flagged with reason
已有研究映射
以下沿用研究目录中的基准与小类映射，不是逐题标注、执行记录或产品背书。