I just wants to check whether i did the right thing or not, Here the question: 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.

Question

anonymous · Answer

Is a excel file  and what i did so far

anonymous · Answer

if u wonder what is the second sheet asking here the question: 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.

anonymous · Answer

sorry for posting this long question :(

anonymous · Answer

By the way this is statistic and probability problem