lesson-excel-statistical

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

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

View Full Document Right Arrow Icon
CSCE120 – Spring 2008 Excel Statistical Functions Lab #2 due next Tuesday by midnight NO CLASS on Thursday, March 13th  
Background image of page 1

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

View Full Document Right Arrow Icon
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 
Background image of page 2
Getting Started… Download and open “gardens-r-us.xls” from  Sakai: Resources: Downloads. Click on the “Gardens-R-Us” worksheet tab.
Background image of page 3

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

View Full Document Right Arrow Icon
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…
Background image of page 4
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 )
Background image of page 5

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

View Full Document Right Arrow Icon
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 
Background image of page 6
Image of page 7
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 Right Arrow Icon
Ask a homework question - tutors are online