APPENDIX A

Charts and Graphs using EXCEL

Computer Instructions

The data for constructing charts and graphs in this Appendix can be found in the file: Appendix 2A-Charts and Graphs.xlsx

http://www.businessexpertpress.com/books/data-visualization-volume-one-recent-trends-and-applications-using-conventional-and-big-data

Constructing a Histogram Using EXCEL

Column A of the EXCEL data file App 2A-Charts and Graphs.xlsx contains the lifetime of 200 television components. Construct a frequency histogram of this data. Before constructing the histogram, we need to determine the number of class intervals or bins for the data. See the section Frequency Distribution in Chapter 3. Suppose we decided to divide the data into class intervals shown in Table 2A.1 ...

Get Data Visualization, Volume I now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial