Can you do just exercise D and E thank you

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Can you do just exercise D and E thank you
D.
What do the Frequency Distributions tell us?
E. Draw a histogram, frequency polygon, and cumulative frequency polygon (ogive) using Microsoft
Excel. A proper ogive has two Y-Axes. The left Y-Axis shows the cumulate frequencies. The second Y-Axis
on the right shows the cumulative relative frequencies. The scale of the second Y-Axis must not exceed
100%. Do not draw a Pareto Chart. Remember: With the histogram there are no gaps between columns.
Do not use 3-D effects in your charts. Paste your charts using Word's Paste Special function.
Histogram:
Frequency Polygon:
Ogive:
Transcribed Image Text:D. What do the Frequency Distributions tell us? E. Draw a histogram, frequency polygon, and cumulative frequency polygon (ogive) using Microsoft Excel. A proper ogive has two Y-Axes. The left Y-Axis shows the cumulate frequencies. The second Y-Axis on the right shows the cumulative relative frequencies. The scale of the second Y-Axis must not exceed 100%. Do not draw a Pareto Chart. Remember: With the histogram there are no gaps between columns. Do not use 3-D effects in your charts. Paste your charts using Word's Paste Special function. Histogram: Frequency Polygon: Ogive:
Exercise 1:
Data for a sample of checks from the Metro Diner from this past week can be found in the Excel workshee
titled Exercise1 and is shown below:
$77 $55 $85
$74
$71 $60
$99
$85 $62
$57
$59
$58
$91
$71
$66
$6
$67
$70
$94 $68
$57
$77
$77
$97 $85
$99
$78 $73
$73
$74
$85
$55
$99
$56
$75
$53 $50
$72 $69
$103
Model your answers on the examples shown in Clear-Sighted Statistics.
A. How many classes would you recommend? Use the 2 to the k rule: 2k > n.
B. What class interval would you suggest? Use this formula:
Н-L
i2
C. Construct a frequency distribution, relative frequency distribution, a cumulative frequency
distribution, and a cumulative relative frequency distribution. Show all four distributions on a
single table. Paste your frequency distributions from Excel into Word using the instructions shown in
the instructions to this assignment.
Transcribed Image Text:Exercise 1: Data for a sample of checks from the Metro Diner from this past week can be found in the Excel workshee titled Exercise1 and is shown below: $77 $55 $85 $74 $71 $60 $99 $85 $62 $57 $59 $58 $91 $71 $66 $6 $67 $70 $94 $68 $57 $77 $77 $97 $85 $99 $78 $73 $73 $74 $85 $55 $99 $56 $75 $53 $50 $72 $69 $103 Model your answers on the examples shown in Clear-Sighted Statistics. A. How many classes would you recommend? Use the 2 to the k rule: 2k > n. B. What class interval would you suggest? Use this formula: Н-L i2 C. Construct a frequency distribution, relative frequency distribution, a cumulative frequency distribution, and a cumulative relative frequency distribution. Show all four distributions on a single table. Paste your frequency distributions from Excel into Word using the instructions shown in the instructions to this assignment.
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman