STEPS

STatistical Education through Problem Solving:

Business Abstracts



* Bank Account Blues

How can the weekly sales of a financial services company be related to its press and advertising budget? Students are invited to investigate this with the aid of regression models. The material is suitable for students who already have some knowledge of regression and MINITAB, e.g. second or third year undergraduates in Business Studies. Emphasis is placed on the modelling cycle and particularly on model validation. A log file is compiled including text from screens, MINITAB screen shots and the students' own notes. This could form the basis of assessed work. All screen and text data is read from external plain text files and the program is therefore customisable by the tutor.

Minitab Release 6 or 8 is required for this module.


In the following modules, a large pharmaceutical company has a number of problems to which solutions are being sought.

* Probability Models

Issues of pollution control in the Company raise problems of simple probability distributions modelling. This material is suitable for students who already have some knowledge of probability distributions and simple MINITAB commands, e.g. first year undergraduates in Business Studies. Problems may be selected from a menu of six as directed by the tutor. Distributions include Binomial, Poisson and Normal. Emphasis is on the process of modelling rather than on a tutorial in probability. A log file is compiled including text from screens, MINITAB screen shots and the students' own notes. This could form the basis of assessed work.

Minitab Release 6 or 8 is required for this module.

* Market Testing SunJoy

The Company is planning to launch a new product. Before spending on research and market testing they require a pre-market test survey of likely buyer reaction to the product. A large demographic database will be used as population from which the student will have to select a suitable sample and summarise the results. The sampling methods covered will be SRS, Quota and Cluster.

* Unfinished Business

At the end of each financial year, the financial subsidiary of the Company has to make an assessment of the liability of the company for unsettled insurance claims. There are thousands of small claims through to fewer than ten extremely large claims. A database of outstanding claims will be available to the student from which to select samples. Sampling methods will be SRS and Stratified (fixed, proportional and optimal).

* Exploring Pharmaceutical Company Environments

The Company is located next to a river and is considering introducing a new product. The student is lead through an exploration of data sets that include expenditure on advertising, research and development and costs of pollution. Exploratory data analysis techniques such as stem and leaf, box and whisker and dot plots are used and lead to consideration of wider issues. On completion, the student will have identified important features of single sample data sets.

* Comparing Pharmaceutical Company Behaviour

The Company wish to include information on the biological effect of pollution in their dissemination of the new product launch. The student is led through a comparison of related data sets using simple extensions of exploratory data analysis techniques applied in the previous module. On completion, the student will be able to compare important features between two or more data sets.

* Suppliers - Do they Measure Up?

The Company uses several different suppliers of raw materials and wishes to assess the effect of supplier, if any, on production rate and product quality. Data for production under a range of conditions, (e.g. operator, line, equipment) with different suppliers is available and one and two factor ANOVA are use to address this problem.

* Salary Distributions

The Company employs a number of skilled and unskilled workers who are paid weekly. This same company also employs a number of salaried workers (paid annually). Students are invited to detect any discrimination between these different groups and also detect if there is any sex discrimination within them.

* Equipment Breakdown

Failure in equipment is an inevitable problem in manufacturing and a pharmaceutical company is no exception. The student is concerned with finding an effective probability distribution to represent these. Various alternatives (e.g. the Weibull and Gumbel) are considered. Beforehand, the student is given a backdrop to the problem by introducing hazard rates, censored and uncensored data, age and non-age-related failures etc.

* Quality Control

The Company has recently received complaints from a number of customers about products supplied to them being under weight. A set of process control data is available based on an existing quality management scheme. Two further datasets are provided in respect of alternative schemes carried out elsewhere. What inferences can be drawn for the schemes? Analysis relies on the use of control charts, capability indices etc.