<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />I like to generate a summary table with the Probability and Density information for each bin of an histogram and taking a by variable like "sex" (Big Class.jmp example File) into account (means i create two histograms).
Using the Big Class.jmp File as an example I can save the Bin Midpoint to the Table and create a summary table with % of Total. This does not give the expected value as it takes the weight into account and does not separate into F and M.
Does anyone has an idea how to create such a summary table with probability and density?
Thanks Mirko
Midpoint weight By sex | sex | N Rows | % of Total(Midpoint weight By sex) | expected probability %
65 F 2 3,09% 11,11%
75 F 1 1,78% 5,56%
85 F 3 6,06% 16,67%
95 F 3 6,77% 16,67%
105 F 1 2,49% 5,56%
115 F 5 13,66% 27,78%
125 F 1 2,97% 5,56%
145 F 2 6,89% 11,11%
75 M 2 3,56% 9,09%
85 M 1 2,02% 4,55%
95 M 6 13,54% 27,27%
105 M 4 9,98% 18,18%
115 M 4 10,93% 18,18%
125 M 3 8,91% 13,64%
135 M 1 3,21% 4,55%
175 M 1 4,16% 4,55%