Subscribe Bookmark
audrey_shull

Staff

Joined:

Jun 23, 2011

What Factors Affect Office Temperature? Creating Custom Maps

This post is the third in a series that shows how we conducted an observational study about office temperatures, from design to execution to analysis and visualization. See Part I and Part II.


In the previous two posts, we discussed the design and execution of an observational study about what factors affect office temperature. In Part II, you saw how we actually collected the data and how we cleaned the data before analyzing it in JMP. Today we will showcase some new features in JMP 9 to visualize some of our results, and we will run a model that will help us determine what factors are strong predictors of office temperature.


One of the new features in JMP 9 is the ability to create custom maps. We created a map of the 4th floor of Building S here at SAS, where most of the JMP staff is located. Using new features in Graph Builder, we can analyze the office temperature results visually.


The map shown below is the JMP floor, grouped by time of day, with color reflecting the Fahrenheit value. This report also contains a background image (another new feature in JMP 9) that happens to be the blueprint for the 4th floor of the building. Exploring data visually in this way can give us hints as to what factors are affecting office temperature. Looking at this particular map, it looks like the offices on the east side of the building are warmer in the mornings than they are in the afternoons. On the western side of the building, the opposite appears to be true. From this visualization, we might expect that both of these variables are affecting office temperatures, or perhaps that the interaction between these terms is significant.




Next, let’s take a look at Fit Model to see the numerical analysis results. I entered all the main effects into the model for the first try. In the table below for Fixed Effect Tests, we see a number of variables that may have a significant effect on temperature, including thermometer, outside temperature, type of space, sector, volunteer and outside conditions. The most surprising thing to me is the fact that neither east or west nor time of day appears to be significant. This first version of our model does not measure interactions between main effects, but my next step will be to include an interaction term in the model for east or westtime of day, since my Graph Builder visualization above indicated that there may be an effect.




The next table of Fixed Effects Tests shows a later version of my model, where I have removed wing and added the interaction term east or westtime of day. Here, my suspicions are confirmed. The interaction term is clearly significant and even has the highest F Ratio.



We want to eliminate the insignificant factors from the model, and the method I chose is a Stepwise regression. The following factors wind up being significant when Stepwise is finished. Notice what is missing: The outside weather conditions and temperature do not seem to have any effect on the inside office temperature. Note that the interaction term is still showing as significant -- this is an example of how visualizations can sometimes guide you in making decisions during your analysis.



In the next post, look for more visualizations of this data using different JMP tools.


How did you like the new features in Graph Builder? What other visualizations would you be interested in seeing?

3 Comments
Community Member

Shawn wrote:

I'd love to see that as well, tried to create a similar graph using the Custom Map Creator add-in from JMP, but can't figure out how to display in graph builder.

Please post how you used Graph Builder to create the room visualization.

Community Member

Daniel wrote:

I'd love to see a post on how you created the room visualization in graph builder.

Community Member

All About Background Maps in JMP 9 - JMP Blog wrote:

[...] The boundary-style maps are vector-based shapes. This type of map draws an outline around a defined area. Some of these are provided as part of JMP, or a user can define his or her own. Because of this, the list you see may be different than the one presented here. This type of background map has been mentioned in other blog posts, such as What Factors Affect Office Temperature? Creating Custom Maps. [...]