An ROTC officer wanted to measure how many pushups his cadets are able to do in 1 minute in order to validate the results from their new training program. The results are as follows: 69 51 61 76 47 54 63 47 46 52 59 45 44 55 48 40 43 63 71 52 42 43 56 42 39 46 47 68 43 44 70 53 47 48 45 42 a. Construct a Frequency distribution table using 6 classes. Include true class boundaries, classmarks, relative frequencies, and greater than/less than cumulative frequencies. b. Draw a frequency histogram to represent the grouped data graphically. Do not forget to label the X and Y axes.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 42PFA
icon
Related questions
Question
100%

SHOW THE STEP BY STEP METHOD IN EXCEL

I WILL UPVOTE

An ROTC officer wanted to measure how many pushups his cadets are able to do in 1 minute in order to
validate the results from their new training program. The results are as follows:
69 51 61 76 47 54
63 47 46 52 59 45
44 55 48 40 43 63
71 52 42 43 56 42
39 46 47 68 43 44
70 53 47 48 45 42
a. Construct a Frequency distribution table using 6 classes. Include true class boundaries, classmarks,
relative frequencies, and greater than/less than cumulative frequencies.
b. Draw a frequency histogram to represent the grouped data graphically. Do not forget to label the X
and Y axes.
Transcribed Image Text:An ROTC officer wanted to measure how many pushups his cadets are able to do in 1 minute in order to validate the results from their new training program. The results are as follows: 69 51 61 76 47 54 63 47 46 52 59 45 44 55 48 40 43 63 71 52 42 43 56 42 39 46 47 68 43 44 70 53 47 48 45 42 a. Construct a Frequency distribution table using 6 classes. Include true class boundaries, classmarks, relative frequencies, and greater than/less than cumulative frequencies. b. Draw a frequency histogram to represent the grouped data graphically. Do not forget to label the X and Y axes.
Expert Solution
steps

Step by step

Solved in 3 steps with 7 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
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL