3 assignments

by

 

5.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.

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:  using the  file. 
  3. An optional supplementary textbook is , 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 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 .
  3. After reading the Word document, open the file .
  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  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.