00:01
In this exercise, we're given a table that shows the various sources of income for the fiscal year 2003.
00:12
And we're going to use it, construct a relative frequency distribution.
00:22
And here we have excel.
00:26
So we're going to create a relative frequency distribution for this data.
00:30
So the first thing we need to do is to sum up all the values.
00:34
For the amount in dollars.
00:38
So we can insert the formula, you can insert a formula for the sum, and then press enter.
00:44
So the sum is $1 ,782 .3 billion.
00:54
If you want to get relative frequency, you introduce a column and put a formula that takes the amount per cost, a number per cost, a number, category divided by the total which is 1 ,782 then you press enter.
01:26
But from all the way down for the rest of the values.
01:31
So these are the relative frequencies.
01:35
And so this table is a table that gives us the relative frequency distribution for that data.
01:46
Next, in part b, we want to get what percentage of the total income is attributed to individual income taxes...