It is necessary to calculate the array group-based challenges and the expectation of dispers

it is Necessary to calculate the array group-based challenges the expectation and variance. Or standard tools of Excel, or to write Excel macro.
In General, write, who understands what the idea of it, the specifics will discuss. Will be considered only candidates with knowledge of theories of statistics.