McPherson Golden. Statistical Analysis in Excel

Independently published, 2022. — 315 p. — ISBN: 979-8353288237.The world of Excel is a large one especially filled with all of the special functions for your special duty. Now if you are an Excel enthusiast, you are going to agree with me that Excel gets deep and extensive. The deeper you get into it, the more you understand. And what you understand is a lot. One thing that makes Excel stand out is that it is easily accessible. Most people with Windows laptops have them preinstalled and they are the number one go-to platform for office management and data analysis. One thing that makes Excel stand out is that it is easily accessible. Most people with Windows laptops have them preinstalled and they are the number one go-to platform for office management and data analysis. So here is the deal though it is one thing to say we have a list of directions without any illustrations and it is another thing to say that we created illustrations for you. Now, we have done the latter. This makes it easier for you such that when you are working or trying to use our book to find your way through Excel, you have pictures also to guide you. Ultimately practice makes perfect. As this book is very technical, do not expect to get it on your first try. But with consistency and repetition, you are going to get it.Evaluating Data in The Real World.
Understanding excels statistical capabilities.
Meeting standards and catching some Z.
Summarizing it all.
What is normal?
Finding your center.
Deviating from the average.
The Confidence Game: Estimation.
One sample hypothesis testing.
Two sample hypothesis tests.
Testing more than two samples.
Slightly More Complicated Things.
Regression: linear and multiple.
Correlation: The Rise and The Fall Of Relationships.
Non-Parametric statistics.
Introducing probability.
More on probability.
Using Probability: Modeling And Simulation.
12 Statistical and Graphical Tips and Tricks.
Topics that just don’t fit elsewhere.
The analysis of covariance.