What This Document Is
This document is a final exam homework assignment for a Statistics (MATH 309) course at Bryant & Stratton College. It assesses students’ ability to apply statistical concepts to a real-world dataset related to employee data at Company ABC. The exam focuses on descriptive statistics, data visualization, and hypothesis testing.
Why This Document Matters
This assignment is crucial for students enrolled in MATH 309 as it constitutes 15% of their overall grade. Successfully completing this exam demonstrates a student’s understanding of key statistical methods and their ability to interpret data, skills valuable for various business and analytical roles. It’s designed to be completed near the end of the course, serving as a comprehensive review of the material covered.
Common Limitations or Challenges
This document provides the exam questions and a dataset, but it does *not* offer solutions or detailed explanations of how to arrive at the answers. Students are expected to have a solid grasp of statistical principles and software like Excel to analyze the data independently. It also assumes prior knowledge of how to perform t-tests and create visualizations.
What This Document Provides
The full document includes:
* A dataset (Table 1) containing information on 15 sales representatives, including gender, ethnicity, pay rate, age, and employee satisfaction.
* Nine exam questions requiring students to calculate descriptive statistics (mean, standard deviation), create frequency tables and charts (pie and bar graphs), and perform a t-test to compare employee satisfaction between genders.
* Specific instructions for using Excel to analyze the data and present the results.
* Table 2 containing data for the t-test.
This preview *does not* include the answers to the exam questions, the completed Excel outputs, or detailed step-by-step instructions on how to perform the calculations or create the visualizations. It only provides a high-level overview of the exam’s content and structure.
