Estimates the standard deviation of a population based on a sample of entries in a database that match specified conditions.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
DSTDEV(database, field, criteria)The DSTDEV function calculates the sample standard deviation for a specific field in a database. It only includes records that meet the criteria defined in a separate range, allowing for complex data filtering before calculation.
=DSTDEV(A1:C10, "Sales", E1:E2)תוצאה: 12.45
Calculates the sample standard deviation of the 'Sales' column for records matching the criteria in E1:E2.
DSTDEV calculates the sample standard deviation, while DSTDEVP calculates the standard deviation for the entire population.