# 5.7 Assignment: Project – Applied Statistics

I don’t understand this Excel question and need help to study.

## Getting Started

The purpose of the Project assignment in each STAT-535 workshop is to provide you with an opportunity to demonstrate your ability to apply the statistical tools you have learned in this course.

## Resources

• Assigned Statistics for Managers: Using Microsoft Excel reading
• MyStatLab assignments
• File: Patients dataset (Excel)

## Background Information

In each workshop, you will be asked to demonstrate some of the knowledge you have gained by applying a few of the statistical tools that you have learned.

## Instructions

1. Treat the Patients dataset (Excel) as a sample from a larger population. Assuming that the total charges variable is normally distributed, use a one-tail t test of hypothesis (α = 0.05) for the mean (σ unknown) to test the hypothesis that the population mean total charges is greater than \$10,000. Make sure you define the null and alternate hypotheses. (20 points)
2. Using the pooled variance t-test for the difference between two means, at the 0.05 level of significance, is there evidence that the mean age for male patients is different from the mean age for female patients? Be sure to provide the null and alternate hypotheses. (20 points)
3. When you have completed your assignment, save a copy for yourself and submit a copy to your instructor using the Assignment submission page by the end of the workshop. Showing your work is required, not just providing answers without showing how you arrived at them.