Scatterplots: Right click on the Scatterplots01.ppt (ppt) and save it to your local drive.
Open the Scatterprlots presentation and read through it at your own pace.

Scatterplots and Correlation: Right click on the Scatterplots02.ppt (ppt) and save it to your local drive.
Open the Scatterprlots/Correlation presentation and read through it at your own pace.

Excel:

Start Excel and create a new workbook for chapter 7

Enter data for the ages of 20 high school students (in one column)

Enter imaginary data for scores to a high school Chemistry test, one test score per student

Insert a scatterplot with the scores on the y-axis and the students ages on the x-axis

Select the data and calculate the correllation coefficient (it will be a number between -1 and 1)
You will find this function from the top menu bar, select Tools, then select Data Analysis
(IF You do not see Data Analysis under the Tool menu, you can add in by selecting Add-Ins from the Tool menu,
and selecting the top two Add-ins. )
Then select Correlation (select the data to be analyzed, and select where you would like the correlation to be displayed - by
default it will insert a new worksheet with the correcation table, but you can specify a location on the
sheet with your data (like cell A25)

Compare your data with the data from other students, see if you can adjust your data to get negative correlation,
and then adjust your data again to get a positive correlation.

What does your scatterplot look like with the correleation coefficient is close to 0?

Calculator Lab #1 Chapter 6 - the Normal Distribution

Review

we reviewed the classwork problems from yesterday. We covered most of the problems, but
not all of them. You can check the rest of your answers and compare further your answers to the
ones we talked about in class using the file Ch05-Practice-Problems-Post.pdf .

Introduction to Chapter 6 - the Normal Distribution

Read Chapter 6

Quick Review

Use the flash card activity and try the multiple choice quiz (just for practice)

Main Activity

Quiz chapters 1-3

Agenda for Thursday September 29, 2011

Computer Lab Activity #1
Checking the Data Analysis Took Pack

Enable the Excel Data Analysis Tool Pack

Excel 2003 and earlier

From the Tools menu bar select Add-Ins

In the Add-Ins dialog box, make sure that the Analysis ToolPak check box under Add-Ins available is selected.

Click OK.

From Excel/Office 2007 and later

Click the Microsoft Office Button

click Excel Options.

Click the Add-Ins category.

In the Manage list, select Excel Add-ins, and then click Go.

In the Add-Ins dialog box, make sure that the Analysis ToolPak check box under Add-Ins available is selected.

Click OK.

Accessing the Histogram Functions

Adding a histogram is different than inserting other types of charts. The histogram function, along with other data analysis tools will be accessed from
either the Data or Data Analysis tools.

Excel 2003 and earlier

Select [Tools] from the top menu bar

Select [Data Analysis]

From Excel 2007 and later

From the top ribbon, select [Data]

In the Analysis group, select [Data Analysis]

From there, select Histogram, and set the parameters according to the data you want to be displayed in your histogram.
Keep in mind, that it is not necessary to have each data element represented in its own "bucket", but that your histogram will
contain a series of "buckets" that represent a range of your data. For example, if we had a list of ages for all of the people who
live in Wenham, we might show a histogram of buckets for ages 0-5, 6-12, 13-19, 20-30, 30-50, 50 and over.

Notice that there are two columns with data - the name of the cereals, and the percentage of sugar.

We want to add a histogram, that will count the number of cereals that have 0-9% sugar, 10-19% sugar,
20-29% sugar, and more than 30% sugar. To do this, we can add the definitions of these "bins" to the
spreadsheet. Add the following data to your spreadsheet. Column D is used just for spacing.

D

Bin

9

19

29

We'll now use the data analysis tool pack to add a histogram. We'll tell it where the data is, where
the definitions of the bins are, and where we want the output to go. We'll tell Excel that we want the
histogram to go on the same spreadsheet, staring at position F4.

In the Data Analysis dialog box, click Histogram, and then click OK.

In the input range, enter (or select) B2 to B50 ($B$2:$B$50)

In the bin range, enter (or select) D1 to D4 ($D$1:$D$4)

Check the box that says Label - notice that we selected the name Bin in our bin range

In the output options, select Output Range F4

Click [OK]

Things to notice and experiment with

we didn't need to add a bin for more than 29, Excel added the "more" row for us.

Sometimes it may help to sort the data to determin the best bins to use.

Online Statistics Tutorials

The web site Patterns in Data
is worth your time because it summarizes many of the terms and concepts from chapter 4. I like the web page, but am not decided on the
videos yet.

Chapter 4 Data Files

Chapter 4 Data Files

Right click on the file name and select [Save Target As] to save it either to your desktop or your My Documents
directory.Open the file with Excel outside of a web browser rather than in the web browser.

Try to create other charts (bar charts, pie charts or others) using other chapter 3 files.

Agenda for Thursday September 22, 2011

Computer Lab Activity #1

Basic Excel Lab We will walk through the steps to ...

Enter data and extend it down a column

Entering formulas

Builtin functions

Scatter Plots

Printing from the STEM Lab

To print your word document to the STEM Lab printer follow these directions

In Microsoft Excel, from the top menu bar, select [File] and then select Print.

From the print window, select [Find Printer]

In the Name field, type in *STEMP and press the [Find Now] button

Select the hsstemp printer

Before you press [Print] make sure the as the hstemp printer is selected (sometimes finding it will put the printer in your printer list, but not select it – we want to make sure we select the STEM lab printer before printing.)

Print your document

Computer Lab Activity #2

Movie Genre Data

We will walt through the process of creating a pie chart using Movie Genre data.
Right click on Ch03_Movies_Genre_Rating.xls and save the file to your desk top.
Start Excel and open the file.
Follow along with the class to insert a pie chart, similar to the one on page 38 for problem number 5.

Excel Activities
Right click on one of these Excel files (pw protected) and see how you can represent the data.