# Expenses Worksheet by swj99471

VIEWS: 70 PAGES: 13

Expenses Worksheet document sample

• pg 1
```									                                       Worksheet

Flow Diagram for The inference about
two populations and ANOVA
• To help identify the procedure to use in
performing inference type analysis we need
to ask a few questions, and pay attention to
• The next slide provides a flow diagram that
helps you determine the proper procedure to
apply.

1
Worksheet

The Flow Diagram
1. How many
populations?
2 Populations       2. Define the       3 Populations
parameters
tested (in
words).

Yes         Paired        No                                Are there any
observations?                           Yes        characteristics     No
common to groups
Define mD;                            Check                         of observations?
H0: mD = 0                           whether
Run a                              Run a Single
H1: mD >,<,  0                      s12 = s 22
randomized                         factor
using the
block design                       ANOVA
F-test
ANOVA

No
Yes      s12 = s 22 ?

Run a t-test                    Run a t-test
for m1-m2                       for m1-m2 Use
with pooled                     S12 and S22 to
variance                        construct the
estimate (Sp2)                  t-statistic
2
Worksheet

Review Problem # 1
One factor in low productivity is the amount of time
wasted by workers. Wasted time includes time spent
cleaning up mistakes, waiting for more material and
equipment, and performing any other activity not related to
production. In a project designed to examine the problem,
an operations management consultant took a survey of 200
workers in companies that were classified as successful (on
the basis of their latest annual profits) and another 200
workers from unsuccessful companies. The amount of time
(in hours) wasted during a standard 40-hour workweek was
recorded for each worker. These data are stored in columns
1 (successful companies) and 2 (unsuccessful companies)
in file “Productivity”.                                    3
Worksheet

• Do these data provide enough evidence at
the 1% significance level to infer that the
amount of time wasted in unsuccessful
firms exceeds that of successful ones?
• Estimate with 95% confidence how much
more time is wasted in unsuccessful firms
than in successful ones.

productivity.xls

4
Worksheet

Review problem # 2
• Ikarus, the Hungarian bus maker, has lost its
important CIS market and is reported on the verge
of collapse. The company is now trying a new
engine in its buses and has gathered the random
samples of miles-per-gallon figures for the old
engine versus the new provided in file “Ikarus”.
• Is there evidence that the new engine is more
economical than the old one?
Ikarus.xls
5
Worksheet

Review Problem # 3
The president of a large company is in the process of
deciding whether to adopt a lunchtime exercise program.
The purpose of such programs is to improve the health of
workers and, in so doing, reduce medical expenses. To get
the employees in one office. The president knows that
during the winter months medical expenses are relatively
high because of the incidence of colds and flu.
Consequently, she decides to record medical expenses for
the 12 months before the program and for 12 months after
the program. The "before" and "after" expenses (in
thousands of dollars) are compared on a month-to-month
basis and shown in file “Expenses”.                       6
Worksheet

• Do the data indicate that exercise programs
reduce medical expenses? (Test with a =
.05.)
• Estimate with 95% confidence the mean
savings produced by exercise programs.

Expenses.xls

7
Worksheet

Review Problem # 4
uh ah.xls
A study performed by a Columbia University professor
(described in Report on Business, August 1991) counted
the number of times per minute professors from three
different departments said "uh" or "ah" during lectures to
fill gaps between words. The data derived from observing
100 minutes from each of the three departments are stored
in file “uh-ah” (Column 1 contains all the data for the
English department, column 2 stores the data for the
mathematics department, and column 3 stores the data for
the political science department.) If we assume that the
more frequent use of "uh” and "ah" results in more boring
lectures, can we conclude at the 5% significance level that
some departments' professors are more boring than others?
8
Worksheet

Review Problem # 5
The friendly folks at the IRS are always looking for ways
to improve the wording and format of its tax return forms.
Three new forms have been developed recently. To
determine which, if any, are superior to the current form,
120 individuals were asked to participate in an experiment.
Each one of the three new forms, as well as the currently
used form, were filled out by 30 different people. The
amount of time (in minutes) taken by each person to
complete the task was recorded and stored in File “IRS”.
The sample means and standard deviations were computed
as follows.
9
Worksheet

–   Form 1: mean = 90.17, standard deviation =31.49.
–   Form 2: mean = 95.77, standard deviation = 30.01.
–   Form 3: mean = 106.83, standard deviation = 30.47.
–   Form 4: mean = 111.17, standard deviation 31.99
• What conclusion can be drawn from these data? (Use ? =.05)
• What are the required conditions for the test conducted
above? Does it appear that the required conditions of the test
are satisfied? IRS.xls
• Can you determine which one of the forms
takes the shortest time to fill in? Use a = .05

10
Worksheet

Review Problem # 6
Many North Americans suffer from high levels of
cholesterol, which can lead to heart attacks. For those with
very high levels (over 280), doctors prescribe drugs to
reduce cholesterol levels. A pharmaceutical company has
recently developed three such drugs. To determine if any
differences exist in their benefits, an experiment was
organized. The company selected 25 groups of three men,
each of whom had levels in excess of 280. In each group,
the men were matched according to age and weight. The
drugs were administered over a two-month period, and the
reduction in cholesterol was recorded. The data are stored
in the first three columns of file Cholesterol. Do these
results allow the company to conclude at the 5%
significance level that differences exist among the three
new drugs?                                                  11
Worksheet

Review Problem # 7
Phonex provides call center services for many different companies.
One of four cities is being considered where a new call center is to be
established. Managers will have to be transferred to the new location,
and Phonex tries to find whether differences in housing prices exist
across the four competing cites. Having concerns about the large
variability among house prices due to house age and size, each house
observed was classified by age +size category, and its price then
recorded. See Phonex.xls.

–   At 5% significance level, is there evidence to conclude that on the
average house prices differ among the four cities?
–   Is it necessary to match house by Age+Size in the three cities (Alpha =
5%)
–   Answer to the best of your ability: Which city is most preferred in terms
of house prices?
12
Worksheet

Review Problem # 8
GroBros., A regional grocery store chain, is considering to
upgrading to a new series of price scanners. Scanners sometimes
have errors, and GroBros. wants to evaluate the average levels
of such errors for 4 different types of scanners(the current one,
and three new ones). Thirty different shopping baskets were
defined (which differ in the number of items, and the types of
items included). Each basket was scanned four times (by each
scanner) and then item prices were determined by hand. The
number of scanning errors in each basket was recorded. See file
GroBros.xls.

a.   State the hypothesis of interest for this test.
b.   At 1% significance level, is there a difference between the
number of errors among the scanners?                       13

```
To top