![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > Functions > Statistical > VARP |
VARP(number1 [,number2] [,…]) |
| Calculates variance based on the entire population. |
| number1 | The first number. | |
| number2 | The second optional number. |
| REMARKS |
| This function assumes that the arguments represent the entire population (as opposed to a sample). | ||
| Text and logical values such as True and False are ignored. | ||
| If you do not want to count any arguments that are text or logical values you can use the VARPA() function. | ||
| You can have a maximum of 30 arguments. | ||
| The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (826393). |
| EXAMPLES |
|
| Functions - V | Index - V | Office Online |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top |