Share
Explore BrainMass

Statistics: Graphs and Frequency Distributions in EXCEL

Using Excel, please set these problems up in order to create the proper graphs.

Enter the following data into Microsoft Excel, and answer the questions.

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.

Solution Preview

Please refer to the attachment for the solutions.

Note: I have made one modification in ...

$2.19