Difference between revisions of "OpenOffice.org Internship/Projects/2010/Statistical Data Analysis Tool"
From Apache OpenOffice Wiki
(→Current tasks) |
|||
| Line 25: | Line 25: | ||
==Tasks Completed== | ==Tasks Completed== | ||
*The basic calc extension development has been completed together with the UI structure and the development structure of the extension | *The basic calc extension development has been completed together with the UI structure and the development structure of the extension | ||
| − | *The extension has been reviewed by my mentor | + | *The extension has been reviewed by my mentor and suggested necessary improvements |
*Correlation analysis | *Correlation analysis | ||
*Covariance analysis | *Covariance analysis | ||
| Line 33: | Line 33: | ||
**t test assuming equal variances | **t test assuming equal variances | ||
**t test assuming unequal variances | **t test assuming unequal variances | ||
| + | *ANOVA test | ||
| + | **One-way ANOVA | ||
| + | **Two-way ANOVA with replications | ||
| + | **Two-way ANOVA without replications | ||
==Current tasks== | ==Current tasks== | ||
Currently working on adding statistical functions to the developed extension. Familiarization with the statistical method and the development is going together with a set of statistical functions have been decided. | Currently working on adding statistical functions to the developed extension. Familiarization with the statistical method and the development is going together with a set of statistical functions have been decided. | ||
| − | * | + | *F test- Two samples for variances--''In progress'' |
| − | + | *Z test- Two samples for means | |
| − | + | ||
| − | * | + | |
==Project status== | ==Project status== | ||
*The project is accepted for the OpenOffice summer internship program 2010 | *The project is accepted for the OpenOffice summer internship program 2010 | ||
| + | *The project is proceeding with adding new analysis methods | ||
Revision as of 11:58, 30 August 2010
Contents
Overview
Statistical models are widely used in analysis of different types of data currently.Statistical analysis of data acts a major role in decision making under uncertainty and it is widely used in surveys, research,business and science. Hence it is very useful to have a statistical data analysis tool in a data manipulating application like Calc. The main aspect of the statistical data analysis tool project is to provide the user ability of performing various statistical functions to analyze data in openoffice calc in a very user friendly manner.
Project plan
- Developing a basic calc extension for data analysis--Done
- Determining the different analysis methods to be included in the tool --In progress
- Getting familiar with each analysis method and collecting information about --In progress
- How the data input should be given to the method
- Other external user given parameters required
- How the output should be displayed
- Developing each analysis method under the following steps -- In progress
- User interface design considering the input and other parameters required
- Developing the functionality of the method
- Displaying the output of the analysis
- Integrating the developed method with the analysis tool ( extension)
Enhancements
- Addition of more useful analysis methods
- User interface enhancements
Documentation
- Statistical data analysis tool documentation (updating the wiki etc.)
- Code documentation
Tasks Completed
- The basic calc extension development has been completed together with the UI structure and the development structure of the extension
- The extension has been reviewed by my mentor and suggested necessary improvements
- Correlation analysis
- Covariance analysis
- Rank and percentile analysis
- T test
- Paired t test for means
- t test assuming equal variances
- t test assuming unequal variances
- ANOVA test
- One-way ANOVA
- Two-way ANOVA with replications
- Two-way ANOVA without replications
Current tasks
Currently working on adding statistical functions to the developed extension. Familiarization with the statistical method and the development is going together with a set of statistical functions have been decided.
- F test- Two samples for variances--In progress
- Z test- Two samples for means
Project status
- The project is accepted for the OpenOffice summer internship program 2010
- The project is proceeding with adding new analysis methods
