EXCEL

Step 7: Create Charts and a Histogram

Where would we be without the ability to view data in charts? It is sometimes easier to grasp context of data if we can see it captured in an image. In this step, you will work with data to create charts (see below), adding a tab for charts, and another for a histogram.

In this step, you will build Tab 3: Graphs—Charts and Tab 4: Histogram. After you complete these tabs, you’ll be ready to sort the data.

Work with Data to Create Charts

It is often helpful to view and interpret analytical results when they are presented visually. Graphs and charts help readers digest and interpret information quickly, consistent with the familiar adage "a picture is worth a thousand words." Let’s see what we can see in your data analysis.

Create the following graphs in your workbook on a separate tab named Graphs_Charts:

1. Create separate pie charts that show percentages of employees by (1) gender, (2) education level, and (3) marital status. Explore pie chart formats.

2. Create separate bar charts that show the (1) number of employees by race and (2) the number of employee per state.

3. Create a line graph for the sales summary provided.

4. Create a histogram that shows the number of employees in incremental salary ranges of $10,000. Here, you want to show how many employees are making $0–$20,000; $20,001–$30,000; $30,001–$40,000; and so forth, up to the highest salary range. This involves counting how many employees are in each "salary bucket" to create a frequency distribution table and histogram. Histograms seem hard, but mastering how to visualize the frequency of events is helpful for analysis.

Used with permission from Microsoft.

Note: Your Excel spreadsheet template has the upper limit and labels already identified. Complete the table and histogram by engaging the Data Analysis Toolpak. Place the output on a new worksheet and label it Histogram.

Resources

· Working with Excel Charts

https://edu.gcfglobal.org/en/excel2010/working-with-charts/1/

· How to Enable Data Analysis Toolpak

How to Enable Data Analysis Toolpak

PART 1: Installing the Analysis ToolPak Add-In for Excel 2010 and 2013

Make sure that the add-in is installed. Before you can use the Histogram tool in Microsoft Excel, you'll need to make sure that the Analysis ToolPak Add-in is ready to use. [1]

Navigate to the "Excel Add-ins" dialog box. You can do this from the main Home screen once you've opened the program.

Click Options on the File menu.

Then, click Add-Ins in the navigation pane.

In the Manage list, choose Excel Add-ins. Then, click Go.

Select the Analysis ToolPak Add-in. Once you're in the Add-Ins dialog box, select the Analysis ToolPak check box under Add-Ins available, if it is not already selected, Then, click OK.

Note that the Analysis ToolPak Add-in will not appear in the Add-Ins dialog box if it is not already installed on your computer. If you do not see Analysis ToolPak in the Add-Ins dialog box, run Microsoft Excel Setup. Add the ToolPak to the list of installed items.

PART 2: Installing the Analysis ToolPak Add-In for Excel 2007

Navigate to the "Excel Add-ins" dialog box. This is where you can check whether the Analysis ToolPak is already installed on your computer.

From the Home screen, click the Microsoft Office button. Then, select Excel Options.

Click Add-Ins from the navigation pane.

Pick Excel Add-ins from the Manage list. Then, click Go.

Select the ToolPak. In the Add-Ins dialog box, make sure that the Analysis ToolPak check box under Add-Ins available has been selected. Then, click OK. This should activate the Analysis ToolPak—and thus the Histogram function—on your computer. [2]

Sources and Citations

[1] https://support.microsoft.com/en-us/kb/214269

[2] http://www.excel-easy.com/examples/histogram.html

· Create Histograms