Zum Hauptinhalt springen
Dekorationsartikel gehören nicht zum Leistungsumfang.
Excel Statistics
A Quick Guide
Taschenbuch von Neil J. Salkind
Sprache: Englisch

47,70 €*

inkl. MwSt.

Versandkostenfrei per Post / DHL

Aktuell nicht verfügbar

Kategorien:
Beschreibung
Ideal for those already familiar with basic Excel features, this updated Third Edition of Neil J. Salkind's Excel Statistics: A Quick Guide shows readers how to utilize Microsoft® Excel's functions and Analysis ToolPak to answer simple and complex questions about data. Part I explores 35 Excel functions, while Part II contains 20 Analysis ToolPak tools. To make it easy to see what each function or tool looks like when applied, at-a-glance two-page spreads describe each function and its use with corresponding screenshots. In addition, actual data files used in the examples are readily available online at an open-access Student Study Site.
Ideal for those already familiar with basic Excel features, this updated Third Edition of Neil J. Salkind's Excel Statistics: A Quick Guide shows readers how to utilize Microsoft® Excel's functions and Analysis ToolPak to answer simple and complex questions about data. Part I explores 35 Excel functions, while Part II contains 20 Analysis ToolPak tools. To make it easy to see what each function or tool looks like when applied, at-a-glance two-page spreads describe each function and its use with corresponding screenshots. In addition, actual data files used in the examples are readily available online at an open-access Student Study Site.
Über den Autor

Neil J. Salkind received his PhD in human development from the University of Maryland, and after teaching for 35 years at the University of Kansas, he was Professor Emeritus in the Department of Psychology and Research in Education, where he collaborated with colleagues and work with students. His early interests were in the area of children's cognitive development, and after research in the areas of cognitive style and (what was then known as) hyperactivity, he was a postdoctoral fellow at the University of North Carolina's Bush Center for Child and Family Policy. His work then changed direction to focus on child and family policy, specifically the impact of alternative forms of public support on various child and family outcomes. He delivered more than 150 professional papers and presentations; written more than 100 trade and textbooks; and is the author of Statistics for People Who (Think They) Hate Statistics (SAGE), Theories of Human Development (SAGE), and Exploring Research (Prentice Hall). He has edited several encyclopedias, including the Encyclopedia of Human Development, the Encyclopedia of Measurement and Statistics, and the Encyclopedia of Research Design. He was editor of Child Development Abstracts and Bibliography for 13 years. He lived in Lawrence, Kansas, where he liked to read, swim with the River City Sharks, work as the proprietor and sole employee of big boy press, bake brownies (see [...] for the recipe), and poke around old Volvos and old houses.

Inhaltsverzeichnis
PART I: Using Excel Functions
1. Computing Averages
The AVERAGE Function
The AVERAGE A Function
The MEDIAN Function
The [...] Function
The [...] Function
GEOMEAN Function
2. Looking at Variability
The STDEV.S Function
The STDEV.P Function
The VAR.S Function
The VAR.P Function
3. Describing Data
The FREQUENCY Function
The [...] Function
The [...] Function
The [...] Function
The [...] Function
The [...] Function
The STANDARDIZE Function
4. Looking at Relationships
The COVARIANCE.S Function
The CORREL Function
The PEARSON Function
The INTERCEPT Function
The SLOPE Function
The TREND Function
The FORECAST Function
The RSQ Function
5. Testing Independence
The [...] Function
The [...] Function
6. Testing Significance
The [...] Function
The [...] Function
The [...] Function
The [...] Function
The [...] Function
The [...] Function
7. Looking at Data
The SMALL Function
The LARGE Function
The AVERAGEW IF Function
The COUNT Function
The COUNTA Function
The COUNTBLANK Function
The COUNTIF Function
PART II: Using the Analysis ToolPak
8. Describing Data
Descriptive Statistics
Moving Average
Random Number Generation
Rank and Percentile
Sampling
9. Comparing Means
z-Test: Two-Sample for Means
t-Test: Paired Two-Sample for Means
t-Test: Two-Sample Assuming Unequal Variances
t-Test: Two-Sample Assuming Equal Variances
Anova: Single Factor
Anova: Two-Factor With Replication
Anova: Two-Factor Without Replication
10. Looking at Relationships
The Correlation Tool
The Regression Tool
11. Illustrating Data
The Histogram Tool
Details
Medium: Taschenbuch
ISBN-13: 9781483374048
ISBN-10: 1483374041
Sprache: Englisch
Ausstattung / Beilage: Paperback
Einband: Kartoniert / Broschiert
Autor: Salkind, Neil J.
Auflage: 3. Auflage
Hersteller: Sage Publications, Inc
Maße: 235 x 191 x 9 mm
Von/Mit: Neil J. Salkind
Erscheinungsdatum: 01.07.2015
Gewicht: 0,327 kg
Artikel-ID: 108151024
Über den Autor

