Black_8e_Excel_Manual_Ch01 - Chapter 1 Introduction to...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1- 1 Chapter 1 Introduction to Using Excel for Business Statistics This manual is an Excel supplement to the text Business Statistics for Contemporary Decision Making, 8th Edition by Ken Black. It will aid the reader in performing the statistical analysis needed to solve the chapter demonstration problems detailed in the text. Microsoft Excel 2013 will be used to perform the analysis. A guide to changes that exist in Excel 2013 will help if that version is being used. A summary of the differences will be noted. Business statistics provides the tools through which such data are collected, analyzed, summarized, and presented to facilitate the decision-making process, and business statistics plays an important role in the ongoing saga of decision making within the dynamic world of business. Excel provides many of the required graphic and statistical analysis functions required to help make informed business decisions. This manual will provide the necessary step-by-step instructions required to solve the types of problems detailed in the text. 1.1 Using Excel Microsoft Excel is a widely used spreadsheet application that includes capabilities such as spreadsheet analysis, graphic display, and database applications. An electronic spreadsheet organizes data much like an accounting worksheet or table of data. Excel can also perform statistical analysis using its built-in functions and other tools. Versions of Excel The examples in this book were written using Excel 2013 with notes about changes in Excel 2010. For those using Excel 2010, skip to section 1.6 . Prior Knowledge It is not necessary to have any prior knowledge of Excel to use this book. However, it is helpful to practice some of the program’s basic functions outlined in the next section before advancing to statistical analysis.
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
1-2 Chapter 1 1.2 Worksheet Basics - Excel 2013 This section identifies the changes in Excel 2013 from the previous versions, most recently Excel 2010. One key change is the start-up page. When you first open Excel 2013, provided templates will display which are useful for certain types of jobs. Other newly added items include the Quick Analysis Tool , which enables you to do instant analysis on a set of data, the Flash Fill option that lets you automatically fill in large amounts of data without manual entry, and the Chart Recommendations Tool enabling the creation and formatting of charts using more intuitive methods. When you open Excel 2013, the screen will look like the one below, giving you a choice of templates, opening a blank worksheet, or certain types of reports or formats for analysis. When you open Excel 2013, you can select a blank worksheet as part of a workbook. Initially, one worksheet is available to you but you can create an unlimited number (limited only by your computer memory) of additional sheets by clicking on the button at the lower left of the worksheet to the right of the tab for Sheet1 . You can insert, move, or delete worksheets as needed. The figure below is a screenshot of a Microsoft Excel 2013 worksheet.
Image of page 2
Chapter 1 1-3 The outer window is the Excel program window. The inside window is the workbook. In this case, both
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern