Survey Analysis (Quant)

Purpose

Clean and prepareIdentify quantitative datainsights forfrom importance/performanceparticipant analysis. responses.

Responsible Party

Project Strategist

Interdependencies

Prepare Survey Data Collectionis has concluded complete.

Directions

1. OpenAnalyze CLEANEDimportance/performance data:
   • Calculate the average answer for each question.
   • Conduct a paired t-test on each category's importance and performance ranges. Categories may have both an in-office performance set and a remote performance set.
   • Identify the p-value by dividing .005 by the number of categories.
   • Compare the t-test results to the p-value to identify statistically significant responses.
2. Analyze additional quantitative data.
   • Depending on what questions are included in the survey, there may be additional insights in the data.
   • Many questions require comparing the average of each response to a multiple-choice question. 
   • Consult with the statistician to identify if additional calculations must be run.
3. Save the analyzed data set (if there is not one, you will have to goBox to qualtrics, exportin the data,project's thenChallenge saveDefining as with a .xlsx)
4. Delete folder.

Resources

Link to templates, etc.

Example:

Pre-sale Alignment Meeting Analysis ToolNone