Overview

Today's session will have five purposes:

1. To demonstrate a few additional features of Excel

2. To lead students through the first excercise in Excel

3. To introduce students to graphing features on Excel

4. To introduce an assignment that will give students practice with problem solving and using graphing features in Excel.

5. To introduce students to some of the data analysis features of Excel.

II. Graphing with Excel

A. Pie and bar charts

B. Line charts

C. Scatter charts

D. Radar charts

II. Formatting charts

A. Changing legends

B. Changing backgrounds and colors

III. Excel Assignment II

IV. Data analysis with Excel

A. Histogram analysis

B. t-test

C. Regression analysis

This page posted and maintained by Kenneth M. Klemow, Ph.D., Biology Department, Wilkes University, Wilkes-Barre, PA 18766. (570) 408-4758, kklemow@wilkes.edu.