Subscribe Bookmark RSS Feed

summary table with distribution

mlo

Community Member

Joined:

Feb 8, 2012

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%