Excel_Tutorial - EXCEL Statistical Functions for Stat 2103...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
EXCEL Statistical Functions for Stat 2103 CONTENTS I. Getting Started with MS Excel II. Statistical Functions for Stat 2103 I. Getting Started with MS Excel Introduction: Microsoft Excel is a spreadsheet application and is a powerful computation and presentation tool used extensively in just about any desk job. The format is so easy to use and flexible, that everyone uses it daily from administrators to fluid dynamic engineers and yes, even by those who do data analysis and statistics. Below are instructions for one possible way to do things. In Excel there are many ways to do any one thing. Over time, you will become familiar with more and more ways. Use the Help Menu Item if you need any additional information as this document only covers the very basic functions of Excel. Follow directions labeled “Tutorial” for a simple example. Open a File/Workbook: To open an Excel file in Excel, either double click on the file icon itself or start Excel by double clicking on its icon and then using Menu Item: File/Open…browse to your file. Or notice the open file button on the toolbar as you follow menu process and use that instead. Or use keystrokes “Control+O”. Tutorial: Start Excel. Create a New File/Workbook: To create a new file, use Menu Item: File/New…Or, use the new file button on the toolbar. Or use the keystrokes “Control+N”. To save the new spreadsheet, use Menu Item: File/Save or use keystroke “Control+S”. Tutorial: Create a new file (known as a spreadsheet) in Excel. Save the new file on your desktop as “xtutorial”. Selecting Cells: To select a cell in Excel, use the mouse to click on one. By holding the left mouse button down as you move your mouse, one can select many cells at once. For complicated non- connected cell selection, experiment with holding down the Shift key and the Control key as you select your cells. Cell selection can also be done without the mouse using the Shift key in concert with the arrow keys. Notice if you select the very first cell (in upper left hand corner of spreadsheet) the “address” of the cell is displayed in the toolbar. The address of the very first cell is “A1”. Notice the labels for rows are numbered and the labels for the columns are lettered. These addresses are very important.
Background image of page 1

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

View Full DocumentRight Arrow Icon
You can also select whole rows or whole columns with a single mouse click by mouse clicking on the name of the row or column. You can also select groups of rows or groups of columns. You can also change the width of any row or column by moving the mouse curser in between two labels for either the rows or the columns. When you find the right spot, the curser will change to a double arrow. At that point, hold the mouse button down and more the mouse to specify what size you want your row or column. Tutorial: Select cells A1, A2, A3.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/17/2011 for the course STATISTICS 2103 taught by Professor Zhao during the Spring '11 term at Temple.

Page1 / 8

Excel_Tutorial - EXCEL Statistical Functions for Stat 2103...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online