Submitted By dickersonwts

Words 2401

Pages 10

Words 2401

Pages 10

PHStat2 is Windows software that assists you in learning the concepts of statistics while using Microsoft Excel. PHStat2 allows you to perform many common types of statistical analyses working with and using the familiar Microsoft Excel interface. PHStat2 is an enhanced version of the original PHStat statistical add-in system. If you have used PHStat previously, read the "What's New?" section to discover the improvements that PHStat2 contains. (In your textbook, you should interpret any general reference to "PHStat" as a reference to PHStat2.)

The rest of this document is organized into sections to assist you in setting up and using PHStat2. The “What’s New in PHStat2” section of this file can also be found in the PHStat2 help system (select Help for PHStat2 from the PHStat menu in Microsoft Excel and look in the “Welcome to PHStat2” topic).

Table of Contents

1 Technical requirements for PHStat2

2 Configuring Microsoft Excel Components for PHStat2

3 Configuring Microsoft Excel Security for PHStat2

4 Setting up PHStat2

5 Using PHStat2

6 Updating PHStat2

7 Troubleshooting PHStat2

8 What's New in PHStat2?

1 Technical requirements for PHStat2

There are separate requirements for using PHStat2 and running the PHStat2 setup program. The requirements for running the setup program are more exclusive. If you plan to setup PHStat2, make sure to review all of the requirements that follow.

Requirements for using PHStat2:

Windows 98/98SE/ME/NT 4.0/2000/XP Home/XP Pro computer system.

Microsoft Excel 97/2000/2002(Office XP)/2003 or later. Excel 97 users must apply the SR-2 or a later free update from Microsoft. PHStat2 is not compatible with Microsoft Excel 95 or the Macintosh versions of Microsoft Office and Excel.

Screen resolution settings set to 800 by 600 pixels or 1024 by 748 pixels, recommended. PHStat2 will run with any screen…...

...PHStat2 readme file. PHStat2 is Windows software that assists you in learning the concepts of statistics while using Microsoft Excel. PHStat2 allows you to perform many common types of statistical analyses working with and using the familiar Microsoft Excel interface. PHStat2 is an enhanced version of the original PHStat statistical add-in system. If you have used PHStat previously, read the "What's New?" section to discover the improvements that PHStat2 contains. (In your textbook, you should interpret any general reference to "PHStat" as a reference to PHStat2.) The rest of this document is organized into sections to assist you in setting up and using PHStat2. The “What’s New in PHStat2” section of this file can also be found in the PHStat2 help system (select Help for PHStat2 from the PHStat menu in Microsoft Excel and look in the “Welcome to PHStat2” topic). Table of Contents 1 Technical requirements for PHStat2 2 Configuring Microsoft Excel Components for PHStat2 3 Configuring Microsoft Excel Security for PHStat2 4 Setting up PHStat2 5 Using PHStat2 6 Updating PHStat2 7 Troubleshooting PHStat2 8 What's New in PHStat2? 1 Technical requirements for PHStat2 There are separate requirements for using PHStat2 and running the PHStat2 setup program. The requirements for running the setup program are more exclusive. If you plan to setup PHStat2, make sure to review all of the requirements that follow. Requirements for using PHStat2: Windows 98/98SE/ME/NT......

Words: 2364 - Pages: 10

...com/officeupdate for latest Excel updates.) PHStat2 is not compatible with the 64-bit versions of Microsoft Excel. PHStat2 no longer fully supports Excel versions earlier than Excel 2003. Users of earlier Excel versions discover that the new procedures discussed in Section 7 will not function properly. For Excel 2007 or Excel 2010, Trust Center Macro Settings set to Disable all macros with notification (see Topic 2a “Configuring Excel 2007/2010 Security for PHStat2” for complete details). For Excel 2003, Microsoft Office macro security level set to Medium (see Topic 2b in “Configuring Excel 2003 Security for PHStat2” for complete details). Internet access for downloading Microsoft Excel updates and PHStat2 updates (visit www.pearsonhighered.com/phstat) as they become available. MyStatLab users will always have access to an up-to-date version of PHStat2 from within their MyStatLab courses and will not need to download updates separately. Requirements for running the PHStat2 setup program: Windows user account with administrator privileges. Student or faculty accounts used to login onto networked computers in academic settings typically do not have this privilege. If you have such an account, ask your network or lab technician for assistance. Approximately 10 MB hard disk free space while running the setup program and 3 MB hard disk space after program setup. 2a Configuring Excel 2007/Excel 2010 Security for PHStat2 You must change the Trust Center settings to allow......

