Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education

Followers

The average price of gold and silver

The average value of Gold and Silver

In this example tutorial I will show how we can calculate how many months the price of gold is equal to or greater than the average value.
NOTE: The rates in the table are not realistic and do not reflect the real price of gold and silver have already been invented for examples of tutorials.

In column 'A' you notice names metals gold and silver as well as monthly changes in the value
In column 'B:F' you see the price of gold and silver during certain months
In column 'G' you notice the average price of silver and gold during the last 5 months
in column 'H' you notice the maximum value or the price of silver or gold during the last five months.

The average price of gold and silver

Changes in the price of gold and silver during the last five (5) months


The goal of this tutorial is to show how we can calculate the change in the prices of gold and silver in the last few months. We can also calculate how many months the price of gold or silver price was higher or the same than the average price of gold or silver during the last five months

In Excel cells 'C4' and 'C5' is formula (copy it to the right): =C2-B2

In cell 'G2' is the formula: =AVERAGE(B2:F2) that has been copied down

In cell 'H2' is the formula: =MAX(B2:F2) that has been copied down

In a cell, for example. 'J2' place the following formula: =COUNTIF(B2:F2;">="&G2)
This formula returns a number 2 which means that the price of gold in the last five months was higher or equal to the average price of gold in only two months in the period of time over the past five months. The same formula applies to the price of silver is only copied down.