# Sir Sandford Fleming College

## Lab 9: Scatter Diagrams and Lines of Best Fit (2001)

This lab activity provides instruction on how to produce scatter diagrams and lines of best fit by using an Excel worksheet and Chart Wizard. The activity is part of a series developed to be used with Microsoft Office 97 software programs.

2003-09-16

## Lab 8: Creating a Frequency Distribution and a Histogram (2001)

This lab activity provides instruction on how to use Excel to create a frequency distribution and a histogram from a set of data. The activity is part of a series developed to be used with Microsoft Office 97 software programs.

2003-09-16

## Lab 7: Interpreting Bar or Column Graphs (2001)

This lab activity provides instruction on how to to interpret bar and column graphs. The activity is part of a series developed to be used with Microsoft Office 97 software programs.

2003-09-16

## Lab 6: Constructing Bar and Column Graphs (2001)

This lab activity provides instruction on how to construct bar and column graphs by using Chart Wizard in Microsoft Excel. The activity is part of a series developed to be used with Microsoft Office 97 software programs.

2003-09-16

## Lab 5: Interpreting Pie Charts or Circle Graphs (2001)

This lab activity provides instruction on interpreting pie charts or circle graphs. It is part of a series developed to be used with Microsoft Office 97 software programs.

2003-09-16

## Lab 4: Constructing Pie Charts and Circle Graphs (2001)

This lab activity provides instruction on how to construct pie charts (circle graphs) by hand and by using Chart Wizard in Microsoft Excel. It is part of a series developed to be used with Microsoft Office 97 software programs.

2003-09-16

## Lab 3: Measures of Central Tendency & Dispersion (2001)

This learning activity provides instruction on how to use Excel to find the mean, median, mode, range, variance and standard deviation of a set of data. It is part of a series developed to be used with Microsoft Office 97 software programs.

2003-09-16

## Lab 2: Finding the Mean, Median, & Mode (2001)

This learning activity provides instruciton on how to use Excel to find the mean, median, and mode of a set of data. It is part of a series developed to be used with Microsoft Office 97 software programs.

2003-09-16

## Lab 1 B: Adding, Averaging and Working with Percent (2001)

This learning activity provides instruction on how to add, average and find percent change for data in an Excel Spreadsheet. It is part of a series developed to be used with Microsoft Office 97 software programs.