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

List of songs in slideshow on Rabindrasangeet

Below are the songs used in the slideshow: Chokher aloy dekhechilem chokher bahire Ami keboli swapan karechi bapan batase Emni karei jay jadi din jak na, Amar hiyar majhe lukiye chile Ami jwalbo na Tomay niye khelechilem khelar gharete khelar putul bhenge geche pralayy jhaarete Amar poran jaha chay tumi tai, tumi tai Go toma chhara ar e jogote mor keho nai, keho nai Go. Swapnamadir neshay mesha e unmattata jagay dehe mone eki bipul byatha Keteche ekela biraher bela akashkusum chayane” (depression) Jani tomar ajana nahi go ki ache amar mone.Ami gopan karite chai go, dhara pare du nayane. Ki bolite pache ki boli tai dure chale jai keboli. Kandale tumi more bhalobasari ghaye- Nibir bedanate pulak lage gaye Keno jamini na jete Keno sara din dhire dhire Sakhi bohe gelo bela, shudhu Amar ekti katha banshi jane Ami bhoy karbo na bhoy karbo na” Jadi tor daak shune keu na ase tabe ekla chalo re” Ektuku chona lage Eto din je bosechinu Akash bhara surya tara Aloker ei jharna dharay Ananda dhara b
Read more

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

Martin Seligman and Positive Psychology

Image
Martin Seligman coined the term - Positive Psychology. It focuses on positive functioning of human being. He suggested self-help techniques: Dr Martin Seligman is the founder of Positive Psychology and explores the latest research in his new book Flourishing. One of his key areas of work has been the infusing of Positive Psychology training with the 1.1 milli on officers of the US army. Rather than focusing on adding additional funds to programs for injured soldiers, his response was to create a training system for the army where officers can become better, stronger and happier people. Why do this? Because the stronger and more emotionally resilient you are, the better you will be able to respond to pressure, crisis and tragedy. Emotionally resilient people after a traumatic event still ‘go through hell’ but rather than remaining traumatised for years afterwards, they actually grow to become emotionally stronger. Now does that mean you should forget about assisting the chronically t
Read more