View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Buck Buck is offline
external usenet poster
 
Posts: 7
Default 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.