4.1 Assignment: Reading and Remediation

 

Getting Started

Viewing the videos and practicing using the practice Excel file with its video can prepare you for the work needed on the research report for a data set.

In order to successfully complete this exercise, you should be able to:

  • Review videos about statistics fundamentals.
  • Practice with the Excel file provided.

Resources

  • Video: Hypothesis Testing
  • Video: Hypothesis Testing with Means
  • Video: T-Tests
  • Video: Independent T-Tests
  • Video: Excel video on Hypothesis Testing
  • Textbook: OpenIntro Statistics
  • File: WS4Practice
  • File: WS4Homework

Background Information

Providing background and descriptive statistics is like a literature review section of a dissertation. You review and communicate the analysis of the raw data. You present visual representations of the data to give meaning to the raw data.

Instructions

  1. Watch the following videos on hypothesis testing, hypothesis testing with means, t-tests, and independent t-ests:
  2. Watch the Excel remediation video, .
  3. An optional supplementary textbook is the , and you can read the concepts there.
  4. Use the lab file  to practice the Excel skills (includes an Excel hands-on video inside the spreadsheet as a link).
  5. Use the file  to demonstrate the Excel skills. Each of the six problems is worth 10 points, for a total of 60 points possible for this assignment.  
  6. When you have completed your assignment, save a copy for yourself and submit a copy to your instructor by the end of the workshop.