Free Tableau Desktop for Students
Tableau Desktop for Students Tableau Desktop is a Powerful tool for Data Analytics. Tableau has launched a free version for students around the world. The free license is for one-year, and it is renewable. Data skills are for everyone. As a student, you now have access to their entire e-Learning suite – for free. Go […]
Excel SORT Function ( 5 Examples)
Excel SORT Function The Excel SORT function returns the contents of a range or an array in ascending or descending order. The returned array is the same shape as the provided array argument. In this section: Advertisements Syntax of Excel SORT Function How to use Custom SORT in Excel? SORT by values. SORT by location. […]
Excel FILTER Function (5 Examples)
Excel FILTER Function The Excel FILTER function allows users to filter a range of data based on criteria users define and returns matching values. In this section: Advertisements Syntax of FILTER Function FILTER the Sales revenue of certain location. How to make the FILTER Dynamic. #CALC! error and how to manage it. FILTER values greater […]
Excel AVERAGE Function (10 Examples)
Excel AVERAGE Function The Excel AVERAGE Function returns the average (arithmetic mean) of the given numbers in a range or an array. For calculating average with conditions, users use AVERAGEIF or AVERAGEIFS function. The AVERAGE Function can handle up to 255 arguments, including number, reference to cells, ranges, arrays, and constants. In this section: Advertisements […]
Multiple Regression in Excel ( 3 Examples)
Multiple Regression in Excel Multiple Regression in Excel is used to predict a variable (Y) based on another variable (X) or variables (X’s). In statistics, regression analysis is used to estimate the relationships between a dependent variable and one or more independent variables. Linear regression analysis is the most common form of regression, in which […]
Multiple Correlation in Excel (2 Examples)
Multiple Correlation in Excel In this section, we will learn Multiple Correlation Excel. Multiple correlation is used to predict a given variable based on a linear function of a set of other variables. When we have two variables (X, Y), one (X) predicts the other (Y), we call the association as simple correlation. When we […]
How to Use Correlation in Excel (5 Examples)
Correlation in Excel Excel users use Correlation in Excel to find relation between variables. The Excel CORREL function returns the correlation coefficient of two cell ranges. To determine the relationship between two variables or properties, Excel users use CORREL function. Users can examine the relationship between temperature and the number of fans sold. In this section: Advertisements […]
Benford’s Law in Excel ( 1 Solved Example)
Benford’s Law in Excel Benford’s Law in Excel is used frequently. Benford’s Law, also known as the first-digit law, is an observation that the leading digit in many real life numerical data set is more likely to be smaller. In the number set, which conforms with this law, the number 1 appears as the leading […]
Excel COUNTIF Function (10 Examples)
Excel COUNTIF Function The Excel COUNTIF function is used to count the number of cells that meet a certain criterion. The Excel COUNTIF function supports a single condition. Users may, for example, count the number of times a particular city appears in a customer list. In this section: Advertisements Syntax of the Function COUNTIF. Important […]
Excel DOLLAR Function (5 Examples)
Excel DOLLAR Function The Excel DOLLAR function is on the of the TEXT functions. It converts a number to text using currency format, with the decimals rounded to the number of places users specify. DOLLAR uses the $#,##0.00_);($#,##0.00) number format, although the currency symbol that is applied depends on users’ local language settings. List of Examples: Advertisements Convert a number […]