Can you complete this using Excel?
Can you complete this using Excel?
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.
Use 5-point bins (95 to 99, 90 to 94, …)
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 |
|
|
|
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
