Policy to Strategy Analysis

I just started work for a company and have been asked to review how corporate policy relates to business strategy implemented at the business unit level.  I am a political science major with some statistics but don't have a good grasp of how to approach this.

The attached Excel file displays the results of a survey completed by selected management at the corporate, regional, division, and department levels and reflects their view of how six elements at each level relate to the other levels (except for Division which has seven elements).  

So far I have added in a dummy variable to account for the additional set of data at the division level, determined the standard deviation, color coded the data to disply up to three standard deviations above the mean, and correlated the data in each panel.  The standard deviation seemed to work all right but the correlations told me very little.  

I need to discern the stronger and weaker relationships among the data elements and develop an easily understandable display. I also need to do some cluster analysis.

Three questions:
1.  Is the standard deviation a good measure for this and is it used correctly?
2.  How would you suggest I analyze the data?
3.  How would you graphically display the results?

I will probably be limited to Excel with the Analysis Toolpak and Powerpoint.  Any analysis or examples you could provide would be appreciated.

Attached file(s):

POLICY ANALYSIS V-05 20040827.xls  View File