I am not a trained statistician but I am trying to improve on my own MBA thesis which was essentially regression analysis of the factors affecting opening cinema box-office in the UK.
I am now trying to look at the mix of marketing channels used by distributors, specifically TV, Press, Outdoor, Radio and Web. My thesis looked at the absolute levels of marketing spend in each channel, but I am now more interested in the combinational proportions of spend across the channels; (e.g., 35% TV, 25% Press, 25% Outdoor, 10% Radio and 5% Web) which of course sum to 100%. The idea is to try to determine an optimal mix under a range of scenarios of budgets opening dates and screen-counts.
I have read that Log-Ratio compositional regression analysis can get around the obvious cross-correlations of inputs that sum to a constant, but I do not know where to start. Can anyone please point me to a novice's guide to log-ratio analysis, especially one that doesn't baffle me with too many strange symbols without definitions, (although I have printed the symbols list from Wikipedia!).
I am very competent with MS.Excel, (although I would prefer not to have to write macros unless I have to), so basing the analysis in it would please me, (and I don't really have any money for expensive 3rd party software).
Would anyone be able to kick-start me please?