PHStat4.1(EXCEL统计插件).zip_phstat资源-CSDN文库

共5个文件

pdf：2个

xlam：1个

epub：1个

其他资源

2星需积分: 50 188 浏览量 2019-09-02 11:28:22 上传评论 1 收藏 3.31MB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

PHStat_4.1.zip （5个子文件）

PHStat 4

PHStatHelp.pdf 2.27MB

PHStatHelp.chm 163KB

PHStat readme.pdf 179KB

PHStatHelp.epub 107KB

PHStat.xlam 764KB

PHStat Help

for Version 4.1

Note:

To change the product logo for your ow n print manual or

PDF, click "Tools > Manual Designer" and modify the print

manual template.

Title page 1

Use this page to introduce the product

by Pearson Education, Inc.

This is "Title Page 1" - you may use this page to introduce

your product, show title, author, copyright, company logos,

etc.

This page intentionally starts on an odd page, so that it is on

the right half of an open book from the readers point of view.

This is the reason why the previous page was blank (the

previous page is the back side of the cover)

mechanical, including photocopying, recording, taping, or information storage and retrieval systems - without the

written permission of the publisher.

Products that are referred to in this document may be either trademarks and/or registered trademarks of the

respective owners. The publisher and the author make no claim to these trademarks.

While every precaution has been taken in the preparation of this document, the publisher and the author assume no

responsibility for errors or omissions, or for damages resulting from the use of information contained in this

document or from the use of programs and source code that may accompany it. In no event shall the publisher and

the author be liable for any loss of profit or any other commercial damage caused or alleged to have been caused

directly or indirectly by this document.

Printed: February 2016 in (whereever you are located)

PHStat Help

Publisher

Special thanks to:

All the people who contributed to this document, to mum and dad

and grandpa, to my sisters and brothers and mothers in law, to our

secretary Kathrin, to the graphic artist who created this great product

logo on the cover page (sorry, don't remember your name at the

moment but you did a great work), to the pizza service down the

street (your daily Capricciosas saved our lives), to the copy shop

where this document will be duplicated, and and and...

Last not least, we want to thank EC Software who wrote this great

help tool called HELP & MANUAL which printed this document.

Managing Editor

Technical Editors

Cover Designer

...enter name...

Production

...enter name...

Team Coordinator

...enter name...

PHStat Help4

Table of Contents

Foreword 7

Part I Welcome to PHStat

................................................................................................................................... 81 Welcome

................................................................................................................................... 82 What's New?

.......................................................................................................................................................... 8New Statistical Procedures

.......................................................................................................................................................... 8PHStat Revision History

Part II PHStat Quick Start Guide

................................................................................................................................... 101 What is PHStat?

................................................................................................................................... 102 What PHStat is not

................................................................................................................................... 103 How PHStat Presents Its Results

................................................................................................................................... 114 Preparing Data for Analysis

................................................................................................................................... 115 Using PHStat

Part III PHStat Technical Reference

................................................................................................................................... 121 PHStat Technical Requirements

................................................................................................................................... 122 Configuring Microsoft Windows Excel Security

................................................................................................................................... 133 Updating PHStat

Part IV Data Preparation Procedures

................................................................................................................................... 141 Stack Data

................................................................................................................................... 142 Unstack Data

Part V Descriptive Statistics Procedures

................................................................................................................................... 151 Boxplot

................................................................................................................................... 152 Descriptive Summary

................................................................................................................................... 163 Dot Scale Diagram

................................................................................................................................... 164 Frequency Distribution

................................................................................................................................... 175 Histogram & Polygons

................................................................................................................................... 186 Scatter Plot

................................................................................................................................... 187 Stem-and-Leaf Display

................................................................................................................................... 198 One-Way Tables & Charts

................................................................................................................................... 209 Two-Way Tables & Charts

Part VI Decision-Making Procedures

................................................................................................................................... 211 Covariance and Portfolio Management

................................................................................................................................... 212 Expected Monetary Value

................................................................................................................................... 223 Expected Opportunity Loss

5Contents

................................................................................................................................... 224 Opportunity Loss

Part VII Probability & Prob. Distributions

................................................................................................................................... 231 Simple & Joint Probabilities

................................................................................................................................... 232 Normal Probability Distribution

................................................................................................................................... 233 Normal Probability Plot

................................................................................................................................... 244 Binomial Probability Distribution

................................................................................................................................... 245 Exponential Probability Distribution

................................................................................................................................... 246 Hypergeometric Probability Distribution

................................................................................................................................... 257 Poisson Probability Distribution

Part VIII Sampling Procedures

................................................................................................................................... 261 Sampling Distributions Simulation

Part IX Confidence Intervals Procedures

................................................................................................................................... 271 Estimate for the Mean, sigma known

................................................................................................................................... 272 Estimate for the Mean, sigma unknown

................................................................................................................................... 283 Estimate for the Population Variance

................................................................................................................................... 284 Estimate for the Proportion

................................................................................................................................... 285 Estimate for the Population Total

................................................................................................................................... 296 Estimate for the Total Difference

Part X Sample Size Procedures

................................................................................................................................... 301 Sample Size Determination for the Mean

................................................................................................................................... 302 Sample Size Determination for the Proportion

Part XI One-Sample Procedures

................................................................................................................................... 311 Z Test for the Mean, sigma known

................................................................................................................................... 312 t Test for the Mean, sigma unknown

................................................................................................................................... 323 Chi-Square Test for the Variance

................................................................................................................................... 324 Z Test for the Proportion

Part XII Two-Sample Procedures (Unsummarized

Data)

................................................................................................................................... 341 Pooled-Variance t Test (unsummarized data)

................................................................................................................................... 342 Separate-Variance t Test (unsummarized data)

................................................................................................................................... 353 Paired t Test (unsummarized data)

................................................................................................................................... 354 F Test for Differences in Two Variances (unsummarized data)

................................................................................................................................... 365 Wilcoxon Rank Sum Test

Part XIII Two-Sample Procedures (Summarized Data)

................................................................................................................................... 371 Pooled-Variance t Test