Want this question answered?

Q: What worksheet function Estimates the standard deviation based on a sample of selected database entries?

Write your answer...

Submit

Still have questions?

Continue Learning about Math & Arithmetic

Here's how you do it in Excel: use the function =STDEV(<range with data>). That function calculates standard deviation for a sample.

Use the STDEV() function.

yes, h=1/sigma(standard deviation)

thanx

A worked out example is shown in the related link. There are a number of calculators that do this automatically. Also, the Excel program (and most other spreadsheet programs) include a standard deviation function. In Excel, it is +stdev(a1:a10) for a list of numbers from a1 to a10.

Related questions

1) Document files 2) Worksheet files 3) Database files 4) Presentation files

Here's how you do it in Excel: use the function =STDEV(<range with data>). That function calculates standard deviation for a sample.

create the database

the function of the database

Yes it can. It enables you to enter a function into the worksheet.

The NOW function

Use the STDEV() function.

function

function

You would typically click on the "Insert Function" button, which is represented by the fx symbol. From there, you can search for the specific statistical function you want to add to your worksheet.

Microsoft Excel is not a database, it is a spreadsheet. You could use it for a rudimentary database application, but that is not it's primary function.

It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.It is a function that recalculates when the spreadsheet is changed or opened. The NOW function is one good example, as is the RANDBETWEEN function.