Purchase Solution

# Statistics: Graphs and Frequency Distributions in EXCEL

Not what you're looking for?

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 ...

Solution provided by:
###### Education
• MSc, Osmania University
• MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
• BSc, Banaras Hindu University
###### Recent Feedback
• "Very fast turnaround. Excellent communication! Much appreciated!"
• "excellent"
• "excellent"
• "excellent work"
• "Fantastic..great solution and very well explained!!!!"

##### Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

##### Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

##### Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

##### Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.