[Free ebook]Statistical Fundamentals: Using Microsoft Excel for Univariate and Bivariate Analysis

[Free ebook]Statistical Fundamentals: Using Microsoft Excel for Univariate and Bivariate Analysis

DOWNLOAD PDF
DOWNLOAD Mobi
DOWNLOAD EPUB

Description

Product Description

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.

From the Author

Most people are aware of the high tuition costs that come with a college education. However, textbooks are also increasing in price. According to the Twenty Million Minds Foundation, the average amount that college students spend on textbooks has risen from about $900 to almost $1,300 per year in the past few years.

I got an idea regarding a deeply discounted textbook when discussing Clayton Christensen's work on disruptive innovation at the university where I worked. Disruptive innovation is a term coined by Mr. Christensen that describes a process by which a product or service takes root initially in simple applications at the bottom of a market and then relentlessly moves upmarket, eventually displacing established competitors. At the meetings we were discussing models to reduce tuition expenses. However, we thought the concept could also be applied to textbooks, since they, like tuition, have become so expensive.

I decided to move forward with this concept. I initially co-wrote a textbook for courses on research design and statistics using SPSS (which I taught in the past). The paperback version is 630 8x10 pages long with a $29.95 list price. It is a substantial book with an extraordinary low list price for a research textbook. E-book versions go for $9.99. This one book replaces two textbooks I used in my courses -- one lists for $118.60 (on SPSS) and the other $154 (on statistics). The book I co-wrote covers the content of these two books and more. Replacing the two textbooks with this textbook saves students over $200 for a single course! If this is not a disruptive use of technology, I don't know what is. I then got the idea to write a similar textbook using Microsoft Excel instead of IBM SPSS since Excel is relatively inexpensive and widely available. At first I was skeptical that I could perform hypothesis tests to the same level of accuracy using Excel, but I discovered I could and I was able to check my results using SPSS. The result is this book (paperback and Kindle versions) on statistics using Microsoft Excel. I hope you find it useful.

Alfred P. Rovai
Chesapeake, Virginia

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

About the author

Follow the author to get new release updates and improved recommendations.
Alfred P. Rovai
Fred, a native of San Jose, California, received a BA degree (mathematics) from San Jose State University, an MA degree (public administration) from the University of Northern Colorado, and an MS degree (education) and PhD degree (academic leadership) from Old Dominion University. He also completed postgraduate work in systems management at the University of Southern California and possesses a postgraduate professional license in mathematics from the Commonwealth of Virginia. Following his retirement from the U.S. Army (his last military assignment was dean at the Joint Forces Staff College), he served as a faculty member at Old Dominion University and then at Regent University and retired in December 2011 as Associate Vice President for Academic Affairs, Regent University. During his career in academe he authored or co-authored six books, multiple chapters in edited books, and more than 50 articles in scholarly journals and served on four editorial review boards. He presently writes, consults, and serves as an adjunct professor teaching graduate-level research design and statistics courses online.
#evba #etipfree #kingexcel

1000 Excel and VBA ebooks free Download on EVBA.info and EtipFree.com





Please Download by this link below 📤

500+ VBA ebooks free Download











Please Download by this link below 📤


📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1


#evba #etipfree #kingexcel

Leave a Comment

Powered by Blogger.