Can you complete this using Excel?

Oct 14th, 2015
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

 

 


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Boston College
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
ddg82
Dec 7th, 2016
" Thanks, good work "
kenmwao2
Nov 24th, 2016
" Solid work, thanks. "
tinytim47
Nov 24th, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
jestin7
Nov 15th, 2016
" This tutor is great! "
lilmoe415
Nov 1st, 2016
" Thank you, Thank you, for top quality work, this is your guy!! "
dontuwannaknow
Oct 10th, 2016
" Excellent work as always thanks so much "
thargrow
Oct 1st, 2016
" Very Satisfied. "
SjSurvivor143
Sep 26th, 2016
" Thanks for the help. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1821 tutors are online

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