Category Archives: Ms. Excel

How to Make Histogram in Excel – Easy Tips

If you work in the business world, you might be familiar with histogram. This column chart is often used by professionals in a business presentation. But, what is histogram actually? And how to make histogram in Excel?

Histogram – What Is It?

A histogram is actually a data analysis tool. This is a common tool used in the business world. The tool comes with a form of a column that displays a variable’s frequency occurrence in the specified range. The tool also functions to organize a group of data points into the ranges of specified-users. A data series will be condensed by a histogram that can be visually interpreted in much easier ways. It is done by taking a lot of data points. The histogram will then group the data points into bins or logical ranges. Generally, there are different common ways that people can do to create a histogram in Excel. They are an in-built histogram chart option for Excel 2016 and Data Analysis Toolpack for Excel 2013 or the prior versions.

Make a Histogram in Excel 2016

So, how to make a histogram in Excel 2016? And how to make a line graph in Excel? If you are currently using Microsoft Excel 2016, there are some steps that you have to complete if you want to create a histogram by using the tool. The program comes with a new addition in the chart selection. This is where the histogram chart functions as an in-built chart for the program. Here are the steps.

  1. The first step you have to do is selecting the entire dataset you are going to present.

  2. Then, you need to click the Insert tab.

  3. After that, you can press on the “Insert Static Chart” option which is located in the Charts group.

  4. Then, you need to click on the Histogram chart icon which is located in the Histogram group.

The above steps on how to make a histogram in Excel will make it possible for you to insert a histogram chart which is based on the data set you have collected before. Once you have completed the steps, you will be able to customize the chart simply by right-clicking the vertical axis. Then you can select Format Axis to continue. This action will allow you to open a pane which is located on the right panel. This contains all the relevant options you need to make the histogram. To customize the histogram chart, there are some things that you will need include by category, automatic, bin width, number of bins, overflow bin, and underflow bin.

How to Run a Regression in Excel – Everything You Need to Know

Talking about Microsoft Excel, it can’t be denied that people can take a lot of benefits from this handy tool and running a regression through the program is just one of them. This is a tool which obtained by the Data Analysis add-in. So, how to run a regression in Excel? And how to make a line graph in Excel? Just take a look at the following steps.

  1. Tell Excel What You Want

The first thing you should do is telling Excel that you need to participate in the big leagues simply by pressing the Data Analysis command button. It can be found on the Data tab.

  1. Select the Regression Tools Provided

Then, you need to choose the Regression tool that can be taken from the Analysis Tools list once the Microsoft Excel shows the Data Analysis dialog box. Then you can click OK and you can start the regression tool.

  1. Identify the X and Y Values

If you have selected between the regression tools, now it comes the time to identify your X and Y values. You can use the input Y range text box to help you identify the range of worksheet that contains the dependent variables. After that, you can move to use the input X range text boy which functions to identify the reference range of worksheet that contains the independent variables. You need to keep in mind that the input ranges should be placed in a single column of values. In addition, you can select the Label check box if you want your input ranges that contain a table.

  1. Set the Constant to Zero

This is optional. But, you have to keep in mind that if your regression line starts at zero, then you need to choose the Constant Is Zero check box.

  1. Choose a Location for the Analysis Results of the Regression

The next step on how to run a regression in Excel is selecting the location. To do this, you need to use the Output Options radio buttons as well as text boxes. This is aimed to help Excel to specify the place for the analysis results of the regression. For example, if you want to put the regression results to a different place, then you can choose another option in the radio button.

  1. Identify the Data You Wish to Return

The last step on how to run a regression in Excel is by identifying the data that you intend to return. To do this, you have to choose from the Residuals check box. It will help you to identify the results of residuals that you want to return as the part of regression analysis results. Then, click OK.

How to Print Envelopes from Excel – Best Tips to Know

Microsoft Excel is a handy tool and it can be used to help you do various things in more practical ways. You can also find it very easy to complete the steps on how to make a line graph in Excel. Either it is creating standard deviation, adding error bars, or making envelopes, this tool can do all for you. If your job requires you to do a lot of conventional mailing, you might need to create custom envelopes that meet your company’s need and Excel will help you to complete your tasks. Here are some useful tips on how to print envelopes from Excel.

Printing Envelopes from Excel

Printing envelopes from Excel will need you to complete several steps. Take a look at the following tips on how to print envelopes from Excel.

  1. Make a Table

The very first step on how to print envelopes from Excel is creating a table which can be taken from the list of address. You can select a cell from a range which contains the addresses like cell B2. Then, you need to go on the Insert tab and then click it on. Make sure that the items contained in the range of cells are correct before you click OK. Each column of the cells will offer you options for filtering and selecting to allow you to design your envelope.

  1. Determine the Name of the Table

