Explore BrainMass
Share

Statistics: Graphs and Frequency Distributions in EXCEL

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 25, 2018, 4:18 am ad1c9bdddf
https://brainmass.com/statistics/summary-tables/statistics-graphs-and-frequency-distributions-in-excel-373409

Solution Preview

Please refer to the attachment for the solutions.

Note: I have made one modification in ...

$2.19
See Also This Related BrainMass Solution

Construct a histogram, a frequency polygon and an ogive for the frequency distribution given

Please help with the following problem. Provide the answer in Excel.

I'm confused on how to create a histogram in Excel. The first two columns (Class Interval and Frequency) were given by the book. I manually figured out Class Midpoint and Cumulative Frequency, and I don't understand how to get Relative Frequency.

The problem is asking to construct a histogram, a frequency polygon and an ogive for the frequency distribution given.

See attached file for full problem description.

View Full Posting Details