B. D H. 1. Problem 4 Use Excel, to create a histogram for the data set. Calculate the cumulate distributution (CDF), remembering that it cannot exceed a value of "1, and plot it on the histogram. The histogram requires the creation of bins with appropriate labels and the frequency of occurence in the data set. Properly document the plots. 2. 3 4. 10 74.526 215.622 254.145 339.301 120.998 178.184 11 30.538 78.750 30.246 76.587 101.603 134.792 12 113.371 29.040 130.969 272.140 78.224 28.045 13 33.916 126.160 48.544 25.277 32.002 149.421 14 306.667 78.755 434.396 104.543 89.517 132.051 15 70.101 126.397 59.329 11.848 71.900 146.558 16 117.949 110.836 302.844 130.652 162.865 65.039 17 91.635 76.391 183.824 150.341 113.358 53.634 324.889 39.666 18 286.099 231.812 37.862 76.014 358.842 19 401.227 100.513 122.532 338.950 48.866 20 110.595 14.491 53.306 453.981 167.567 53.593 21 252.401 47.123 139.744 54.303 361.257 112.461 22 342.701 254.182 64.467 54.361 69.798 203.400 221.645 99.848 12.850 175.563 85.468 23 24 86.251 109.636 105.387 65.900 64.516 77.185 191.923

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

please show step by step on excel, new one excel

A.
B
F
H.
Problem 4 Use Excel, to create a histogram for the
data set. Calculate the cumulate distributution
(CDF), remembering that it cannot exceed a value of
"1", and plot it on the histogram. The histogram
4.
requires the creation of bins with appropriate labels
and the frequency of occurence in the data set.
Properly document the plots.
7.
8.
10
74.526
215.622 254.145
339.301 120.998
178.184
11
30.538
78.750
30.246
76.587
101.603
134.792
12
113.371
29.040
130.969
272.140
78.224
28.045
13
33.916
126.160
48.544
25.277
32.002
149.421
14
306.667
78.755
434.396
104.543
89.517
132.051
15
70.101
126.397
59.329
11.848
71.900
146.558
16
117.949
110.836
302.844
130.652 162.865
65.039
17
91.635
76.391
183.824
150.341
113.358
53.634
18
286.099
231.812
37.862
324.889
76.014
358.842
19
401.227 100.513
122.532
39.666
338.950
48.866
20
110,595
14.491
53.306
453.981
167.567
53,593
21
252.401
47.123
139.744
54.303
361.257
112.461
22
342.701 254.182
64.467
54.361
69.798
203.400
23
221.645
12.850
86.251
109.636
175.563
85.468
24
99.848
105.387
65.900
64.516
77.185
191.923
Transcribed Image Text:A. B F H. Problem 4 Use Excel, to create a histogram for the data set. Calculate the cumulate distributution (CDF), remembering that it cannot exceed a value of "1", and plot it on the histogram. The histogram 4. requires the creation of bins with appropriate labels and the frequency of occurence in the data set. Properly document the plots. 7. 8. 10 74.526 215.622 254.145 339.301 120.998 178.184 11 30.538 78.750 30.246 76.587 101.603 134.792 12 113.371 29.040 130.969 272.140 78.224 28.045 13 33.916 126.160 48.544 25.277 32.002 149.421 14 306.667 78.755 434.396 104.543 89.517 132.051 15 70.101 126.397 59.329 11.848 71.900 146.558 16 117.949 110.836 302.844 130.652 162.865 65.039 17 91.635 76.391 183.824 150.341 113.358 53.634 18 286.099 231.812 37.862 324.889 76.014 358.842 19 401.227 100.513 122.532 39.666 338.950 48.866 20 110,595 14.491 53.306 453.981 167.567 53,593 21 252.401 47.123 139.744 54.303 361.257 112.461 22 342.701 254.182 64.467 54.361 69.798 203.400 23 221.645 12.850 86.251 109.636 175.563 85.468 24 99.848 105.387 65.900 64.516 77.185 191.923
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY