DEVSQ Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is considered a software application program which provides over one hundred functions that relates to statistics and probability. The software application has a facility to construct a wide array of charts and graphs to be able to display data. This article provides you with an immediate reference guide in assisting you to bind the statistical capability of the Microsoft Excel.

Microsoft Excel is not merely designed for statistical computing. Thus, the user is advised in using the statistical package like SPSS or Minitab upon requiring statistical analysis in data manipulation and validation, calculation and presentation of the summary statistics as well as tabulation. It also has the optional facility of Analysis ToolPak add-in, which includes macros to carry out numerous basic statistical analyses. The add-in installation instructions vary within the Microsoft Excel version. With this, the user can use the Help facility in Microsoft Excel.

There are definitely two reasons why this should be used with enough concern:

  • The add-in output ought to be misleading.
  • It ensures the automatic calculations update within the light of changes in the workbook thus the add-in output is not merely linked to its data source unlike the other functions of the spreadsheet. Therefore, any data changes the facility of add-in must run it to obtain the updated output.

Microsoft Excel has varieties of functions and formulas wherein it is merely important to use in calculating, manipulating, formatting and many more. Most people do not know about Microsoft Excel, therefore, it is really hard for them to figure out on how to use this kind of software application. To be able to know the Microsoft Excel, you have to know and study first the different functions and formulas, which is very important for the spreadsheet of Microsoft Excel.

Once the user learned the basics of the Microsoft Excel, it is now easy to initiate the different functions and formulas needed in their spreadsheet. One of the functions that the user should learn is the DEVSQ function which is under the statistical function of the Microsoft Excel.

DEVSQ function in Microsoft Excel returns the sum of the square deviations of the given data points from its mean sample. The syntax for the DEVSQ function is “DEVSQ(number1, number2…). “Number1,number2….” are considered one of the thirty arguments which the user wanted to calculate the sum of the squared deviation. In addition, the user can also use the reference or the single array to a range instead of given arguments, which is separated by various commas.


  • The arguments should be consists of names or numbers, references or arrays that contains numbers.
  • The text presentations and logical values of numbers are typed directly within the lists of the counted arguments.
  • Arguments having error text or values, which are not to be translated within the various number causing errors.
  • If the arguments of reference or array contain logical values, text, or having empty cells, values are being ignored. However, cells having the zero value are definitely included.

Post comment