# Can a table be created for these using excel

FratBro23
Category:
Statistics
Price: \$15 USD

Question description

Please write a few sentences discussing the interesting features of the data revealed by your display.

Binned Frequency tables.  Use the given bin sizes to make a frequency table for the following data set in Microsoft Excel:

89677875647083956984

77889890926886796096

In your table include columns for frequency, relative frequency, and cumulative frequency.  Be sure to use Excel to calculate these columns.  Refer to pages 310 – 312 as needed.

a. Use 5-point bins (95 to 99, 90 to 94, …)
b. Use 10-point bins (90 to 99, 80 to 89, …)

Largest States.  Make a bar graph of the populations of the five most populous states (2010 Census), with the bars in descending order.   Refer to p. 313 to 316 as needed.

State         Population

 California 37.3 million Texas 25.1 million New York 19.4 million Florida 18.8 million Illinois 12.8 million

Pie Charts.   Construct a pie chart for the following data set.  The first step is to compute a percentage for each category in the data set.   Refer to p. 313 to 316 as needed.

The annual revenue (in millions of dollars) of the leading food businesses are shown in the table below.

Company            Sales (\$ millions)

 PepsiCo 57.8 Kraft Foods 49.5 General Mills 14.8 Sara Lee 12.9 Kellogg 12.4

(Top Tutor) Daniel C.
(997)
School: Purdue University
Studypool has helped 1,244,100 students

1821 tutors are online

### Related Statistics questions

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors