Analyze your data and display it in a histogram

Reference no: EM13966269

Present your data in a histogram

You can analyze your data and display it in a histogram (a column chart that displays frequency data) by using the Histogram tool of the Analysis ToolPak. This data analysis add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) is available when you install Microsoft Excel 2010, but it might not be loaded automatically.

Important If you don't see the Data Analysis button in the Analysis group on the Data tab, you must Load the Analysis ToolPak add-in.

To create a histogram, you must organize the data in two columns on the worksheet. These columns must contain the following data:

Input data This is the data that you want to analyze by using the Histogram tool.

Bin numbers These numbers represent the intervals that you want the Histogram tool to use for measuring the input data in the data analysis.

When you use the Histogram tool, Excel counts the number of data points (data points: Individual values plotted in a chart and represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes called data markers. Data markers of the same color constitute a data series.) in each data bin. A data point is included in a particular bin if the number is greater than the lowest bound and equal to or less than the greatest bound for the data bin. If you omit the bin range, Excel creates a set of evenly distributed bins between the minimum and maximum values of the input data.

The output of the histogram analysis is displayed on a new worksheet (or in a new workbook) and shows a histogram table and a column chart that reflects the data in the histogram table.

Load the Analysis ToolPak

The Analysis ToolPak is a Microsoft Excel add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first.

Click the File tab, and then click Options.

Click Add-Ins, and then in the Manage box, select Excel Add-ins.

Click Go.

In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

Tip If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.

Attachment:- Econ-3316 Assignment 2 student.xlsx

Reference no: EM13966269

Questions Cloud

Compute the total deduction for these contributions : Compute the total deduction for these contributions. The AGI in each case is before any deduction Neither spouse is an active participant in a qualified retirement plan

Hired as a consultant for the united potato growers. : You have been hired as a consultant for the United Potato Growers. Your research indicates that fresh potatoes have an own price elasticity of -.12 and potatoes in general are -.29.

Difference between macroeconomics and microeconomics : Why is it desirable for a country to have a larger GDP? Give an example of something that would raise GDP and yet be undesirable.

Develop a risk assessment matrix for the briargrove project : Develop a risk assessment matrix for The Briargrove Project. Develop a Matrix for assessing an aspect of the project

Analyze your data and display it in a histogram : You can analyze your data and display it in a histogram (a column chart that displays frequency data) by using the Histogram tool of the Analysis ToolPak. This data analysis add-in (add-in: A supplemental program that adds custom commands or custom f..

Having a sustainable supply deals with : Having a sustainable supply deals with

Assume allan applies the equity method : Assume Allan applies the equity method to its Investment in Bellevue account

Positions of a test machine : In order to test the wear on four hyperalloys, a test piece of each alloy was extracted from each of the three positions of a test machine. The reduction of weight in milligrams due to wear was determined on each piece, and the data are given in T..

Pivotal roles in upholding ethical conduct : Analyze the primary way in which different staffing levels may play pivotal roles in upholding ethical conduct, including treating patients with dignity. Justify your position.

User Account

All Pages