Are you seeking assistance with this request still? This was a few weeks back and you were looking for verification of numbers. I suggest utilizing a crosstab view to verify numbers and walk through the calculations and expected values for a few of your data marks.
Thank you for responding. Yes, I am still looking for assistance on this issue that i am facing.
I did verify the numbers, but the main issues is that i want someone to make sure that the formulas I am using are correct and that is the only reason I have attached my workbook here.
If the variance I am using is correct or should there be a correction to it?, if I should use percentile or Percent of total to display the variance?
If you could take a look and help me out, it would be great.