Course Description
Quantitative methods and spreadsheet skills to support management practice and decision making. Topics include statistical hypothesis testing, confidence intervals, regression analysis, optimization modeling, decision analysis and risk analysis. Prerequisite: Admitted to M.B.A., P.B.C. in Business Foundations, or permission of the Program Director. Pre-M.B.A. workshop in statistics and spreadsheet skills or a spreadsheet-based undergraduate course in probability and statistics.
Syllabus
Student Learning Outcomes, Goals, Objectives:
Students successfully completing this course will be able to:
- Describe a set of data using histograms, scatter diagrams, and summary statistics.
- Compute statistics from sample data to support confidence interval estimation, hypothesis testing, and regression analysis.
- Infer the statistical precision of insights derived from confidence interval estimation, hypothesis testing, and regression analysis.
- Construct effective models of decision-making situations using principles of professional spreadsheet design.
- Compute optimal solutions to decision-making models for the management of a wide range of situations in which quantitative analysis improves decision-making.
- Analyze spreadsheet simulation models and decisions with uncertain outcomes by using multiple criteria for optimality and risk.
Course Grading Information:
| Activity/Performance Measure | Percentage/Points |
|---|---|
| Excel Prep Course | 10% |
| Quizzes | 20% |
| Homework Assignments | 30% |
| Final Exam | 35% |
| Participation and Professionalism | 5% |
Letter grade distribution: The required performance for each letter grade is given below. Note that final grade averages are not rounded off to the next higher integer. For example, a 92.99 is an A-, not an A.
Grading Scale
| Percentage | Letter Grade |
|---|---|
| 93-100% | A |
| 90-92.99% | A- |
| 87-89.99% | B+ |
| 83-86.99% | B |
| 80-82.99% | B- |
| 77-79.99% | C+ |
| 70-76.99% | C |
| Below 70% | F |
Attendance/Participation:
Course Videos: Students are strongly encouraged to watch all course videos, given the quantitative and hands-on nature of the course. Video viewing is not graded, but the assignments assume familiarity with the video content.
Late/Missed Assignments: Late or missed work without a university-approved excuse will receive a zero. Assignments are not accepted late for partial credit.
If a student anticipates missing a deadline due to a university-approved absence, they must notify the Professor before the due date — or, if advance notice is not possible, as soon as reasonably possible and no later than 24 hours after the due date, except in cases of documented emergency. Students must provide documentation supporting the excused absence, consistent with university policy.
Make-up work for approved absences is offered at the Professor's discretion and may consist of the original assignment or an alternative assignment the Professor deems appropriate to support student learning. The Professor will set the make-up deadline at the time the make-up is approved. Students should be aware that not all work can be made up: make-up work may be denied if (i) an alternative assignment would place an unreasonable demand on the Professor, or (ii) the nature of the original assignment is such that completing it after the assigned time would not serve its learning purpose. In such cases, the Professor may instead reweight the remaining coursework.
Course Materials Purchased by the Students:
MindTap® Business Statistics, Instant Access for S. Christian Albright & Wayne L. Winston, Business Analytics: Data Analysis and Decision Making; 7th Edition. 2017.
Scholarly Perspectives
This course engages diverse scholarly perspectives to develop critical thinking, analysis, and debate and inclusion of a reading does not imply endorsement.