Words: 2005 - Pages: 9

...Microsoft. Microsoft Excel Data Analysis ToolPak and Analysis ToolPak–VBA add-ins installed (supplied on the Microsoft Office/Excel program CD). For Excel 2000 through Excel 2003, Microsoft Office macro security level set to Medium (see topic 3 in “Configuring Microsoft Excel Security for PHStat2”) For Excel 2007, Trust Center Macro Settings set to Disable all macros with notification (recommended) or Enable all macros (not recommended). See section 3a or 3b for more details. (There are no security settings in Excel 97 or the original, unpatched version of Excel 2000.) Updated anti-virus program, optional but recommended. Internet access for downloading Microsoft Excel updates from www.microsoft.com and PHStat2 updates from www.prenhall.com/phstat, as they become available. Optional but recommended. Requirements for running the PHStat2 setup program: CD or DVD drive. Approximately 10 MB hard disk free space while running the setup program and 3 MB hard disk space after program setup. On some older systems, the Windows system files that may get replaced or added during the setup process will require up to 6 MB additional hard disk space. Windows user account with administrator or software-installing privileges (applies only to Windows NT/2000/XP/Vista or networked users only). Student or faculty accounts used to login onto networked computers in academic settings typically do not have this privilege. If you have such an account, ask your network or lab technician for......

Words: 1904 - Pages: 8

...com/officeupdate for latest Excel updates.) PHStat2 is not compatible with the 64-bit versions of Microsoft Excel. PHStat2 no longer fully supports Excel versions earlier than Excel 2003. Users of earlier Excel versions discover that the new procedures discussed in Section 7 will not function properly. For Excel 2007 or Excel 2010, Trust Center Macro Settings set to Disable all macros with notification (see Topic 2a “Configuring Excel 2007/2010 Security for PHStat2” for complete details). For Excel 2003, Microsoft Office macro security level set to Medium (see Topic 2b in “Configuring Excel 2003 Security for PHStat2” for complete details). Internet access for downloading Microsoft Excel updates and PHStat2 updates (visit www.pearsonhighered.com/phstat) as they become available. MyStatLab users will always have access to an up-to-date version of PHStat2 from within their MyStatLab courses and will not need to download updates separately. Requirements for running the PHStat2 setup program: Windows user account with administrator privileges. Student or faculty accounts used to login onto networked computers in academic settings typically do not have this privilege. If you have such an account, ask your network or lab technician for assistance. Approximately 10 MB hard disk free space while running the setup program and 3 MB hard disk space after program setup. 2a Configuring Excel 2007/Excel 2010 Security for PHStat2 You must change the Trust Center settings to allow......

Words: 2005 - Pages: 9

...Microsoft. Microsoft Excel Data Analysis ToolPak and Analysis ToolPak–VBA add-ins installed (supplied on the Microsoft Office/Excel program CD). For Excel 2000 through Excel 2003, Microsoft Office macro security level set to Medium (see topic 3 in “Configuring Microsoft Excel Security for PHStat2”) For Excel 2007, Trust Center Macro Settings set to Disable all macros with notification (recommended) or Enable all macros (not recommended). See section 3a or 3b for more details. (There are no security settings in Excel 97 or the original, unpatched version of Excel 2000.) Updated anti-virus program, optional but recommended. Internet access for downloading Microsoft Excel updates from www.microsoft.com and PHStat2 updates from www.prenhall.com/phstat, as they become available. Optional but recommended. Requirements for running the PHStat2 setup program: CD or DVD drive. Approximately 10 MB hard disk free space while running the setup program and 3 MB hard disk space after program setup. On some older systems, the Windows system files that may get replaced or added during the setup process will require up to 6 MB additional hard disk space. Windows user account with administrator or software-installing privileges (applies only to Windows NT/2000/XP/Vista or networked users only). Student or faculty accounts used to login onto networked computers in academic settings typically do not have this privilege. If you have such an account, ask your network or lab technician for......

Words: 1904 - Pages: 8

