Chapter 1: What s New in Excel 2003

 < Day Day Up > 



Microsoft Excel has been around since 1985, so it's no surprise that the basic spreadsheet elements of the program have remained fairly constant for quite some time. That said, there is always room for improvement, and Microsoft Office Excel 2003 has a bunch of new features that make data gathering, collaboration, and data transfer much more effective than in previous versions. The bulk of the improvements in Excel 2003 revolve around the use of Extensible Markup Language, or XML, which is a flexible, text-based markup system that lets you describe the contents of a spreadsheet so that the data it contains can be handled automatically instead of manually, saving time and reducing the possibility of errors introduced from re-keying or copying the data. Excel 2003 also comes with a suite of improved statistical functions, which are far more precise than in previous versions of the program.

Using Improved Statistical Functions

Most Excel users will never go beyond the relatively simple formulas and formatting tasks used to track business and financial data, but scientific and advanced business or academic users who take advantage of the advanced statistical functions available in Excel need great precision from those functions. The Excel programming team changed how the program calculates the results of quite a few statistical functions, improving the accuracy of those results and making them much more useful to advanced users. Table 1-1 lists the enhanced functions and describes each one.

Table 1-1: Improved Statistical Functions

BINOMDIST

Determines the probability that a set number of true/false trials, where each trial has a consistent chance of generating a true or false result, will result in exactly a specified number of successes (for example, exactly five out of ten coin flips will end up heads).

CHIINV

Finds a value that best fits a result in a chi-squared distribution.

CONFIDENCE

Returns a value you can use to construct a confidence interval for a population mean.

CRITBINOM

Determines when the number of failures in a series of true/false trials exceeds a criterion (for example, more than 5 percent of light bulbs in a production run fail to light).

DSTDEV

Estimates the standard deviation of values in a column by considering only those values that meet a criterion.

DSTDEVP

Calculates the standard deviation of values in a column based on every value in the column.

DVAR

Estimates the variance of values in a column or list by considering only those values that meet a criterion.

DVARP

Calculates the variance of values in a column or list based on every value in the column.

FINV

Returns the value that would generate a target result from an F-test (a test of variability between two data sets).

FORECAST

Calculates future values based on an existing time series of values.

GAMMAINV

Returns the value that would generate a given result from a gamma- distributed (that is, skewed) data set.

GROWTH

Predicts the exponential growth of a data series.

HYPGEOMDIST

Returns the probability of selecting an exact number of a single type of item from a mixed set of objects. For example, a jar holds 20 marbles, 6 of which are red. If you choose three marbles, what is the probability you will pick exactly one red marble?

INTERCEPT

Calculates the point at which a line will intersect the y-axis.

LINEST

Generates a line that best fits a data set by generating a two- dimensional array of values to describe the line.

LOGEST

Generates a curve that best fits a data set by generating a two- dimensional array of values to describe the curve.

LOGINV

Returns the inverse logarithm of a value in a distribution.

LOGNORMDIST

Returns the number of standard deviations a value is away from the mean in a lognormal distribution.

NEGBINOMDIST

Returns the probability that there will be a given number of failures before a given number of successes in a binomial distribution.

NORMDIST

Returns the number of standard deviations a value is away from the mean in a normal distribution.

NORMINV

Returns a value that reflects the probability a random value selected from a distribution will be above it in the distribution.

NORMSDIST

Returns a standard normal distribution, with a mean of 0 and a standard deviation of 1.

NORMSINV

Returns a value that reflects the probability a random value selected from the standard normal distribution will be above it in the distribution.

PEARSON

Returns a value that reflects the strength of the linear relationship between two data sets.

POISSON

Returns the probability of a number of events happening, given the Poisson distribution of events.

RAND

Generates a random value.

RSQ

Returns the square of the Pearson coefficient of two sets of values.

SLOPE

Returns the slope of a line.

STDEV

Estimates the standard deviation of a numerical data set based on a sample of the data.

STDEVA

Estimates the standard deviation of a data set (which can include text and true/false values) based on a sample of the data.

STDEVP

Calculates the standard deviation of a numerical data set.

STDEVPA

Calculates the standard deviation of a data set (which can include text and true/false values).

STEYX

Returns the predicted standard error for the y value for each x value in a regression.

TINV

Returns a t value based on a stated probability and degrees of freedom.

TREND

Returns values along a trend line.

VAR

Estimates the variance of a data sample.

VARA

Estimates the variance of a data set (which can include text and true/ false values) based on a sample of the data.

VARP

Calculates the variance of a data population.

VARPA

Calculates the variance of a data population, which can include text and true/false values.

ZTEST

Returns the probability that the mean of a data sample would be greater than the observed mean of data in the set.



 < Day Day Up > 



Microsoft Excel 2003 Programming Inside Out
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
Year: 2006
Pages: 161

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net