data analysis

Faridak3
UNIT032MEASURESPROJECT.xlsx

INDEX

NAME : DATE:
TOPICS COVERED IN UNIT 3
1
2
3
4

EX 3.1 CENTRAL MEASURES

SAMPLE MEASURES
Account Amount MEASURE SAMPLE
P7-INVESTMENT 10,922.40 € OBSERVATIONS
P81-TELECOM SERVICES-OTHER 10,196.45 € MEAN
Z1-FINANC.INCOME-EXPENSES 1,078.50 € MEDIAN
P6-TRAVEL 3,095.26 € MODE
P3-PAYROLL 7,642.00 € MAX
P3-PAYROLL 2,140.00 € MIN
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

EX 3.2 WEIGHTED AVERAGE

WEIGHTED AVERAGE

EX 3.3 SHAPE

SAMPLE
Account Amount MODE
P7-INVESTMENT 10,922.40 € Me MEDIAN
P81-TELECOM SERVICES-OTHER 10,196.45 € MEAN
Z1-FINANC.INCOME-EXPENSES 1,078.50 € S STANDARD DEVIATION
P6-TRAVEL 3,095.26 €
P3-PAYROLL 7,642.00 € PEARSON
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 €

EX 3.4 DISPERSION

MEASURES OF DISPERSION
Account Amount
P7-INVESTMENT 10,922.40 €
P81-TELECOM SERVICES-OTHER 10,196.45 € MEASURE OF DISPERSION SAMPLE
Z1-FINANC.INCOME-EXPENSES 1,078.50 € OBSERVATIONS (N)
P6-TRAVEL 3,095.26 € RANGE (R)
P3-PAYROLL 7,642.00 € MEAN ABSOLUTE DEVIATION (MAD)
P3-PAYROLL 2,140.00 € SAMPLE VARIANCE (S2)
P3-PAYROLL 1,986.00 € SAMPLE STANDARD DEVIATION (S)
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