{"id":14,"date":"2012-07-20T18:56:35","date_gmt":"2012-07-21T01:56:35","guid":{"rendered":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/?page_id=14"},"modified":"2013-08-05T12:48:53","modified_gmt":"2013-08-05T19:48:53","slug":"how-to-analyze-data-in-spreadsheets","status":"publish","type":"page","link":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/how-to-analyze-data-in-spreadsheets\/","title":{"rendered":"Screencasts"},"content":{"rendered":"<h1>Some preliminaries&#8230;<\/h1>\n<p>Before you start, download Phon from the Phon Project website <a href=\"http:\/\/phon.ling.mun.ca\/phontrac\/wiki\/Downloads\" target=\"_blank\">here<\/a>.\u00a0 The screencasts below were created using version 1.5.2 which was released on February 29, 2012.<\/p>\n<p>You will also need OpenOffice for doing data analysis which you can download from <a href=\"http:\/\/www.openoffice.org\/download\/\" target=\"_blank\">here<\/a>.\u00a0 Phon is also compatible with LibreOffice and, in fact, LibreOffice is probably the better choice in future for a series of boring reasons that are not worth mentioning here.\u00a0 Note that Microsoft Excel does not display IPA symbols properly when they are exported from Phon.\u00a0 If you want, you can work in Excel once you&#8217;re at the stage of making pretty charts and graphs, but before that you will need the regular expression capability and font-friendliness of Open\/LibreOffice.<\/p>\n<p><strong><em>Please note that your data must be transcribed in Unicode for it to display correctly in Phon.<\/em><\/strong>\u00a0 For most people, this means using the Doulos SIL font which is free to <a href=\"http:\/\/scripts.sil.org\/cms\/scripts\/page.php?item_id=DoulosSIL_download#7de9e023\" target=\"_blank\">download<\/a> and install in the appropriate place on your computer.\u00a0 If your data have been transcribed in SIL IPA93, you have to convert them to Doulos SIL.\u00a0 SIL International explains how to convert data from SIL IPA93 on the <a href=\"http:\/\/scripts.sil.org\/cms\/scripts\/page.php?item_id=SILIPA93DataConversion\" target=\"_blank\">SIL IPA93 Data Conversion page<\/a> on their website.\u00a0 It involves downloading their SIL Converter and installing it in MS Word 2003.\u00a0 This is a straightforward process if you have MS Word 2003.\u00a0 It is also possible to convert data in plain text files and Standard Format Marker text files.\u00a0 Otherwise, contact SIL directly regarding conversion (and good luck!).<\/p>\n<h1>How to use Phon<\/h1>\n<p>Click on the links below to watch screencasts explaining how to use Phon on various topics.<\/p>\n<h2>1.\u00a0 Preparing to use Phon<\/h2>\n<ul>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Preparing_data.swf\">Getting your data into Phon (Part 1)<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Importing_Data_into_Phon.swf\">Getting your data into Phon (Part 2)<\/a><\/li>\n<\/ul>\n<h2>2.\u00a0 Working in Phon<\/h2>\n<ul>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Entering_participant_info.swf\">Entering information about participants<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Linking_audio_files.swf\">Linking audio files<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/How_to_segment_audio_files.swf\">Segmenting audio files<\/a><\/li>\n<\/ul>\n<h2>3.\u00a0 Exporting data from Phon<\/h2>\n<ul>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Exporting_all_data_using_merge2.swf\">Getting all your data out of Phon using merge sessions<\/a> (which is necessary for word structure analyses).\u00a0 NB: Merge sessions has been replaced with Export Data as CSV in Phon 1.6.<\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Installing_script.swf\">Installing the Phone Clusters script<\/a> (which is necessary for any kind of consonant analysis)\u00a0 Note: If you are using a Mac and cannot find the Library, it is likely just hidden.\u00a0 To unhide your Library, go to your Applications folder, then to your Utilities folder.\u00a0 In the Utilities folder, double click on Terminal.\u00a0 A window will open up with a black background.\u00a0 Copy and paste the following command into the Terminal window: <code>chflags nohidden ~\/Library<\/code> then press Enter and your Library should magically reappear.<\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Script_C_by_wordposition1.swf\">Using the Phone Clusters script for singleton consonant analysis by word position<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Script_CC_data.swf\">Using the Phone Clusters script for consonant cluster analysis<\/a> (including how to find and use the template)<\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Script_feature_analysis.swf\">Using the Phone Clusters script for feature analysis<\/a><\/li>\n<\/ul>\n<h1>How to analyze your data using spreadsheets<\/h1>\n<h2>Whole word match and word shape analyses<\/h2>\n<ul>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Using_WWM_WSM_template.swf\">Data preparation and introduction to the template<br \/>\n<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/WWM_template_explanation.swf\">Conducting a whole word match analysis using the template<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Tabulating_WWM_results.swf\">Tabulating whole word match results<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/WSM_template_explanation.swf\">Conducting a word shape analysis using the template<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Tabulating_WSM_results.swf\">Tabulating word shape match results<\/a><\/li>\n<\/ul>\n<h2>Word length and stress analysis<\/h2>\n<ul>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Wordlength_stress_template_explanation.swf\">Conducting a word length and stress analysis using the template<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Tabulating_wordlength_stress.swf\">Tabulating word length and stress results<\/a><\/li>\n<\/ul>\n<h1>Singleton consonant by word position analyses<\/h1>\n<ul>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/C_by_wordposition_analysis.swf\">Conducting a singleton consonant by word position analysis using the template<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/C_by_wordposition_results.swf\">Tabulating singleton consonant by word position results<\/a><\/li>\n<\/ul>\n<h1>Consonant cluster analysis<\/h1>\n<ul>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/CC_analysis_group_results.swf\">Tabulating consonant cluster results by group<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/CC_analysis_by_subject.swf\">Tabulating consonant cluster results by subject<\/a><\/li>\n<\/ul>\n<h1>Feature analysis<\/h1>\n<p>There are a series of three templates (one for each word position) which automate, to a large extent, the calculation of the number of subjects in a group who show 90% accuracy or more in their production of a given phoneme.\u00a0 It also calculates the percentage match by phoneme according to left and centre-right prominence.\u00a0 The formulas used to do these calculations are complex.\u00a0 Too complex, it turns out, to be converted from OpenOffice Spreadsheet to Excel without errors.\u00a0 This is a problem because, while Excel spreadsheets <em>can<\/em> be uploaded to the blog, OpenOffice spreadsheets <em>cannot<\/em>.\u00a0 If you are interested in trying out this template, please contact someone in the lab for a copy.\u00a0 If you are curious about how they work and would like to see how to use them, watch the\u00a0<a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/WF_Stop_analysis.swf\">Tabulating consonant mastery by word position<\/a> screencast.<\/p>\n<h1><\/h1>\n<h1>Resources<\/h1>\n<p>The talented and helpful developers of Phon wrote a script for the SASS phonology lab to facilitate analysis of both singleton and consonant clusters according to word position and stress pattern.\u00a0 Download the script and accompanying documentation in <a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Phone-Clusters-20120501.zip\">this zip file<\/a>.\u00a0 Once you have downloaded it, please refer to\u00a0<a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Installing_script.swf\">Installing the Phone Clusters script<\/a> screencast for installation on Macs.\u00a0 For installation on Windows, see the <a href=\"http:\/\/phon.ling.mun.ca\/phontrac\/wiki\/search\/scriptlibrary\">Phon script library page<\/a>.<\/p>\n<p>Several templates in the form of Excel spreadsheets that are compatible with Open\/LibreOffice have been made to expediate data analysis.\u00a0 The columns are already set up and formulas have been included so that calculations, such as percentage matches, can be done quickly and easily.\u00a0 The templates are provided below and are organized by analysis type.\u00a0 Please refer to the appropriate screencast for the various spreadsheet tips and tricks you will need to be able to make efficient use of the template.<\/p>\n<ul>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/WWM_and_WSM_template.xls\">Whole Word and Word Shape Match Analysis Template<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/wordlength_and_stress_template.xls\">Word Length and Stress Analysis Template<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/C_by_word_position_template.xls\">Singleton Consonant by Word Position Analysis Template<\/a><\/li>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/CC_template.xls\">Consonant Cluster Analysis Template<\/a><\/li>\n<\/ul>\n<h1><\/h1>\n<h1>Troubleshooting<\/h1>\n<ul>\n<li><a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/files\/2012\/07\/Affricates_problem.swf\">Dealing with Affricates in the Word Shape Match Analysis<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Some preliminaries&#8230; Before you start, download Phon from the Phon Project website here.\u00a0 The screencasts below were created using version 1.5.2 which was released on February 29, 2012. You will also need OpenOffice for doing data analysis which you can &hellip; <a href=\"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/how-to-analyze-data-in-spreadsheets\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":8137,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-14","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/wp-json\/wp\/v2\/pages\/14","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/wp-json\/wp\/v2\/users\/8137"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/wp-json\/wp\/v2\/comments?post=14"}],"version-history":[{"count":51,"href":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/wp-json\/wp\/v2\/pages\/14\/revisions"}],"predecessor-version":[{"id":55,"href":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/wp-json\/wp\/v2\/pages\/14\/revisions\/55"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/crosslinguisticprojectmaterials\/wp-json\/wp\/v2\/media?parent=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}