Data Analysis

A collection of 63 posts

How To Use t-Test In Excel

This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal. Below you can find the
28 October 2020

How To Use Slicers In Excel

You can insert slicers in Excel to quickly and easily filter pivot tables. However, using the report filter gives the exact same result. Below you can find a two-dimensional pivot table. Go back
27 October 2020

How to Use Sensitivity Analysis In Excel

Sensitivity analysis gives you insight in how the optimal solution changes when you change the coefficients of the model. After the solver found a solution, you can create a sensitivity report. 1. Before
27 October 2020

How To Use Randomize List In Excel

This article teaches you how to randomize (shuffle) a list in Excel. For example, we want to randomize the list in column A below. 1. Select cell B1 and insert the RAND() function.
27 October 2020

How To Make Pie Chart In Excel

Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series. To create a pie chart of the 2017 data series,
27 October 2020

How to Delete Duplicates in Excel

This example teaches you how to remove duplicates in Excel. Go here to only find duplicates. 1. Click any single cell inside the data set. 2. On the Data tab, in the Data
27 October 2020

How to Create Thermometer Chart In Excel

This example teaches you how to create a thermometer chart in Excel. A thermometer chart shows you how much of a goal has been achieved. To create a thermometer chart, execute the following
27 October 2020

How To Create a Pivot Chart In Excel

A pivot chart is the visual representation of a pivot table in Excel. Pivot charts and pivot tables are connected with each other. Below you can find a two-dimensional pivot table. Go back
27 October 2020

How To Create a Pareto Chart In Excel

This example teaches you how to create a Pareto Chart in Excel. The Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes. In this
27 October 2020

How To Add Trendline In Excel

This example teaches you how to add a trendline to a chart in Excel. 1. Select the chart. 2. Click the + button on the right side of the chart, click the arrow next
27 October 2020

How To Use F-Test In Excel

This example teaches you how to perform an F-Test in Excel. The F-Test is used to test the null hypothesis that the variances of two populations are equal. Below you can find the
25 October 2020

How To Use Error Bars In Excel

This example teaches you how to add error bars to a chart in Excel. 1. Select the chart. 2. Click the + button on the right side of the chart, click the arrow next
25 October 2020

How To Use Date Filters In Excel

This example teaches you how to apply a date filter to only display records that meet certain criteria. 1. Click any single cell inside a data set. 2. On the Data tab, in
25 October 2020

How To Use Data Tables In Excel

Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas. You can create a one variable data table or a two variable data table.
25 October 2020

How To Create Gantt Chart In Excel

Excel does not offer Gantt as chart type, but it’s easy to create a Gantt chart by customizing the stacked bar chart type. Below you can find our Gantt chart data.
25 October 2020

How To Create A Line Chart In Excel

Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis. Use a scatter chart (XY
25 October 2020

How To Use Moving Average In Excel

This example teaches you how to calculate the moving average of a time series in Excel. A moving average is used to smooth out irregularities (peaks and valleys) to easily recognize trends. 1.
25 October 2020

How to Use One-Way Anova In Excel

This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor or one-way ANOVA is used to test the null hypothesis that the means of
24 October 2020

How To Use Data Series In Excel

A row or column of numbers that are plotted in a chart is called a data series. You can plot one or more data series in a chart. To create a column chart,
24 October 2020

How To Use Correlation In Excel

The correlation coefficient (a value between -1 and +1) tells you how strongly two variables are related to each other. We can use the CORREL function or the Analysis Toolpak add-in in Excel
24 October 2020