...(Price). pHStat Interval Estimates | | | | Data | X Value | 3000 | Confidence Level | 95% | | | Intermediate Calculations | Sample Size | 155 | Degrees of Freedom | 153 | t Value | 1.97559 | XBar, Sample Mean of X | 2673.019 | Sum of Squared Differences from XBar | 55651629 | Standard Error of the Estimate | 7883.369 | h Statistic | 0.008373 | Predicted Y (YHat) | 18385.34 | | | For Average Y | Interval Half Width | 1425.095 | Confidence Interval Lower Limit | 16960.25 | Confidence Interval Upper Limit | 19810.44 | | | For Individual Response Y | Interval Half Width | 15639.37 | Prediction Interval Lower Limit | 2745.969 | Prediction Interval Upper Limit | 34024.71 | Table 2 – Dataset 1 Confidence and Prediction Interval Estimates (j) 95% Confidence Interval Estimate of Ȳ When X = 3000 Ŷi=9854.0412+2.8438×3000 =18385.34 hi=1n+Xi-X2SSX =1155+3000-2673.019255651629 =0.008373 Using the 5% Level of Significance two-tail test, the critical value of t with n – 2 (153) degrees of freedom from the t-tables is tCRIT,0.025,153=±1.9799 95% confidence interval of mean car price when X = 3000 Ŷi-tn-2SYXhi≤μY|X=3000≤Ŷi+tn-2SYXhi 18385.34-1.9799×7883.3690.008373≤μY|X=3000≤18385.34+1.9799×7883.3690.008373 16957.12≤μY|X=3000≤19813.56 With 95% confidence, the average value of Y for X = 3000 is between $16957.12 and $19813.56. NOTE: The calculated interval varies slightly from the output from pHStat stated in......

Words: 3699 - Pages: 15

...PHStat2 readme file. PHStat2 is Windows software that assists you in learning the concepts of statistics while using Microsoft Excel. PHStat2 allows you to perform many common types of statistical analyses working with and using the familiar Microsoft Excel interface. PHStat2 is an enhanced version of the original PHStat statistical add-in system. If you have used PHStat previously, read the "What's New?" section to discover the improvements that PHStat2 contains. (In your textbook, you should interpret any general reference to "PHStat" as a reference to PHStat2.) The rest of this document is organized into sections to assist you in setting up and using PHStat2. The “What’s New in PHStat2” section of this file can also be found in the PHStat2 help system (select Help for PHStat2 from the PHStat menu in Microsoft Excel and look in the “Welcome to PHStat2” topic). Table of Contents 1Technical requirements for PHStat2 2Configuring Microsoft Excel Components for PHStat2 3Configuring Microsoft Excel Security for PHStat2 4Setting up PHStat2 5Using PHStat2 6Updating PHStat2 7Troubleshooting PHStat2 8What's New in PHStat2? 1 Technical requirements for PHStat2 There are separate requirements for using PHStat2 and running the PHStat2 setup program. The requirements for running the setup program are more exclusive. If you plan to setup PHStat2, make sure to review all of the requirements that follow. Requirements for using PHStat2: Windows 98/98SE/ME/NT 4.0/2000/XP......

Words: 2397 - Pages: 10

...| 102 | Number of reported errors | 11 | 12 | 6 | 9 | 10 | At 5% level of significance, is there sufficient evidence to conclude that the proportions of errors in transactions assigned to each of the 5 memory locations are all different? To use Excel Click Add-ins| PHStat | Multiple sample tests | Chi-square test | Question 2 (20 Marks) One criterion used to evaluate employees in the assembly section of a large factory is the number of defective pieces per 1,000 parts produced. The quality control department wants to find out whether there is a relationship between years of experience of employees and defect rate. Since the job is repetitious, after the initial training period any improvement due to a learning effect might be offset by a loss of motivation. A defect rate is calculated for each worker in a yearly evaluation. The results for 100 workers are given in the table below. Defect rate | Years since Training Period | | < 1 Year | 1-4 Years | 5-9 Years | High | 6 | 9 | 9 | Average | 9 | 19 | 23 | Low | 7 | 8 | 10 | At the 0.05 level of significance, test whether there is a relationship between defect rate and years of experience. To use Excel Click Add-ins| PHStat | Multiple sample tests | Chi-square test | Question 3 (15 Marks) A vice president for marketing recently recruited 20 outstanding college graduates to be trained in sales and management. The 20 individuals are randomly assigned, 10 each, to one of two groups. A......

Words: 1918 - Pages: 8

