![]() Part 1: Reverse-Engineer The column B formulae are: Last Point =MAX(A2:A6) Mean =SUMPRODUCT(B2:B6,A2:A6)/SUM(B2:B6) E(x^2f) =SUMPRODUCT(A2:A6^2,B2:B6) E(xf)^2 =SUMPRODUCT(A2:A6,B2:B6)^2 E(f) =SUM(B2:B6) Variance =B10-B11/B12 StDev =SQRT(B13/(B12-1)) Part 2: Chart Trickery Data table: Column D is just an incremental counter. I used Excel 2007 for this hopefully you have the same options available in your version. Second, I employed some chart trickery to make the normal distribution curve look right when superimposed on the column chart. How can I get this effect? There are two main part to this answer: First, I reverse-engineered the grouped data to come up with an appropriate mean and standard deviation on this scale. ![]() ![]() But.the normal should be overlayed on the bar plot. Otherwise, you get something like I've attached. How can I do this in excel? I need the axis to line up such that it takes up the width of the bar plot. ![]() Next, I want to add a normal distribution (line plot) with a mean of 0.136 and standard deviation of 0.497 on top of this histogram. Specifically, I have the frequencies 2 6 12 10 2 and it produces the bar plot you see below. Since Excel doesn't have histograms, I made a bar plot using the groups I developed. Let's say I have a list of values and I have already chunked them into groups to make a histogram.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |