# Constructed data: a measurement in 10 cells from each of 8 mice per group (vehicle, drug).
# True model: group difference 2.0 units; between-mouse SD 1.5; between-cell SD 3.0.
# The seed (1) was the first one run; it was not selected.
import numpy as np, pandas as pd
rng = np.random.default_rng(1); rows = []
for g, eff in (("vehicle", 0.0), ("drug", 2.0)):
    for m in range(1, 9):
        u = rng.normal(0, 1.5)
        for c in range(1, 11):
            rows.append((g, f"{g[0]}{m}", c, round(20 + eff + u + rng.normal(0, 3.0), 2)))
pd.DataFrame(rows, columns=["group", "mouse", "cell", "y"]).to_csv("cells.csv", index=False)
