data analysis

profileFaridak3
UNIT022FREQUENCIESPROJECT.xlsx
Home>Business & Finance homework help>Accounting homework help>data analysis

INDEX

NAME : DATE:
TOPICS COVERED IN UNIT 2
1
2
3
4
5
6
7
8
9
10

P 2.1 Freq.Table

Account Amount
P7-INVESTMENT 10,922.40
P81-TELECOM SERVICES-OTHER 10,196.45
Z1-FINANC.INCOME-EXPENSES 1,078.50
P6-TRAVEL 3,095.26
P3-PAYROLL 7,642.00
P3-PAYROLL 2,140.00
P3-PAYROLL 1,986.00
P99-VARIOUS-OTHER 10,824.00
P5-OFFICE RENT 12,870.72
P84-AUDITORS & ADVISORS-OTHER 984.00
P99-VARIOUS-OTHER 17.00
P6-TRAVEL 911.24
P99-VARIOUS-OTHER 392.78
P4-INSURANCE 69.00
P99-VARIOUS-OTHER 6,027.00
P3-PAYROLL 51,468.83
C5-ADVANCE PAYMENT FROM XYZ 500,000.00
P7-INVESTMENT 172.20
P3-PAYROLL 12,385.00
P3-PAYROLL 19,757.00
P90-TAXES-OTHER 18,694.00
P6-TRAVEL 10,824.63
P7-INVESTMENT 4,194.30
P82-RECRUITMENT-OTHER 19,680.00
P99-VARIOUS-OTHER 220.20
C1-CLIENT XYZ 186,809.82
C4-VAT RETURN 45,537.00
P88-TRANSLATION-OTHER 204.18
P3-PAYROLL 121,691.77
P80-OFFICE MATERIAL-OTHER 758.57
P6-TRAVEL 14,900.00
Z1-FINANC.INCOME-EXPENSES 700.00
P86-ENERGY SERVICES-OTHER 17,500.00
P5-OFFICE RENT 13,205.28
P80-OFFICE MATERIAL-OTHER 40,233.67
P80-OFFICE MATERIAL-OTHER 384.01
P99-VARIOUS-OTHER 7,514.93
P80-OFFICE MATERIAL-OTHER 375.92
P89-COURIER SERVICES-OTHER 260.76
P81-TELECOM SERVICES-OTHER 11,500.00
P7-INVESTMENT 172.20
P6-TRAVEL 40,000.00

_x000D_&1#&"Calibri"&10&K000000 INTERNAL - RESTRICTED

P 2.2 Freq.Dist (Excel)

Account Amount
P7-INVESTMENT 10,922.40
P81-TELECOM SERVICES-OTHER 10,196.45
Z1-FINANC.INCOME-EXPENSES 1,078.50
P6-TRAVEL 3,095.26
P3-PAYROLL 7,642.00
P3-PAYROLL 2,140.00
P3-PAYROLL 1,986.00
P99-VARIOUS-OTHER 10,824.00
P5-OFFICE RENT 12,870.72
P84-AUDITORS & ADVISORS-OTHER 984.00
P99-VARIOUS-OTHER 17.00
P6-TRAVEL 911.24
P99-VARIOUS-OTHER 392.78
P4-INSURANCE 69.00
P99-VARIOUS-OTHER 6,027.00
P3-PAYROLL 51,468.83
C5-ADVANCE PAYMENT FROM XYZ 500,000.00
P7-INVESTMENT 172.20
P3-PAYROLL 12,385.00
P3-PAYROLL 19,757.00
P90-TAXES-OTHER 18,694.00
P6-TRAVEL 10,824.63
P7-INVESTMENT 4,194.30
P82-RECRUITMENT-OTHER 19,680.00
P99-VARIOUS-OTHER 220.20
C1-CLIENT XYZ 186,809.82
C4-VAT RETURN 45,537.00
P88-TRANSLATION-OTHER 204.18
P3-PAYROLL 121,691.77
P80-OFFICE MATERIAL-OTHER 758.57
P6-TRAVEL 14,900.00
Z1-FINANC.INCOME-EXPENSES 700.00
P86-ENERGY SERVICES-OTHER 17,500.00
P5-OFFICE RENT 13,205.28
P80-OFFICE MATERIAL-OTHER 40,233.67
P80-OFFICE MATERIAL-OTHER 384.01
P99-VARIOUS-OTHER 7,514.93
P80-OFFICE MATERIAL-OTHER 375.92
P89-COURIER SERVICES-OTHER 260.76
P81-TELECOM SERVICES-OTHER 11,500.00
P7-INVESTMENT 172.20
P6-TRAVEL 40,000.00

_x000D_&1#&"Calibri"&10&K000000 INTERNAL - RESTRICTED

P 2.3 Freq.Dist (Formula)

Account Amount
P7-INVESTMENT 10,922.40
P81-TELECOM SERVICES-OTHER 10,196.45
Z1-FINANC.INCOME-EXPENSES 1,078.50
P6-TRAVEL 3,095.26
P3-PAYROLL 7,642.00
P3-PAYROLL 2,140.00
P3-PAYROLL 1,986.00
P99-VARIOUS-OTHER 10,824.00
P5-OFFICE RENT 12,870.72
P84-AUDITORS & ADVISORS-OTHER 984.00
P99-VARIOUS-OTHER 17.00
P6-TRAVEL 911.24
P99-VARIOUS-OTHER 392.78
P4-INSURANCE 69.00
P99-VARIOUS-OTHER 6,027.00
P3-PAYROLL 51,468.83
C5-ADVANCE PAYMENT FROM XYZ 500,000.00
P7-INVESTMENT 172.20
P3-PAYROLL 12,385.00
P3-PAYROLL 19,757.00
P90-TAXES-OTHER 18,694.00
P6-TRAVEL 10,824.63
P7-INVESTMENT 4,194.30
P82-RECRUITMENT-OTHER 19,680.00
P99-VARIOUS-OTHER 220.20
C1-CLIENT XYZ 186,809.82
C4-VAT RETURN 45,537.00
P88-TRANSLATION-OTHER 204.18
P3-PAYROLL 121,691.77
P80-OFFICE MATERIAL-OTHER 758.57
P6-TRAVEL 14,900.00
Z1-FINANC.INCOME-EXPENSES 700.00
P86-ENERGY SERVICES-OTHER 17,500.00
P5-OFFICE RENT 13,205.28
P80-OFFICE MATERIAL-OTHER 40,233.67
P80-OFFICE MATERIAL-OTHER 384.01
P99-VARIOUS-OTHER 7,514.93
P80-OFFICE MATERIAL-OTHER 375.92
P89-COURIER SERVICES-OTHER 260.76
P81-TELECOM SERVICES-OTHER 11,500.00
P7-INVESTMENT 172.20
P6-TRAVEL 40,000.00

_x000D_&1#&"Calibri"&10&K000000 INTERNAL - RESTRICTED

P 2.4 Bar Chart

P 2.5 Pie Chart

P 2.6 Histogram

P.2.7 Cum.Histagram

P 2.8 Polygon

P 2.9 Cum. Polygon