The aim of the diploma thesis was to create independently an application, automating a correspondence analysis calculation using MS Excel and taking advantage of VBA programming language. The application was then used to analyse Slovak banking sector. The created application is based on macro sets which can be split up to two parts. The first part produces a contingency table and converts it into a format usable in the second part. Then there is executed the Correspondence Analysis calculation itself. Supplement Matrix is being used, that allows to discharge functions from matrix and linear algebra. The application allows to process any matrix dimension. Dialog window offers four normalization types, shortened and also full output and it is possible to display row or column variable categories, eventually both. The analysis subject was to find out which of the products are typical for considered banks and for which clients, divided into age categories, is attractive particular bank and/or product. A starting point is a product usage data matrix at a particular bank. There was made a conclusion, that it is possible to divide banks into more traditional or modern type institutions and also that each bank has a typical product.
| Identifer | oai:union.ndltd.org:nusl.cz/oai:invenio.nusl.cz:15778 |
| Date | January 2008 |
| Creators | Ganajová, Michaela |
| Contributors | Řezanková, Hana, Pecáková, Iva |
| Publisher | Vysoká škola ekonomická v Praze |
| Source Sets | Czech ETDs |
| Language | Czech |
| Detected Language | English |
| Type | info:eu-repo/semantics/masterThesis |
| Rights | info:eu-repo/semantics/restrictedAccess |
Page generated in 0.0023 seconds