What This Document Is
This document is a final exam for Week 7.5 of MATH 309 - Statistics at Bryant & Stratton College. It assesses students’ ability to apply statistical concepts to a real-world Human Resources dataset concerning sales representatives at Company ABC. The exam is worth 15% of the overall course grade.
Why This Document Matters
This exam is crucial for students enrolled in MATH 309 to demonstrate their understanding of descriptive statistics and hypothesis testing. It’s designed to be completed after covering topics like data analysis in Excel, frequency distributions, and t-tests. Successful completion indicates a grasp of how to interpret data and draw conclusions relevant to business scenarios.
Common Limitations or Challenges
This document *is* an assessment, not a learning tool. It tests existing knowledge and skills. It does not provide instruction on *how* to perform the statistical analyses, but rather expects students to already know those methods. Students will need access to Excel and a foundational understanding of statistical principles to complete the exam.
What This Document Provides
The exam includes:
* A dataset (Table 1) of 15 sales representatives with variables like gender, ethnicity, pay rate, age, and employee satisfaction.
* Nine questions requiring descriptive statistics calculations (mean, standard deviation) using Excel.
* Tasks involving creating frequency tables and charts (pie and bar graphs) to visualize ethnicity data.
* A hypothesis test (t-test) to compare employee satisfaction between genders, including null and alternative hypothesis formulation and interpretation of Excel output.
* A second dataset (Table 2) specifically for the t-test calculations.
This preview does *not* include the answers to the exam questions, the completed Excel calculations, or the generated charts. It only provides a structural overview of the exam’s content.
