|
|
Statistical Analysis in Web Environment
Postler, Štěpán ; Löster, Tomáš (advisor) ; Bílková, Diana (referee)
The aim of this thesis is creating a web application that allows dataset import and analyzing data with use of statistical methods. The application uses a user access that allows multiple number of persons manipulate with a single dataset, as well as interact with each other. Data is stored on a remote server and application is accessible from any computer that is connected to the Internet. The application is created in PHP programming language with use of MySQL database system, and user interface is built in HTML language with use of CSS styles. All parts of application are stored on an attached CD in form of text files. In addition to the web application, a part of the thesis is also a text output, which contains a theoretical part in form of description of the chosen statistical analysis methods, and a practical part containing list of application's functions, data model's description and demonstration of data analysis options on specific examples.
|
|
|
Statistical Analysis and Multivariate Methods in MS Excel
Postler, Štěpán ; Löster, Tomáš (advisor) ; Mazouch, Petr (referee)
The aim of this thesis is creating an application in Microsoft Office Excel 2003 that allows user to solve problems using some statistical analysis methods. This application is provided in stat.xls file, which is the main part of the thesis. The XLS file enables Excel to applicate methods of univariate and bivariate categorical analysis of frequencies, univariate, bivariate and even multivariate analysis of quantitative data and index analysis of economic data. To applicate the methods the file uses various forms, Excel R1C1 and Array formulas, macros and VBA code. The file is executable with Microsoft Office Excel 2003 or newer versions. The file is suitable mainly as utility for study of statistical methods and it can also be used with an extensive data file. In addition to the stat.xls file, a part of the thesis is also a text output, which contains description of the chosen statistical analysis methods, description of creating the file stat.xls itself and illustration of the file's functions on specific examples.
|
guest ::
