Agenda for Thursday December 22, 2011
Main Activity

Computer Lab - Simulating the ESP problem

  • Use Excel statistics functions to create a simulation that can be reused for multiple trials.

  • Download and save the file ESP.xsl and
    the Word Document ESP.doc
  • Open the ESP.xls file using Excel and the ESP.doc using Word
  • ESP.xls sheet [Problem] contains a copy of the ESP problem
  • Sheet [Notes] provides some hints as to the functions that can be used, and some examples.
  • Sheet [Example-Grades] provides an example of using the IF function, to assign letter grades from numeric grades.
  • Sheet EPS is where you can complete the ESP problem - you can create additional sheets as you desire.

Agenda for Tuesday December 13, 2011
Main Activity

Computer Lab Chapter 8 - Scatterplots, Associations, and Correlation

    Select 5 spreadsheets from the list below, one at a time.
  1. Download save the file
  2. Write down the name of the file (in a chart with 4 columns)
  3. Open the file and create a scatter plot of the data
  4. Identify the correlation : positive, negative, or no correlation
  5. Have Excel draw the trend line
  6. include the equation of the trendline and the value for r squared
  7. Write down the equation of the trendline and the value for r squared

Online Calculator

Normal Distributiion

Agenda for Thursday December 1, 2011
Main Activity

Computer Lab Chapter 7 - Scatterplots, Associations, and Correlation

  • Use Excel to create scatterplots
  • Have Excel identify the correlation

  1. Download and save the file containing Kentucky Derby speeds from 2007.
  2. Start Excel and open the file
  3. Create a scatter plot
Chapter 7 Files
  • Start Excel
  • Enable Macros
  • Download QuizBook! QuizBook!-75-Stats

  • Open the QuizBook!
  • Complete the quizzes and record the completion codes

Alternative Agenda for Thursday December 1, 2011
Computer Lab
  • 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:
    1. Start Excel and create a new workbook for chapter 7
    2. Enter data for the ages of 20 high school students (in one column)
    3. Enter imaginary data for scores to a high school Chemistry test, one test score per student
    4. Insert a scatterplot with the scores on the y-axis and the students ages on the x-axis
    5. 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)
    6. 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.
    7. What does your scatterplot look like with the correleation coefficient is close to 0?

Agenda for Monday November 15, 2010
Computer Lab
  • Right click on the NormalDistribution.ppt file and save it to your local drive. View the presentation on Normal Distributions.

  • Copy your standard deviation Excel workbook and adjust it to accept a list of test scores. Add to your calculations a column to computer Z-scores.

    Be sure to save all of your work.

    Test your spreadsheet with known data.

Agenda for Thursday November 3, 2011
Main Activity

Computer Lab Chapter 6 - the Normal Distribution

  • We will use the mean, stdevp and normaldist functions from Excel
  • We'll create a simple calculator to help model and solve problems
  • We'll figure out how to tell if a data collection is normally distributed

Chapter 6 Files

Agenda for Thursday October 27, 2011
Main Activity

Calculator Lab #1 Chapter 6 - the Normal Distribution


Take home test Test-Chapter-5.pdf due next Tuesday at the start of class.

Agenda for Wednesday October 26, 2011


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 .

Main Activity

Introduction to Chapter 6 - the Normal Distribution


Read Chapter 6

Agenda for Friday October 7, 2011

Quick Review

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
    1. From the Tools menu bar select Add-Ins
    2. In the Add-Ins dialog box, make sure that the Analysis ToolPak check box under Add-Ins available is selected.
    3. Click OK.
  • From Excel/Office 2007 and later
    1. Click the Microsoft Office Button
    2. click Excel Options.
    3. Click the Add-Ins category.
    4. In the Manage list, select Excel Add-ins, and then click Go.
    5. In the Add-Ins dialog box, make sure that the Analysis ToolPak check box under Add-Ins available is selected.
    6. 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
    1. Select [Tools] from the top menu bar
    2. Select [Data Analysis]
  • From Excel 2007 and later
    1. From the top ribbon, select [Data]
    2. 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.

