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

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.2: Representing Data
Problem 4GP
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
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL