Small sample data analysis by excel

Data organization


Data entry by dialog
Matrix manipulation
Transpose
Data sorting
Simultaneous analysis in multiple worksheet


Data quality

Identification of missing values
Identification of incorrect values
Data dispersion
Variable wise data representation


Visual data analysis










Web:
http://people.umass.edu/evagold/excel.html
http://home.ubalt.edu/ntsbarsh/excel/excel.htm

Comments

Post a Comment

Popular posts from this blog

My first book inauguration

Image
The book titled " Principles of Questionnaire Development with empirical studies (for students and researchers in Social sciences) " (ISBN:9788190992312) was inaugurated by Professor Manjula Mukerjee, The Director of the Indian Institute of Psychometry, Kolkata, in the Workshop on SPSS -SYNTAX held at the Institute dated 29th October, 2010. During her speech, she appreciated the examples cited in this book to understand different principles of questionnaire development. Ms. Rama Manna (standing at the left side)was the co-ordinator of the workshop. The researchers of different specialization (Clinical Psychology,Psychiatry,Education,Human development,Environmental science) of different universities and research institutes attended the workshop. I taught them different SPSS syntax. There is one chapter on SPSS Syntax in this book. (Standing: Dr. Rudraprasad Acharya, Dr. Souvik Chakraborty, Dr. Shubhojit Kuila, Dr. Suvendu Dutta) I am thankful to Prasad Psycho Corporation for
Read more

Psychoinformatics in management

 Psychoinformatics is an interdisciplinary field that combines psychology and informatics to study and analyze psychological phenomena through the use of computational tools and methods. It involves the collection, analysis, and interpretation of large-scale psychological data using techniques from data science, machine learning, and artificial intelligence. The goal of psychoinformatics is to gain deeper insights into human behavior, cognition, and emotions, often leveraging big data from various sources like social media, mobile devices, and wearable technology. This field aims to enhance understanding of psychological processes and improve applications in areas such as mental health, education, and human-computer interaction. Example  An example of psychoinformatics in practice is the use of smartphone data to monitor and predict mental health conditions. Here's how it might work: Data Collection: A research team develops a mobile app that collects data from users' smartphon
Read more

Symposium on Mental health care insurance (24th Feb, 2014)

Importance of Mental health care insurance D. Dutta Roy ISI., Kolkata Number of new policies in health insurance is growing after privatization. It mainly covers general health insurance rather mental health care insurance (MHCI) though World Health Organization predicted 20% growth of mental illness in India. There is no systematic study on insurance needs of the beneficiaries. As a result, many mentally ill people are under-insured or non-insured. This  causes difficulty to provide adequate mental health care through systematic insurance policies and schemes. On the other hand they are stigmatized by the society and sometimes they are abused. Abuse aggravates the severity of the symptoms.   Mental health care system in India is plagued with lot of stigma still now. Major stigma is collective unwillingness of society to provide adequate financial assistance to the mentally ill people. Again, this causes serious sufferings on family members of the mentally ill. One good family is
Read more