Once you have finished with the first step, then you will need to identify the name for your table. The name will automatically update when the table is edited once it is successfully defined. First, you need to press “Define Name” command which can be found on the Formula tab. Then, you have to type the name Addresses as well as their range of cells in the New Name dialogue. After that, you can click on Ok and start naming the table.

  1. Verifying Addresses

The next thing you should do is verifying addresses by adding a new column to the Table. All you need to do is going to cell H2 and type 2008. The name and the table will automatically expand soon after that.

  1. Sorting List

You can do it by clicking the dropdown in the 2008 column and click on sort A to Z command. What you need to sort include separating tables, start the mail merge, and add the Address block as well as preview envelopes.

  1. Print the Envelopes

Last but not least is printing the envelopes. Make sure that you have copied the entire table, clear the cells’ contents, and leave the table headers. Then, just copy the addresses sheet just under the headers in the “ReadytoPrint” sheet. Then click print and your envelopes are ready.

How to Calculate Standard Error in Excel – A Beginner’s Guide

One of the most critical elements in the statistic parameter is the standard error. Being popular with another name, standard deviation, this statistic parameter can be very difficult for some people. However, this tool is actually very handy once you know how to use it. So, how to calculate standard error in Excel easily? And how to make a line graph in Excel?

Varieties of Standard Error

Before learning on how to calculate standard error in Excel, it will be better to know the main varieties used in the standard error. Generally, there are two main varieties often applied in the standard deviation, they are a standard error for a sample and standard for a population. The two main varieties are included in the Excel.

  1. Standard Error for A Sample

The standard deviation for a sample will make it possible for you to calculate for your chart. It has a specific function to represent the standard deviation taken from the mean that will be used for a selected sample of data. This tool will allow you to calculate and determine how much a specific data subset deviates from the main value. For example, when you create a chart that shows the salaries of all workers in a company, then you will only want the data on the wages in the IT sector. In this way, you will see the standard error for a sample.

  1. Standard Deviation

This standard error functions to help you calculate a population that indicates the average deviation for all data shown in the table. In this standard error, the STDEV.P function will be used to calculate the deviation of all workers.

How to Calculate Standard Deviation in Excel?

If you are wondering about how to calculate standard error in Excel, there are some common methods that you can use. But, this following method is considered to be the simplest one and it can be used to calculate both standard deviations for a population and a sample.

  1. Open on an Excel table.

  2. Tap on the cell where you want to display the standard deviation value.

  3. Type “=STDEV.S (C4: C7)” or “STDEV.P (C2: C11)”. The values shown in the brackets function to denote the cell range where you want to calculate the value of the standard error.

  4. Click “Enter”.

  5. Press on the “Home” tab if you intend to round the result of the calculation to two decimals.

  6. Press the arrow located next to “General” to allow you to open the dropdown menu.

  7. Select the “Number” option.

How to Add Bars in Excel – Simple Tips to Follow

If you have to work a lot with Excel to create graphics for a presentation, you might have known that error bars are needed sometimes. However, creating bars can be very difficult for some people. Here are simple tips to help you on how to add error bars in Excel.

Error Bars – What Are They?

Error bars in Excel are actually data variability in the form of graphical representations. The bars are used to allow you to show the measurement precision. Most of the time, they represent both the standard error and standard deviation. The error bars also often indicate how far the true value from the determined value. In addition, they also provide data set with a more comprehensive view. In this way, you will be able to see both the errors and margins shown in the data.

How to Add the Error Bars?

How to make a line graph in Excel? With Microsoft Excel, you will be able to add error bars to various chart types such as scatter charts, bar charts, and line charts. So, how to add error bars in Excel? Well, there are some steps that you have to complete to put error bars in your Excel.

  1. The first thing you should do is click on your chart.

  2. After that, you need to click the Chart Elements.

  3. Once finished with the Chart Elements (plus sign), you can check the box Error Bars. You need to click the arrow located next to the bars after that. It will show you a list of items that you can select and add to the chart you make.

Meanwhile, if you want to know how to add error bars in Excel and modify the default, you can do these following steps.

  1. You can click More Options shown in the Error Bars.

  2. Then you will see the Format Error Bars menu show up to allow you to modify the error bar’s styles.

What You Can Add to Your Chart

There are some error bars that you can add to the chart you create, here they are:

  • Standard Deviation

This is an error bar which is used to help you display a standard display that can be applied for all values.

  • Percentage

This is the most common type of error bar that you can add in your Excel. The bar is used to help you determine the error range of a percentage as well as the error amount found in each value.

  • Standard Error

The standard error is commonly used to allow the users to indicate the standard error for each value shown in the dataset.