how can you plot this ogives in excel step-by-step?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
how can you plot this ogives in excel step-by-step?
30
29
29
26
23
25
22
20
20
15
14
15
10
39.910
44.545
49.180
53.815
58.450
63.085
67.720
Rainfall Intensity
Less-than Ogive
Greater-than Ogive
(Re verse) Cumulative Frequency
Transcribed Image Text:30 29 29 26 23 25 22 20 20 15 14 15 10 39.910 44.545 49.180 53.815 58.450 63.085 67.720 Rainfall Intensity Less-than Ogive Greater-than Ogive (Re verse) Cumulative Frequency
Class
Class Mark
Rel n
Cumu n
Rev Cumu n Cumu Rel n Rev Rel Cumu n
39.910
44.545
42.2275
0.241
7
29
0.241
1.000
44.545
49.180
46.8625
7
0.241
14
22
0.483
0.759
49.180
53.815
51.4975
0.207
20
15
0.690
0.517
53.815
58.450
56.1325
0.103
23
0.793
0.310
58.450
63.085
60.7675
3
0.103
26
0.897
0.207
63.085
67.720
65.4025
0.103
29
3
1.000
0.103
29
1.000
Transcribed Image Text:Class Class Mark Rel n Cumu n Rev Cumu n Cumu Rel n Rev Rel Cumu n 39.910 44.545 42.2275 0.241 7 29 0.241 1.000 44.545 49.180 46.8625 7 0.241 14 22 0.483 0.759 49.180 53.815 51.4975 0.207 20 15 0.690 0.517 53.815 58.450 56.1325 0.103 23 0.793 0.310 58.450 63.085 60.7675 3 0.103 26 0.897 0.207 63.085 67.720 65.4025 0.103 29 3 1.000 0.103 29 1.000
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman