Question

Time
2
4
7
4
7
1
2
32
12
1
5
8
5
5
3
4
26
18
4
13 Sorting through unsolicited e-mail and spam affects the productivity of office workers. An InsightExpress survey monitored office workers to determine the unproductive time per day devoted to unsolicited e-mail and spam (USA Today, November 13, 2003). The data in the Microsoft Excel Online file below show a sample of time in minutes devoted to this task. Summarize the data by constructing the following items. x Open spreadsheet a. Fill in the frequency (to the nearest whole number), the relative frequency (2 decimals), the cumulative frequency (to the nearest whole number), and the cumulative relative frequency (2 decimals) values below. Class (Minutes) Frequency Relative Frequency Cumulative Frequency Cumulative Relative Frequency 1-5 6-10 11-15 16-20 21-25 26-30 31-35 (Total)

Answer 1

a)
.the completed frequency table be:-

class(minutes)	frequency	relative frequency	cumulative frequency	cumulative relative frequency
1-5	12	0.60	12	0.60
6-10	3	0.15	15	0.75
11-15	2	0.10	17	0.85
16-20	1	0.05	18	0.90
21-25	0	0.00	18	0.90
26-30	1	0.05	19	0.95
31-35	1	0.05	20	1.00
total	20	1.00

relative frequency = frequency of that class / 20

cumulative relative frequency = cumulative frequency of that class / 20

b).i). percentage of office workers spend 5 minutes or less on unsolicited email and spam = 60 %

[ from graph vale corresponding to 5 = 0.6 = (0.6*100) % = 60 % ]

ii).percentage of office workers spend more than 10 minutes on this task = 30 %

[ from graph value corresponding to 10 = 0.7

percentage of workers who spend more than 10 minutes = (1-0.7)*100% = 30% ]

*** if you have any doubt regarding the problem please write it in the comment box...if you are satisfied please give me a LIKE if possible...