Can a table be created for these using excel

timer Asked: Oct 14th, 2015

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:




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


37.3 million


25.1 million

New York

19.4 million


18.8 million


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)



Kraft Foods


General Mills


Sara Lee 






Tutor Answer

(Top Tutor) Studypool Tutor
School: Rice University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags

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