In this assignment you will create a dataset, codebook, and descriptive statistics from the survey you developed and disseminated!.
Dataset: After completing your survey in GoogleForms, download the data in Excel form. You can use GoogleSheets for some of the work, but it is limited in its performance of statistical tests (and all of the how-to videos are in Microsoft Excel).
Codebook: After downloading your data from the GoogleForm, provide the corresponding information in the codebook so you know how response categories are coded. This should be the first sheet in your Excel Workbook
Descriptive statistics: You will conduct descriptive statistics for three different variables PER GROUP MEMBER, but at least one nominal, one ordinal, and one continuous (ratio or interval). You will also produce a thematic analysis of one open-ended question. Each variable’s descriptive statistics will be presented on a separate worksheet in your Excel workbook (for a total of 4 worksheets). You will also write a sentence or two describing the variable’s descriptive statistics.
Keep in mind you may have to/want to recode your variables to present more meaningful responses. If you choose to delete the missing data (NAs/don’t knows/NAP) be sure to report in your written description how many responses were considered missing.
See the EXAMPLE assignment: EXAMPLE descriptive stats Galuzzi Fall 20.xlsx Download EXAMPLE descriptive stats Galuzzi Fall 20.xlsx.
Refer back to the Resources posted in Module 3.
Guidelines
Here is what is expected for each variable. All this analysis will be completed in Excel.
1) For categorical variables, create figures (column, bar, pie charts, etc.) to depict the frequencies in addition to frequency tables that include counts and proportion/percent. Write a brief description of the data in an open cell for each variable.
2) For ordinal variables, create figures (column, bar, pie charts, etc.) to depict the frequencies in addition to frequency tables that include counts and proportion/percent. Write a brief description of the data in an open cell for each variable. You will also provide full descriptive statistics including mean, median, mode, standard deviation, range, minimum, and maximum. Write a description in an open cell reporting this information.
3) For interval/ratio variables, provide full descriptive statistics including mean, median, mode, standard deviation, range, minimum, and maximum. Write a description in an open cell reporting this information.
4) For open-ended questions, conduct a thematic analysis like you did in your field observation analysis where you identify the primary themes/domains/categories representing the patterns in responses.
What you will submit:
Excel file with the raw data, codebook, and descriptive information for each variable on separate worksheets. The presentation of the information should be clean and readable. For each variable’s descriptive statistical information where appropriate you will create a figure to visually depict the data. For open-ended information, you will present your thematic codes where you define and describe the main themes.
