Statistics for Managers Using Microsoft Excel 5Th Edition

Document Sample
Statistics for Managers Using Microsoft Excel 5Th Edition Powered By Docstoc
					                                                  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
                         statistical tests and methods appropriate to a broad scope of business
                         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
                          statements made in a business setting.
                      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.
Grading               Recommended scale

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


                      The GRADUATE catalog provides these guidelines and grading options:
                         • A/A– Superior graduate work
                         • B+/B/B– Satisfactory graduate work
                         • C Work that is barely adequate as graduate-level performance
                         • 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:

                      Academic Honesty
                           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
Additional    Mid-term Exam 25%
Information   Final Exam 25%
              Homework 25%
              Research Paper 25%

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:181
posted:8/19/2011
language:English
pages:6
Description: Statistics for Managers Using Microsoft Excel 5Th Edition document sample