[Free ebook]Statistical Fundamentals: Using Microsoft Excel for Univariate and Bivariate Analysis - KING OF EXCEL

    • Thursday, January 16, 2020

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

    [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
    Tags
    Share This
    Author Image

    About KingExcel.info

    às
    Marcadores:

    Popular Posts

    Popular Posts

    Popular Posts