Can MS Forms show the percentage of responses?

%3CLINGO-SUB%20id%3D%22lingo-sub-2660991%22%20slang%3D%22en-US%22%3ECan%20MS%20Forms%20show%20the%20percentage%20of%20responses%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660991%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20recently%20hopped%20across%20from%20Survey%20Monkey%20to%20MS%20Forms.%20However%2C%20I%20cannot%20seem%20to%20replicate%20a%20handy%20feature%20that%20Survey%20Monkey%20had%2C%20and%20that%20is%20percentages.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20looking%20at%20responses%2C%20SM%20would%20give%20me%20the%20percentage%20of%20responses%20i.e.%20very%20poor%20made%20up%2010%25%20of%20the%20responses%2C%20poor%20made%20up%205%25%2C%20average%20made%20up%2033%25%2C%20good%20made%20up%2016%25%2C%20and%20very%20good%20made%20up%2036%25.%20Is%20there%20any%20way%20to%20obtain%20this%20information%20from%20MS%20Forms%2C%20especially%20when%20it%20is%20exported%20to%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20assistance%20will%20be%20greatly%20appreciated.%20Many%20thanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECali%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2660991%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2664087%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20MS%20Forms%20show%20the%20percentage%20of%20responses%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2664087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131456%22%20target%3D%22_blank%22%3E%40caliselina%3C%2FA%3E%26nbsp%3Bif%20you%20use%20likert%20scale%20questions%20that%20will%20give%20you%20in%20the%20responses%20chart%20the%20percentage%20of%20each%20option%20selected%20in%20each%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have recently hopped across from Survey Monkey to MS Forms. However, I cannot seem to replicate a handy feature that Survey Monkey had, and that is percentages. 

When looking at responses, SM would give me the percentage of responses i.e. very poor made up 10% of the responses, poor made up 5%, average made up 33%, good made up 16%, and very good made up 36%. Is there any way to obtain this information from MS Forms, especially when it is exported to Excel?

 

Any assistance will be greatly appreciated. Many thanks in advance.

 

Cali

1 Reply

@caliselina if you use likert scale questions that will give you in the responses chart the percentage of each option selected in each question.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)