Take the 2-minute tour ×
Mathematics Stack Exchange is a question and answer site for people studying math at any level and professionals in related fields. It's 100% free, no registration required.

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|improve this question

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.