ORIE2700_section1 - Conditionals IF and COUNTIF Sorting...

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

View Full Document Right Arrow Icon
ORIE 2700: Section 1 26–29 August 2011 Flaw of Averages One cannot base decisions solely on average values as these do not take into account the amount of variability that is possible in the system. Excel Skills Generate random values (for demonstration purposes) Navigation: use Ctrl + ↑↓ to navigate, Ctrl + Shift + ↑↓ to select Format data: change number of decimal places Insert formulas applied to subsets of data, fill down rows Use Copy > Paste Special > Values to keep current formula values and prevent recalculation
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Conditionals IF and COUNTIF Sorting using Home > Sort & Filter > Sort Home > Sort & Filter > AutoFilter to sort, show top n values, or other criteria Statistical functions: AVERAGE, MEDIAN, STDEV, PERCENTILE Summary stats using Data > Data Analysis > Descriptive Statistics (have to load Analysis Toolpak Add-in) Histogram: Data Analysis > Histogram Scatterplot: Insert > Scatter 1...
View Full Document

This note was uploaded on 09/30/2011 for the course ENGRD 2700 at Cornell University (Engineering School).

Ask a homework question - tutors are online