Statistical Fundamentals: Using Microsoft Excel for Univariate and Bivariate Analysis

Rovai, Alfred P

ISBN 10: 0991104609 / ISBN 13: 9780991104604

Published by Watertree Press, 2014

About this Item

Ships same or next business day with delivery confirmation. Good condition. May or may not contain highlighting. Expedited shipping available.

Seller Inventory # 1000006874296-2495

Bibliographic Details

• Title: Statistical Fundamentals: Using Microsoft Excel for Univariate and Bivariate Analysis
• Publisher: Watertree Press
• Publication Date: 2014
• Language: English
• ISBN 10: 0991104609
• ISBN 13: 9780991104604
• Binding: Soft cover
• Condition: Good

About this title

Synopsis

The purpose of this book is to provide a working background of descriptive and inferential statistics and step-by-step examples of how to perform various statistical procedures using Micro- soft Excel's native operators and functions. Automated procedures are also described using Excel's Analysis TookPak and AnalystSoft StatPlus.

From the Back Cover

The purpose of this book is to provide a working background of descriptive and inferential statistics and step-by-step examples of how to perform various statistical procedures using Microsoft Excel's native operators and functions. Automated procedures are also described using Excel's Analysis TookPak and AnalystSoft StatPlus. Below is a list of the hypothesis tests described in this book.

Goodness-of-Fit Tests
One-Sample t-Test, Binomial Test, Chi-Square Goodness-of-Fit Test, Kolmogorov-Smirnov Test
Comparing Two Independent Samples
F-Test of Equality of Variance, Independent t-Test, Mann-Whitney U Test, Pearson Chi-Square Contingency Table Analysis
Comparing Multiple Independent Samples
One-Way Between Subjects ANOVA, Kruskal-Wallis H Test
Comparing Two Dependent Samples
Dependent t-Test, Wilcoxon Matched-Pair Signed Ranks Test, Related Samples Sign Test, McNemar Test
Comparing Multiple Dependent Samples
One-Way Within Subjects ANOVA, Friedman Test
Correlations
Pearson Product-Moment Correlation Test, Partial and Semipartial Correlation, Reliability Analysis (Split-Half and Cronbach's alpha), Spearman Rank Order Correlation Test, Phi, Cramér's V
Linear Regression
Bivariate Regression