Paste data → Histogram (X) + Lognormal PDF → ln(X) histogram + Normal PDF → μ̂,σ̂ → Probabilities → Excel.
Theme:
1) Data (positive values)
Interpretation example for students: waiting times (minutes) at a very popular restaurant. Values are positive and right-skewed (many short waits, a few long waits).
n:— | mean (raw X):— | sd (raw X):—
μ̂, σ̂ = —
μ̂ and σ̂ are the mean and sd of ln(X) (log space). We fit on ln(X), then interpret back on the original minutes scale.
2) Histogram (raw X) + Lognormal PDF
Paste data and click Analyze to draw the histogram.
Bars are density-scaled; smooth line is Lognormal(μ̂,σ̂) PDF.
3) Why Lognormal? Show ln(X) is ~Normal
Logic: If \(Y=\ln X\) ≈ Normal(μ,σ²), then \(X\) is Lognormal(μ,σ). This explains the long right tail on the original scale.
After Analyze, we’ll draw the histogram of ln(data) + Normal(μ̂,σ̂) PDF.
Bell-shaped ln(X) supports using the lognormal model for X.