Measuring growth-how much did revenue increase using 12 months
Thank you joeu2004.
" "a" is the average monthly increment for the trendline.", is what I was
looking for.
I understand that the regression curve does not fit the actual data as you
mentioned so its difficult to say with confidence that this "trend" is
accurate.
More data is needed but comparison to prior periods is impossible since the
business underwent significant changes in operations.
One last thing: how do you get this data into Excel RSQ? That requires x-
and y- values. I could see using revenue and EBITDA as the two variables,
but you seemed to imply that it could be done, and I did not provide EBITDA.
|