search for: excel2000

David A. Paul wrote: > I don't have the reference, but a biologist friend of mine once > showed me a refereed journal article that purported to demonstrate > numerical errors made by MSExcel. This would have been Excel97 or > Excel2000... In any case, the journal's scope was biological in > nature and the article was of interest since Excel is heavily used in > that community. An excellent source of information about the incompetence of Excel as a statistical package can be found on Jonathan Cryer's web page at h...

...I think because is has some memory of the > previous one. I don't think Excel 2000 removes add-ins cleanly. > brian, we had a stress test of the addin yesterday election ight forecast, the systen was running about 8 hours without any problems. win95+excel97 i have to start testing in excel2000 now. i dod some very simple first tetst, and so far, no problems. uninstalling might be a a problem. a relatively secure way of uninstalling found is: first delete the xla file, with excel NOT running. then start excel, it will complain about the missing addin. then go to teh addin menu, and click...

Hi, I wonder if anybody could help me in converting this easy SAS program into R. (I'm still trying to do that!) PROC IMPORT OUT= WORK.CHLA_italian DATAFILE= "C:\Documents and Settings\carleal\My Documents\REBECCA\stat\sas\All&nutrients.xls" DBMS=EXCEL2000 REPLACE; GETNAMES=YES; RUN; data chla_italian; set chla_italian; year=year(datepart(date)); month=month(datepart(date)); run; proc sort data=chla_italian; by station; run; /* Check bloom for seasonal cycle outliers */ data sort_dataset; set chla_italian; chla=chl_a; dayno...

For numbers ending in 5 Excel always rounds up and I want to reproduce this in R rather than use the round function. I have tried: x<-as.integer(x*100+0.5)/100 and x<-floor(x*100+0.5)/100 However, some values of x cause problems e.g x<-floor(4.145*100+0.5)/100 4.14 I have tried breaking it down into steps and force the results to 10 significant figures in the following function,

...class var1 var2 var3; model ln_y = covar var1 var2 var3 var1*var3 var2*var3; lsmeans var1 var2 var3 var1*var3 var2*var3 /out=LSMeffect stderr; run;quit; proc print data=LSMeffect; run; proc export data=LSMeffect outfile='C:\Documents and Settings\nxf\Desktop\sas1.xls' DBMS=EXCEL2000 replace; run; I've been using R for about 4 months, apologies if this has a simple solution I'm unaware of. I'm completely new to SAS. Many thanks in advance, Nieves Felipe.

...003-06-04 at 08:09, Paul, David A wrote: > >> I don't have the reference, but a biologist friend of mine > >> once showed me a refereed journal article that purported > >> to demonstrate numerical errors made by MSExcel. This > >> would have been Excel97 or Excel2000... In any case, the > >> journal's scope was biological in nature and the article > >> was of interest since Excel is heavily used in that > community. > >> > >> -david paul > > > > > >There is a series of articles here: > > >...