Michael Girvin - Business Department, Highline Community College

Fall:
Busn216
Busn101
Busn233
Classes:             
Busn135
Busn214
Busn210
Acc121
You Tube Excel Videos & Excel is
Fun Book


Home Page
Links

Personal Info
Business Dept

Highline

 

Download by clicking Save:
PowerPoints for chapter03
HandWrittenInClassNotesch03.pdf
Hints.doc

Excel Templates (download by clicking save):
These Excel workbooks will work for both Excel 2003 and Excel 2007:

Chapter03 Excel Template
Excel workbook with selected homework solutions for ch03 from M.Girvin

Extra Geometric Mean v. Mean hint: ArithmeticMeanVs.GeometricMeanBusn210.xls

VBlogs (View by clicking link):

Excel 2003:
                Chapter03
                Note01: This VBlog is huge, it may take a while to load
                Note02: skip the video between time 83.17 to 87.22 (we won't use MegaStat)

Excel 2007:
                Part01
                Part02
                Part03
                Part04

You Tube Videos:
AVERAGE function
Mean Median Mode: AVERAGE MEDIAN MODE
Standard Deviation of Sample STDEV function
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Items 2, 3, 6-9 are required; items 1, 4, 5 are optional

  1. View (Open)or Download (Save) Full PowerPoint slides: PowerPoint ch 3
  2. View (Open) or Download (Save) Abbreviated PowerPoint slides: PowerPoint ch 3 ShortVersion
     
  3. Read Textbook and do Homework
     
  4. Complete chapter project by hand, click to view and then print handout for chapter project: Ch 3 project "by hand" handout
  5. Click to view solution to "by hand chapter project":
    p.01 p.01.5 p.02 p.03 p.04 p.05 p.06

     

  6. Download (Save) Excel workbook used for short chapter project: Ch 3 short project download Excel workbook
  7. View Ch 3 short project in Excel handout describing the short chapter project: Ch 3 short project
     
  8. Download (Save) Excel workbook used for chapter project: Ch 3 project download Excel workbook (Answers and formula answers are viewable at the end of the sheet tab list)
  9. View VBlogs for description of how to complete Ch 3 project in Excel:
    vb08 vb09 vb10 vb11 vb12

     

  10. Extra workbook with fun Standard Normal Curve example: Excel Download of Standard Normal Curve (Bell Curve)

Michael GirvinOffice Hours and contact information