lesson-excel-statistical

# lesson-excel-statistical - CSCE120 Spring 2008 Excel...

This preview shows pages 1–7. Sign up to view the full content.

CSCE120 – Spring 2008 Excel Statistical Functions Lab #2 due next Tuesday by midnight NO CLASS on Thursday, March 13th

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

View Full Document
Learning Objectives Perform some simple data analysis on garden supply sales To do this, we will: use named cell ranges use basics statistical functions including: min(), max(), average() large(), small() median(), mode() count(), counta(), countblank() countif(), sumif()  rank(), percentrank()  frequency()  calculate weighted averages create a simple histogram from a frequency table

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

View Full Document
Named Cell Ranges What are they? Why use them? How do you name a  cell range? =SUM( orders ) =MAX( orders ) =LARGE( orders , 2 ) Using named cell ranges in functions…
Give it a try… With your learning partner -  assign names to cell ranges for: Order Date Salesperson Order Amounts Category. create formulas and/or functions to  calculate: Total Sales Largest Sales Smallest Sales 2nd Largest Sales 2nd Smallest Sales Keep in mind… =Small( cell-range, kth-value ) =Large( cell-range, kth-value )

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

View Full Document
Three ways to determine the  “average”: Mean =average() Mode =mode() Median =median() Why can’t we just use the mean? Different types of averages help answer different  types of questions. For example: \$4,000,000 \$400.000 \$400,000 \$250,000 \$250,000 \$250,000 \$200,000 \$200,000 \$200,000 \$200,000 Use the Median = \$250,000 Use the mode = \$200,000 Use the Mean = \$635,000 Approximately, how much property taxes will the  city receive from this neighborhood? What can a new home buyer expect to pay in this
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 19

lesson-excel-statistical - CSCE120 Spring 2008 Excel...

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

View Full Document
Ask a homework question - tutors are online