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...
 
Back
Top