Ok, I have been doing some more digging and it looks like a Factorial ANOVA (2 IVs and 1 DV) is a good starting point.
What follow up tests could I do to answer my questions?
Hi all,
I am struggling to find out how best to correctly analyse some data - because I don't know what to search for, not due to the complexity of the methods. I am hoping to get some direction on what to apply to analyse my problem:
The average sales conversion rate of (as a %) is a factor of two known categorical variables: the salesperson, and the source of the lead. There may be more degrees of freedom that I don't necessarily know of.
What I would like to do is somehow understand the conversion rate potential of:
- A single salesperson independent of the lead sources they work.
- A single lead source independent of the salesperson who works it.
What I would like to be able to say is:
- that Daniel has the potential to convert at 5% assuming an ideal lead source, and
- Inbound Email has the potential to convert at 4% assuming an ideal salesperson.
As you can see, I know what I am looking for and I'm fairly sure it's possible with the data I have but I don't understand the terminology at all!
Not sure if this will help but I have started to aggregate the data into a table:
SALESPERSON1 SALESPERSON1 SALESPERSON1
----------------------------------------------------------------------
LEADSOURCE1 | 5% | 2% | 1%
LEADSOURCE2 | 2% | 1% | 1%
LEADSOURCE3 | 5% | 3% | 2%
----------------------------------------------------------------------
Any help would be greatly appreciated.
Daniel