Data Analysis with Microsoft Excel: Updated for Office 2007

548 NORMINV NORMINV(p, mean, sd) returns the inverse of the normal distribution with mean mean and standard deviation sd. NORMSD ...

Excel Reference 549 LOG LOG(number, base) returns the logarithm of number, with the specifi ed (optional, default is 10) base. L ...

550 Statistical Analysis Function Name Description CHITEST CHITEST(observed, expected) calculates the Pearson chi-square for obs ...

Excel Reference 551 TREND TREND(known-y’s, known-x’s, new-x’s, constant) returns the y values of given input values (new-x’s) ba ...

552 StatPlus™ is supplied with the textbook Data Analysis with Microsoft Excel 2007 to perform basic statistical analysis not co ...

Excel Reference 553 Patterned Data The StatPlus>Create Data>Patterned Data command generates a column of data following a ...

554 Manipulating Columns Indicator Columns The StatPlus>Manipulate Columns>Create Indicator Columns command takes a column ...

Excel Reference 555 Unstack Column The StatPlus>Manipulate Columns>Unstack Column command takes data found in two columns— ...

556 Standardize Data Values The StatPlus>Manipulate Columns>Standardize command standardizes values in a collection of dat ...

Excel Reference 557 Periodic Sample The StatPlus>Sampling>Periodic Sample command samples data values from a collection of ...

558 Fast Scatterplot The StatPlus>Single Variable Charts>Fast Scatterplot command creates a quick scatterplot bypassing ma ...

Excel Reference 559 Stem and Leaf Plots The StatPlus>Single Variable Charts>Stem and Leaf Plots command cre- ates a stem a ...

560 Normal Probability Plot The StatPlus>Single Variable Charts>Normal P-plots command creates a normal probability plot w ...

Excel Reference 561 Multiple Histograms The StatPlus>Multivariable Charts>Multiple Histograms command creates stacked hist ...

562 Scatterplot Matrix The StatPlus>Multivariable Charts>Scatterplot Matrix command creates a matrix of scatterplots. The ...

Excel Reference 563 Individuals Chart The StatPlus>QC Charts>Individuals Chart command creates an Indi- viduals chart of q ...

564 Range Charts The StatPlus>QC Charts>Range Chart command creates a Range chart of quality-control data. The subgroups c ...

Excel Reference 565 Moving Range Charts The StatPlus>QC Charts>Moving Range Chart command creates a Moving Range chart of ...

566 S-Charts The StatPlus>QC Charts>S-Chart command creates a s-chart or sigma-chart of quality control data. The subgroup ...

Excel Reference 567 Pareto Chart The StatPlus>QC Charts>Pareto Chart command creates a Pareto chart of quality-control dat ...