...PHStat2 readme file. PHStat2 is Windows software that assists you in learning the concepts of statistics while using Microsoft Excel. PHStat2 allows you to perform many common types of statistical analyses working with and using the familiar Microsoft Excel interface. PHStat2 is an enhanced version of the original PHStat statistical add-in system. If you have used PHStat previously, read the "What's New?" section to discover the improvements that PHStat2 contains. (In your textbook, you should interpret any general reference to "PHStat" as a reference to PHStat2.) The rest of this document is organized into sections to assist you in setting up and using PHStat2. The “What’s New in PHStat2” section of this file can also be found in the PHStat2 help system (select Help for PHStat2 from the PHStat menu in Microsoft Excel and look in the “Welcome to PHStat2” topic). Table of Contents 1PHStat2 technical requirements 2Configuring Microsoft Excel for PHStat2 3Setting up PHStat2 4Using PHStat2 5Updating PHStat2 6Troubleshooting PHStat2 7What's New in PHStat2? 1 PHStat2 technical requirements To set up and use PHStat2 successfully, your computer system must meet the following technical requirements. -Windows 95, Windows 98, Windows 98 SE, Windows ME, Windows NT 4.0, Windows 2000, or Windows XP operating systems. -Microsoft Excel 97 or later, including Excel 2000 and Excel 2002 (Excel XP). If you are using Microsoft Excel 97, you must have previously applied at least...

Words: 2040 - Pages: 9

...chart, Bar chart, and Pareto chart for the Rate variable using PHStat – One-Way Tables and Charts. Copy and paste the table and charts into your word document and answer the following questions: (a) From the table which is the least frequent absenteeism rate? (b) From the Bar chart which two absenteeism rates are the most frequent? (c) From the pie chart what is percent of absenteeism rate high? (d) From the Pareto chart the two most frequent two absenteeism rates contribute what percentage together? (1 point) How-to: Click on Add-Ins - PHSTAT - Descriptive Statistics and choose One Way Tables and Charts. Check Raw Categorical data. Click in the Raw Data Cell Range window and then highlight the entire column labeled Rate. Choose the pie, bar charts since you will need all these at some point. PHStat puts the table on 1 sheet and the graphs on another, but you can change the location of the graphs by right clicking on the graph and choosing ‘Move’ and put it in the same sheet as the table if you wish. 4. From the file PS1_F13_Absent.xlsx, (a) Create and attach a frequency, percent, and cumulative % table for the Wage variable. Use the bins in cells L1:L8 or create your own if preferred. (b) Which bin has the smallest frequency? What range of values for Wage does this represent? (c) What percent of employees make more than or equal to $50,000? (1 point). Click on PHStat – Descriptive Statistics – Frequency Distribution. ......

Words: 907 - Pages: 4

...chart, Bar chart, and Pareto chart for the Rate variable using PHStat – One-Way Tables and Charts. Copy and paste the table and charts into your word document and answer the following questions: (a) From the table which is the least frequent absenteeism rate? (b) From the Bar chart which two absenteeism rates are the most frequent? (c) From the pie chart what is percent of absenteeism rate high? (d) From the Pareto chart the two most frequent two absenteeism rates contribute what percentage together? (1 point) How-to: Click on Add-Ins - PHSTAT - Descriptive Statistics and choose One Way Tables and Charts. Check Raw Categorical data. Click in the Raw Data Cell Range window and then highlight the entire column labeled Rate. Choose the pie, bar charts since you will need all these at some point. PHStat puts the table on 1 sheet and the graphs on another, but you can change the location of the graphs by right clicking on the graph and choosing ‘Move’ and put it in the same sheet as the table if you wish. 4. From the file PS1_F13_Absent.xlsx, (a) Create and attach a frequency, percent, and cumulative % table for the Wage variable. Use the bins in cells L1:L8 or create your own if preferred. (b) Which bin has the smallest frequency? What range of values for Wage does this represent? (c) What percent of employees make more than or equal to $50,000? (1 point). Click on PHStat – Descriptive Statistics – Frequency Distribution. ......

Words: 907 - Pages: 4

