descriptive statistics - text in survey

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a survey which has some text answers and some numerical answers. I
need to complete histogram and descriptive statistics on this data but I get
an error message stating my "data contains non-numerice input". Does that
mean all data has to be converted to nummerical format?
 
one way to solve theproblem use count if

suppose non numeric data for e.g. a.s.d.f.g etc are in A1 to A100
find out unique set by using advance filter
and then use countif function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I refresh in Descriptive Stats in Toolpak add-in? 1
Text data -- linking Excel sheets 1
Doing Statistics on Time Values 2
certain words "CONTAINS" in an free text cell........... 2
Tabulate Survey Results in Excel 2003 2
In descriptive statistics, what does "confidence level" mean? 3
What FORMULA will count records that CONTAIN certain text? 2
Analyze Survey Results in Access - Matrix form 0

Back
Top