Free Crypto DeFi Staking Yield/Rewards Calculator App

14:44:00 0
We have designed a free, simple calculator app to help you calculate your crypto staking total and daily rewards. It is always advisable to first estimate the total rewards from any staking opportunity before committing your coins/tokens.
defi staking rewards calculator

What is DeFi Staking?

Staking is one of the ways to earn passive income from some of your cryptocurrencies. This earning opportunity was created by DeFi (Decentralized Finance). When you stake your coin/token on any staking platform, the coin/token is locked in a smart contract for a specific period of time. Then as an incentive, you will be earning a daily reward, which accumulates until the lock-up/staking period is over. Some other ways to earn passive income from DeFi include: Yield farming, lending, providing liquidity, etc.

How the DeFi Staking Yield/Rewards Calculator App Works

This is a simple spreadsheet calculator app for calculating the total rewards for staking a certain amount of a coin/token for a particular staking/lock-up period in any DeFi staking platform. It also calculates your daily rewards for staking the coin/token. The purpose of creating this app is to help you estimate your expected staking rewards, so that you can weigh it and make appropriate decision.

You will be required to input the following:
  • The name of the coin/token you wish to stake. For example, if you are staking Ether, simply input ETH.
  • Principal amount of the coin/token you wish to stake. For example, if you wish to stake 5 ETH, simply input 5.
  • The Annual Percentage Yield (APY) offered by the staking platform. Assuming the staking platform is offering APY of 250% for ETH, simply input 250.
  • Staking/lock-up period in days. For example, if the lock-up period is 30 days, simply input 30.
Then the staking reward calculator will calculate the following:
  • Your daily reward for the staked coin/token amount.
  • The number of the coin/token you will earn at the end of the lock-up/staking period.
To do another calculation, press the Reset button.


Check:
NOTE: 
Once you download the spreadsheet template, upload it back to your own google drive. This is to ensure that any record you add to the spreadsheet will be saved automatically and you can access the spreadsheet template easily.

Check out the screenshot below to understand how the app works.
DeFi staking rewards calculator app

How to Calculate your Staking Rewards Manually 

Formula for calculating your total staking rewards/yield
= (Principal amount of the coin staked x APY x Staking period)/(365 x 100)

Formula for daily staking rewards
= Total staking rewards/Staking period in days

NOTE: To learn more about cryptocurrency trading, check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: Complete Guide on How to Buy & Sell Bitcoin & Altcoins for Profit, DeFi Yield Farming with Cryptocurrency Investments & Security Tips. The book also explained how to calculate profits for other crypto trading pairs like ETH, NEO, BNB, KCS, USDT, etc.

How to Manage your Crypto Portfolio with CoinGecko App

05:42:00 0

Imagine having bought hundreds of crypto coins in different exchange apps. Sometimes, logging into each of these exchanges to check the performance of these cryptocurrencies you bought might be very stressful. But there are some special crypto portfolio trackers that can help you monitor the performance of all your crypto trades easily. CoinGecko app has a powerful crypto portfolio tracker you can use for free. You will learn how to use CoinGecko app to easily track your crypto portfolio from your smartphone or PC and how to set price alert for any coin.

how to manage your crypto portfolio in coingecko app

CoinGecko is one best free crypto research tools you can use to perform fundamental analysis before buying any cryptocurrencies. You can also learn about DeFi, yield farms, markets, Crypto news, Coin price updates, Crypto price to fiat currencies calculator, etc.

How to Use CoinGecko App Crypto Portfolio Tracker to Manage your Trades

First, you need to download the latest CoinGecko app from Google play store on your phone. You can get it at https://gcko.io/coingecko-android. Install the app and launch it on your phone.

Next, click the More tab and then click on Sign Up / Sign In. Login by clicking on Sign In if you already have an account with CoinGecko or you click on Create Account to create new account. 

how to manage your crypto portfolio in coingecko app

