DATA ANALYSIS

[jocelynfraser]

Hi Everyone,

Based on Julian's comments, the ideas Stephanie shared for synthesizing our information and the materials Carlos circulated, I wondered if laying out our chart slightly differently might be an idea.  If we create a matrix that lists countries in one column and our data points in columns on a table or spreadsheet  we might be able to see at a glance where we have some commonalities and gaps.  I would like to suggest we create some codes for the data - ideally numeric so we could potentially develop a formula to analyse the findings.  I'm pretty weak on the math side but I know there are a number of you who are skilled in this area.

I've attached a table to illustrate what I am thinking about -- just a rough draft using Word (because it was easy) and with mostly alpha codes but if there is any interest in this approach perhaps we could develop something in  Excel using more numeric codes.

Cheers,

Jocelyn

[Stephanie Zimmerling]

Hi All,

Jocelyn, I think this is a great idea. I would suggest Excel. My skills in excel are moderate and I can likely whip together some pivot tables to see if I can find any correlations. With pivot tables you generally just need an indicator or categories. So for example high, low, moderate. This will allow countries to group for easy comparison. My capabilities will formulas in excel are strong too but my statistical skills are very weak... Does anyone else have strengths in that area? I am happy to work on the excel sheet using the matrix sent by Jocelyn and the existing table to see what I can come up with - hopefully something! 

Stephanie

--
You received this message because you are subscribed to the Google Groups "Mongolia Project 2015" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongoliaproject...@googlegroups.com.
To post to this group, send email to mongoliap...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongoliaproject2015/0e10487e-4b06-4c1d-80e5-814268eba7cf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

<CONCEPT - ANALYSIS CHART.docx>

[Carlos da Costa]

Hi Stephanie,

I can certainly help you with this. 

Cheers,

Carlos

Sent from my BlackBerry 10 smartphone on the Rogers network.

From: Stephanie Zimmerling Sent: Wednesday, March 11, 2015 7:48 AM To: jocelynfraser Cc: mongoliap...@googlegroups.com Subject: Re: DATA ANALYSIS

To view this discussion on the web visit https://groups.google.com/d/msgid/mongoliaproject2015/5968A1FD-59E9-4899-9D3B-74F6F3E3F61D%40gmail.com.

[Stephanie Zimmerling]

HI All, 

Christina, Carlos and I are going to meet tomorrow morning at 9:30 in C.K. Choi to start working on data analysis. If you would like to join, please come! I have put together the bare bones of a spreadsheet and populated to the best of my knowledge from the existing table. I apologize if I interpreted your data incorrectly. Please feel free to edit as necessary. If everyone could please try and populate the table before tomorrow morning that would be fantastic! The spreadsheet is titled 'DATA ANALYSIS' and it can be found on Google Drive. 

Stephanie

To view this discussion on the web visit https://groups.google.com/d/msgid/mongoliaproject2015/COL402-EAS14926FD7F02AD9C14DE2AA1A0190%40phx.gbl.

[Debbie Prasad]

Hi Everyone,

I know how to use Stata (a data analysis software) and can also try and do some analysis and let you know what comes of it. Will try it within the next few days and try to let everyone know by friday morning?

Best,

Debbie

On Wed, Mar 11, 2015 at 8:15 AM, Carlos da Costa <carlos_...@hotmail.com> wrote:

To view this discussion on the web visit https://groups.google.com/d/msgid/mongoliaproject2015/COL402-EAS14926FD7F02AD9C14DE2AA1A0190%40phx.gbl.

[Mario Ramirez]

Hi All,

I got the rule of law index in the spread sheet for almost all the countries. I could not find  the index for DRC, Mauritania, Republic of Congo and Yemen though.

is it the index or the ranking or both, we needed to report?

http://data.worldjusticeproject.org/#grid


cheers,

Mario.

---

Date: Wed, 11 Mar 2015 11:00:14 -0700
Subject: Re: DATA ANALYSIS
From: debbie.p...@gmail.com
To: carlos_...@hotmail.com
CC: stephanie....@gmail.com; jocely...@shaw.ca; mongoliap...@googlegroups.com

To view this discussion on the web visit https://groups.google.com/d/msgid/mongoliaproject2015/CAFwHRqtqP9Mwx%2BDCjb6wTZhcnmw8tMAuCoqULZkWk9SGmYYQug%40mail.gmail.com.

[Stephanie Zimmerling]

Hi Everyone, 

I know there has been some confusion regarding all the e-mails flying around. The Data Analysis spreadsheet can be found here: https://docs.google.com/spreadsheets/d/1cJcUF7gCAm2IJbKj1tJ5GgKtJhyQsqK9hBo09sR9ZaY/edit#gid=951679736

Please populate your countries information by the end of the weekend. I will use the data entered to generate a form of heat map in Monday's class. 

Feel free to get in touch if you have any questions about the headings. 

Stephanie

To view this discussion on the web visit https://groups.google.com/d/msgid/mongoliaproject2015/COL129-W816721C545981A84298FF5FD060%40phx.gbl.

[Jocelyn Fraser]

Thanks Stephanie.  This is looking good. I have added a column for consideration as I think it clarifies what I believe is an important issue:  the presence of enabling legislation and the effectiveness of that legislation.  

I'd also like to suggest we reduce all variables to a three point value set.  0, 0.5, 1.0.  I've made the change in a few columns and there are some -- such as population density - where we made need to establish the category boundaries once the raw data is entered to the table.  While we may not choose to go any further with the data analysis but if we do, putting our "fuzzy" data into the three point value set may facilitate that additional work.

Cheers,

Jocelyn