Step-By-Step, Complete, and Easy To Understand

Advanced Statistics in Excel

Thousands of Worked-Out Examples in Excel

In the 62-Chapter, 1100+Page pdf eBook
and the Attached Excel Workbook With ALL Examples


Read What Students In Difficult Statistics Courses Just Like You And Their Professors Are Saying About The Excel Statistical Master:

"I bought Mark Harmon's Excel Master Series manual as a reference for a graduate course on statistics that I was taking as part of an MBA program at the University of Delaware. I purchased the materials about halfway through the course and wish I had known about this manual from the start of the class!

Mark has done a great job in writing complex statistical concepts in an easy to understand format that makes grasping them both easy to understand and to use.

With the help of Mark's book, and some diligent studying, I received an A in my stats course.

Thanks Mark!"

Chris Veale
Newark, Delaware

"The Excel Statistical Master really saved me in my graduate statistics class last semester. The book that was used in the class really did not give the practical down to earth instructions I needed to apply my statistical knowledge to excel.

In this quide I was able to find helpful step by step instructions (and pictures) that walked me through creating ANOVA's, Hypothesis testing, and so much more.

I highly recommend this book for graduate students and managers who are looking to maximize the power of Excel in their daily operational activities."

Christopher M. Walden
Jacksonville Beach, Florida

"Mark, Thanks for your invaluable material. I have used it in my current business research methods for my bachelor students. It has enabled me to abandon SPSS for the first time!

I have also given your link to
the last MBA class I had. They told me that your book was of great help to understand my course!"

Professor Emmanuel Fragnière
HEG Geneva and University of Bath

"Faced with a seemingly intractable spreadsheet assignment for my online Operational Research course at a UK university and very little time, my purchase of this book could not have come at a better time.

With clear steps to follow, mastering the Statistical 'matter' and being able to apply them with Microsoft Excel assisted a great deal and broke down the 'hard nuts' in my spreadsheet assignment quickly.

I recommend this book if you are afraid of 'statistics'.  It'll definitely drive those fears far away."

Toyin Lamikanra
Online Masters Program in Operational Research
University of Strathclyde

"After years of searching for a simplified statistics book, I found the Excel Statistical Master.

Unlike the indecipherable jargon in the countless books I have wasted money on,
the language in this book is plain and easy to understand.

This is the best $40 I have ever spent.
"

Mahdi Raghfar
New York, New York

"Currently I am teaching MBA courses at New York and I must say, I really like the Excel Statistical Master. It is incredibly useful. The explanations and videos in the manual are excellent.

It has really made my work with statistics a LOT easier. I'm really glad that I came across the manual.

If you're a student of business statistics, this e-manual is worth WAY more it's priced. My students that I have referred to this manual told me that it really helped with several courses. My students all stated, and I agree, that the explanations are clear and easy-to-follow, and the manual is comprehensive."

Dr. Yan Qin

Adjunct Assistant Professor of New York University

Adjunct Assistant Professor of Keller Graduate School of Management

Co-director, Nankai-Grossman Research Center
New York, New York


"I am a medical student at Semmelweis University in Budapest and the Excel Statistical Master helped me so much with passing my midterms and my semifinal exam. There is no way I would have passed without it.

Even though I went to all of the classes and consultations, it was the Excel Statistical Master that taught me all of the basic concepts for the different tests we used. 

Each test is explained in different steps and how you performed it on Excel. Illustrations and screenshots make it easy to follow, even for those like me that never had used Excel before.

I highly recommend Excel Statistical Master for all medical students. It's worth every dollar. And I have to say that the communication with the seller have been the best! If I had questions about statistics problems, he more than gladly answered them. It's so easy and saved my from hours with reading!

Thanks a lot!"

Annette Myhre
Medical Student
Semmelweis University
Budapest, Hungary

"I am taking evening courses to get my degree in business administration at the University of Applied Sciences in Friedberg, Germany. During the day I am a sales manager in a production facility.

For my bachelors thesis, I am performing a comprehensive statistical analysis of repair costs at the facility that I work.

After searching for days on Google for the right framework to solve this problem, I finally found the solution. The Excel Statistical Master has allowed me to find exactly the right distributions and showed me how to create some excellent graphs. The explanations and videos in the manual are excellent, even for a non-native English speaker!

