Mathematics Stack Exchange is a question and answer site for people studying math at any level and professionals in related fields. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to fit a skew normal curve to a data set in excel. My goal is to model incomes in geographic areas in order to get the # of people < $23,000 income, using several median values and their associated population sizes. I graphed the population frequency distributions in excel - some are normal as expected, but some appear skewed. Ive had success modelling with the cumulative normdist function in excel, as long as the data's frequency distribution was normal-looking and not skewed.

To get the skew pdf, do I have to calculate the error function, or just use the cdf of standard normal times the st norm pdf (times 2)?

Is there a way to integrate the skew normal pdf (once obtained) in excel perhaps using rectangles under the fitted curve? How to test goodness-of-fit?

Thanks for your advice.

share|cite|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.