In my previous post, I shared several Graph Builder graphs of the muscle quality and body fat percentage data I’ve been getting from my Skulpt Aim. However, since the post was already long, I didn’t have a chance to include any instructions on how to recreate those graphs. In case you have similar data or want to create a similar type of graph, here’s how to do it! I have also included animated gifs that capture the main steps in the process of creating each graph. (Click the animated gifs and graphs to see them enlarged.)
Weight Graph with Annotations
This graph shows all the weight data points that I have gleaned from medical record requests, notebooks, and wireless scale data from birth through about 2014. My table includes columns with weight measurements in rows and the date of each in m/d/y format.
In Graph Builder, I used the following steps to create this graph:
Graphs of Body Fat Percentage and Muscle Quality
The stacked table I used to create this graph included columns for Date, % fat, MQ, Body part, and Side, with one row for each observation.
To create this graph, I took the following steps in Graph Builder:
To create the version shown below with a separate color and regression element for each body part, I dragged Body Part to the Overlay variable drop zone. You can see my steps in the animated gif below.
Bar Graph of Replicates by Side
To create this graph, I started with my Skulpt Aim results table, and then created a summary table from that data by clicking Tables > Summary, choosing the Replicate column, selecting N as the Statistic, and adding Body part and Side as Group variables.
Starting from the Summary results table, I performed the following steps:
Body Shape Graph of MQ and % fat
I made my next two graphs using custom female muscle shape files I created with the free Custom Map Creator add-in. I described how I used the add-in to create these files in a previous post. By the way, I uploaded copies of my map files to the JMP user community here. Apologies to the guys -- you are going to have to create your own shape files! To make my custom map visible to JMP, I placed the shape files created by the add-in into the folder C:\Users\~myusername\AppData\Roaming\SAS\JMP\Maps.
Comparing my shape files to the areas measured by the Aim, I noted that the Back measurement area for the Aim was in the area I call Trapezius in my shape files. I created a copy of my Body part variable in my Aim results table and named it Body shape, then changed all occurrences of Upper Back to Trapezius in that column so that the colors would show up in the correct area of my body map. I did wish that I had done a better job with my Trapezius shape.
Then, I performed the following steps:
I performed the same set of steps for my % fat graph which appeared below the MQ one, except that I also clicked the Reverse Color checkbox so that lower body fat areas would show up colored red rather than yellow. As you’ll recall, MQ and % fat are inversely related, and the Skulpt app also uses color gradients that color high MQ and low % fat similarly.
Graphing My Measurement Variability
My final graph required calculations of daily Standard Deviation by body part and side for both MQ and % fat. I initially used Summary to calculate these statistics, dragging the SD columns from the linked Summary table into my main table. While this is a handy shortcut for a one-time calculation, I preferred for the calculation to happen automatically when I added new data to the table rather than repeating the Summary step each day.
Thanks to a suggestion from Xan Gregg, I decided to use a Column Standard Deviation formula column and specify my Body Part/Side concatenated variable and Date as the two optional By Vars in the formula. This gave me values for SD(MQ) and SD(% fat) for each body part, side and day.
To create a graph of these values, I performed the following steps:
I also made some final adjustments to ranges and decimals in the Axis Setting dialog, added shaded axis reference ranges between 0 and 1, and increased the Graph Spacing by right-clicking on the division between the graph sections and changing the number to 5.
I’ll be giving a talk on using my custom body map file with my workout data at JMP Discovery Summit in San Diego next week. I hope to see you there! If you won’t be in San Diego, you can see my previous blog posts on creating custom maps and workout data visualization in my Fitness and Food series on the JMP Blog.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.