Thanks Mark!"

Frank A. Mathias
Facility Management Major
Bachelor of Business Administration
University of Applied Sciences
Friedberg, Germany

"I am a recent MBA student from a top 10 business school in the US. I bought this product to supplement by knowledge about Statistics and haven't regretted about the decision.

The book is an excellent source of easy to understand material. The videos have helped me immensely in my advanced marketing classes such as pricing and data driven marketing.

I highly recommend it to any current student or a working professional as a one stop shop for stats."

Amit Dingare
New York, New York

"I purchased the Excel Statistical Master program to serve as an additional point of reference, to compliment my textbooks in my MBA Statistics class. The Excel Statistical Master program served that purpose.

The step-by-step instructions and video demonstrations provided an easy-to-understand platform.

I would encourage both students and professionals needing to perform data analysis to purchase the Excel Statistical Master program.

The Excel Statistical Master program is a fantastic tool for anyone desiring to “make sense” of the data available to them."

James Daniel
MBA Candidate
Executive MBA Program
Mays Business School Texas A&M University

“Bless you Mark,

Do you know how many students drop out of Stats with Excel courses because of the enormity of the course? And none of the teachuhow excel online courses ever cover the extent of stats needed.

This is great to know someone is out there to help the MBAs.

Wish you every success Mark.”

Susie Rust
MBA Candidate
Finance and Entrepreneurship Majors
Graziadio School of Business and Management
Pepperdine University
Los Angeles, California

"I bought the Excel Statistical Master to help me in my statistics class. I must say, it was unbelievably useful. Not only did I master statistics in Excel, but the e-manual actually did a much better job of explaining statistics than my text book did.

That e-manual made my statistics class much easier to understand, and I am now able to do all of that stuff in Excel, easily ! It is a GREAT book !
If you're a student or business manager wanting to learn statistics, this is easiest, fastest way to do it.

Thank you again for everything."

Tiran Ovsepyan
North Hollywood, California

"The Excel Statistical Master is being used for my MBA Thesis. I am using it to generate statistical analysis of my quantitative thesis study. It makes statistical calculation more meaningful. As I am working on my MBA thesis, I use it to generate statistics from the survey results that I collect.

It is one tool no one can be without, especially  students. I will also use it when I start my Business in Healthcare Statistics.

Thank you."

Vilma L Johnson, M.Sc., CISA
MBA Candidate
Union Park, Florida


"It is terrific that you offer this ebook; you are doing a tremendous service for people and I thank you for that. This is such a useful tool that you are providing.

Statistics can be an intimidating subject and this is the only product out there that cuts through the complexities and gives a clear, easy to understand overview.

If you offer other products in the future, please feel free to put me on your marketing list. It is refreshing to meet good people that are willing to share valuable information.

Best Regards,"

Chris Leal
Irvine, California


"At first I was quite skeptical of this book and the attendant Microsoft Excel spreadsheets. Everyone touts how easy their product is and how you really "need" their product to be successful.

For one of the few times I can remember, that claim is fulfilled with this product.

I have been using Excel since the product first came out on the Macintosh. But the Excel Master series has shown me how really limited my knowledge was and how much there is yet to learn.

The Excel Master series is certainly an enjoyable and well constructed method of learning statistics. The quality of the author's effort to reduce a relatively boring subject to easily understood examples and text is evident throughout.

 I highly recommend this series to anyone interested in the application of statistics to everyday problems using to most powerful computer environment available."

John G. Black
Warriors Mark, Pennsylvania
Read What Professionals Who Needed To Master Statistics To Solve Real Problems At Work Are Saying About The Excel Statistical Master:

"We just started building statistical Excel spreadsheets for our direct mail and online marketing campaigns, I purchased Excel Statistical Master to help fill in some of the blanks.

Little did I know, this book has everything I could ever want to know about business statistics.
Easy to follow and written so even a child could understand some of the most complex statistical theories.

Thanks Mark!"

Brandon Congleton Marketing Director www.WorldPrinting.com
Clearwater, Florida


"Whenever I evaluate a book on statistics, I always look at the table of contents to check both the topics covered and the examples.

