Blog

Reading and Remediation Assignment

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.

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

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

Resources

• File: WS5Practice
• File: WS5Homework
• Video: Chi-Square
• Video: Chi-Square Testing
• Textbook: OpenIntro Statistics
• File: Chi-Square_10by10.xlsx

Background Information

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

Instructions

1. Watch the following video on chi-square:
2. Watch the Excel remediation videos on chi-square testing: Chi-Square Testing using the Chi-Square_10by10.xlsx file.
3. An optional supplementary textbook is OpenIntro Statistics, and you can read the concepts there.
4. Use the lab file WS5Practice to practice the Excel skills (includes an Excel hands-on video inside the spreadsheet as a link).
5. Use the file WS5Homework to demonstrate the Excel skills. Each of the three problems is worth 20 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

5.2 Assignment: Summarizing Raw Data

Getting Started

Being able to summarize data using pivot tables is a crucial skill to develop in business and research. Excel provides a powerful pivot table tool that is heavily used in finance, accounting, information technology, and other business areas. In this course, the skill is used to support a chi-square analysis.

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

• Summarize data into a contingency table from raw data using pivot tables.

Resources

• File: WS5-2_PivotTables
• File: WS5-2_PivotAssignment

Instructions

1. Review the rubric to make sure you understand the criteria for earning your grade.
2. Read the file WS5-2_PivotTables.
3. After reading the Word document, open the file WS5-2_PivotAssignment.
4. Create the appropriate summary tables called contingency tables.
5. When you have completed your assignment, save a copy for yourself and submit a copy to your instructor by the end of the workshop.

5.4 Assignment: Create Categorical Hypothesis

Getting Started

After the prior activities, the analysis section can be written for the research report. Since there are three analyses to perform, this is a partial assignment for the analysis section.

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

• Write part of the analysis section for a data set.

Resources

• File: Research Report Patients
• Your most recent research report

Background Information

This is one of the more detailed assignments in this course. You will write your third analysis for the report.

Instructions

1. Study the Research Report Patients file.
2. In your report, fill out the third analysis section, including any statistics and graphs and interpretation on the analysis.
3. When you have completed your assignment, save a copy for yourself and submit a copy of the research report to your instructor by the end of the workshop.