# Statistics for Managers Using Microsoft Excel 5Th Edition

Document Sample

```					                                                  The School of Business & Technology

Course Syllabus
Course                BUSN 5760 - Applied Business Statistics
Term                  Spring 1, 2010
Little Rock Metropolitan Campus, Saturdays, 9:00 a.m. – 1:30 p.m.
Instructor            Name:           Sanders, Herman
Phone:          920-7794
Email:          sanders@webster.edu

Catalog Description   The student examines the application of statistical analysis, hypothesis testing,
and regression analysis in business decision making. The course should focus on
the utilization of statistical methods as applied to business problems and
operations.
Prerequisites         Basic mathematical and Personal Computer skills.

Course Level          a) Demonstrate the application of statistical theory to practical business
Learning Outcomes        situations and data.
b) Help the student develop skill in the statistical analysis and interpretation
of data.
c) Help the student develop insight in the selection and application of
problems.

Outcomes
1. Students can describe basic statistics concepts and apply proper sampling
methods.
2. Students can compute basic descriptive statistics.
3. Student can describe a normal distribution and apply the concepts of the
normal distribution to that of sampling distributions.
4. Students can construct confidence intervals for both numerical and categorical
data, and can apply to a real-world business scenario.
5. Students can use numerical or categorical data to assess the validity of
6. Students can perform simple and multiple regression analysis.
7. Students can determine expected wealth in an uncertain business climate.
8. Students can apply various advanced forecasting techniques.
Materials             Levine, D.M., Stephan, D., Krehbiel, T.C., & Berenson, M.L. Statistics for
Managers Using Microsoft Excel (5th edition). Upper Saddle River, NJ: Prentice
Hall. ISBN 0-13-229545-8.

93-100 A
90-92 A-
87-89 B+
83-86 B
80-82 B-
70-79 C
0-69 F

• CR Work that is performed as satisfactory graduate work (B– or better).
A grade of "CR”is reserved for courses designated by a department,
involving internships, a thesis, practicums, or specified courses.
• F Work that is unsatisfactory
• I Incomplete work
• ZF An incomplete which was not completed within one year of the end
of the course. ZF is treated the same as an F or NC for all cases involving
G.P.A., academic warning, probation, and dismissal.
• IP In progress
• NR Not reported
• W Withdrawn from the course
Activities            Course will be presented utilizing overhead projection equipment.

Weekly activities will include readings, lecture material, statistical exercises, and
discussions of statistical concepts. You are encouraged to use MS Excel to
complete all statistical exercises. You are also expected to participate in the
discussions.

There will be a Midterm Examination in week 4, covering all material from weeks
1, 2 and 3.

There will be a Final Examination in week 9, covering all material from weeks 5
through 8.

There will be a weekly assignment comprised of problems and conceptual
exercises (other than during the mid-term and final exam weeks). All problems
can be solved using Excel. Grading on these assignments will be based on
completion and timeliness.
Policy Statements:
University Policies   University policies are provided in the current course catalog and course
schedules. They are also available on the university website. This class is
governed by the university’s published policies. The following policies are of
particular interest:

The university is committed to high standards of academic honesty.
Students will be held responsible for violations of these standards. Please
refer to the university’s academic honesty policies for a definition of
academic dishonesty and potential disciplinary actions associated with it.

Drops and Withdrawals
Please be aware that, should you choose to drop or withdraw from this
course, the date on which you notify the university of your decision will
determine the amount of tuition refund you receive. Please refer to the
university policies on drops and withdrawals (published elsewhere) to find
out what the deadlines are for dropping a course with a full refund and for
withdrawing from a course with a partial refund.

Special Services
If you have registered as a student with a documented disability and are
entitled to classroom or testing accommodations, please inform the
instructor at the beginning of the course of the accommodations you will
require in this class so that these can be provided.

Disturbances
Since every student is entitled to full participation in class without
interruption, disruption of class by inconsiderate behavior is not
acceptable. Students are expected to treat the instructor and other students
with dignity and respect, especially in cases where a diversity of opinion
arises. Students who engage in disruptive behavior are subject to
disciplinary action, including removal from the course.

Student Assignments Retained
From time to time, student assignments or projects will be retained by The
Department for the purpose of academic assessment. In every case, should
the assignment or project be shared outside the academic Department, the
student's name and all identifying information about that student will be
redacted from the assignment or project.

Contact Hours for this Course
It is essential that all classes meet for the full instructional time as
scheduled. A class cannot be shortened in length. If a class session is
cancelled for any reason, it must be rescheduled.

Course Policies

Weekly Schedule   Week 1:         INTRODUCTION AND DESCRIPTIVE STATISTICS: Basic
Terminology, Descriptive Statistics, Charts and Graphs Chapters
1-3

Homework

* Q1) A survey indicates that male employees were more likely
than females to relocate without being promoted. What
information would you want to know before you accepted the
results of this survey?
* Q2) At your college’s main campus, 120 students are randomly
selected and asked the distance of their commute to campus.
From this group a mean of 3.2 miles is computed. Identify the
following as either (A) Observation, (B) Parameter, (C)
Population, (D) Sample, or (E) Statistic
o 2a) All students enrolled at the college
o 2b) The computed 3.2 miles
o 2c) The 120 students selected
o 2d) 8 miles distance traveled by one student
o 2e) The mean commute distance for all students
* Q3) Given a sample of 50 IQ scores ranging from 80 to 145, if
the 145 were accidentally typed in error as a 415, what would be
the impact on the following statistics? (answer with INCREASE,
DECREASE or REMAINS THE SAME).
o 3a) _____the mean
o 3b) _____the median
o 3c) _____the standard deviation
o 3d) _____the range
* Q4) Chapter 2: Problem 2.27abd (use intervals of 1.85-1.90,
1.90-1.95, 1.95-2.00, 2.00-2.05, 2.05-2.10, 2.10-2.15) using
Frequency_Distribution.xls
* Q5) Chapter 3: Problem 3.57abd using
Descriptive_Statistics.xls

Week 2:   DISCRETE PROBABILITY DISTRIBUTIONS AND NORMAL
PROBABILITY: Expected Value, Binomial Probability, Normal
Probability Chapters 4-6

Homework

* Q1) Chapter 4: Problem 4.9abc using Joint_Probability.xls
* Q2) Chapter 4: Problem 4.25ab using Joint_Probability.xls
* Q3) Chapter 5: Problem 5.5 using Expected_Value.xls
* Q4) Chapter 5: Problem 5.23 using Binomial_Probability.xls
* Q5) Chapter 6: Problem 6.7 using Normal_Probability.xls
* Q6) Chapter 6: Problem 6.11abd using Normal_Probability.xls

Week 3:   SAMPLING DISTRIBUTIONS, ESTIMATION: Central Limit
Theorem, Confidence Intervals for Means and Proportions,
Sample Size, Sampling Chapters 6-8

Homework

* Q1) Chapter 7: Problem 7.51abcd using
Normal_Probability.xls(Normal-CLT worksheet)
* Q2) Chapter 8: Problems 8.7ab using Confidence_Interval.xls
* Q3) Chapter 8: Problems 8.17ab using Confidence_Interval.xls
* Q4) Chapter 8: Problems 8.33a using Confidence_Interval.xls
* Q5) Chapter 8: Problems 8.71 using Confidence_Interval.xls
* Q6) Chapter 8: Problems 8.41 using Sample_Sizes.xls
* Q7) Chapter 8: Problems 8.73 using Sample_Sizes.xls

Week 4:   MID-TERM EXAM

Week 5:   HYPOTHESIS TESTING FOR ONE SAMPLE: One Sample
Hypothesis Testing for Means and Proportions Chapter 9
Homework

* Q1) Chapter 9: Problem 9.29a using
Hypothesis_Tests_One_Sample.xls
* Q2) Chapter 9: Problem 9.47b using
Hypothesis_Tests_One_Sample.xls
* Q3) Chapter 9: Problem 9.69a using
Hypothesis_Tests_One_Sample.xls
* Q4) Chapter 9: Problem 9.87ab using
Hypothesis_Tests_One_Sample.xls

Week 6:   HYPOTHESIS TESTING FOR 2+ SAMPLES: Two Sample
Hypothesis Testing for Means and Proportions, Analysis of
Variance Chapters 10-11

Homework

* Q1) Chapter 10: Problem 10.11a using
Hypothesis_Tests_Two_Samples.xls
* Q2) Chapter 10: Problem 10.27a using
Hypothesis_Tests_Two_Samples.xls
* Q3) Chapter 10: Problem 10.33a using
Hypothesis_Tests_Two_Samples.xls
* Q4) Chapter 11: Problem 11.13abd using ANOVA.xls

Week 7:   HYPOTHESIS TESTS OF RELATIONSHIPS: Correlation,
Simple Linear Regression, Chi Square Test of Independence
Chapters 12-13

Homework

* Q1) Chapter 12: Problem 12.23 using Chi_Square.xls
* Q2) Chapter 12: Problem 12.25 using Chi_Square.xls
* Q3) Chapter 13: Problem 13.77abcdfgh using Correlation.xls

Week 8:   MULTIVARIATE MODELING: Multiple Linear Regression,
Time Series Analysis with Smoothing and Seasonality Chapters
14 & 16

Homework

* Q1) Chapter 14: Problem 14.61abcdf using
Multiple_Regression.xls
* Q2) Chapter 16: Problem 16.7abcd using Forecasting.xls
* Q3) Chapter 16: Problem 16.49abf seasonal forecast only for
last 6 years (2000-2005) using Forecasting.xls

Week 9:   Final Exam; Hand in Homework and Research Project