Data Analysis : Bubble Graphs
Diagrammatic representation is the backbone of data analysis because most people do not understand tables laden with numbers. The business world wants the analysis done and results interpreted in a very easy to understand layman terms. Hence graphs and charts become a tool of high importance to researchers in order to conclude their findings.
Bubble graphs are graphs with the normal 2-d axis but have an extra feature called 'bubbles' and the size and position of these bubbles are also of relevance to the analysis.
Here is an example of graph prepared using SPSS which are not very attractive to look at neither they contain detailed information.
So we shall use MS Excel to fulfill the need for a better graphical representation in form of bubble graphs as follows :
Here we have taken 3 categorical variables to map the bubbles in MS Excel for all the service providers. We can see that "other services" has the biggest bubble which means that most of the respondents have said yes to other services apart from sms, voice etc. from these providers.
Now we can better map these bubbles to higher accuracy standards by using PERMAP.
Step 1 : Create a proximity matrix using SPSS as shown below
Step 2 : Copy the Proximity matrix table to excel and then to notepad and make the notepad file PERMAP compatible by writing the syntax above the data table. The process has been shown as under
Step 3 : Having done this we have to import this notepad file into PERMAP. Then the file should be saved as a PERMAP file like the one below
Step 4 : We should copy the contents of the above highlighted part into excel and a add a third column which has the count or frequency of respondents who have said YES. Next we insert Bubble graph for the data and thus is ready for interpretation
No comments:
Post a Comment