Data Science Tutorial

Data Science Data Science is the most challenging field of the 21st generation. Every type of IT industry is looking for candidates with knowledge of data science. We are providing the basic and some advanced concepts related to the operation …

Read moreData Science Tutorial

Excel MIN() Function

Excel MIN() Function The MIN() function in excel returns the smallest or minimum value from the provided numbers, named range or array. It ignores logical values and text. Syntax MIN(Number1,Number2, …) Parameter Number1(required)– This parameter represents the string for which …

Read moreExcel MIN() Function

Excel COUNTBLANK() Function

Excel COUNTBLANK() Function The COUNTBLANK() function in excel counts the number of blank cells within a range. Syntax

Parameter value1(required)– This parameter represents the first cell in the range. value2, …(optional)– It represents the second, third, and so on …

Read moreExcel COUNTBLANK() Function

Excel COUNTA() Function

Excel COUNTA() Function The COUNTA() function counts the number of cells in a range that are not empty. Syntax

Parameter value1(required)– This parameter represents the first cell in the range. value2, …(optional)– It represents the second, third and so …

Read moreExcel COUNTA() Function

Excel COUNT() Function

Excel COUNT() Function The COUNT() function counts the number of cells in a range that contain numbers. Syntax

Parameter value1(required)– This parameter represents the first cell in the range. value2, …(optional)– It represents the second, third, and so on …

Read moreExcel COUNT() Function

Excel AVERAGE() Function

Excel AVERAGE() Function The AVERAGE() function returns the average of its arguments, which can be number or names, arrays, or references that contain numbers. It ignores text values and blank cells. Syntax

Parameter Number1(required)– This parameter represents the string …

Read moreExcel AVERAGE() Function

Excel ROUNDUP() Function

Excel ROUNDUP() Function The ROUNDUP() function in excel returns a number rounded up to the nearest possible value and away from zero. Syntax

Parameter Number(required)– This parameter represents the number which you want to round up. num_digits(required)– This parameter …

Read moreExcel ROUNDUP() Function

Excel ROUND() Function

Excel ROUND() Function The ROUND() function in excel rounds the numbers to specified digits. Syntax

Parameter Number(required)– This parameter represents the number which you want to round up. num_digits(required)– This parameter represents the number of decimal places to which …

Read moreExcel ROUND() Function

Excel MOD() Function

Excel MOD() Function The MOD() function in excel returns the remainder after a number is divided by a divisor Syntax

Parameter Number(required)– This parameter represents the number which you want to divide. Divisor(required)– This parameter represents the number to …

Read moreExcel MOD() Function

Excel INT() Function

Excel INT() Function The INT() function in excel is used to round a number down to the nearest integer. It removes decimal points from any number value & return rounded down number value in the cell. Syntax

Parameter Number(required)– …

Read moreExcel INT() Function

Excel MAX() Function

Excel MAX() Function The MAX() function in excel returns the largest or maximum number from a range of cells. It ignores logical values and text. Syntax

Parameter Number1(required)– This parameter represents the string for which you want to find …

Read moreExcel MAX() Function

Hierarchical Clustering Algorithm

Introduction to Hierarchical Clustering The other unsupervised learning-based algorithm used to assemble unlabeled samples based on some similarity is the Hierarchical Clustering. There are two types of hierarchical clustering algorithm: 1. Agglomerative Hierarchical Clustering Algorithm It is a bottom-up approach. …

Read moreHierarchical Clustering Algorithm

Excel Function and Formulas

Excel Today() Function The today() function returns the serial number of today’s date as per system number of today’s date as per system’s regional settings. Syntax

Parameter NA Category Date & Time Returns This function returns today’s date in …

Read moreExcel Function and Formulas

Formats in Excel

What are the formats? Formats are different options that one uses to change the appearance of data (maybe text, number, etc..) in an excel file. They do not change the value of the cell but change the way it appears. …

Read moreFormats in Excel

Notes in Excel

Notes in Excel Notes are used to include additional information to the cell and explain formulas calculation, any modification made to the cell, providing necessary information on data that is entered or to provide any guidance on data that a …

Read moreNotes in Excel

Formatting in Excel

Formatting in Excel Formatting in Excel is used to alter and change the appearance of your data in a standardized form. It also helps you to give a professional look to your reports, worksheets, and workbooks. There are many numbers …

Read moreFormatting in Excel