Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel INDIRECT Function
  • Last row number in range
  • How to use Excel COLUMN Function
  • How to get first row number in range in Excel
  • Lookup entire row in Excel

Data Analysis Examples

  • How To Remove Duplicates In Excel Column Or Row?
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Randomize/ Shuffle List in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How To Insert and Customize Sparklines in Excel

Data Validation Examples

  • Excel Data validation exists in list
  • Excel Data validation don’t exceed total
  • Excel Data validation must not contain
  • Excel Data validation date in specific year
  • Excel Data validation specific characters only

DEVSQ function: Description, Usage, Syntax, Examples and Explanation

by

What is DEVSQ function in Excel?

DEVSQ function is one of Statistical functions in Microsoft Excel that returns the sum of squares of deviations of data points from their sample mean.

Syntax of DEVSQ function

DEVSQ(number1, [number2], …)

The DEVSQ function syntax has the following arguments:

  • Number1, number2, …    Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want to calculate the sum of squared deviations. You can also use a single array or a reference to an array instead of arguments separated by commas.

DEVSQ formula explanation

  • Arguments can either be numbers or names, arrays, or references that contain numbers.
  • Logical values and text representations of numbers that you type directly into the list of arguments are counted.
  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
  • The equation for the sum of squared deviations is:equation

Example of DEVSQ function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data
4
5
8
7
11
4
3
Formula Description Result
=DEVSQ(A2:A8) Sum of squares of deviations of data above from their sample mean. 48

Post navigation

Previous Post:

COVARIANCE.S function: Description, Usage, Syntax, Examples and Explanation

Next Post:

EXPON.DIST function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Join cells with comma in Excel
  • How to check if cell contains one of many things in Excel
  • Get position of 2nd 3rd and more instance of character in Excel
  • FIXED function: Description, Usage, Syntax, Examples and Explanation
  • How to get top level domain (TLD) in Excel
  • Calculate days remaining in Excel
  • Add days to date in Excel
  • Convert decimal hours to Excel time
  • Get day from date in Excel
  • Get day name from date in Excel
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
  • Calculate interest for given period in Excel
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
  • FVSCHEDULE function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles