DATA ANALYSIS RATE COMPARISON Space Office | https://www.spaceoffice.ai/blog/data-analysis Question: Eligible population and unit: Outcome and source of record: Cohort dates, time zone, and follow-up: Attribution and missing-source rule: Deduplication rule: Decision owner: Fictional school data Period,Source,Eligible visitors,Registrations Earlier,Direct,300,60 Earlier,Referral,200,10 Later,Direct,100,22 Later,Referral,400,24 1. Divide registrations by eligible visitors within each source row. 2. Sum registrations and visitors independently within each period. 3. Divide those totals. Earlier is 70/500 = 14%. Later is 46/500 = 9.2%. 4. Multiply each later rate by the earlier visitor share for that source. 5. Add the products. (0.6 x 22%) + (0.4 x 6%) = 15.6%. Explain the comparison Observed change: Reference mix: Unknown or unmatched rows: What the comparison supports: What would require more evidence: Owner and next check: