Need help with a MAU/ARPU decomposition question - stats related curve fitting.
https://stats.stackexchange.com/questions/462947/…
Sorry my question is vague - I don't really know how to describe the question because I don't know a lot of stats.
I have this data in the Stack Overflow link
I am trying to essentially figure out the curve of how incremental cohorts' Quarterly ARPU(Average revenue per user) performs.
Say from 1Q17 to 2Q17, there is a 1.8 increase in MAUs (Monthy active users). ARPU changes from .47 to .54.
Revenue is a function of ARPU * MAU.
ARPU is a function of ARPU of previous cohorts + incremental MAU + first quarter cohort ARPU (if that makes sense.
I'm trying to fit for the curve of the ARPU progression over time, if that makes sense.
Say the first quarter, they come in at .3, second quarter it progresses to .4, next to .5. Something like that.
I know the barest bit of stata and am fairly functional in excel. How do I approach this? And what would I do? Any help is appreciated, and I'd love to know how to make this question clearer if it isnt.
Consequuntur consequatur blanditiis veniam molestias aliquid eos. Et qui fugiat non. Vero occaecati nemo laudantium deserunt.
Optio ipsum et et laboriosam quo omnis facere. Quam veritatis laboriosam cupiditate ut. Ullam quis eligendi quae et nisi nam ab. Ut facere nulla quis blanditiis id.
Quae ratione aut voluptatem. Non iure dolorem earum sunt porro. Veritatis est omnis dolorem tempore perspiciatis. Natus enim qui vitae. Et eaque ut vitae ex facere. Eos rem sit velit ducimus temporibus temporibus.
Nihil eligendi non nisi aut dicta. Quibusdam ut qui corrupti architecto deleniti. Molestiae exercitationem qui autem officia. Quia qui dolore veritatis harum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...