Analyzing the Analytics

We are analyzing the data-set Premarital Sex for today's class.  This is to visualize the opinion on Premarital Sex from 1989 to 2008.  We plot the line graphs for the three groups based on Average Sex per year:  1) Not wrong at all 2) Sometimes wrong 3) Almost always wrong and Always wrong We have an interesting result already. Over the past 20 years, those opposed to premarital sex have been having more and more sex on average each year, while those who think it is not wrong at all have been having less and less.  Now, we plot the Respondent's opinion on pre-martial sex based on Average Age of Respondent. Since younger people have sex much more frequently than older people (create a new worksheet plotting SexPerYear against AGE if you want to see for yourself), we can see that the puzzling trends in sexual activity are likely linked to the changing average age of these difference groups. The answer appe...

Getting Started, Loading Data and Creating Bubble Charts  We have used the Sales dataset for this exercise. The data has 3 categories- 1) Furniture 2) Office Supplies 3) Technology All these categories have various sub-categories. We visualize the profits across the sub-categories. We color code the circles as per the categories.  The size of the circle indicates the amount of profit for the particular sub-category. We can see that the Technology category has the highest profits while Furniture has the lowest profits with losses in Bookcases and Tables sub-categories. In the next exercise, we will be analyzing region wise trends in Profit and Discount from our Sales data. Since we are interested in geographical comparisons, our natural choice will be a map. As seen above, the maps illustrate profit and discount ranges by region. We can determine that losses (red) are incurred on the coasts with profits (green) in the midwest and north. W...

We have tried to visualize the USDA_activity_dataset.xls for this exercise. In the first view, we create a map for each state showing obesity rates at the county level. Now we have a map showing a dot for every county which has a record. There are 3 unknown locations which have been removed. In the second sheet, we have filtered by State:Alabama and color coded the obesity rates. The red circles are the ones where adult obesity rate is high. The obesity rate is highest for County:Greene with rate 43.50 The obesity rate is lowest for County:Baldwin with rate 24.50 In the third sheet, we have done scatter plots to see the relationship between obesity and health-related behaviours at county level. We can see that there is a linear increase int he obesity rates w.r.t Smoking, Eating less fruits and vegetables and less exercise. Thus, there are many attributes contributing for the adult obesity rates.