Variance where x is the sample mean AVERAGE(number1,number2,…) and n is the sample size. =VAR.S(A2:A11) =VAR.P(A2:A11) VAR.S assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance by using VAR.P. Arguments can either be numbers or names, arrays, or references that contain numbers. Logical…