IV

The Data

How do you decode your data into information that you can visually explore and analyze?


DATA EXERCISE

Try your hands on decoding your data into information that you can visually explore and analyze.

1. Time series chart

Create a time series chart using the World Internet Usage data in wide format available at: http://becomingvisual.com/portfolio/wideandlongformats. Note the challenges associated with this data format for graphing.

2. Radar Chart

Try using the data in Table 4.9 to create a radar chart, bar chart and pie chart. Download the data at: http://becomingvisual.com/portfolio/summarytable

3. Missing Values

There are many options for replacing missing values. These include 1) replacing empty fields with the values that appear most frequently, 2) using the mean value, or 3) developing a predictive model to determine with a degree of confidence and accuracy the best approximate value for the missing one. Learn more at: http://becomingvisual.com/portfolio/missingfields

4. Calculate descriptive statistics

Use R’s summary function. Or, Excel users can go to data > data analysis. Mac users may have a little more difficulty unless they download the StatPlus add-on for Excel. Learn more at: http://becomingvisual.com/portfolio/summarystatistics

5. Scatterplot matrix

You can save time by creating a scatterplot matrix that shows the relationships between many variables in a single data set as shown in Figure 4.10. Learn more at: http://becomingvisual.com/portfolio/scatterplotmatrix