After creating a new account, you will be required to login to the email account you used for the registration, click a verification link to verify your CoinGecko account. After that, your CoinGecko account is ready for use!

Now click on Portfolio tab to start building your favourite coin list. 

Watchlist vs. Portfolio

how to manage your crypto portfolio in coingecko app

When you click on the Portfolio tab in your CoinGecko app, you will see two sub-tabs: Watchlist and Portfolio. The 2 tabs contain all the coins you mark as favourite. As the name implies, the Watchlist sub-tab is where you see the current price of the coin, 24H performance and the current market cap. But you cannot add a transaction under the Watchlist sub-tab.

But it is under the Portfolio sub-tab that you can add or record the transactions (buy, sell and transfer) you have carried out for any coin under your portfolio. In other words, the balance you see at the top of the Portfolio sub-tab is your real crypto portfolio if you add all the transaction you carried out in all the coins under your portfolio.

In summary, the Watchlist sub-tab of CoinGecko app is just like the front-end of a webpage while the Portfolio sub-tab is the back-end where you have many setup options.

See:

How to Add a Coin to your Portfolio

There are ways to add coins to your CoinGecko app portfolio:

Method 1: Search the Coin from the Market Tab

This method becomes handy if you just came across a new coin that interest you and wish to watch the coin's performance for some time before investing in it. With this method, you add the coin to the CoinGecko app watchlist.

To Add a Coin to your Watchlist: Under the Market tab, type the coin name in the search bar.

CoinGecko will load the details of the coins. You will see 4 basic tabs: 
  • Price Chart: This is where you see details like: contract address, market cap, trading volume, available and total supply, etc.
  • Exchanges: Here you will see all the exchanges where the coin can be purchased, with their available trading pairs and trading volume.
  • Portfolio: Clicking the Add to Portfolio link under this tab adds the coin to your portfolio list so that you can start tracking its performance. 
  • Info: Here, you will find the link to the official website of the coin project, blockchain/supply link, social media links, etc.
NOTE: You can add the coin to your portfolio by clicking the + sign at the right top corner of the page.
how to manage your crypto portfolio in coingecko app

Then click on Add Coin to Portfolio.
how to manage your crypto portfolio in coingecko app

Method 2: Search the Coin from the Portfolio Tab

To add a coin to your portfolio using this method: From the Portfolio tab, click the + symbol at the top right corner of the page and then type the coin name in the search box that appears.

how to manage your crypto portfolio in coingecko app

Once the coin appears in the search result, click on it. 

how to manage your crypto portfolio in coingecko app

Congrats! You have successfully added a coin to your CoinGecko app favourite list. Do this for all the coins you wish to track their performance.

Check:

How to Add the Transaction Details for your Portfolio in CoinGecko App

After adding coins to your portfolio, next is to add the transactions details (buy, sell and transfer) for each of the coins in your portfolio so that the tracker will help you calculate the percentage Profit and Loss (PnL) and the balance. With this, you will know the coins that are performing well and by what percentage.

Under the Portfolio sub-tab, click on Add at the right hand side of each coin in your portfolio.
how to manage your crypto portfolio in coingecko app


There are 3 types of transactions you can setup for each coin in your portfolio:

  • Buy: For adding completed buy transactions.
  • Sell: For adding completed sell transactions.
  • Transfer: For recording transfer (in and out) transactions. For example, if you bought a certain amount of a coin in a particular exchange platform and wish to move a percentage to another exchange.
Choose the correct tab that suits the transaction you carried out for the coin in any exchange app. For example, if you initially bought 20 ETH and then sold 15 ETH, you need to add both the buy details for the 20 ETH (indicate the unit cost price in USD, the quantity and the date) and then the sell details for the 15 ETH (include the unit selling price in USD, the quantity and the date) under the Portfolio sub-tab, so that CoinGecko app can properly track your portfolio balance (5 ETH).
how to manage your crypto portfolio in coingecko app

