MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
Bartleby Related Questions Icon

Related questions

Question

Create a histogram of the actors' age data using Excel

  • First we need to define the bins that Excel will use to create the histogram. In this case, our minimum data point is 31, and our max is 76. We'll use a bin width of 5, and make bins from 30 to 80:
  • In one of the columns near the data, enter these numbers: 30, 35, 40, 45, etc., up to 80.
  • Now click the Data tab and select the Data Analysis button. Then choose Histogram in the resulting pop-up window and click OK.
  • In the next window, click in the box next to Input Range and select the cells containing your data.
  • Then click in the box next to Bin Range and then select the cells containing your bin information.
  • Finally, check the box at the bottom of this window marked Chart Output, and then click OK.
  • Excel will create a new worksheet containing the histogram and a table with the frequency counts. The histogram is usually pretty small; you can click on it and then drag one of the handles on the outside to enlarge it.
  • Histograms shouldn't have spaces between the bars, so right-click on one of the bars and choose Format Data Series. Once the Format Data Series window appears set the gap width to 0% (No Gap).
  • Before closing the Format Data Series window, click on Fill & Line tab (paint bucket) on the left, click the Border and select Solid line, and set the color to black.
  • Close the Format Data Series window by clicking the X button. You will now see the histogram graph with the new border changes.
Dataset: Best Actor Oscar Winners (1970-2001)
Best Actor Oscar Winners (1970-2001)
Name
George C. Scott
Movie
Gene Hackman
Marlon Brando
Year
1970
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
Nicolas Cage
1996
Geoffrey Rush
1997
Jack Nicholson
1998
Roberto Benigni
1999
Kevin Spacey
Russell Crowe
2000
2001 Denzel Washington Training Day
Jack Lemmon
Art Carney
Jack Nicholson
Peter Finch
Richard Dreyfuss
Jon Voight
Dustin Hoffman
Robert De Niro
Henry Fonda
Ben Kingsley
Robert Duvall
F. Murray Abraham
William Hurt
Paul Newman
Michael Douglas
Dustin Hoffman
Daniel Day-Lewis
Jeremy Irons
Anthony Hopkins
Al Pacino
Tom Hanks
Tom Hanks
Patton
The French Connection
The Godfather
Save the Tiger
Harry and Tonto
One Flew over the Cuckoo's Nest 38
Network
The Goodbye Girl
Coming Home
Kramer vs. Kramer
Raging Bull
On Golden Pond
Gandhi
Tender Mercies
Amadeus
Kiss of the Spider Woman
The Color of Money
Wall Street
Rain Man
My Left Foot
Reversal of Fortune
The Silence of the Lambs
Scent of a Woman
Philadelphia
Forrest Gump
Leaving Las Vegas
Shine
PHONG76684496858±±±6%54848+
As Good As it Gets
Life is Beautiful
American Beauty
Gladiator
Age
43
40
60
32
40
42
37
39
35
61
33
51
32
43
42
37
38
31
60
40
36
expand button
Transcribed Image Text:Dataset: Best Actor Oscar Winners (1970-2001) Best Actor Oscar Winners (1970-2001) Name George C. Scott Movie Gene Hackman Marlon Brando Year 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 Nicolas Cage 1996 Geoffrey Rush 1997 Jack Nicholson 1998 Roberto Benigni 1999 Kevin Spacey Russell Crowe 2000 2001 Denzel Washington Training Day Jack Lemmon Art Carney Jack Nicholson Peter Finch Richard Dreyfuss Jon Voight Dustin Hoffman Robert De Niro Henry Fonda Ben Kingsley Robert Duvall F. Murray Abraham William Hurt Paul Newman Michael Douglas Dustin Hoffman Daniel Day-Lewis Jeremy Irons Anthony Hopkins Al Pacino Tom Hanks Tom Hanks Patton The French Connection The Godfather Save the Tiger Harry and Tonto One Flew over the Cuckoo's Nest 38 Network The Goodbye Girl Coming Home Kramer vs. Kramer Raging Bull On Golden Pond Gandhi Tender Mercies Amadeus Kiss of the Spider Woman The Color of Money Wall Street Rain Man My Left Foot Reversal of Fortune The Silence of the Lambs Scent of a Woman Philadelphia Forrest Gump Leaving Las Vegas Shine PHONG76684496858±±±6%54848+ As Good As it Gets Life is Beautiful American Beauty Gladiator Age 43 40 60 32 40 42 37 39 35 61 33 51 32 43 42 37 38 31 60 40 36
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman