Joseph Schmuller - Statistical Analysis with Excel For Dummies

Здесь есть возможность читать онлайн «Joseph Schmuller - Statistical Analysis with Excel For Dummies» — ознакомительный отрывок электронной книги совершенно бесплатно, а после прочтения отрывка купить полную версию. В некоторых случаях можно слушать аудио, скачать через торрент в формате fb2 и присутствует краткое содержание. Жанр: unrecognised, на английском языке. Описание произведения, (предисловие) а так же отзывы посетителей доступны на портале библиотеки ЛибКат.

Statistical Analysis with Excel For Dummies: краткое содержание, описание и аннотация

Предлагаем к чтению аннотацию, описание, краткое содержание или предисловие (зависит от того, что написал сам автор книги «Statistical Analysis with Excel For Dummies»). Если вы не нашли необходимую информацию о книге — напишите в комментариях, мы постараемся отыскать её.

Become a stats superstar by using Excel to reveal the powerful secrets of statistics  Microsoft Excel offers numerous possibilities for statistical analysis—and you don’t have to be a math wizard to unlock them. In 
fully updated for the 2021 version of Excel, you’ll hit the ground running with straightforward techniques and practical guidance to unlock the power of statistics in Excel.
Bypass unnecessary jargon and skip right to mastering formulas, functions, charts, probabilities, distributions, and correlations. Written for professionals and students without a background in statistics or math, you’ll learn to create, interpret, and translate statistics—and have fun doing it! 
In this book you’ll find out how to: 
Understand, describe, and summarize any kind of data, from sports stats to sales figures Confidently draw conclusions from your analyses, make accurate predictions, and calculate correlations Model the probabilities of future outcomes based on past data Perform statistical analysis on any platform: Windows, Mac, or iPad Access additional resources and practice templates through Dummies.com For anyone who’s ever wanted to unleash the full potential of statistical analysis in Excel—and impress your colleagues or classmates along the way—
 walks you through the foundational concepts of analyzing statistics and the step-by-step methods you use to apply them.

Statistical Analysis with Excel For Dummies — читать онлайн ознакомительный отрывок

Ниже представлен текст книги, разбитый по страницам. Система сохранения места последней прочитанной страницы, позволяет с удобством читать онлайн бесплатно книгу «Statistical Analysis with Excel For Dummies», без необходимости каждый раз заново искать на чём Вы остановились. Поставьте закладку, и сможете в любой момент перейти на страницу, на которой закончили чтение.

Тёмная тема
Сбросить

Интервал:

Закладка:

Сделать

Although Excel hasn’t added any new statistical functions, the Windows version (of 365) has an exciting new feature called linked data, which enables you to look up information about a variety of topics (movies, universities, stocks, and more) without leaving Excel. (Exciting as it is, we won’t be working with this one.)

The Mac and iPad have added Data from Pictures. As its name suggests, this feature looks at a picture of a data table and puts the data into a spreadsheet. I cover this topic in Chapter 2.

A new feature in Windows and Mac called Analyze Data offers insights about your data. I cover this feature in Chapter 2as well.

An add-in called XLMiner Analysis ToolPak mimics Excel’s Analysis Toolpak (an extensive set of analytical tools) and adds logistic regression, which, as I mentioned, I cover in Chapter 21.

Foolish Assumptions

This isn’t an introductory book about Excel or about Windows, Mac, or iPad, so I'm assuming that you

Know how to use your computer: I don’t spell out the details of pointing, clicking, selecting, and other basic actions.

Have Excel (Microsoft 365 subscription) installed on your machine and can work along with the examples: I don’t walk you through the steps of Excel installation. Incidentally, I work with the 32-bit version — it seems to get the updates more quickly than the 64-bit version does. Excel 2021 should work for most of the examples, but the subscription version receives the latest updates.

Have worked with Excel: I don’t go into the essentials of worksheets and formulas. I do fill you in on a few Excel fundamentals in Chapter 1, however.

If you don't know much about Excel, consider looking into Greg Harvey's excellent Excel books in the For Dummies series.

Icons Used in This Book

As is the case with all For Dummies books, icons appear all over the place. Each one is a little picture in the margin that lets you know something special about the paragraph it sits next to.

Statistical Analysis with Excel For Dummies - изображение 2This icon points out a hint or a shortcut that can help you in your work and make you an all-around better human being.

