I am working in Microsoft 365. I want to use historical data to provide the probability of an outcome based on several variables. I want to know if X will be positive or negative based on day of week, month and hour. In the formula attached I would like to find the probability that Hour 1 will be positive based on all variables. I also want the capability to see what the probability that hour 1 is positive on just Mondays? I hope my explanation was clear. Thank you.
Bookmarks