statistical analysis

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

Guest

I am trying to do a correlation analysis but I have missing data, how can I deal with this, is there a way of coding missing data like a . in SAS?
 
Excel has no missing data symbol. If you leave the cells empty that are
missing, then they will be ignored. If you are using the CORREL()
function (as opposed to the correlation tool in the Analysis ToolPak),
you can also put text (such as ".", "NA", etc.) in the missing cells and
have them ignored.

Jerry

silvia said:
I am trying to do a correlation analysis but I have missing data, how
Click to expand...
 

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

Add-in - Analysis ToolPak 1
How do I refresh in Descriptive Stats in Toolpak add-in? 1
Choosing the right statistical function 9
Analysis ToolPak - why doesn't it work? 3
Correlation analysis 6
nonlinear regression/ curve fits 4
How can you access Data Analysis Plus for MS Excel? 6
statistical analysis / trend repetition 1

Back
Top