Section 03 · Stewardship & Analytics
The Christian Minister
Faithful stewardship is a math discipline. Allocate every dollar with intent, then track growth, restricted funds, and clergy taxes correctly.
Lesson 03 · Stewardship Math
Attendance Growth — Smoothing the Noise to See the Signal
Week-to-week attendance bounces wildly: rain, holidays, school events, sickness. A 4-week moving average averages the last 4 Sundays together, so the noise cancels out and the real trend appears. Then you compare this year's smoothed number against the same week last year (Year-over-Year) to see if you're actually growing.
Why It Matters
A pastor who sees attendance drop from 220 to 180 in one week panics and changes the sermon series. But if the 4-week average is still climbing, that single low Sunday was just a rainy day. Smoothing prevents whiplash decisions.
The Formula
MA₄ = (W₁ + W₂ + W₃ + W₄) / 4 YoY % = (Now − LastYear) / LastYear × 100MA₄ — 4-week moving average attendance
W₁..W₄ — The four most recent Sunday counts
YoY % — Year-over-year growth percentage
Worked Example
Last 4 Sundays: 195, 210, 180, 215. Same 4-week window one year ago averaged 185.
- 1. Sum this month: 195 + 210 + 180 + 215 = 800
- 2. MA₄ = 800 / 4 = 200
- 3. YoY change = 200 − 185 = 15
- 4. YoY % = 15 / 185 × 100 ≈ 8.1%
Answer:Healthy 8.1% YoY growth — keep the current strategy
Common Pitfalls
- •Reporting raw weekly numbers to leadership — they will overreact to noise.
- •Comparing this Easter to last regular Sunday — always compare like-for-like weeks.
- •Ignoring seasonality: summer dips are normal; only worry if YoY drops too.
Growth Trend Tracker
MA(n) = (xₜ + xₜ₋₁ + … + xₜ₋ₙ₊₁) ÷ n • YoY% = (Current − Prior) ÷ Prior × 100
Smoothing noisy weekly data with a moving average reveals true direction; YoY shows real growth vs last cycle.
Period avg
211.4
Prior year avg
YoY change
+11.27%