Class notes

Lecture notes Basic Statistics (sta1501) Statistics for Management and Economics

0 purchase

Course
Basic Statistics (STA1501)

Institution
University Of South Africa (Unisa)

Lecture notes Basic Statistics (sta1501) Statistics for Management and Economics Important for excel getting started basics

[Show more]

Preview 4 out of 127 pages

View example

Uploaded on November 4, 2024
Number of pages 127
Written in 2024/2025
Type Class notes
Professor(s) None
Contains All classes

excel

drowsy-polls0j Member since 10 months 26 documents sold

A1 Introduction to Microsoft Excel

The purpose of this appendix is to introduce you to Microsoft Excel and provide enough instruction to allow you to

use Excel to produce statistical results. We suggest that you obtain an Excel instruction book to help you learn more

about the software.

The information and instructions below pertain to Office 2007 and 2010, Microsoft’s latest version.

Installing Excel

Installing Excel on your computer is easy. Simply follow the instructions in the booklet that accompanies your

edition of Microsoft Excel. In most cases you will install some edition of Office, which includes Excel, Word, and

PowerPoint, as well as several other programs.

After installing the software, keep the compact disk (CD) or diskettes handy; it is quite possible that you will need

them again.

If the screen (called a desktop) does not show a Microsoft Excel icon, click Start, Programs, and Microsoft Excel.

(Alternatively, if the desktop has an Excel icon, double-click it.) The Excel screen depicted in Figure 1 will appear.

(Unless otherwise stated, “clicking” refers to tapping the left button on your mouse. “Double-clicking” means

tapping the left button twice quickly.) The screen that appears may be slightly different, depending on which version

of Excel you have.

,Figure 1 Blank Excel Screen for Office 2010

Excel Screen

At this point the screen is blank except for the top where up to five rows or bars appear. These are the locations of

most of the commands that you will issue to Excel. Move the mouse, which in turn will move the pointer to different

positions on the screen. To select a command, position the pointer over the command, and click once.

The first row is called the Title bar. In the center you see the name of the program, Microsoft Excel. At the right

side there are three small boxes, which (moving left to right) minimize, restore, or close the Excel program. You can

see what the box does before you execute it by placing the mouse pointer over it and waiting a second before

moving or clicking. On the left side of this row you can see the Office icon. Clicking that will open a list of choices

including New, Open, Save, Print, and others.

The second row contains the following choices.

,Home Insert Page Layout Formulas Data Review View Developer

Clicking any one of these provides you with a number of other selections. Try clicking each of the options to see the

additional list. For example, click Home and you will see (among other things)

Clipboard Font Alignment Number Styles Cells Editing

For the first four you can click the arrow in the right-hand side, which will give you more choices and options.

The third row contains the commands that save, open a new worksheet, open an existing file, or several other

choices.

The fourth row displays the contents of the active cell (described below).

Excel Workbook and Worksheet

Excel files are called workbooks, which contain worksheets. A worksheet consists of rows and columns. The rows

are numbered, and letters identify the columns. The intersection of a row and column is called a cell, which is box

that can store a number, word, or formula.

If you click the Microsoft Office button and New or the New icon in the third row you will see Figure 2 (page

12). Notice that the cell in row 1 column A is active, which means that you can type in a number, word, or formula.

You can designate any cell as active by moving the mouse pointer (which now appears as a large plus sign) and

clicking. Alternatively you can use any of the four Up, Down, Left, or Right arrow keys. (These appear on your

keyboard as arrows pointing up, down, left, and right, respectively.)

, Figure 2 Blank Excel screen

At the bottom of the screen you will see the word Ready. As you begin to type something into the active cell, the

word changes to Enter. Above this word you will find the tabs Sheet1, Sheet2, and Sheet3, the three worksheets

that comprise this workbook. You can operate on any of these as well as other sheets that may be created. To change

the worksheet, use your mouse pointer, and click the sheet you wish to move to.

Inputting Data

To input data open a new workbook. Activate the cell in the first row of the column in which you plan to type the

data. If you wish, you may type the name of the variable. For example, if you plan to type your assignment marks in

row A, you may type “Assignment Marks” in cell A1. Hit the Enter key, and cell A2 becomes active. Begin typing

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying this summary from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller drowsy-polls0j. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy this summary for R50,00. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy summaries for 15 years now

Start selling

Class notes

Lecture notes Basic Statistics (sta1501) Statistics for Management and Economics

Document information

Subjects

Connected book

More summaries for

Written for

Seller

Reviews received

Content preview