|
In-Class Assignment 3
The manager of a clothing store decided to investigate the
relationship between the number of sales clerks on duty and the amount of
merchandise lost due to shoplifting and other causes. The dollar volume of lost
was recorded for each of the 12 weeks. The data is given below:
|
Weeks
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
|
No
of Clerks
|
20
|
21
|
22
|
23
|
24
|
25
|
25
|
20
|
22
|
24
|
26
|
28
|
|
Losses(in 100’s of $)
|
20
|
23
|
18
|
17
|
17
|
12
|
17
|
26
|
21
|
11
|
10
|
4
|
-
Using Excel 97, calculate the correlation between the number of
clerks present and the losses due to shoplifting and other causes. (Insert the
correlation coefficient value in the same sheet as the data)
-
Format your worksheet such that it’s presentable (You might want
to highlight the correlation co-efficient and its value).
Understanding the concept
Answer the following questions (You may either write on the print out, or type your answers on a
separate page using a word-processor).
|