Click the Fees & Notes link to add the description for the transaction (under the Notes field) and the transfer fee (under the Fees field).

how to manage your crypto portfolio in coingecko app

Once you are done, click on Submit. Confirm the submission by clicking on Save.

how to manage your crypto portfolio in coingecko app

NOTE: You only add transaction details for the coins you have actually bought or sold in any exchange. If you added the coin(s) to your portfolio just to study its movement pattern then don't add any transaction detail for the coin(s).

How to SetUp CoinGecko App Price Alert Feature

Search for the coin you wish to add price notification for and then tap on it to see its details on CoinGecko. Tap the + sign at the top right hand side of the page as shown in the screenshot below.

how to manage your crypto portfolio in coingecko app

Select the Add Price Alert option. This prompts the Add Price Alert page.

how to manage your crypto portfolio in coingecko app

Now specify the price at which you want CoinGecko app to alert you. You can specify in percentage or you type the exact alert price. 

Specify the how often you wish to be alerted (once or recurring?). The tap on Save as shown in the screenshot below.

how to manage your crypto portfolio in coingecko app
CoinGecko will alert you through your phone notification once the coin(s) reaches that specified price.

Do you wish to learn more about cryptocurrency trading? Check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: Complete Guide on How to Buy & Sell Bitcoin & Altcoins for Profit, DeFi Yield Farming with Cryptocurrency Investments & Security Tips. The book also explained how to discover cryptocurrencies with powerful potentials, how to calculate profits for other crypto trading pairs like BTC, ETH, NEO, BNB, KCS, USDT, etc.

See:

Conclusion

You have learnt how to use CoinGecko app to track your crypto trading portfolio. There are other popular crypto portfolio tracking apps like Blockfolio, Delta, CoinTracking, Coin Market Manager, Kubera, CryptoCompare, Altrady CoinStats, etc. Each of these apps has its pros and cons. Weigh them and choose the one that suits you most. I love CoinGecko app portfolio tracker because it is very simple and easy to use. Blockfolio is another crypto portfolio management app I love.

Comment your questions and suggestions below. Click a share button to share this tutorial article with your social media friends. Enjoy!

Free Excel App for Converting USD or USDT to ETH - Crypto Calculator

11:02:00 0

This is a simple excel cryptocurrency converter app or calculator you can use to convert funds from USD or USDT to ETH. The calculator also shows you the current equivalence of 1 ETH in USD (the BTC price is gotten from CoinGecko). This means that your device must be connected to the internet so that you will see the current Ethereum value when you open the app.

usd to eth converter app

Remember: 
1,000,000,000 Gwei = 1 ETH
1 Gwei = 1/(1,000,000,000) ETH = 10^(-9) ETH = 0.0000000001 ETH

How to Use the USD or USDT to ETH Calculator App (Spreadsheet Template)

All you need to do is to enter the amount (in USD) you wish to convert to ETH. The app will convert the amount you entered and show you the equivalence in BTC. Optionally, if you wish to transfer the fund from one exchange to another after converting from USD to ETH, this app can help you calculate the total Gwei value to enter when withdrawing the fund from any exchange, including the transfer charge. All you need to do is to type the ETH transfer fee of the exchange app (usually between 0.005 ETH to 0.007 ETH). Once you enter the value, the app will add it to the initial converted USD amount you entered. With this, all you need to do is to copy the total value and enter it when withdrawing the fund from any exchange platform.

To do another calculation, press the Reset button.


Check:
NOTE: 
Once you download the spreadsheet template, upload it back to your own google drive. This is to ensure that any record you add to the spreadsheet will be saved automatically and you can access the spreadsheet template easily.

Check out the screenshot below to understand how the app works.
usd to eth converter app

