Spreadsheets

By eHow Computers Editor

0 comments

Microsoft Excel is a widely used business and computational spreadsheet software package. One computational function contained within the software package is the standardize function. The standardize function uses a numerical value, mean and ... more »

How to Use Excel's STDEVA Function

By eHow Computers Editor

0 comments

Microsoft Excel provides a useful and efficient set of statistical functions that enable a user to estimate a given probability from a given set of values. One such useful tool is the STDEVA function, which allows a user to determine the standard ... more »

How to Use Excel's STDEVP Function

By eHow Computers Editor

0 comments

In addition to performing financial calculations, Microsoft Excel contains a robust set of mathematical functions. These functions make complex calculations simple with just a few clicks. STDEVP is one such function that makes it possible to ... more »

How to Use Excel's STDEVPA Function

By eHow Computers Editor

0 comments

The STDEVPA function one of many available in Excel to help with your statistical analysis. STDEVPA allows you to include all of the arguments of your data, including text and logic values, to arrive at a standard deviation based on those arguments... more »

How to Use Excel's STEYX Function

By eHow Computers Editor

0 comments

Excel's STEYX function calculates the standard error for the predicted y value for all x values in the regression. Here, the standard error measures the error of y's predictive value for each value of x. The following steps will show how to use ... more »

How to Use Excel's SUBSTITUTE Function

By eHow Computers Editor

0 comments

Excel's SUBSTITUTE function is useful if you have a lot of cells that have the same data format but different values. With the SUBSTITUTE function, you can enter information once, then write a formula displays a variation of that cell throughout ... more »

How to Use Excel's SUBTOTAL Function

By eHow Computers Editor

0 comments

Excel's SUBTOTAL function calculates a subtotal from a database or list. It is normally used only to modify an existing list because the Subtotals command from the Data menu can usually create the list more easily. The following steps will show ... more »

How to Use Excel's Sumif Function

By eHow Computers Editor

0 comments

Elementary addition becomes cumbersome when it includes large volumes of data, however, using an Excel spreadsheet to perform calculations saves time if you are familiar with functions such as SumIf. Learning SumIf turns hours worth of work into ... more »

How to Use Excel's SUMPRODUCT Function

By eHow Computers Editor

0 comments

Though it is often used to multiply a long string of numbers, Excel's SUMPRODUCT can be used to perform a variety of mathematical equations. SUMPRODUCT is one of those seemingly simple functions that becomes more invaluable as you learn its ... more »

How to Use Excel's SUMSQ Function

By eHow Computers Editor

0 comments

Excel's SUMSQ function returns the sum of the squares of a set of numbers. This calculation is commonly required as part of a more complex formula in a variety of statistical applications. The following steps will show how to use Excel's SUMSQ ... more »

How to Use Excel's SUMX2MY2 Function

By eHow Computers Editor

0 comments

Excel's SUMX2MY2 function calculates the sum of the differences of the squares of two sets of values and is named after the mnemonic "SUM of X^2 Minus Y^2." This function is frequently used in statistical applications and the following steps will ... more »

How to Use Excel's SUMX2PY2 Function

By eHow Computers Editor

0 comments

Excel's SUMX2PY2 function returns the sum of the squares of two sets of values and is named after the mnemonic "SUM of X^2 Plus Y^2." This term is encountered frequently in statistical calculations and the following steps will show how it is used... more »

How to Use Excel's SUMXMY2 Function

By eHow Computers Editor

0 comments

Excel's SUMXMY2 function calculates the sum of the squares of the differences between two sets of values. It is named after the mnemonic "SUM of (X Minus Y)^2" and is found in statistical formulas... more »

How to Use Excel's SYD Function

By eHow Computers Editor

0 comments

Every business needs to track depreciation on its assets, both for income tax and management purposes. The most common depreciation methods are straight line and sum-of-the-years' depreciation, also known as SYD. Often a business owner uses one ... more »

How to Use Excel's TAN Function

By eHow Computers Editor

0 comments

Excel's TAN function calculates an angle's tangent in radians or degrees. "Tan" refers to the tangent, one of the primary trigonometric functions. An "x" refers to the value that goes into the function with the tan, and together we refer to them ... more »

How to Use Excel's TANH Function

By eHow Computers Editor

0 comments

Excel has many functions that can complete calculations for you. Using the TANH function to find the tangents of numbers will simplify the process and save you time... more »

How to Use Excel's TEXT Function

By eHow Computers Editor

0 comments

Excel's TEXT function allows users to type in a function that returns a value converted to text. For instance, you can use it to change the way a date is displayed or change a number value to currency. You can also create a sentence that includes ... more »

How to Use Excel's TIME Function

By eHow Computers Editor

0 comments

The TIME function in Excel makes factoring time calculations a nearly error-proof process. Whether you're using the function to calculate time sheets, payroll or to simplify a hectic schedule, it can be a useful tool. In addition, you can use the ... more »

How to Use Excels TINV Function

By eHow Computers Editor

0 comments

Excel's TINV function analyzes data to find its probabilities and inverse probabilities. It is essentially a more in-depth analysis than the TDIST Excel function because it uses a two-tail analysis instead of a one-tail analysis... more »

How to Use Excel's TRIM Function

By eHow Computers Editor

0 comments

Excel's TRIM function removes all spaces from the specified text except a single space between words. It is frequently used on text that has irregular spacing. TRIM deletes the ASCII space, which has decimal value of 32. It does not delete the ... more »

How to Use Excel's TRUNC Function

By eHow Computers Editor

0 comments

Excel's TRUNC function truncates a number to a specified number of digits and returns the resulting number. It is important to distinguish TRUNC with INT and ROUND. TRUNC will return #VALUE! if test_number is not a number. The following steps ... more »

How to Use Excel's TYPE Function

By eHow Computers Editor

0 comments

Excel's TYPE function returns the data type of a specified value. If this value is a reference to a cell containing a formula, TYPE returns the type of a formula's resulting or displayed value. TYPE is used when a value's type affects the ... more »

How to Use Excel's UPPER Function

By eHow Computers Editor

0 comments

Excel's UPPER function converts the specified text to uppercase. It returns the specified text with all lowercase letters replaced by their uppercase equivalent. Characters that already are uppercase, or have no uppercase equivalent, will change... more »

How to Use Excel's VAR Function

By eHow Computers Editor

0 comments

Excel's VAR function estimates the variance of a population by calculating the compound variance of a sample. This function is identical to VARA except that VAR does not accept errors, logical values or text. The following steps will show how to ... more »

How to Use Excel's VARPA Function

By eHow Computers Editor

0 comments

Excel's VARPA function stands for variance population arguments. It calculates the variance based on the entire population. The argument list is considered to be the entire population, so the variance must be calculated using VARPA if the ... more »

Check Out All Categories

Articles in Spreadsheets