function is called large. here is a link: http://chandoo.org/wp/2010/06/04/average-of-top-5-values/
still, I have tried it and had a syntax error when I have typed: =AVERAGE(LARGE(C9:H9,{1,2,3,4,5,6,7}))
I will be glad if someone can help:)
The NPER() function.
The FV function calculates the future value of an investment.
The PPMT function.
It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.
Surprisingly, it is =AVERAGE(number1, number2,...)
Here's how you do it in Excel: use the function =STDEV(<range with data>). That function calculates standard deviation for a sample.
You can use MAX function in MS Excel to find out Largest Number. Follow the steps mentioned below Suppose you have number from A1 to A15 Cells and you want to find out Largest value and want to place it in A16. Then A16 Type, =MAX(A1:A15).
FV( interest_rate, number_payments, payment, PV, Type )
The SUM function would be used to total up the figures for the budget, but other functions might be used too during the process.
Excel does not have a HIGHVALUE function. It does have a MAX function that finds the largest number in a range.The MAX function returns the largest value from the numbers provided.MAX(number1,number2,...number_n)number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
To calculate the standard deviation of a portfolio in Excel, you can use the STDEV.P function. This function calculates the standard deviation based on the entire population of data points in your portfolio. Simply input the range of values representing the returns of your portfolio into the function to get the standard deviation.