OMIS-Excel Notes-Linda's

# histogram covariance correlation regression random

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: What did we learn? • Excel basics – Navigating a spreadsheet – Relative and absolute references – Cells, calculations and formulas – Layout and formatting Exploring Excel 2010 • Excel basics 12 Excel Notes – – – – Jessica Gahtan OMIS2000 Navigating a spreadsheet Relative and absolute references Cells, calculations and formulas Layout and formatting OMIS2000- Week 2: Quantitative Data Analysis Approaches; Summarizing and Interpreting Data Formulas • Predefined functions for common mathematical calculations etc. • Begin with = sign • Can take one or more attributes • Can refer to cells within the spreadsheet, other sheets within the workbook , or even combinations from multiple workbooks • Example: SUM(range) Formula Help • If you know the formula, type it with the = sign – Clicking on the = sign beside the formula bar (“Edit Formula”) will open a dialog box with a brief explanation and help with the attributes and their order If you don’t know the formula, – Use the fx (“Paste Function”) button to search for the formula in Excel’s database • For a more detailed description of each formula with examples, use the Excel Help function on the toolbar Some Basic Formulas • AVERAGE(range) – Returns the mean of the selected values • COUNT(range) – Counts the number of cells that contain numbers • STDEV(range) – Computes sample standard deviation • VAR(range) – Computes sample variance • MAX(range) – Returns the maximum value in the range • MIN(range) – Returns the minimum value in the range • 13 Excel Notes Jessica Gahtan OMIS2000 Note: all of the ab...
View Full Document

## This note was uploaded on 03/28/2014 for the course OMIS 2000 taught by Professor Hk during the Fall '13 term at York University.

Ask a homework question - tutors are online