Averaging The 5 Lowest Values In Your Data!
Let’s assume you are a math’s teacher interested in finding the average of the math’s score of last five students – he is interested in finding why they are performing poor. How will he proceed?
Developing And X And R Chart For Quality Control
We do create different type of charts to fulfill our charting needs – quite a few of them are related to quality control purposes.
Using Moving Averages For Forecasting
Sales people often need to estimate the sales of upcoming months. They do it with a handful of techniques that uses both quantitative analysis as well as qualitative judgment.
How To Calculate Average Absolute Difference For You Data With Negative Value!
A recent question on a website requested for calculating the average of absolute differences for a year-over-data.
How To Calculate Weighted Average In Excel
The average value of number of cells or a data range in Excel can easily be calculated using AVERAGE() formula.
Finding minimum, maximum and average number in a list and counting the number of cells.
Using the MIN(), MAX(), COUNT() and AVERAGE() functions on a list
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