...3 | 0 | 3 | 1 | 150 | 1 | 4 | 300 | 4 | 1 | 300 | 1 | 5 | 150 | 5 | 1 | 100 | 2 | 4 | 300 | 4 | 2 | 200 | 3 | 4 | 250 | 4 | 3 | 300 | 3 | 5 | 300 | 5 | 3 | 250 | 4 | 5 | 100 | 5 | 4 | 0 | Determine the maximum flow (in hundreds of gallons of water per minute) from node 1 to node 5 55,000 gallons of water per minute (see excel file tab #5 for Windows QM output) 6. The governor of Michigan believes that the state can improve the state’s crime rate if the state can reduce the college debt carried by its citizens and if they can increase the percent of the population covered by health insurance. 1. Using the States Data Set and PHStat, create the multiple regression prediction equation. Y = 214.63 + (-0.0041*college debt) + (19.97*not covered) (see excel tab “6 COMPUTE” for PHStat multiple regression output and equation) 2. Predict the crime rate for Michigan if the college debt were $25,000 and the percent not covered by insurance was 10? Y = 214.63 + (-0.0041*25,000) + (19.97*0.10) Y = 114.13 7. A concessionaire for the local ballpark has developed a table of conditional values for the various alternatives (stocking decisions) and states of nature (size of crowd). Stocking Decision | Large Crowd ($) | Average Crowd ($) | Small Crowd ($) | Large Inventory | $22,000 | $12,000 | -$2,000 | Average Inventory | $15,000 | $12,000 | $6,000 | Small Inventory | $9,000 | $6,000 | $5,000 | If the probabilities associated with......

Words: 1250 - Pages: 5

...contract wishes to be 95 percent sure of finishing by the due date, use the NORMINV Excel Function to determine what due date (project week #) should be negotiated? 84 project weeks . Below is the input info: . 5. In a state lottery participants select 8 numbers between 1 and 49. At the end of the week, the state lottery commission randomly draws 8 numbers between 1 and 49. How many different possible winning number combinations could be drawn by the lottery commission? There are 450978066 possible winning number combinations. =COMBIN(49,8) in Excel. 6. From the Salary Data Set and assuming that the salary data is a random sample from the population of salaries from the multi-national company use the 95% confidence level in PHStat to estimate the mean beginning salary for company executives. 1. The 95% confidence level interval is: Company Mean | | | | Data | Sample Standard Deviation | 8327.099004 | Sample Mean | 16968.6 | Sample Size | 100 | Confidence Level | 95% | | | Intermediate Calculations | Standard Error of the Mean | 832.7099004 | Degrees of Freedom | 99 | t Value | 1.9842 | Interval Half Width | 1652.2771 | | | Confidence Interval | Interval Lower Limit | 15316.32 | Interval Upper Limit | 18620.88 | 2. If you were to change the confidence level to 99%, what would happen to the confidence interval? What is the 99% confidence interval? Company mean 99% | | | | Data | Sample......

Words: 1204 - Pages: 5

...or below. The firm examined 35 randomly chosen fax transmissions during the next year, yielding a sample mean of 14.44 with a standard deviation of 4.45 pages. (a) At the .01 level of significance, is the true mean greater than 10? (b) Use Excel to find the right-tail p-value. [Use Excel- Megastat, hypothesis tests, mean vs. hypothesized value, z-test or Use Phstat, one-sample tests, z-test for the mean, sigma known. Show all 5-step procedure for hypothesis test. See the model example in the lecture - one population test for a small sample]. * * 2. Chapter Exercises 9.64 An auditor reviewed 25 oral surgery insurance claims from a particular surgical office, determining that the mean out-of-pocket patient billing above the reimbursed amount was $275.66 with a standard deviation of $78.11. (a) At the 5 percent level of significance, does this sample prove a violation of the guideline that the average patient should pay no more than $250 out-of-pocket? State your hypotheses and decision rule. (b) Is this a close decision? [Use Excel- Megastat, hypothesis tests, mean vs. hypothesized value, t-test or Use Phstat, one-sample tests, t-test for the mean, sigma unknown. Show all 5-step procedure for hypothesis testing. See the model example in the lecture - one population test for a small sample]....

Words: 286 - Pages: 2

...applied. Microsoft Excel Data Analysis ToolPak and Analysis ToolPak–VBA add-ins installed (supplied on the Microsoft Office/Excel program CD). For Excel 2000 through Excel 2003, Microsoft Office macro security level set to Medium (see topic 3 in “Configuring Microsoft Excel Security for PHStat2”) For Excel 2007, Trust Center Macro Settings set to Disable all macros with notification (recommended) or Enable all macros (not recommended). See section 3a or 3b for more details. (There are no security settings in Excel 97 or the original, unpatched version of Excel 2000.) Updated anti-virus program, optional but recommended. Internet access for downloading Microsoft Excel updates from www.microsoft.com and PHStat2 updates from www.prenhall.com/phstat, as they become available. Optional but recommended. Requirements for running the PHStat2 setup program: CD or DVD drive. Approximately 10 MB hard disk free space while running the setup program and 3 MB hard disk space after program setup. On some older systems, the Windows system files that may get replaced or added during the setup process will require up to 6 MB additional hard disk space. Windows user account with administrator or software-installing privileges (applies only to Windows NT/2000/XP/Vista or networked users only). Student or faculty accounts used to login onto networked computers in academic settings typically do not have this privilege. If you have such an account, ask your network or lab technician for......

Words: 2026 - Pages: 9