NSE Nifty Derivatives OI analysis using Python and Excel
NSE Nifty Derivatives OI analysis using Python and Excel
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
How to Refresh or Update a Pivot Table In Excel
Any changes you make to the data set are not automatically picked up by the pivot table. Refresh the pivot table or change the data source to update the pivot table with the
How To Use Transportation Problem In Excel
Use the solver in Excel to find the number of units to ship from each factory to each customer that minimizes the total cost. Formulate the Model The model we are going to
How To Use Subtotal function in Excel
Use the SUBTOTAL function in Excel instead of SUM, COUNT, MAX, etc. to ignore rows hidden by a filter or to ignore manually hidden rows. Rows Hidden by a Filter 1. For example,
How To Use Structured References In Excel
When working with tables in Excel, you can use structured references to make your formulas easier to understand. For example, we have the following table. 1. Select cell E1, type Bonus, and press
How To Use Sort data in a range by Color In Excel
Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or
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
How To Use Shortest Path Problem In Excel
Use the solver in Excel to find the shortest path from node S to node T in an undirected network. Points in a network are called nodes (S, A, B, C, D, E
How to Use Shade Every Other Row in Excel
This example shows you how to use conditional formatting to shade alternate rows. Shading every other row in a range makes it easier to read your data. 1. Select a range. 2. On
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
How To Use Reverse List In Excel
This article teaches you how to reverse a list in Excel. For example, we want to reverse the list in column A below. 1. Enter the value 1 into cell B1 and the
How To Use Regression Analysis in Excel
This example teaches you how to run a linear regression analysis in Excel and how to interpret the Summary Output. Below you can find our data. The big question is: is there a
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.
How to Use Quadratic Equation In Excel
A quadratic equation is of the form ax2 + bx + c = 0 where a ≠ 0. A quadratic equation can be solved by using the quadratic formula. You can also use Excel’s Goal
How To Use Number and Text Filters In Excel
This example teaches you how to apply a number filter and a text filter to only display records that meet certain criteria. 1. Click any single cell inside a data set. 2. On
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,
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
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
How to Create Scatter Chart In Excel
Use a scatter chart (XY chart) to show scientific XY data. Scatter charts are often used to find out if there’s a relationship between variable X and Y. Straight Lines To
How to Create Outlining Data In Excel
Outlining data makes your data easier to view. In this example we will total rows of related data and collapse a group of columns. 1. First, sort the data on the Company column.
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
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
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
How To Use Group Pivot Table Items In Excel
This example teaches you how to group pivot table items. Learn how to group products and how to group dates by quarters. Below you can find a pivot table. Go back to Pivot
How To Use GetPivotData Function In Excel
To quickly enter a GETPIVOTDATA function in Excel, type an equal sign (=) and click a cell in a pivot table. The GETPIVOTDATA function can be quite useful. 1. First, select cell B14 below
How To Use Find Duplicates In Excel
This example teaches you how to find and highlight duplicates (or triplicates) in Excel. Go here to remove duplicates. 1. Select the range A1:C10. 2. On the Home tab, in the Styles
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
How To Use Exponential Smoothing In Excel
This example teaches you how to apply exponential smoothing to a time series in Excel. Exponential smoothing is used to smooth out irregularities (peaks and valleys) to easily recognize trends. 1. First, let&
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
How To Use Descriptive Statistics In Excel
You can use the Analysis Toolpak add-in to generate descriptive statistics. For example, you may have the scores of 14 participants for a test. To generate descriptive statistics for these scores, execute the
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
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.
How To Use Conditional Formatting for Icon Sets In Excel
Icon Sets in Excel make it very easy to visualize values in a range of cells. Each icon represents a range of values. To add an icon set, execute the following steps. Select
How To Use Calculated Field/Item In Excel
This example teaches you how to insert a calculated field or calculated item in a pivot table. Below you can find a pivot table. Go back to Pivot Tables to learn how to
How To Create Multi-level Pivot Table In Excel
It’s perfectly ok to drag more than one field to an area in a pivot table. We will look at an example of multiple row fields, multiple value fields and multiple
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.
How To Create Frequency Distribution In Excel
Did you know that you can use pivot tables to easily create a frequency distribution in Excel? You can also use the Analysis Toolpak to create a histogram. Remember, our data set consists
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
How To Create A Histogram In Excel
This example teaches you how to create a histogram in Excel. 1. First, enter the bin numbers (upper levels) in the range C4:C8. 2. On the Data tab, in the Analysis group,
How To Create a Geographic Heat Map In Excel
To create a heat map in Excel, simply use conditional formatting. A heat map is a graphical representation of data where individual values are represented as colors. To create a heat map, execute
How To Create A Gauge Chart(Speedometer Chart) In Excel
A gauge chart (or speedometer chart) combines a Doughnut chart and a Pie chart in a single chart. If you are in a hurry, simply download the Excel file. This is what the
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.
How To Use Maximum Flow Problem In Excel
Use the solver in Excel to find the maximum flow from node S to node T in a directed network. Points in a network are called nodes (S, A, B, C, D, E
How To Use Manage Rules In Excel
To view all conditional formatting rules in a workbook, use the Conditional Formatting Rules Manager. You can also use this screen to create, edit and delete rules. 1. Select cell A1. 2. On
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
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,
How To Use Data Bars In Excel
Data bars in Excel make it very easy to visualize values in a range of cells. A longer bar represents a higher value. To add data bars, execute the following steps. 1. Select
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
How To Use Conflicting Rules In Excel
Sometimes multiple conditional formatting rules in Excel conflict. A higher rule always wins. This example illustrates two different results. 1. The value 95 is higher than 80 but is also the highest value