Not only does the author cover all of the techniques you're likely to need in a graduate program, he also goes into substantial detail on when to use each technique.

I also found that his case studies and focused examples, all of which are listed in the detailed table of contents, were on point and good learning tools that will help learners know when and how to apply the techniques.

His explanations, particularly on when (and how) to use two-tailed tests for hypothesis testing and the Poisson and exponential distributions, were clear and will help anyone learn how to implement these techniques.

In particular, this book will help anyone without a substantial background in math, such as many political science M.A. students, to learn and apply the concepts.

Practical and Clear Graduate Statistics in Excel is very well done and well worth your money."

Curtis D. Frye
Author of
Microsoft Excel 2010 Plain & Simple

"The Excel Statistical Master is a real life saver in my forensic accounting practice. Until I found the package I was struggling with some of the "how to" aspects of statistics..no more. The videos are an extra bonus that really help!

I am very pleased!!!"

Glenn Forrest
Seattle, Washington


"I'm a Statistician with more than 25 years of field work, at the same time I'm probably the top MS Excel expert in the Middle East.

Excel now is a Universal tool and an absolute must for those wishing to understand practical Statistics and applying Statistics to a very large percentage of real life situations.

All of the above facts require a clear understanding of the statistical features and capabilities of Excel. What is needed is a guide that takes you to the point DIRECTLY.

As an Instructor Mr. Harmon's excellent work saves me considerable time, and should help all students. And as a quick and direct revision tool for those applying Statistics in Business, Insurance, Medical Decision making and many more situations.

Thank you very much Mr. Harmon."

Abdul Basit AL-Mahmood Senior Consultant ExcelTech
Kingdom of Bahrain

"Mark, I am quite impressed with the Excel Statistical Master.

As a research practitioner, I’ve used the easy-to-understand document to help work through some pretty daunting data sets.

As a professor of research, I will suggest the eManual as a supplement to my students.

I think the strength of the eManual is the straightforward explanations of complex procedures in a software platform that is readily available. SPSS and SAS should shudder at the competition.

Great job!"

Tait J. Martin, Ph.D.
President and Chief Insight Officer
The iNSiGHT Cooperative
Tallahassee, Florida


"This book (and associated optional video material) allows people with only very basic statistics knowledge to apply useful statistical analysis in MS/Excel by explaining the concept, introducing examples, showing how to use formulas in those examples and even calculating by hand some of the statistical values you would only normally obtain by using an excel function (without regards on how the values are actually obtained).

This is a small investment that could provide you with good possibilities to advance both in school and in your professional life.

If you are looking for an easy way to use statistical analysis this is a right investment. Also the author is willing to answer questions if you ever have one, though I confess I've never asked anything."

Cony Rodriguez
6 Sigma Black Belt Student
Metepec, Mexico

"The Excel Statistical Master eManual is a wonderful product for anyone who needs to apply a variety of statistical tools and does not have the time or background to develop those tools themselves.

The Excel Statistical Master is easy to use, comprehensive, and powerful.

Congratulations on an excellent product!"

Cliff Sather
Bennington, New England

"Going through Excel Statistical Master has helped me in filling the gaps which most of the professional ignore while building models from scratch.

There are many books in market available in market but
Excel Statistical Master explains everything in a simple way and how to use Excel to solve real life problems. Every topic in Excel Statistical Master is self explanatory and I would recommend freshmen as well as professionals to go through Excel Statistical Master.

Thanks Mark."

Ashutosh Gupta
Sr. Financial Analyst/Team Lead Mortgage Industry Advisory Corporation
Bengaluru, India

"I originally found this series on the author's website while searching for a intro guide to statistics using Excel.

As an engineering major in college, I never took statistics.

Now that I am a practicing engineer, statistics is an important part of my job - from reviewing test data to designing experiments and performing ANOVA.

The Excel Statistical Master series has helped me get up to speed faster than any traditional textbook.

I also found that my technical reports are more polished and professional as a result of my study of this material. The lessons are organized into logical groupings of topics and are just the right size for self-study or if you are using it as a course supplement.

Once I had mastered some of the basic topics I was able to skip around and study those topics I needed for my work. The ability to follow along with the exercises in Excel and then test out new scenarios is a real bonus and a great way to gain a feel for some of the concepts.

Since most of my work is done with Excel anyway, the exercises have served as templates for my job.

I highly recommend this series to anyone who works with statistics and also to the professional who desires to have a nicely organized reference for performing statistical calculations in Excel."

Chris Bronnenberg
Los Angeles, California

"I use this book as a reference to insure I work a problem in the correct manner. I am not a statistician but I need to apply statistics from time to time. I don't remember if for a given situation I need to do a 2 tail test or a single tail test. Or if the probability in a situation is of normal or binomial nature.

This book is structured around examples (at least one for each single application of statistics covered in book)and the detailed way to work each one step by step. Each step explains the theory behind it, what formulas to use and why, what assumptions to make or not make, and how to interpret the results.

It is easy to find an example that fits your particular problem. Following the example allows you to work out your own problem correctly. Doing it in excel allows you to present your problem, calculations, result and interpretation in a professional manner.

It is the best statistics reference I have seen so far and it is well worth the money."

Luis R. Heimpel
El Paso, Texas

"My first encounter with the EXCEL Statistical Master came when writing a report for a customer when the axiom "an un-used tool becomes rusty" presented itself. I knew what analysis and presentation tool I wanted, but using EXCEL became cumbersome and frustrating.

A quick on-line check revealed
the EXCEL Statistical Master which proved to be unequivocal, easy to follow, and complete.

Only after completing the report did I notice the description on the front page "Clear And Simple yet Thorough." Clearly, my experience supported substantiated this claim. Seldom does one encounter such truth in advertising.

Last weekend the manual was very useful in helping my grandson, who just started a statistics class in high school, help understand, envision, and define his semester project as to which data to gather and how to analyze and present that data.

I have recommended the Excel Statistical Master to customers and my contractors."

Pat Goodman
SSL Consulting
Morgan Hill, California


"I am an IT Consultant who gives a Data Analysis for Decision Making workshop to various private and public sector organizations. This workshop consists of many statistical methods.

I often use the Excel Statistical Master in my workshop to demonstrate procedures, give usable examples and frequently, learn new procedures myself.

I find it easy to use, clear and succinct. It should wipe out the fear of statistics from those who have a block against it."

Akram Najjar
Director
InfoConsult
IT Consulting
Beirut, Lebanon


"I'm a PhD consultant in the area of "user experience". I help companies make their web sites user friendly. When I conduct a usability test on a web site design, I need to determine if one design is better than another. So I need to conduct a t-test. At other times, I conduct focus groups that help my client determine which of, say, 10 product designs is better than the others. So I need to conduct non-parametric ANOVAs on their rating responses.

All this goes to say, I need to deal with data rapidly, and in a manner that I can send to my client. Does my client have any statistical software? No, they don't have SyStat or MiniTab or SPSS, or any other packaged stats program. However, my clients DO have Excel.

With Excel, they can open my spreadsheet and see the data. While they are looking at the data (and perhaps running their own descriptive statistics like means, etc.) they can also see my statistical analysis I conducted with the Excel Statistical Master. They can see my charts, too.

So, you can imagine the benefit this gives to my client. It's "one-stop shopping". Data, analysis, and charts all appear in one file. I like being able to send one file that works with Microsoft Office. My client has Microsoft Office. Now they have everything they wanted: stats, data, and charts."

John Sorflaten, PhD Certified Usability Analyst (CUA)
Certified Professional Ergonomist (CPE)
Sr. Usability Engineer www.saic.com
Columbia, Maryland

The Excel Statistical Master