NOTE: To learn more about cryptocurrency trading, check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: Complete Guide on How to Buy & Sell Bitcoin & Altcoins for Profit, DeFi Yield Farming with Cryptocurrency Investments & Security Tips. The book also explained how to calculate profits for other crypto trading pairs like BTC, NEO, BNB, KCS, USDT, etc.

See:

Free Excel App for Converting USD or USDT to BTC - Crypto Calculator

11:02:00 0

This is a simple excel cryptocurrency converter app or calculator you can use to convert funds from USD or USDT to BTC. The calculator also shows you the current equivalence of 1 BTC in USD (the BTC price is gotten from CoinGecko). This means that your device must be connected to the internet so that you will see the current Bitcoin value when you open the app.

app for converting usdt to btc - crypto calculator

How to Use the USD or USDT to BTC Calculator App (Spreadsheet Template)

All you need to do is to enter the amount (in USD) you wish to convert to BTC. The app will convert the amount you entered and show you the equivalence in BTC. Optionally, if you wish to transfer the fund from one exchange to another after converting from USD to BTC, this app can help you calculate the total satoshi value to enter when withdrawing the fund from any exchange, including the transfer charge. All you need to do is to type the BTC transfer fee of the exchange app (usually between 0.0005 BTC to 0.0007 BTC). Once you enter the value, the app will add it to the initial converted USD amount you entered. With this, all you need to do is to copy the total value and enter it when withdrawing the fund from any exchange platform.

To do another calculation, press the Reset button.


Check:
NOTE: 
Once you download the spreadsheet template, upload it back to your own google drive. This is to ensure that any record you add to the spreadsheet will be saved automatically and you can access the spreadsheet template easily.

Check out the screenshot below to understand how the app works.
app for converting usdt to btc - crypto calculator
NOTE: To learn more about cryptocurrency trading, check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: Complete Guide on How to Buy & Sell Bitcoin & Altcoins for Profit, DeFi Yield Farming with Cryptocurrency Investments & Security Tips. The book also explained how to calculate profits for other crypto trading pairs like ETH, NEO, BNB, KCS, USDT, etc.

Remember:
1 Satoshi = 0.00000001 BTC = 10^(-8) BTC

See:

Free Ethereum Trading Pair Profit/Loss Excel Calculator App

11:01:00 1
This is a simple calculator to help you know the number of units of a coin you bought that you should sell at a particular price level in order to pull out your investment capital plus a little extra percentage profit. It will also help you calculate the unit price of the coin after a certain percentage loss, so as to help you know the unit price value to use as your stop-loss.
ethereum trading pair profit loss calculator app
The calculator assumes you didn't buy at more than three (3) price levels. If you bought at more than three price levels, then you need to calculate the average unit price and the total number of units of the coin bought before using this calculator. 

This calculator also works only for ETH trade pairs. For example, NULS/ETH, OMG/ETH, ADA/ETH, ZEC/ETH, etc.

NOTE: 
1,000,000,000 Gwei = 1 ETH
1 Gwei = 1/(1,000,000,000) ETH = 10^(-9) ETH = 0.0000000001 ETH

How to Use the Ethereum Trading Pair Profit/Loss Excel Calculator Spreadsheet Template

Here is a simple challenge you can solve with this calculator: 

Assuming you first bought 100 units of a coin, say Cardano (ADA) at 0.000150000 ETH (150,000 Gwei). Then the price came down further to 0.000120000 ETH (120,000 Gwei), you bought another 100 units. Also the price tanked further to 0.000100000 ETH (100,000 Gwei), you bought another 100 units, how do you know the number of units of this coin to sell in order to extract your investment capital plus 10% profit after the price of the coin has doubled? Also, what will be the unit price of the coin at 5% loss?

The parameters you need to enter are: 
  • Coin name (eg. ADA)
  • Unit price of the coin and the Number of units of the coin bought at each buy level (first buy, second buy and third buy, as the case may be) 
  • Capital pull out percentage (eg. 100%) 
  • Extra percentage profit to pull out alongside your investment capital (eg. 10%) 
  • Maximum percentage loss tolerance (eg. 5%). 
