data analysis
Faridak3
UNIT032MEASURESPROJECT.xlsxINDEX
| 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 € | xˉ | 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
