trying to figure if my answer is correct or wrong here what

trying to figure if my answer is correct or wrong, here what im support to do:

On the first page, data is given (column A) and you are to compile it (column D) into bins as indicated in column C. Find the actual mean (G1), variance (G3), and standard deviation (G4). Also use the compiled bin data to approximate the mean (G2), variance (G5), and standard deviation (G6). Include a bar-chart (in cells C13:G25) displaying the compiled frequency data with bins as labels.

On the second page, data is generated in column H, but this is solely to create the frequency and relative frequency compilations of columns B and C. A bar-chart is given in cells A12:G29 displaying the relative frequency data. You are to complete cells F1:F3 with the approximate average, variance and standard deviation from the relative frequency data.

here part 2:

this have over 100 colums

Solution

Formulas to be note to compute the data

On Column D, into bins as indicated in column C

COUNTIF(A1:A100,\"X<10\");
For Mean we use Average(A1:A100);
Standard Deviation STDEV.S(A1:A100);
Variance We use Fromula VAR.S(A1:A100)
Approx Variance from Bins VAR.S(D1:D10);
Approx Standard Deviationfrom Bins STDEV.S(D1:D10);