You can hide the fields and buttons, but you still have limited formatting capability. The plot area cannot be resized, and the pivot fields and buttons clutter them up. I could make a pivot chart, but I dislike pivot charts.
The empty rows come from checking the Empty Rows Between Items for the Factor field. The data area contains Average of Result, while Factor and Level are stacked in the rows area, with Level inside Factor. Instead of constructing a table of formulas to analyze the data, I can instead create a simple pivot table. I’ve converted the range to a list for all the usual reasons. This is what the top section of the data looks like when normalized in this way.
This means each observation needs as many records (rows) as it has factors. A more flexible arrangement is to replace the several fields for each factor with two fields: one for factor name and one for factor value. That is, each input parameter had its own field. The data I started with was a flat table, one row per observation, but it wasn’t normalized.
In Preliminary Data Exploration in Excel I showed how to start the process of analyzing a table of data.
0 kommentar(er)