Computer Lab Activity #2
Creating a Histogram
Save (and then open) the file Ch04_Sugar_in_cereals.xls
  • 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.

    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.

    1. In the Data Analysis dialog box, click Histogram, and then click OK.
    2. In the input range, enter (or select) B2 to B50 ($B$2:$B$50)
    3. In the bin range, enter (or select) D1 to D4 ($D$1:$D$4)
    4. Check the box that says Label - notice that we selected the name Bin in our bin range
    5. In the output options, select Output Range F4
    6. 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.
    • You can add more bins as needed, or make the bins more meaningful.
    • Select Histogram again, change the Output range to "F14" and check the box Chart Output
    • Try some of the other histogram options
    • 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

Agenda for Tuesday September 27, 2011
Computer Lab Activity #1
    Basic Excel Lab
    We will walk through the steps to ...
  • Use the auto-sum features of Excel
  1. Right click on the file Ch03_Winter_Olympics_2006.xls
    and save it to your desktop or My Documents folder.
  2. Open the file using Excel (not in a web browser)
  3. Experiment with the autofill functions - try using the sum calculations to match the medal counts shown, then test out some of the other function.

Computer Lab Activity #2

Titanic - Bar Charts

Create a bar chart with the Titanic data. You may want to experiment with subtotals and counts. You can use the file that you used when creating a pie chart.

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
  1. In Microsoft Excel, from the top menu bar, select [File] and then select Print.
  2. From the print window, select [Find Printer]
  3. In the Name field, type in *STEMP and press the [Find Now] button
  4. Select the hsstemp printer
  5. 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.)
  6. 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.

Agenda for Thursday September 15, 2011

Chapter 2, Quetion 21 (posted)

  • Identify the Ws
Main Activity

Article Analysis

    In groups of 2-3:
  • Find an article in one of the magazines provided
  • Summarize the article
  • Identify the Ws
  • Create a poster/visual you will use to present your article to the class

Read the first half of Chapter 3

  • Pages 20-26

Agenda for Statistics Tuesday September 13, 2011
Main Activity

Computer Lab

  • Register online at
    1. Select Create my free account
    2. Select account-type "Student"
    3. Enter a userid and password that you will remember
    4. You do NOT have to put in your full last name, but please put in your real first name and last initial.
    5. you can enter your real e-mail address or an email address &
    6. go to the next screen and enter your class code: DMR649
    7. When you get to the class web site you should find one activity named "Evaluating Expressions", take it for a test drive.

  • Register online at
    1. Go to
    2. Click on the big yellow arror to sign up
    3. Create a userid/password
    4. To add a class you will need to follow the link "Click here to search a new class "
    5. Enter F-Block as a search term and select "keyword" search; select the box of the instructor "Jim Brennan" and the click on [Register] to submit your request.

  • Review the reference sites used by the textbook for up-to-date statistics
    • From the class site, click on the "Online Resources" tab at the top
    • Explore some of the web sites provided and create bookmarks for the one that you find interesting.

  • Learn how to play SET
    1. Go to
    2. Follow the link on the left How To Play
    3. View the "Flash Set Tutorial" but please keep your speaker volume down (not too loud, but not off)
    4. Try the Set Daily Puzzle

Agenda for Friday September 9, 2011
Main Activity

Introduction to Statistics

  • How many states have you visited?
  • Introduction to the textbook
  • Assigning textbooks
  • Homework : Complete before class on Wedneday September 14
  • Read chapter 1 (short)
  • Read chapter 2 (short - but read it carefully, browse some of the chapter questions)

Agenda for Thursday September 8, 2011
Main Activity

Statistics Pre-test

Agenda for Tuesday September 6, 2011
Main Activity

Revised Tuesday Schedule

  • Student Expectations
  • Complete the following sentences
    • I learn the best when ...
    • I find it difficult to learn when ...
    • The characteristics of a good student ...
    • The characteristics of a good teacher ...

Agenda for Tuesday August 30, 2011
Main Activity

Freshman Orientation

  • Introductions
  • Scavenger Hunt Clues