( that'll be you ! )

Become an Excel Statistical Master - Download the Excel Statistical Master for only $39.95

1,100+ Pages of Easy-To-Follow Graduate-Level Statistical Frameworks In Excel 2010/2013 With ALL Examples of ALL Topics Fully Worked-Out In the Attached Excel Workbooks

Here Are The 4 Manuals That You Will Receive
Plus the Excel Workbooks For Each Manual
With ALL Examples Completed IN DETAIL:

Excel Master Series All 4 Manuals 

Become an Excel Statistical Master - Download the Excel Statistical Master for only $39.95

   

Detailed Description of  the
Excel Statistical Master

Complete and practical yet easy-to-understand graduate-level statistics course with ALL of the problems and examples worked out in the Excel workbooks that come with each of the four manuals. Thoroughly covers all topics of an intense graduate statistics course using nothing but step-by-step, simple explanations.

No other book provides detailed, simple instructions and completely worked-out examples in Excel of all of these topics that appear in a graduate statistics course: Some of the major topics covered with easy-to-follow explanations and fully described and demonstrated in detail in Excel include

- Single-variable and multiple regression
- Logistic regression
- Single-factor and two-factor ANOVA
- ALL types of t-Tests and z-Tests
- Chi-Square independence tests
- Chi-Square Goodness-of-Fit tests
- Chi-Square population variance tests
- Confidence intervals of population means
- Confidence intervals of population  proportions
- Minimum sample size required for confidence interval of specific size
- Combinations
- Permutations
- Correlations - both Pearson and Spearman
- Covariance
- Automated histograms using graphs and formulas
- Automated charting techniques (Distribution graphs that change automatically when the distribution's parameters are adjusted by the user)
- Automated sorting techniques with formulas
- Central Limit Theorem demonstrated in Excel

Normality tests covered in detail in Excel include

- Kolmogorov-Smirnov test
- Anderson-Darling test
- Shapiro-Wilk test
- Chi-Square Goodness-of-Fit test
- Automated histograms (histogram bar automatically adjust when data is changed)

Nonparametric tests covered in detail in Excel include
 
- Mann-Whitney U test (alternative for 2-sample t-Tests)
- Wilcoxon Signed-Rank test (alternative for 1-sample and paired t-Tests)
- Kruskal-Wallis test (alternative for 1-way ANOVA)
- Sign Test
- Scheirer-Ray-Hare test (alternative for 2-way ANOVA)

Logistic Regression topics covered in detail in Excel include

- Logit and P(X) calculation
- MLL, Max Log-Likelihood Function With Excel Solver
- R Square - Log-Linear Ratio
- R Square - Cox and Snell
- R Square - Nagelkerke
- Evaluation of variable significance with the Likelihood Ratio instead of Wald Statistic with Excel Solver
- Classification Table to display model's percentage correctly predicted
- Hosmer-Lemeshow Test to evaluate model's overall fit

Post-Hoc ANOVA tests covered in detail in Excel include

- Tukey's HSD
- Tukey-Kramer
- Games-Howell

Variance comparison tests covered in detail in Excel include

- F test
- Levene's test
- Brown-Forsythe test

ANOVA substitute tests  covered in detail in Excel when sample groups do not have similar variances include

- Welch's ANOVA
- Brown-Forsythe F test

Effect size tests tests covered in detail in Excel include

- Eta square
- RMSSE
- Omega square

Correlation parameters for Pearson and Spearman correlations covered in detail in Excel include

- Calculation of r Critical
- p value of calculated r

Special bonus section on how to calculate a test's power using the online utility G*Power

The following distributions are explained with real-world applications using lots of solved problems in Excel:

- Normal distribution
- t-distribution,
- Binomial distribution
- f distribution
- Chi-Square distribution
- Poisson distribution
- Exponential distribution
- Uniform distribution
- Beta distribution
- Gamma distribution
- Hypergeometric distribution
- Multinomial distribution

Instructions for creating interactive PDF and CDF graphs in Excel for the following distributions

 Normal distribution
- t-distribution,
- Binomial distribution
- Chi-Square distribution
- Poisson distribution
- Exponential distribution
- Uniform distribution
- Beta distribution
- Gamma distribution
- Hypergeometric distribution


No  other  book covers this many essential statistics topics in such a simple, easy-to-follow manner and with ALL examples for EVERY topic fully worked-out in attached Excel workbooks.


Loaded with completed, real-world problems all in Excel, this e-manual is an outstanding supplement to a graduate statistics course. Very clear explanations are used to show exactly how the Excel formulas integrate with the statistical frameworks being applied.


The reader will learn how to master and apply graduate-level statistics much faster than a student in a normal graduate statistics course because this e-manual’s emphasis is entirely on problem solving, not on useless, forgettable theory that fills up many statistics courses.


This e-manual achieves two goals: teaching graduate-level statistical frameworks in an easy-to-understand way and then showing how to implement all of it in Excel.


The widely-used Microsoft Excel program provides a very simple but incredibly complete platform to perform heavy-duty, advanced statistical analysis. All other statistical software packages, such as Minitab, SyStat, and SPSS, are expensive, require lots of user training, and expect that the user is an expert statistician right from the start. Not this e-manual nor Microsoft Excel.


The ability to perform graduate-level statistics in Excel is an extremely useful and powerful tool for any graduate statistics student and business manager.


The statistics student will greatly appreciate never again having to look up and figure out complicated statistical charts. Homework assignments can be quickly checked with Excel. Once difficult statistical business problems are now readily solvable in Excel.


The easy-to-follow frameworks in this e-manual can be cleanly and swiftly duplicated in the real world and on statistics exams by hand (without Excel) right away.


The lessons are all in bite-size chunks that are quickly absorbed for immediate use.


The user-interactive Excel graphs in Manual 4 allow the user to vary the cells containing all of the distribution’s parameters, such as mean, standard deviation, and degrees of freedom, and watch the graphed distribution instantly change right on the spreadsheet to conform to the new parameters. This is an excellent and unique tool to fully grasp the functionality of the distributions discussed in this e-manual.


All problem-solving techniques are presented as step-by-step frameworks that can be readily applied to similar problems, not as seemingly unrelated and difficult-to-apply statistical theorems like most statistics course do.


A number of problem-solving techniques are presented in this e-manual that do not appear in any other statistical text.


A number of widely-used and complicated statistical tests, such as the major normality test, the most widely-used nonparametric tests, sample variance tests, ANOVA post hoc tests, effect size tests, and ANOVA substitute tests such as Welch's ANOVA and the Brown-Forsyth F test, are described from top to bottom and also in Excel. There is even a bonus section on how to automatically calculate a test's power using the free and widely-used online utility G*Power. 


Graduate statistics students and business managers will find this e-manual to be, by far, the easiest and fastest way to master graduate-level statistics and to apply advanced statistics in Excel to solve difficult, real-world problems, homework assignments, and exam questions.

The author is a Microsoft-Certified Expert in Excel 2010 and is a statistics instructor at two universities.

The reader of this e-manual will quickly become an Excel Statistical Master.

 

1,100+ Pages of Easy-To-Follow Graduate-Level Statistical Frameworks With Excel

(Manuals downloads in the standard PDF format)

Become an Excel Statistical Master - Download the Excel Statistical Master for only $39.95
Absolute, Immediate, No-Questions-Asked, Money-Back Guarantee If Not TOTALLY, 100%, Not Just Satisfied, But DELIGHTED that the Excel Statistical Master is BY FAR the Easiest and Fastest Way To Master an Advanced, Graduate-Level Course of Statistical Problem-Solving Techniques and Frameworks AND Be Able To Do It All With The Program That You Know Well - Excel.

Become an Excel Statistical Master - Download the Excel Statistical Master for only $39.95



"Why Is the Excel Statistical Master Such a Great Learning Tool?"


►It's LOADED With Completed Problems ALL in Excel.

►All Solved Problems Are REAL-WORLD, BUSINESS Problems.

►Nothing But SIMPLE Explanations.

►Lessons Are All in BITE-SIZE Chunks.

►The Statistics Are MBA-LEVEL .

►All Lessons Are In CLEAR, EASY-TO-FOLLOW FRAMEWORKS .

NO USELESS THEORY Is Taught.

NO PRIOR STATISTICAL KNOWLEDGE Is Needed.

►Every Lesson Is Entirely In Excel.
NO LOOKING UP ON CHARTS .

►You Already Know Excel. NO NEW SOFTWARE NECESSARY .. You Don't Need SPSS, SAS, Systat, or Minitab.

 

Absolute, Immediate, No-Questions-Asked, Money-Back Guarantee If Not TOTALLY, 100%, Not Just Satisfied, But DELIGHTED that the Excel Statistical Master is BY FAR the Easiest and Fastest Way To Master an Advanced, Graduate-Level Course of Statistical Problem-Solving Techniques and Frameworks AND Be Able To Do It All With The Program That You Know Well - Excel.

Become an Excel Statistical Master - Download the Excel Statistical Master for only $39.95

The Excel Statistical Master

( that'll be you ! )