The calculator will calculate the number of units to sell in order to recover your capital plus the specified extra capital. It will also show you the number of units that will remain after you have pulled out your capital plus some profits. The calculator will also show you the selling price (in ETH) to sell the coin in order to meet your target. 

Also, it will also calculate the unit price of the coin at a particular percentage loss. This is to help you know the value to use when setting stop loss in your exchange app. If you are a long term Ethereum pair trader, you will appreciate this calculator. 

The excel workbook has two sheets: Crypto trading calculator and Crypto trading records.

The Crypto trading calculator sheet contains the profit/loss calculator. While the Crypto trading records sheet is where you can record the important details of each of your trade. Make sure you save the spreadsheet after entering a new record in that sheet before closing the excel app. If you wish to use the calculator to calculate the percentage profit/loss of another coin, simply click the Reset button and then enter the required parameters.

NOTE: 
Ignore any error display in some cells while entering the parameters. Once you provide all the required parameters, the errors will disappear.


Check:
NOTE: 
Once you download the spreadsheet template, upload it back to your own google drive. This is to ensure that any record you add to the spreadsheet will be saved automatically and you can access the spreadsheet template easily.

Check out the screenshot below to understand how the app works.
ethereum trading pair profit loss calculator app
NOTE: To learn more about cryptocurrency trading, check out this book on Amazon - How to Make Money from Crypto Trading & Investing for Beginners: Complete Guide on How to Buy & Sell Bitcoin & Altcoins for Profit, DeFi Yield Farming with Cryptocurrency Investments & Security Tips. The book also explained how to calculate profits for other crypto trading pairs like BTC, NEO, BNB, KCS, USDT, etc.

How to Password Protect & Decrypt Word Documents Offline & Online

12:06:00 0
In order to prevent unauthorized access to your personal or office documents, you need to protect it with a password. For some other reasons, you might also want to remove password from a previously protected MS word files. You will learn how to password protect a word document and how to unlock any word document offline in this tutorial article. You will also learn how to restrict editing access on a word document and how to remove the restriction. Finally, I will reveal some free online tools for locking and unlocking a word document, and how to use these tools. For illustration, I used Microsoft Word 2013. But you can use any other version like 2010, 2013, 2016, 2020 upwards.

How to Password Protect MS Word File Offline

First open the word document you wish to protect with MS Word app.

Now click the File menu. Select the Info option.

Click the drop down arrow near Protect Document menu. Next, select Encrypt with Password as shown below.

Enter the document open password. Re-enter the password to confirm it and then click OK.


Microsoft Word will now indicate that the file has been protected. To view the content of the word file, you need to enter the password. Now click on Save to save the changes you made to the file.

Learn how to password protect PDF filesboth online and offline for free.

How to Restrict Editing in Word Document

You can control the types of editing others can make in your file by setting up the restrict editing in Microsoft word.

To setup restricting access:

Click File menu > Info option.

Select Restrict Access from the Protect Document menu as shown below.

You have 3 steps to follow: Formatting restrictions, Editing restrictions (with optional Exception) and Start Enforcement.

  • For Formatting restrictions: Check the "Limit formatting to a selection of styles" check box. You can click the Settings link to edit the allowed styles.
  • For Editing restriction: Check the "Allow only this type of editing in the document" check box. Then click the drop down menu to select the editing types to allow. No changes (Read only) is the default.
    You can also use the optional Exceptions section to specify parts of the document and users who are allowed to edit them freely. If you wish to allow everyone, then check the Everyone check box and then specify all regions they can edit by clicking the drop down arrow to the right of the check box. If you want only specific users to be able to edit these selected parts freely, click the More users link.
  • For Start enforcement: When you are ready to apply the changes to the document click on the Yes, Start Enforcing Protection button.