Neil J. Salkind received his PhD in human development from the University of Maryland, and after teaching for 35 years at the University of Kansas, he was Professor Emeritus in the Department of Psychology and Research in Education, where he collaborated with colleagues and work with students. His early interests were in the area of children's cognitive development, and after research in the areas of cognitive style and (what was then known as) hyperactivity, he was a postdoctoral fellow at the University of North Carolina's Bush Center for Child and Family Policy. His work then changed direction to focus on child and family policy, specifically the impact of alternative forms of public support on various child and family outcomes. He delivered more than 150 professional papers and presentations; written more than 100 trade and textbooks; and is the author of Statistics for People Who (Think They) Hate Statistics (SAGE), Theories of Human Development (SAGE), and Exploring Research (Prentice Hall). He has edited several encyclopedias, including the Encyclopedia of Human Development, the Encyclopedia of Measurement and Statistics, and the Encyclopedia of Research Design. He was editor of Child Development Abstracts and Bibliography for 13 years. He lived in Lawrence, Kansas, where he liked to read, swim with the River City Sharks, work as the proprietor and sole employee of big boy press, bake brownies (see [...] for the recipe), and poke around old Volvos and old houses.

Inhaltsverzeichnis
PART I: Using Excel Functions
1. Computing Averages
The AVERAGE Function
The AVERAGE A Function
The MEDIAN Function
The [...] Function
The [...] Function
GEOMEAN Function
2. Looking at Variability
The STDEV.S Function
The STDEV.P Function
The VAR.S Function
The VAR.P Function
3. Describing Data
The FREQUENCY Function
The [...] Function
The [...] Function
The [...] Function
The [...] Function
The [...] Function
The STANDARDIZE Function
4. Looking at Relationships
The COVARIANCE.S Function
The CORREL Function
The PEARSON Function
The INTERCEPT Function
The SLOPE Function
The TREND Function
The FORECAST Function
The RSQ Function
5. Testing Independence
The [...] Function
The [...] Function
6. Testing Significance
The [...] Function
The [...] Function
The [...] Function
The [...] Function
The [...] Function
The [...] Function
7. Looking at Data
The SMALL Function
The LARGE Function
The AVERAGEW IF Function
The COUNT Function
The COUNTA Function
The COUNTBLANK Function
The COUNTIF Function
PART II: Using the Analysis ToolPak
8. Describing Data
Descriptive Statistics
Moving Average
Random Number Generation
Rank and Percentile
Sampling
9. Comparing Means
z-Test: Two-Sample for Means
t-Test: Paired Two-Sample for Means
t-Test: Two-Sample Assuming Unequal Variances
t-Test: Two-Sample Assuming Equal Variances
Anova: Single Factor
Anova: Two-Factor With Replication
Anova: Two-Factor Without Replication
10. Looking at Relationships
The Correlation Tool
The Regression Tool
11. Illustrating Data
The Histogram Tool
Details
Medium: Taschenbuch
ISBN-13: 9781483374048
ISBN-10: 1483374041
Sprache: Englisch
Ausstattung / Beilage: Paperback
Einband: Kartoniert / Broschiert
Autor: Salkind, Neil J.
Auflage: 3. Auflage
Hersteller: Sage Publications, Inc
Maße: 235 x 191 x 9 mm
Von/Mit: Neil J. Salkind
Erscheinungsdatum: 01.07.2015
Gewicht: 0,327 kg
Artikel-ID: 108151024
Warnhinweis