once I desire to analyzedata and also a an option CORRELATION then pick the variety and even pick I have actually labels in the first row, It claims "correlation- input range contains non-numeric data" even I tried placing in NUMBER the layout of the table. What I have to do?
This subject is locked. You have the right to follow the concern or vote together helpful, yet you cannot reply to this thread.
form of abuse Harassment or threats Inappropriate/Adult contents Nudity Profanity software piracy SPAM/Advertising Virus/Spyware/Malware danger various other Term of use or code of conduct violation child exploitation or abuse
Harassment is any behavior intended come disturb or uncomfortable a human or team of people. Threats include any type of threat the suicide, violence, or injury to another. any kind of content of an adult design template or unreasonable to a ar web site. any kind of image, link, or conversation of nudity. any behavior the is insulting, rude, vulgar, desecrating, or mirroring disrespect. any type of behavior that shows up to violate finish user patent agreements, including providing product keys or web links to pirated software. Unsolicited bulk mail or bulk advertising. any kind of link come or advocacy that virus, spyware, malware, or phishing sites. any other inappropriate content or behavior as identified by the terms of Use or code of Conduct. any type of image, link, or conversation related to kid pornography, child nudity, or various other child abuse or exploitation.
Details (required):
250 personalities remaining
publication submit

Replies (3) 


JA
JasleS
responded on October 6, 2017

Are you using the role called CORREL?


Report abuse
Report abuse
kind of abuse Harassment or risks Inappropriate/Adult contents Nudity Profanity software program piracy SPAM/Advertising Virus/Spyware/Malware danger other Term of usage or code of command violation son exploitation or abuse
Harassment is any type of behavior intended come disturb or upset a person or group of people. Dangers include any threat that suicide, violence, or injury to another. any type of content of an adult template or unreasonable to a community web site. any type of image, link, or discussion of nudity. any behavior that is insulting, rude, vulgar, desecrating, or mirroring disrespect. any behavior that appears to violate end user license agreements, including giving product secrets or links to pirated software. Unsolicited mass mail or mass advertising. any type of link come or advocacy that virus, spyware, malware, or phishing sites. any type of other inappropriate contents or actions as identified by the regards to Use or code of Conduct. any type of image, link, or conversation related to child pornography, kid nudity, or other child abuse or exploitation.
Details (required):
250 characters remaining
publication send

76 human being found this reply beneficial

was this reply helpful?
Yes
No

i m really sorry this didn't help.


Great! many thanks for your feedback.

You are watching: How to analyze non numeric data in excel

How satisfied are you v this reply?


Thanks for her feedback, it helps us improve the site.

How satisfied room you through this reply?


Thanks for your feedback.


GR
grislobato
replied on October 8, 2017
*
In answer to JasleS's write-up on October 6, 2017
No, I permit in excel add-ins: AnalysisToolpak- VBA for data analysis and there is an option of correlation, so ns tried to analyze data in a table and likewise select the "labels in the very first row" due to the fact that I had. However It ongoing to to speak that.
Report abuse
Report abuse
form of abuse Harassment or dangers Inappropriate/Adult contents Nudity Profanity software piracy SPAM/Advertising Virus/Spyware/Malware danger various other Term of usage or password of command violation kid exploitation or abuse
Harassment is any kind of behavior intended to disturb or upset a human or group of people. Hazards include any type of threat of suicide, violence, or damage to another. any type of content of an adult theme or inappropriate to a ar web site. any image, link, or discussion of nudity. any behavior the is insulting, rude, vulgar, desecrating, or reflecting disrespect. any kind of behavior that shows up to violate finish user patent agreements, including giving product tricks or links to pirated software. Unsolicited mass mail or bulk advertising. any kind of link come or advocacy of virus, spyware, malware, or phishing sites. any other inappropriate contents or habits as defined by the terms of Use or code of Conduct. any kind of image, link, or conversation related to child pornography, boy nudity, or other child abuse or exploitation.
Details (required):
250 characters remaining
publication send

15 people found this reply beneficial

to be this answer helpful?
Yes
No

i m really sorry this didn't help.


Great! thanks for her feedback.

How satisfied space you through this reply?


Thanks for your feedback, it help us enhance the site.

How satisfied space you v this reply?


Thanks for your feedback.


JO
joeu2004
replied on October 8, 2017

grislobato wrote:

It states "correlation- input variety contains non-numeric data" also I tried placing in NUMBER the layout of the table. What I have to do?

-----

Perhaps what shows up to it is in numeric is in reality text, i m sorry is not uncommon once you copy-and-paste data, because that example.

(FYI, changing the layout to Number only alters the appearance of data the is already numeric. That does not change text data, and also it does no preclude having text data in those cells.)

Suppose your data is in A1:A100 and B1:B100. In parallel columns, get in the formulas =ISNUMBER(A1) and =ISNUMBER(B1) in rows 1:100. Do any kind of return FALSE?

If so, try to use the Data > text To Columns function for each of A1:A100 and B1:B100 separately.

Are any kind of of the ISNUMBER results still FALSE?

If so, the data can contain non-breaking spaces (HTML nbsp; ASCII 160). In parallel columns, enter the formulas

=--SUBSTITUTE(A1,CHAR(160),"") and also =--SUBSTITUTE(B1,CHAR(160),"") in rows 1:100. Copy those columns and paste-value into A1:B100.

See more: What Is The Plural Of Dolphin S, Dolphin Definition And Meaning

Are any type of of the ISNUMBER resultsstill FALSE?

If so, I suggest that girlfriend upload a redacted Excel document that demonstrates the difficulty (ideally prior to the transforms that I argued above) to a file-sharing website (e.g.box.net/files), and post the public/share URL in a solution here. Check the URL first, being mindful to log out of the file-sharing website.


Harassment is any kind of behavior intended come disturb or uncomfortable a human being or team of people. Threats include any threat the suicide, violence, or damage to another. any kind of content of an adult theme or unreasonable to a community web site. any type of image, link, or discussion of nudity. any kind of behavior the is insulting, rude, vulgar, desecrating, or showing disrespect. any kind of behavior that appears to violate finish user license agreements, including giving product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. any link to or advocacy the virus, spyware, malware, or phishing sites. any other inappropriate content or behavior as defined by the regards to Use or password of Conduct. any kind of image, link, or conversation related to boy pornography, child nudity, or other child abuse or exploitation.
Details (required):