hypothetical formula

[jespo1351]

Hi,

I am not sure if this is possible in excel with a formula, array or macro but I'll ask anyways. I am not looking for an exact answer but I probability guide.

This is all made up information for the sake of an example. So there are items in Column A that sold the quantities in column B for that day. Columns C-J are statistical bits of information containing sales history, current stats and current marketing ratings from our company.

Question- Is there an array/formula/macro that can take C3:J10 and compare it to B3:B10 to determine the most likely reason/s from C3:J10 for the higher Grade in column B? maybe a table to chart would be better?

So are the Q4 rankings more of an impact towards the GRADE or is the industry rating something to pay attention to? Could it be a combination of both 2016 sales history and volume?

Thank you for any advice or direction

[MrShorty]

This sounds like it is first a statistics question before it can be a programming/spreadsheet question.

The exact statistical tests are above my pay grade, but I know that there are tests and strategies for determining the importance of predictor variables in multivariate regression. A couple of tutorials:
This one is a minitab blog, so the example is in minitab: http://blog.minitab.com/blog/adventu...ression-models
This one is for Excel: http://www.real-statistics.com/multi...ression-model/
And I'm sure there are others
At this stage, I would recommend some research into how statisticians measure and test for the significance of different variables in a correlation. Then once you understand the statistics behind the question, you can help us understand it, and then we will be better able to help you program that into Excel.