Complete the multile choice question:
Graphs and Frequency Distributions in EXCEL
1. Twenty employees of Bright Idea Lightbulb Company were asked if they approved or disapproved of the new floor manager. Below are their responses. Let A represent approved and D represent disapproved.
A A D A D
D D A A D
D A D D A
D D D D A
a. Construct a frequency distribution and a bar graph.
b. Construct a relative frequency distribution and a pie chart.
2. Below, you are given the number of workers needed by Helping Hands Temporary Workforce over a period of days.
52 99 92 86 84
63 72 76 95 88
92 58 65 79 80
90 75 74 56 99
a. Construct a frequency distribution for this data. Let the first class be 5-59, and draw a histogram.
b. Construct a cumulative frequency distribution.
c. Construct a relative frequency distribution.
d. Construct a cumulative relative frequency distribution.
3. The frequency distribution below was constructed from data collected from a group of 25 residents at Perfect Vintage Retirement Home.
Height (in inches) Frequency
58-63 3
64-69 5
70-75 2
76-81 6
82-87 4
88-93 3
94-99 2
a. Construct a relative frequency distribution.
b. Construct a cumulative frequency distribution.
c. Construct a cumulative relative frequency distribution.