Introduction to database and analysis software’s suitable for.pptx

This ppt provides brief introduction and major strengths and limitations of database and analysis software’s suitable for health research.

1. Introduction to database and analysis software’s suitable for health research Presentation By : Nabin Parajul Roll no : 10 MPH 1 st semester, 2024 batch 30/07/2024 1

2. Introduction to database and analysis software’s. Application of software in public health. Overview on Epi info SPSS Ms excel R Stata Python Reference 30/07/2024 2 Contents

3. Database An organized collection of data, generally stored and accessed electronically from a computer system. Data can be easily accessed and manipulated by authorized users. Eg : Electricity service provider uses database to manage bills, client id and issues, social media like FB, Instagram etc Software A set of instructions, data, or programs used to operate computers and execute specific tasks. Enhances the capabilities of hardware, allowing users to perform a wide range of tasks. 30/07/2024 3 Introduction to database and analysis software’s.

4. Application software specifically designed for statistical analysis and data visualization. It assist to manage and manipulate large datasets. Provides tools for performing various statistical tests and procedures. It plays a crucial role in enhancing the efficiency and effectiveness of public health functions. Eg : Ms excel, SPSS, Python, Epi info, Stata, etc. 30/07/2024 4 Statistical software

5. Systematic data collection, storage and management. Data analysis, identifying health trend in diseases surveillance. Health promotion and education. Collaborating health information for planning and policy formation. Conducting research. Training and capacity building. 30/07/2024 5 Application of software in public health.

6. 30/07/2024 6 Epi info Epi Info™ a public domain software tool fo r public health practitioners and researchers.   Developed by centre for disease control (CDC) The software enables epidemiologists and other public health professionals to create questionnaire, customize the data entry process, and analyse data.

7. 30/07/2024 7 Tools in Epi Info

8. Create Forms – Create a questionnaire using one or more forms to collect and view data. Enter Data – Enter data and view existing records. Analyse Data (Classic and Visual Dashboard) – Manage data, run statistical analyses, and generate lists, tables, graphs, and charts. Create Maps – Create maps from map server. 30/07/2024 8 Contd..

9. Strengths Cost effective as no licensing fee is required. Its tools are compatible in mobile devices so easy for field activities. Includes a wide range of statistical analysis tools for epidemiological research. Integrated Geographic Information System (GIS) for mapping and spatial analysis. Developed for public health practitioners so easy for disease surveillance and outbreak investigation. 30/07/2024 9 Strengths and limitations

10. Limitations. It lacks some advanced statistical techniques found in other software. Working with large datasets affects in performance and analysis speed. It is primarily desktop based software therefore there might be security risk associated with data storage and management Although it was developed by CDC the user community is very small compare to other software’s. 30/07/2024 10 Contd..

11. 30/07/2024 11 Statistical Package for Social Science (SPSS) IBM SPSS It is a software package used for the analysis of statistical data (data management, advanced analytics, multivariate analysis, business intelligence, and criminal investigation) It was developed by three students at the University of Stanford (Norman H. Nie, C. Hadlai (Tex) Hull and Dale H. Bent)

12. 1. Data editor window Used to define, enter and edit data and run statistical tests. Data view Variable view 2. Output window show the results that have been output from data analysis 3. Syntax window Shows the underlying commands that have been executed in data analysis. Activated when we click on the paste function 30/07/2024 12 Windows in SPSS

13. 30/07/2024 13 Contd.. Data view Variable view

14. 30/07/2024 14 Contd.. Output window Syntax view

15. Descriptive statistics : All the measures of central tendency, Dispersion, percentile values etc can be analysed Frequency Descriptive Cross tab Explore 30/07/2024 15 Analysis in SPSS

16. 30/07/2024 16 Descriptive statistics

17. Statistical procedure often performed for testing the mean value of a distribution. Used under the assumption that population from which data are drawn is normally distributed. one sample T-test Independent sample T-test Paired sample T-test One way anova 30/07/2024 17 Parametric test

18. 30/07/2024 18 Contd..

19. Chi- square Test McNemar’s Test Mann Whitney Wilcoxon Matched Pairs Signed Ranks Test 30/07/2024 19 Non-para meteric test

20. 30/07/2024 20

21. Strength SPSS offers wide range of statistical tools which are suitable for data analysis. SPSS provides tools for creating visual and graphical representations. Many complex statistical tests are available as built in features Timely update of necessary tools in different versions. 30/07/2024 21 Strength and Limitation of SPSS

22. Limitations SPSS can be expensive to buy for students. Usually training requires to explore all the features. It analyse whatever the command it receives although output has no meaning. It is designed primarily for quantitative data so not suitable for all types of data. 30/07/2024 22 Contd..

23. 30/07/2024 23 Ms Excel It is a versatile spreadsheet software, using a grid of cells in rows and column to manipulate data. It is developed by Microsoft and be used in computes and mobiles with inbuild features. It is globally used to organize data and usually for financial analysis

24. Excel allows users to create and organize data in a tabular format with rows and columns. Excel provides a wide range of built-in functions (e.g., SUM, AVERAGE,) for mathematical operations. Excel offers various chart types (bar, line, pie, etc.) for data visualization. Excel files can be shared, collaborated on, and tracked by multiple users. 30/07/2024 24 Features of Ms Excel

25. 30/07/2024 25 outlook

26. 30/07/2024 26 R ‘R’ software is widely used  free statistical software  that provides statistical and graphical techniques including linear and non-linear modeling It is developed by R core team (Ross ihaka and Robert Gentlemen)

27. R software is open source and its free. Toolboxes essentially plugins are available for great range of applications. Knowledge of coding is required here A large, coherent, integrated collection of intermediate tools for data analysis, Graphical facilities for data analysis and display either on-screen or on hardcopy R is used for quantitative data analysis 30/07/2024 27 Features

28. 30/07/2024 28 Stata Stata is also a widely used software that enables to analyze , manage, store and produce graphical visualization of data. Stata was initially developed by Computing Resource Center in California and the first version was released in 1985

29. Stata provides robust tools for statistical analysis. Researchers and analysts worldwide trust it for its accuracy and efficiency. Stata allows to store, organize, and manipulate data for large or small datasets. It is generally used by researchers in the field of economics, social sciences and biomedicine to examine the data patterns. Stata is used for quantitative data analysis 30/07/2024 29 Features of Stata

30. 30/07/2024 30 Python Python  is a fully functional, open, interpreted programming language It was developed by python software foundation in 1991

31. Python is a complete, integrated statistical package that provides everything for data analysis from data management to basic and advanced analysis. Python makes it easy to conduct data cleaning and management, distinctly styled graphs, descriptive analysis and advanced analysis. There is no user Fees to use this software. 30/07/2024 31 Features

32. https://www.ssc.wisc.edu/sscc/pubs/spss/classintro/spss_students1.html?fbclid=IwAR2T2HNOThTBbJLe42F9Tm2cpyVSF1dyFGFt9xwn2GVRSGqXW5CRHITPhFA https://imotions.com/blog/statistical-tools/ https://online-spss.com/benefits-of-using-spss-for-data-analysis/ www.cdc.gov www.R-project.org https://en.wikipedia.org/wiki/Python_(programming_language) 30/07/2024 32 Reference

33. 30/07/2024 33