This prompts the Start Enforcing Protection dialog box as shown below.


You have two protection methods: Password and Authentication. You can use any protection method that suits you. Then click OK.

  • For the Password method: you need to enter a new restrict access password and confirm it. It must be different from the document open password you set earlier. Note that the document will not be encrypted. So malicious users can edit the file and remove the password with an online password unlock tool.
  • For the User authentication method: Users must pass the authentication before they can have access to the restrict access settings. Note that authenticated users can also remove the document protection. But the document will be encrypted and Restricted Access will be enabled.

Also note that you must sign in to your Microsoft office account in order to activate the User authentication method. But you can use the Password method without signing to your Microsoft account.

Save the word document to effect these changes you made.

See:

How to Decrypt a Protected Word Document Offline

To remove the password of a protected word document offline, you must provide the document. After which you will be allowed to decrypt the word file.

First, open the word document you wish to unlock with MS Word app.

You will be requested to type in the document open password before you can view the content of the document. Type the password and click OK as shown below.

Now to remove the document open password, click the File menu. Select the Info option.

Click the drop down arrow near Protect Document menu and select Encrypt with Password.

The Encrypt Document dialog box pops up with the document open password in the Password field. Delete those password and click OK.

MS Word has permanently removed the password. Save the word document to effect these changes.

How to Remove Editing Restriction in a Word Document

You might remove a document open password and also discover that you cannot edit the content of the word document. This is because the word document is set to restrict editing in some part or all parts of the document. In order to edit such a document, you need provide the Restrict Editing password or remove the password completely.

To deactivate Restrict Editing in a Word file:

Open the word document with MS word. If the file is locked with a document open password, follow the above guide for unlocking a password protected word document to unlock it.

If all editing access were restricted for the document, it will open in read only mode.

To enable editing, click on the View menu and then select Edit Document as shown below.

The document will now open fully, showing all the menus and MS Word features.

Now when you try to edit the document, MS Word will notify you that the document is restricted from unintentional editing.

To remove the restriction, click the Stop Protection button as shown below.

Microsoft Word will remove the editing restrictions. Now save the word document to effect these changes.

Learn how to remove password from any PDF file online and offline for free.

How to Use any Word Document Password Unlock Tool

  1. Upload the word file you wish to unlock to the server of the website.
  2. Most tools will ask you to provide the document open password. Type it.
  3. If editing access was also restricted in the document, you will be asked to provide the remove restriction password.
  4. The tool will start the decryption process. Once it is successful, you can download the decrypted version of the word document.

NOTE: For offline word document unlock tools, you don’t need to upload the word document first. It does the decryption offline.

Free Online and Offline Word Document Password Recovery Tools

Here are some free online and offline tools you can use to unlock any word document and also remove editing restriction.

  • Aspose Free Online Documents Unlocker: Unlock word documents, allows you to save to any desired format (PDF, JPG, HTML, etc.) and removes password in multiple files.
  • Passper for Word: Recovers the document open password and also removes the editing restriction password.
  • GuaWord: MS Word command-line password removal utility.
  • PassFab for Word: Password recovery tool for protected MS Word documents.

How to Use Online Tools for Locking any Document

Here is a general guide for using any online tool for password protecting any document.

  1. Upload the document you wish to password protect to the server of the website.
  2. You will be asked to provide and confirm the document open password.
  3. If you wish to restrict editing access, you will also provide another password for this.
  4. Then the tool will encrypt the document and ask you to download it. 
  5. Download it and try to open it. You will be required to provide the document open password to access the content of the file. If editing was also restricted, you be asked to provide the remove editing restriction password.

Check:

Conclusion

You have learnt how to password protect any word document both online and offline. Also, you learnt how to remove password from any locked word document both online and offline. I also revealed free tools for locking and unlocking word documents online. Feel free to use any method that suits you most.

