design a macro program as per the requirement in the attached file. I have also attached the macrodata.

Suppose that we have some variable p that is the proportion of defective items in a sample. Either the sample ai is 0 or it is 1 for all i=1 to N. The p is given by N a i p= N i=1 Let's say I have a sippy cup for kids and if there is a burr, a i is defective. If defective I record a 1, if not, a 0 (discrete). So my sample might look like this in column A. 1 0 0 0 1 Now p would then be 2/5 or p=.4 In my original problem, I just said to use one column. If I had many samples, I could calculate the average of p. Now with many sample sets we can write pj where j is the number of sample sets. Thus the average of p is M p p j = M j=1 where j = 1 to M and M is the number of sample sets. The variance is given by (nothing up my sleeve and I wave the magic wand) ( 1 ) p p N var = Remember we want to calculate p= p which is given by (1 ) p p N Now the question is \"Can you modify the above program to calculate the standard deviation?\". Try programing this and it will serve as the program I requested