Analyzing your data in JMP requires four basic steps, which are described in greater detail below: Step 1:Enter the raw data into JMP. This allows you to see how your missing values affect a line fit or see how many. Hope this helps, and please do enlighten me if I am missing something that makes this all easier/irrelevant. JMP is a powerful statistical and graphing software package that you have access to as a student taking a Biology lab course. 5 2.5K views 8 years ago Learn how to add a category of rows with missing values to your Graph Builder graphs. Why graph buidler can't just do this on it's own is another wtf moment for JMP but hey I'm on 12, so maybe 13 can do this? It's elegant and ridiculous, just like JMP! So again, I think the most intuitive solution is a column of 1's. Also you would want to make sure your column you are sorting by has data in every row or the count's will be wrong. Yes, you could edit that text but holy cow, we are just applying band-aid after band-aid here. Yes, you could add ANY continuous column to the merge zone and choose N as your sort statistic, but I think this is odd because the chart then says "category sorted by 'unrelated continuous variable'" when it's really sorted by the counts (hence calling my column of 1's count). Now all your categories can be bar charted and sorted by count. Then whenever you chart a category, you drop the 1's (i called it count) column into the merge zone of the axis and choose sum as the statistic for sorting. So the easiest and most intuitive solution for me is to create a new column of 1's in your data table. One solution out there is to make a summary table of that category.ugh, why make more tables to do such a simple thing!? All the articles out there talk about sorting by some other continuous variable dropped into the merge zone of the graph builder But I just want it sorted by the count of each category (you know, the ones that Graph Builder already counted! This is something matplotlib in python does automatically, btw, when you give it categories and counts). One option is also to remove the effect of users preferences, but depending on the platform this might take a lot of effort to set all default values to 1 or 0.I banged my head against the wall figuring out how to sort a simple bar chart of a category (which graph builder can automatically count and display the proper bar heights for, but gives no sorting abillity by that count.). Names Default To Here(1) Īxisbox = (Report(dist) << XPath("//ScaleBox")) Īxisbox << Add Ref Line(55, "Dotted", red, "F mean", 2) Usually I use XPath with some combination of << child, << sib, << parent and so on. Sometimes these have to be built a bit case by case. If there's multiple distributions in the report, loop through or be more specific when grabbing the xpath. use xpList instead of referencing an axisbox index. XpList = myrpt << XPath("//DropBox/BorderBox/AxisBox") // returns a list of matching occurrences Hopefully this stands the test of time, but it's worked for me so far. Meaning, don't just look for an axis box as there could be 4 of them, rather look for the axis box in a border box in a drop box, which appears to be unique to the 'main' axis. You can look at the xml, or look at the properties of an output report to see what might work. I probably could have found a workaround there, but ended up using xpath. I tried doing a 'get items' but I think it always returned 4 even though some were empty. But if the script is deployed widely, you need to account for other user preference settings. if you always have the same settings, you can hard code it and it should be fine. But if you add any of the other axes, the index becomes 2, 3 or 4 (the max of the total axes displayed. In the distribution platform, if you don't have the probability, density, and show counts axes set to be displayed, then the index for the axis box of the distribution's data is 1, meaning you can reference it with report(xxxx), similar to Jarmo's post above. I would not expect to be an issue in graph builder, mostly because I don't think user preferences come into play as much. It's related to the Distribution platform specifically (not graph builder which was in the original question), but may apply to other platforms depending on user preferences, I'm not sure. This is tangentially related but I'll put it here anyway.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |