The security level tab ofthe security dialog box that appears

PHStat2 Help
version 3.52

Copyright © 2015, Pearson Education, Inc.

(This is help system version 3.52)

1.2 What's New?

Descriptive Summary

1.2.2 PHStat2 Revision History

Added compatibility with 64-bit versions of Microsoft Windows Excels.

Descriptive Summary procedure added.

Corrected an issue in the Separate-Variance t procedure when the hypothesized difference is not

zero.

Enhanced introductory help system topics.

Corrected minor issues in the Separate-Variance t procedure.

Corrected formatting of the Variance Inflationary Factor option of Multiple Regression.

Corrected issue with Paired t Test procedure when Upper-Tail Test option is selected.

You use PHStat2 to perform a particular analysis by first selecting choices from the PHStat2 menu and completing entries in a dialog box. PHStat2 generates new worksheets and chart sheets to hold the results of an analysis. Many of these sheets contain formulas that will allow you to change the underlying data and see new results without having to rerun a procedure.

This version of PHStat2 works best with Excel 2010 or Excel 2013 (Microsoft Windows) or Excel 2011 (OS X). This version is also compatible with Excel 2007. (This version has limited compatibility with Excel 2003.)

If you are a student, use PHStat2 only with the data discussed in your text or required by your instructor. For such sets of data, the results produced by PHStat2 will allow you to form the proper conclusion about your data. (See also How PHStat2 presents its results.)

2.3 How PHStat2 Presents Its Results

For procedures that require two or more cell ranges, such as the regression procedures, make sure that all of your cell ranges are from the same worksheet.

Generally, you should use row 1 to enter a label for a column’s data. Due to technical limitations of Excel, avoid using numbers as a row 1 labels. If you must enter a number, enter the number preceded by an apostrophe. For example enter ‘2014.

3.1 PHStat2 Technical Requirements

Microsoft Windows Excel 2007, Excel 2010, or Excel 2013, OS X Excel 2011, or Office 365. Limited capability with Microsoft Windows Excel 2003 as explained the Readme file.

Excel 2010 and Excel 2013 Security
In Excel 2010 or Excel 2013, you must change the Trust Center settings to allow PHStat to properly

4. Click OK to close the Trust Center dialog box.

Back in the Excel Options dialog box:
5. Click OK to finish
For systems with very stringent security settings, you may need to modify step 5. For such systems, in step 5, click Trusted Locations in the left pane and then, in the Trusted Locations right pane, click Add new location, click Browse and navigateto the folder into which you place the PHStat files. Then

recently used commands first check box if it is checked and click Close.

4.1 Stack Data

Takes group data that has been arranged in columns and stacks it into two new columns, the first one of which contains the group labels, on a new worksheet.

First cells in both ranges contain label: If selected, the contents of the first cell in each column is treated as a descriptive label and not as a data value to be included in the unstacked data.

First cell contains label: If selected, the contents of the first cell in each column of the raw data cell range is treated as a group label. If not selected, all cells in the column are treated as data and group labels in the form Group1, Group2… are created.

Input Options:

Output Options:

Title: The custom title to be placed on the chart sheet and optional worksheet.

Copyright © 2015, Pearson Education, Inc.

will occur.

Raw Data Cell Range: The single- or multiple-column cell range (see Input Options) containing the numerical data to be summarized.

First cell contains label: If selected, the contents of the first cell in each column of the cell range entered in the dialog box is treated as a descriptive label and not as a data value.

Grouping Variable Cell Range: The single-column cell range containing the group labels. (Enabled only if Multiple Groups – Stacked is selected.

Output Options:

5.3 Dot Scale Diagram

Creates a dot scale diagram as a chart object on a new worksheet that also contains the numerical data plotted and a summary table of statistics.

Bins Cell Range: The single column cell range containing an ordered list of class maximum values in ascending order that is used to define the bins (classes). The last value in this cell range should be greater than or equal to all values contained in the variable cell range.

First cell in each range contains label: If selected, the contents of the first cell in each cell range entered in the dialog box is treated as a descriptive label and not as a data value.

Grouping Variable Cell Range: The single-column cell range containing the group labels. (Enabled only if Multiple Groups – Stacked is selected.)

Output Options:

If there are values contained in the variable cell range that are greater than the last value in bins cell range, the procedure includes those values in the counts of the last bin (class) and appends a plus sign to the bin label.

5.5 Histogram & Polygons

Variable Cell Range: The single- or multiple-column cell range (see Input Options) containing the numerical data to be summarized.

Bins Cell Range: The single column cell range containing an ordered list of class maximum values in ascending order that is used to define the bins (classes). The last value in this cell range should be greater than or equal to all values contained in the variable cell range.

Multiple Groups – Unstacked: If selected, the variable data cell range is interpreted as an unstacked data range in which each column of the range contains the data for an individual group. When this option is selected, the variable data cell range must be two or more consecutive columns.

Multiple Groups – Stacked: If selected, the variable cell range is interpreted as a stacked series of data values. When this option is selected, the variable cell range must be a single column.

Frequency Polygon: If selected, generates a frequency polygon on a separate chart sheet.

Percentage Polygon: If selected, generates a percentage polygon on a separate chart sheet.

If there are values contained in the variable cell range that are greater than the last value in bins cell range, the procedure includes those values in the counts of the last bin (class) and appends a plus sign to the bin label.

Copyright © 2015, Pearson Education, Inc.

Data:

Y Variable Cell Range: The single-column cell range containing the values of the Y variable.

5.7 Stem-and-Leaf Display

Creates a stem-and-leaf display using the rounding method on a new worksheet from a set of numerical data. Optionally generates a summary statistics table on the same worksheet.

Autocalculate stem unit: If selected, the procedure selects the power of ten which, when divided into the data values, produces at least 5 stems. This is the default option.

Set stem unit as: If selected, the edit box to the right of this option is enabled and a power of ten can be entered to override the value that the procedure would otherwise use. Use this option if the Autocalculate option produces too few or too many stems.

If a value that is not a power of ten is entered as the set stem unit as value, an error will occur.

Use the Set stem unit as option with care as a poor choice of stem unit value could lead to a very many (or very few) stems.

Data:

Type of Data:

Output Options:

Title: The custom title to be placed on the worksheet and any chart sheets generated.

Notes:

If the cell range for table of frequencies includes row or column totals, an error will occur.

Column Variable Cell Range: The single-column cell range containing the categories to be used as columns in the summary table.

First cell in each range contains label: If selected, the contents of the first cell is treated as a descriptive label and not as a category value.

Output Options:

Title: The custom title for the worksheet generated by this procedure.

Number of Events: The number of events for each alternative course of action.

Number of Alternative Actions: The number of alternative courses of action, or choices, for a decision.

Notes:

The sum of all probabilities entered must equal 1. If the sum of all probabilities is another number, the results shown on the worksheet will be invalid.

Creates a new worksheet that calculates expected opportunity losses from probability and
opportunity loss data for the events associated with a set of alternative courses of action. The worksheet generated contains an empty probabilities & opportunity losses table into which you enter probability and opportunity loss data for each combination of event and alternative course of action to complete the analysis. (You can also enter labels for each event and each alternative course of action.)

Title: The custom title for the worksheet generated by this procedure.

Notes:

Number of Events: The number of events for each alternative course of action.

Number of Alternative Actions: The number of alternative courses of action, or choices, for a decision.

Creates a new worksheet that calculates normal probabilities.

Probability for range: If selected, worksheet calculates the probability of values between the entered range of X values.

X for Cumulative Percentage: If selected, worksheet calculates the X and Z values corresponding to a cumulative area under the normal curve.

Data:
Variable Cell Range: The single-column cell range containing the numerical data to be summarized.

First cell contains label: If selected, the contents of the first cell of the variable cell range is treated as a descriptive label and not as a data value.

Data:
Sample Size: The sample size.

Prob. of an Event of Interest: The probability of an event of interest ("success").

Cumulative Probabilities: If selected, adds additional table columns that calculate cumulative probabilities for P(<=X), P(<X), P(>X), and P(>=X).

Histogram: If selected, generates a histogram, based on the table of binomial probabilities, on a separate chart sheet.

Calculates the exponential probability for values less than or equal to a given X value on a new worksheet.

Data:

7.6 Hypergeometric Probability Distribution

Creates a table of hypergeometric probabilities on a new worksheet.

Output Options:

Title: The custom title for the worksheet generated by this procedure.

Output Options:

Title: The custom title for the worksheet generated by this procedure.

Distribution Options:

Uniform: If selected, samples are generated from a uniformly distributed population between 0 and 1.

Title: The custom title for the worksheet generated by this procedure.

Histogram: If selected, generates a histogram, based on the simulated distribution, on a separate chart sheet.