6. Using Excel Relative and cumulative frequency distributions Aa Aa The distrib

Question

6. Using Excel Relative and cumulative frequency distributions Aa Aa The distribution of personal income in the United States in 2008 is shown in the following table. (Data source: These data were obtained from the U.S. Census Bureau, distribution of personal income, 2008.) Income Range $19,999 and below $20,000 to $39,999 $40,000 to $59,999 $60,000 to $79,999 $80,000 to $99,999 $100,000 and over Number of Individuals (Thousands) 82,611 58,656 32,540 16,930 7,880 13,215 To answer the questions that follow, download an Excel spreadsheet containing the given data by clicking on the following words in bold: Download Excel File The upper left-hand corner of the Excel spreadsheet in the file you download should look like the following sample spreadsheet. Use Excel to compute the relative frequency and cumulative frequency distributions and select the correct values in the sample spreadsheet. Number of Individuals (Thousands) 82,611 58,656 32,540 16,930 7,880 13,215 Relative Frequency 0.39 Cumulative Relative Frequency 0.39 Income Range 2 $%19,999 and below 3 $20,000 to $39,999 4 $40,000 to $59,999 5 $60,000 to $79,999 6 $80,000 to $99,999 7 $100,000 and over 0.06 1.00

Explanation / Answer

how we got 0.30 in Rel freq

82611/211832=0.39

58656/211832=0.28

32540/211832=0.15

16930/211832

7880/211832

13215/211832

Cumulative Frequency we got as

0.39

0.39+0.28

0.39+0.28+0.15

0..39+0.28+0.15+0.08

0..39+0.28+0.15+0.08+0.04

0..39+0.28+0.15+0.08+0.04+0.06

Income Range Number of Individuals Rel freq Cumulative Rel Freq 19999 and below 82611 0.39 0.39 20000 to 39999 58656 0.28 0.67 40000 to 59999 32540 0.15 0.82 60000 to 79999 16930 0.08 0.90 80000 to 99999 7880 0.04 0.94 100000 and over 13215 0.06 1.00 Total 211832

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.