Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Moving average versus exponential forecast, which is better for predicting respondents?

Copper Contributor

Hello,

My dataset includes monthly data of about 12 months that shows a funnel including, number of respondents, number of people who showed up at the event, and number of people who signed up to join for future events. I would like to set up a forecast so that we can set a target of let's say 80 new joiners and it would show us how many people we would need to achieve this target at each stage based on previous data.

Currently, I've gone with taking the last two months running average to get these numbers. But as I'm not too familiar with the forecast functions, I'm not sure if that is a better method for such data. I just want to make sure I'm following best practices. Please advise if I can do this in a better way.

0 Replies