Thursday, September 13, 2012

Bubblegraphs-Team B


Today we will learn about bubble graphs.
SPSS does not produce very efficient graphs hence the need to look elsewhere. We will use MS-Excel to make more revealing graphs.A bubble chart is a type of chart that displays three dimensions of data. Each entity with its triplet (v1, v2, v3) of associated data is plotted as a disk that expresses two of the vi values through the disk's xy location and the third through its size. Bubble charts can facilitate the understanding of social, economical, medical, and other scientific relationships.
Bubble charts can be considered a variation of the scatter plot, in which the data points are replaced with bubbles. As the documentation for Microsoft Office explains, "this type of chart can be used instead of a Scatter chart if your data has three data series, each of which contains a set of values.




  Graphs                                                                                                                                               In this bubble graph:
Variables used are   Voice , SMS  and Other
Values on X and Y axis should be continuous. We will now create a table which will now
We can plot a bubble graph using the data copied from SPSS.




We can plot a bubble graph using the data copied from SPSS in Excel and we get the follw


We then transform this table into a new table since the previous table contains errors. 


 Once we get a cluster we format the axis's and stretch the bubbles to get a better graph which is easily distinguishable.






No comments:

Post a Comment