Drop your questions in the comment section below. Click Here to subscribe to our blog to get notified via email when we drop new tutorial articles and videos. Share this article with your social media friends by clicking a share button below. Enjoy!

How to Calculate Mean (Average), Median & Mode in Excel

09:04:00 0
In numerical data analysis, there are 3 main measures of central tendency you need. These are: Average (Mean), Median and Mode. They are all standard measures of central location, but each of them is used in different instances to measure a central point. In this article you will learn how to calculate the mean, mode and median of a set of numerical data or grouped data in Microsoft Excel. I used Microsoft Office Excel 2013 for illustration, but you can use any other version, like 2010, 2016, etc.

How to Calculate Average in Excel

Average is also known as Arithmetic mean. It is the most popular of the 3 measures of central tendencies. To calculate the mean of a group of numbers, you simply add them up and then divide the total by count of these numbers. 

For instance, to calculate the mean of these numbers: {10, 20, 30, 40, 50}; Add them up and then divide the total by 5.

This is a manual way to calculate mean. But there are built in functions in MS Excel that can help you calculate mean faster.

Depending on your need, Excel has different built in Average functions. 
  • AVERAGE
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
I will explain each of these functions.

Excel AVERAGE Function

Use this average function if you want to calculate the average of a set of numbers in cells.

The syntax is:

=AVERAGE(number1, [number2], …) or AVERAGE(cell references or cell range)

Note that in the first syntax, the first argument (number1) is required, while the subsequent ones are optional. You can include up to 255 arguments.

Examples of cell references are A2, B2, C3, etc. Examples of cell range is A2:A5, B2:B5, C2:C5, etc.
From the workers' details in the above screenshot, to calculate the average salary of all the worker, type the following formula:

=AVERAGE(D2:D11) then press Enter key. It will return $1,385 in the cell.

NOTE:
  • When using the AVERAGE function, cells containing zero values are counted, while blank cells are not counted. 
  • Also, cells containing text string and boolean values are neglected. But if you type boolean values directly into the AVERAGE, they are counted. The boolean value - TRUE is equal to 1, while the boolean value - False is equal to 0. Example, the formula =AVERAGE(TRUE, FALSE) will returns 0.5. This is the average of 1 and 0.
See: 

Excel AVERAGEA Funtion

Use this average function If the cells contain different types of data like number, text and boolean values (true and false).

The syntax is:

=AVERAGEA(value1, [value2], …)

Where value1, value2, … are values, arrays, cell references or ranges that you want to calculate the average. The first argument is required, while the other (up to 255) arguments are optional.

When using the AVERAGEA formula, the following should be noted:
  • Empty cells are ignored.
  • Text values returned by other formulas, including empty string are evaluated as 0.
  • Boolean value TRUE is evaluated as 1, while boolean value FALSE is evaluated as 0.
For example, the formula =AVERAGEA(5,FALSE) returns 2.5, which is the average of 5 and 0. The formula =AVERAGEA(5,TRUE) returns 3, which is the average of 5 and 1.

NOTE:
If you do not want the Boolean values and text strings to be included in your calculations, use the Excel AVERAGE function.

Excel AVERAGEIF Function

To find the average of a set of numbers based on a single criterion, use this average function.

The syntax is:

AVERAGEIF(range, criteria, [average_range]) then press Enter key.

Where:
  • Range is the range of cells where the given criteria will be tested.
  • Criteria is the condition used to determine which cells to include when calculating the average. The criteria can be supplied in the form of a number, logical expression, text value, or cell reference. For example, 2, ">2", "cat", or B2.
  • Average_range (Optional) is the cells you actually want to calculate their average. If omitted, Excel will calculate an average of the values in the range argument.
For example, if we want to calculate the average of only the male workers in the above screenshot, type the following formula:

=AVERAGEIF(B2:B11, "male", D2:D11) then press Enter key.

It will return $1,440.

AVERAGEIFS

