Data Analysis with Microsoft Excel: Updated for Office 2007

528 Input Range Enter the range of worksheet data you want to analyze. The range must be contiguous. Grouped By Indicate whether ...

Excel Reference 529 Kth Smallest Click to print the kth smallest value for each row or column of the input range; enter the valu ...

530 Labels Indicate whether the fi rst row (or column) includes header information. Chart Output Click to create a chart of obse ...

Excel Reference 531 Variable 2 Range Enter the range of the second sample, either a single row or a single column. Labels Indica ...

532 Bin Range Enter an optional range of values that defi nes the boundaries of the bins. Labels Indicate whether the fi rst row ...

Excel Reference 533 Input Range Enter the range of worksheet data for which you want to calculate the mov- ing average. The rang ...

534 Number of Variables Enter the number of columns of random variables you want to generate. If no value is entered, Excel fi l ...

Excel Reference 535 Rank and Percentile The Rank and Percentile command produces a table with ordinal and per- centile values fo ...

536 Input Y Range Enter a single column of values that will be the response variable in the lin- ear regression. Input X Range E ...

Excel Reference 537 Confi dence Level Click to indicate a confi dence interval for linear regression parameter esti- mates. A 95 ...

538 Input Range Enter the range of worksheet data you want to sample. The range must be contiguous. Labels Indicate whether the ...

Excel Reference 539 t-Test: Paired Two Sample for Means The t-Test: Paired Two Sample for Means command calculates the paired tw ...

540 Alpha Enter an alpha value used to calculate the critical values of the t shown in the output. See “Output Options” at the b ...

Excel Reference 541 Labels Indicate whether the fi rst row of the Y range and that of the X range include header information. Al ...

542 Hypothesized Mean Difference Enter a mean difference with which to calculate the t test. If no value is en- tered, a mean di ...

Excel Reference 543 Variable 1 Range Enter an input range of the fi rst sample; it must be a single row or column. Variable 2 Ra ...

544 This section documents all the functions provided with Excel that are relevant to statistics. So that you can more easily fi ...

Excel Reference 545 MEDIAN MEDIAN(number1, number2,.. .) returns the median of up to 30 numbers. MIN MIN(number1, number2,.. .) ...

546 VAR VAR(number1, number2,.. .) returns the sample variance of up to 30 numbers (or an array or reference). VARP VARP(number1 ...

Excel Reference 547 BINOMDIST BINOMDIST(successes, trials, p, type) returns the probability for the binomial distribution (type ...