Douglas A. Lind, William G. Marchal, Samuel A. Wathen, Statistical Techniques in Business and Economics, 12th edition. McGraw Hill Publisher ISBN: 0072868244
There are student workbooks that accompany the text that will assist students with exercises.
This text comes with statistical software called Megastat. It is a software program that is an add-in to Excel that will perform statistical functions for you very rapidly. It is highly recommended that students take advantage of the productivity that this software offers.
For those that have Excel expertise, Excel has many statistical functions on its own but Megastat makes them much easier to use. Students without any familiarity with Excel might consider the following text as well to assist them
ISBN: 0072868287: Douglas A. Lind, William G. Marchal, Samuel A. Wathen, Basic Statistics Using Excel for Office XP McGraw Hill Publisher
Catalog Course Objective
This course is for students who are only interested in learning advanced principles of quantitative methods for applying in business operations. The emphasis is gaining knowledge and understanding of the principles of statistics.
Course Objectives
At the end of this course, you should be able to demonstrate knowledge and understanding of the topics covered.
Topics to be covered:
Hypothesis Testing for Two Samples
Demonstrate an understanding of hypothesis testing for the difference between two population means, and two population proportions.
Distinguish between dependent and independent groups, and determine which test to apply in a given situation.
Explain the Wilcoxon Rank Sum Test for differences between two medians.
ANOVA
Demonstrate the F Test for differences of two population variances.
Explain the difference between one and two factor ANOVA and determine which is the most appropriate test for the business research application.
Demonstrate an understanding of testing three or more group means at one time; evaluate the output of the statistical tests; and determine if additional analysis is warranted.
Regression and Correlation
Demonstrate an understanding of simple regression model and its use in prediction.
Explain correlation and test the significance of that relationship; interpret the results from both manual calculations and computer output. Determine if a relationship exists between the two variables, and the direction of that relationship.
Explain the multiple regression model and its use in predicting events.
Explain the use of dummy variables in a regression analysis and their interrelationship with other quantitative variables, and interpret their impact on the model.
Explain the importance of multicollinearity and autocorrelation in a multiple regression analysis, and the various methods for controlling them.
Quality Control and Time Series Data
Explain the use of various statistical tools to evaluate the production process and/or quality of service.
Demonstrate and interpret diagrams to identify quality control problems.
Explain the various factors influencing time series data and interpretation of the data.
Analysis of Categorical Data
Explain the use of the chi-square goodness-of-fit test and interpret the output.
Demonstrate an understanding of the chi-square test of independence.
Multivariate Analysis
Describe the uses for multivariate analysis of business and survey data.
Expectations
As an on-line course you are expected to study the topic, work on problems from the text. The text contains the answers to the odd numbered problems as an appendix. Further problems are available in a student workbook that can be acquired to accompany the text.
Students will take a Mid-term and Final Exam which will demonstrate their knowledge of the material.
Operating Directions
This is a self-paced course guided by the instructor. Plan to complete all work 8 weeks.
You may use other statistics texts in addition to readings the textbook.
Submit all exercises as MS Word or Excel as email attachments.
You are required to be ethical as required by educational institutions.