Skip to Content
Business Statistics For Dummies, 2nd Edition
book

Business Statistics For Dummies, 2nd Edition

by Alan Anderson
January 2024
Beginner
400 pages
9h 3m
English
For Dummies
Content preview from Business Statistics For Dummies, 2nd Edition

Chapter 16

Key Statistical Techniques in Excel

IN THIS CHAPTER

Bullet Understanding how to implement functions in Excel

Bullet Discovering Excel’s key statistical analysis functions

Bullet Performing complex statistical analyses with the Analysis ToolPak

Microsoft Excel provides a large collection of tools that can help you with statistical calculations. You can use the built-in functions to calculate a single value or an array of values, or use one of Excel’s add-in tools such as the Analysis ToolPak to calculate more advanced routines. In this chapter, you discover how to implement Excel functions, become familiar with the many statistical functions available in Excel, and see how Excel’s add-in tools can help you generate results more quickly and easily than is possible with a calculator.

Implementing Excel Functions

You implement Excel functions by selecting a cell, typing an equals sign (=) followed by the name of the function, a left parenthesis ((), and then the values needed by the function to work, known as arguments. (If you need multiple values, you separate them with commas.) You then follow the input values with a right parenthesis ()) and press the Enter key. For example, the square ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Business Statistics, 3rd Edition

Business Statistics, 3rd Edition

Naval Bajpai

Publisher Resources

ISBN: 9781394219926Purchase Link