Statistical Analysis with Excel For Dummies - изображение 3This one points out timeless wisdom to take with you long after you finish this book, young Jedi.

Statistical Analysis with Excel For Dummies - изображение 4Pay attention to this icon — it's a reminder to avoid an action that may gum up the works for you.

Statistical Analysis with Excel For Dummies - изображение 5This icon indicates material you can blow right past if statistics and Excel aren't your passion.

Where to Go from Here

You can start the book anywhere, but here are a few hints. Want to learn the foundations of statistics? Turn the page. Introduce yourself to Excel's statistical features? That's Chapter 2. Want to start with graphics? Hit Chapter 3. For anything else, find it in the table of contents or in the index and go for it.

Beyond This Book

In addition to what you’re reading right now, this book comes with a free, access-anywhere Cheat Sheet that will help you quickly use the tools I discuss. To find this Cheat Sheet, visit www.dummies.com and search for Statistical Analysis with Excel For Dummies Cheat Sheet in the Search box. And don’t forget to check out the bonus content on this book’s companion website, at http://www.dummies.com/go/statisticalanalysiswexcelfd5e .

If you’ve read any of the previous editions, welcome back!

If not, it’s nice to meet you.

Part 1

Getting Started with Statistical Analysis with Excel: A Marriage Made in Heaven

IN THIS PART …

Find out about Excel’s statistical capabilities

Explore how to work with populations and samples

Test your hypotheses

Understand errors in decision-making

Determine independent and dependent variables

Chapter 1

Evaluating Data in the Real World

IN THIS CHAPTER

картинка 6 Introducing statistical concepts

картинка 7 Generalizing from samples to populations

картинка 8 Getting into probability

картинка 9 Making decisions

картинка 10 Understanding important Excel fundamentals

The field of statistics is all about decision-making — decision-making based on groups of numbers. Statisticians constantly ask questions: What do the numbers tell us? What are the trends? What predictions can we make? What conclusions can we draw?

To answer these questions, statisticians have developed an impressive array of analytical tools. These tools help us make sense of the mountains of data that are out there waiting for us to delve into, and to understand the numbers we generate in the course of our own work.

The Statistical (and Related) Notions You Just Have to Know

Because intensive calculation is often part and parcel of the statistician’s tool set, many people have the misconception that statistics is about number crunching. Number crunching is just one small step on the path to sound decisions, however.

By shouldering the number crunching load, software increases your speed of travel down that path. Some software packages are specialized for statistical analysis and contain many of the tools that statisticians use. Although not marketed specifically as a statistical package, Excel provides a number of these tools, which is why I wrote this book.

I just said that number crunching is a small step on the path to sound decisions. The most important part are the concepts statisticians work with, and that’s what I talk about for most of the rest of this chapter.

Samples and populations

On election night, TV commentators routinely predict the outcome of elections before the polls close. Most of the time they’re right. How do they do that?

The trick is to interview a sample of voters right after they cast their ballots. Assuming the voters tell the truth about whom they voted for, and assuming the sample truly represents the population, network analysts use the sample data to generalize to the population of voters.

This is the job of a statistician — to use the findings from a sample to make a decision about the population from which the sample comes. But sometimes those decisions don’t turn out the way the numbers predict. History buffs are probably familiar with the memorable photo of President Harry Truman holding up a copy of the Chicago Daily Tribune with the famous, but incorrect, headline “Dewey Defeats Truman” after the 1948 election. Part of the statistician’s job is to express how much confidence they have in the decision.

Читать дальше
Тёмная тема
Сбросить

Интервал:

Закладка:

Сделать

Похожие книги на «Statistical Analysis with Excel For Dummies»

Представляем Вашему вниманию похожие книги на «Statistical Analysis with Excel For Dummies» списком для выбора. Мы отобрали схожую по названию и смыслу литературу в надежде предоставить читателям больше вариантов отыскать новые, интересные, ещё непрочитанные произведения.


Отзывы о книге «Statistical Analysis with Excel For Dummies»

Обсуждение, отзывы о книге «Statistical Analysis with Excel For Dummies» и просто собственные мнения читателей. Оставьте ваши комментарии, напишите, что Вы думаете о произведении, его смысле или главных героях. Укажите что конкретно понравилось, а что нет, и почему Вы так считаете.

x