I am not a statistician and I need help checking some work I have done. Is my maths valid? Is this alternative formulation of the problem useful to anyone? I am aware that I have just re-invented the wheel and I now have an easy check on my problem, but considering a problem from multiple viewpoints can be useful.
I have appended a PDF and two of my Excel working files.