Sign In | Subscribe
Start learning today, and be successful in your academic & professional career. Start Today!
Loading video...
This is a quick preview of the lesson. For full access, please Log In or Sign up.
For more information, please see full course syllabus of Statistics
  • Discussion

  • Study Guides

  • Download Lecture Slides

  • Table of Contents

  • Related Books

Bookmark and Share
Lecture Comments (10)

0 answers

Post by Michael Onizak on March 10, 2014

Just a heads up; those using MS Excel 2007 the pivot table button is located under the "Insert" tab not the "Data" tab. Also, as you saw the Apple version having three separate windows to create the pivot table where as the MS 2007 will be in one window. Hope this helps

0 answers

Post by steven bain on December 2, 2013

The files appear to the wrong files for this lesson waste of time!

0 answers

Post by Christopher Hu on November 17, 2013

hi Dr.  do you cover p-value?  thanks

0 answers

Post by Patrick Manuel on June 28, 2013

Where are the exercise files? I can't find them. Please post the exercise files. Thanks.

0 answers

Post by Monica Ballard on February 12, 2013




For the first expercise, my formula appears right in excel but I keep getting the answer of 0 rather than 7

0 answers

Post by Monica Ballard on February 12, 2013

For the first expercise, my formula appears right in excel but I keep getting the answer of 0 rather than 7

0 answers

Post by Brijesh Bolar on August 12, 2012

Very nice sessions. It is a pleasant surprise to learn excel as a part of stats course. I always wanted to learn excel for stats and this fulfills my wish.

2 answers

Last reply by: Jorge Delgado
Fri Nov 2, 2012 10:21 AM

Post by Robert Hsiao on January 27, 2012

I would like to download this data file, so it is easier to follow the lesson.

Planning and Conducting Experiments

  • Well designed and conducted experiments use random assignments and can be replicated.

  • Treatments: any specific experimental conditions applied to subjects.

  • Control Group: a group of individuals as similar as possible to individuals receiving treatment but do not receive treatment.

  • Random Assignments: experimental units are randomly assigned into the different treatment and control groups.

  • Replication: ensures that there are enough observations to reduce the variation in the results.

Planning and Conducting Experiments

Lecture Slides are screen-captured images of important points in the lecture. Students can download and print out these lecture slide images to do practice problems as well as take notes while watching the lecture.

  • Intro 0:00
  • Purpose 0:06
  • Characteristics 1:00
  • Basic Terms 2:00
    • Treatment
    • Control Group
    • Experimental Units
    • Random Assignment
    • Replication
  • Sources of Bias and Confounding 4:48
    • Counfounding
    • Example
    • Placebo Effect
    • Example
    • Blinding
    • Example
  • Completely Randomized Design 9:12
  • Randomized Block Design 12:44
    • Block
    • Matched Pairs
    • Example
    • Randomized Block Design
    • Example
  • Studies and Surveys vs Experiments 17:03