Recall that the sample variance of a data set can be found by using the VAR. S function in Excel or.

Recall that the sample variance of a data set can be found by using the VAR. S function in Excel or.

Recall that the sample variance of a data set can be found by using the VAR. S function in Excel or by plugging each x value of the data set into the formula: Variance = Ʃ(x – x¯) / (n – 1)where x is the mean of the data set and n is the number of values in the set.a) What is the bullwhip measure for the retailer?b) What is the bullwhip measure for the manufacturer?c) What is the bullwhip measure for the supplier?d) What conclusions can you draw regarding the impact that economies of scale may have on the bullwhipeffect?