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 the 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: Correlation and Regression
• Video: Scatterplot and Simple Linear Progression
• Textbook: OpenIntro Statistics
• File: WS3Practice
• File: WS3Homework

Background Information

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

Instructions

1. Watch the following video on correlation and regression: 
2. Watch the Excel remediation video on scatterplots and simple linear regression: Scatterplot Regression.
3. An optional supplementary textbook is OpenIntro Statistics, and you can read the concepts there.
4. Use the lab file WS3Practice file to practice the Excel skills (includes an Excel hands-on video inside the spreadsheet as a link).
5. Use the file WS3Homework 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.