circumstances. Liabilities of Australian Private Non-Financial Corporations* (6%) Equity - Unilated (11%) Bills of Exchange Other Bonds - issued in Aust (294) $33b $113bn $117b Bonds - 188ued Olahore (5%) $99bn $218bn $557bn $785bn Loans & Placements (293) Equity - Lietud * Amount outstanding, as at September 2009. (Source: ABS Australian Financial Accounts). a Assignment - Compatibility Mode - Saved to this PC- Search Curricu Insert Design Layout References Mailings Review View Help Arial - 12 A A Aa A EA! BIab X, X A 1 Normal 1 No Spac... Heading 1 Title Subtitle inter Font 5 Paragraph Styles Question 12: Replicate the pie graph on page 36 of the ASX report. Use the September 2009 data row from the ABS financial accounts which is what the ASX used. Your boss wants you to show her a graph that looks the same. Specifically, the Colours need to be the same Order and placement of the sectors need to be identical. So 'Bills of Exchange' must be between the 12 and 1 o'clock markers on a clock and it must be yellow Sectors on the graph should be labeled with their name, amount outstanding, and percentage of the total (may be slightly different due to data revisions) Title and footnote should be the same. Note that the graph does not need to look identical to the one on page 36, it just needs to have the above similarities Include a table like that shown below with the variable and ABS series ID's of the data that you used to build the graphs. The series ID's are in row 10 of the data spreadsheets. The 'loans and placements' amounts have been provided as an example . 1 Normal 1 No Spac... Heading 1 Title Font Paragraph Styles Data Sources used in 'Liabilities of Australian Private Non-Financial Corporations' Graph Item ABS Series ID Bills of exchange Bonds - issued in Australia Bonds - issued offshore Loans and placements A3431753X + A3432599F Equity listed Equity unlisted Other 1 Be aware that the ASX report was written more than 10 years ago and the ABS has revised their data after its release so your numbers based on the latest data may have some differences compared to those shown in the ASX report In case it helps the original file from September 2009 published by the ABS that would have been used by the ASX in their report has been uploaded Include your graph in your answer to this question English font states Focus circumstances. Liabilities of Australian Private Non-Financial Corporations* (6%) Equity - Unilated (11%) Bills of Exchange Other Bonds - issued in Aust (294) $33b $113bn $117b Bonds - 188ued Olahore (5%) $99bn $218bn $557bn $785bn Loans & Placements (293) Equity - Lietud * Amount outstanding, as at September 2009. (Source: ABS Australian Financial Accounts). a Assignment - Compatibility Mode - Saved to this PC- Search Curricu Insert Design Layout References Mailings Review View Help Arial - 12 A A Aa A EA! BIab X, X A 1 Normal 1 No Spac... Heading 1 Title Subtitle inter Font 5 Paragraph Styles Question 12: Replicate the pie graph on page 36 of the ASX report. Use the September 2009 data row from the ABS financial accounts which is what the ASX used. Your boss wants you to show her a graph that looks the same. Specifically, the Colours need to be the same Order and placement of the sectors need to be identical. So 'Bills of Exchange' must be between the 12 and 1 o'clock markers on a clock and it must be yellow Sectors on the graph should be labeled with their name, amount outstanding, and percentage of the total (may be slightly different due to data revisions) Title and footnote should be the same. Note that the graph does not need to look identical to the one on page 36, it just needs to have the above similarities Include a table like that shown below with the variable and ABS series ID's of the data that you used to build the graphs. The series ID's are in row 10 of the data spreadsheets. The 'loans and placements' amounts have been provided as an example . 1 Normal 1 No Spac... Heading 1 Title Font Paragraph Styles Data Sources used in 'Liabilities of Australian Private Non-Financial Corporations' Graph Item ABS Series ID Bills of exchange Bonds - issued in Australia Bonds - issued offshore Loans and placements A3431753X + A3432599F Equity listed Equity unlisted Other 1 Be aware that the ASX report was written more than 10 years ago and the ABS has revised their data after its release so your numbers based on the latest data may have some differences compared to those shown in the ASX report In case it helps the original file from September 2009 published by the ABS that would have been used by the ASX in their report has been uploaded Include your graph in your answer to this question English font states Focus