Data Visualization & Analysis: Car Manufacturers & Mutual Funds Case Study, Assignments of Computer Science

Download Data Visualization & Analysis: Car Manufacturers & Mutual Funds Case Study and more Assignments Computer Science in PDF only on Docsity! Information Visualization CS 7450 Home Work 6 Sanmati Kamath The goal of this assignment was to work with two tools, EzChooser and InfoZoom and use them to visualize two datasets and undertake some tasks to understand the data. The datasets that were chosen for this assignment were “Car” and the “Mutual Fund” datasets. EzCHOOSER 1. Which manufacturers have the highest horse power? Which country do these manufacturers belong to? First showing all the data and filtering by the highest “Horsepower” values helped in reducing the displayed information. Then, clicking on the horsepower and the Country of Origin, showed the results quite well. The result of filtering is also displayed in simple text format at the bottom of the screen giving more detail on entity names etc. Figure 1: Maximum horsepower for European and Japanese cars is about 133. We see that American cars have high horse powers but the others have a maximum of ~133. 1 2. The second task was to find out which cars have the best MPG. Was this a common feature with all cars for the same countries of origin? Choosing MPG values above 30 MPG, gave the result seen in Figure 2. Japanese cars have the highest number of cars with MPG values > 30.0. Figure 2: Japanese cars and MPG values. 3. The trend clearly seems to be that American cars were built for Horsepower whereas the Japanese and European cars were built for mileage. Were there any outliers to this trend? Filtering by Country by Origin and MPG values > 35, we see that there were some American cars with very high mileage. These are listed in Figure 3. Figure 3: Plymouth Champ is an outlier with a MPG of 39 2 INFOZOOM Infozoom is a tool that incorporates not only display of the information, but also lets a user carry out complex tasks on the data and save it. It is a lot more complex than the previous tool tested. Similar tasks as above were carried out on Infozoom. They are listed below along with the results. 1. Which manufacturers have the highest horse power? Which country these manufacturers belong to? Infozoom allows mathematical functions to be implemented on the data resulting in more informative displays. Infozoom allows one to use a Compressed and a Wide view, which helps in getting details as well as overview with ease. For answering the above question, the inverse relation between Mileages (MPG) and the Acceleration and Horsepower were taken into consideration. As Infozoom allows mathematical tasks to be performed on the data, the (Acceleration + Horsepower)/MPG values were computed and displayed. This brought out the relation between the three variables but also gave a good indication of the trends in car manufacturing in the three countries. Figure 7 shows this result. Figure 7: Result showing the relation between Horsepower, Acceleration and MPG 5 2. The second task was to find out which cars have the best MPG. Was this a common feature with all cars for the same countries of origin? Listing the cars by country of origin and showing the MPG values in compressed form, gives a good idea of the trends. Figure 8: Cars by Origin and MPG values. Green depicts the best and red the worst in gas mileage. 3. Does a good performance mean a good Morning Star rating? Just plotting all the information showed that there was a dependency of rating over at least the YTD, 3Mo, 1Yr and 3 Yr performances. Though, 5Yr and 10Yr performances play a role, they do not seem to play a major role in the ratings. Taking the AVERAGE (YTD, 3Mo, 1Yr, 3Yr) values, did show dependency of the ratings over the average and are shown in Figure 9. Figure 9: Morning star rating shown with the average of the YTD, 3Mo, 1Yr and 3Yr earnings. 6 4. Within the five star rated categories, find the fund with the best average over 3Mo, 1Yr and 3Yr and YTD). The Infozoom tool made this analysis quite easy. Figure 10 shows the plot and the fund turned out to be Rydex OTC Inv (symbol RYOCX) of the Large Growth category. Figure 10: Finding the fund with the highest average for certain terms. 5. Compare three funds- Fidelity, Janus and PaineWebber; list the 3Yr, 5Yr, 10 Yr, Yield, Expense Ratio and Categories of the fund type. Obtaining an alphabetical listing and choosing the three funds and filtering and listing their details was quite easily accomplished on Infozoom. Over and above that, Infozoom allowed to compute the average values where missing values of PaineWebber were considered to be zeros. 7