how to plot these data

I've been told spotfire is powerful in visualizing patterns, but have failed on multiple levels to see the power and thus am seeking help/suggestions.

I have a 7x6 table. Each column represents data from one individual (for a total of 6 individuals)

Each row represents a specific category of measurement (Salary, Height, Weight, Vacation Days) or party affiliation.

I'd like to discern any pattern between R and D using these four listed categories.

See attachment for details.

I've tried the following with no success (zero !, cannot get a plot that looks intelligent).

1. I tried and failed to plot people against the numbers for each category using scatter plot.

2. I tried and failed to plot people against the numbers for each category using heatmap (scaled among each category)

3. I tried and failed to plot  these numbers against R or D using scatter plot to see a pattern (if any of the 4 categories can separate R (Republican) from D (Democrate))

Any suggestion. Great many Thanks.

Attachments

AttachmentSize
File test_file.xlsx9.11 KB

(3) Answers

Login