To find the average of a set of numbers based on more than one criterion, use this average function. This function is the plural form of AVERAGEIF.

The syntax is:

AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Where:
  • Average_range is the range of cells that you want to average.
  • Criteria_range1, criteria_range2, … are the ranges where the specified criteria will be tested. It accepts up 127 arguments. Criteria_range1 is required, while the subsequent ones are optional.
  • Criteria1, criteria2, … are the criteria that tells Excel which cells to include when calculating the average. You can supply the criteria in the form of a number, logical expression, text value, or cell reference. Criteria1 is required, subsequent criteria are optional.
For example, to calculate the average salary of female workers who are married, type the following formula:

=AVERAGEIFS(D2:D11, B2:B11, "female", C2:C11, "married") then press the Enter key.

The formula returns $1,600.

You can learn more about excel average functions here.

Check:

How to Calculate Median in Excel

Median is simply the middle value in a group of numbers when they are arranged in ascending or descending order. 

For example, the median of the following set of numbers: {1, 2, 2, 3, 4, 4, 5} is 3.

Finding the median of an odd number of values in a group is easier. But for even number of values, the medain is the average of the two middle values.

For example, to calculate the medain of these set of values: {1, 2, 2, 3, 4, 4, 5, 5}; you take the average of the 4th and 5th values in the data set. 
That is,  (3+4)/2 = 3.5

The syntax for median function is Excel is:

=MEDIAN(number1, [number2], …) then press the Enter key.

Where:
Number1, number2, … are numeric values you wish to find their median and can be up to 225 arguments. These can be numbers, dates, named ranges, arrays, or references to cells containing numbers. Number1 is required, while the subsequent numbers are optional.

The following are worth noting for Excel median calculation:
  • Cells with zero value are included in calculation.
  • Empty cells and cells containing text and boolean values are not included in calculation.
  • If you type the boolean values directly as arguments in the MEDIAN function, they are counted. The boolean TRUE value is evaluated as 1, while the boolean FALSE value is evaluated as 0. For example, the formula =MEDIAN(TRUE,FALSE,5,6,7) returns 5, which is the median of the numbers {1, 0, 5, 6, 7}.
From the above screenshot of the workers' detail, to calculate the median of the workers' salaries, type the following formula:

=MEDIAN(D2:D11) then press the Enter key.

The formula will return $1,350.
To confirm the answer, you can sort the data in the cells which you wish to find their median either in ascending or descending order. Since number of our data set was even (10), Excel returned the average of the 5th and 6th data (i.e. $1,300 and $1,400) which is equal to $1,350.
You can learn more about calculating median in excel here.

See:

How to Calculate Mode in Excel

Mode is the value in a data set that has the highest frequency or occurrence. You don't need to perform any calculation to find the mode of a data set. All you need to do is to count the number of times each value occurs in the data set.

For example, the mode of the set of values {1, 2, 2, 3, 3, 4, 4, 4} is 4.

The syntax for mode function is Excel is:

=MODE(range) or =MODE(number1, [number2], ...)
 then press Enter key.

Where:
  • Range or number1, [number2], ... is the range of cells or data set you wish to find their mode.
For the workers' details in the above screenshot, to find the mode of the workers' salary, type the following formula:

=MODE(D2:D11) then press the Enter key.

The formula will return #N/A error because all the values in the cell range occurred only once. So there is no mode.

NOTE:
If Excel discovers that there are two or more modes in your data set, the Excel MODE function will return the lowest mode.

Conclusion

You have learnt how to calculate mean (average), median and mode in any version of Microsoft Excel. You also learnt how to calculate these measures of central tendencies manually in this article. Feel free to apply these tips in any data set of your choice.

Help your social media friends to discover this amazing Excel tutorial by clicking a share button below.

Drop your comments below. Also click Here to subscribe to our blog via email so that we will update you when new WordPress themes are released by these sites.