Alan Roberts

About

Username
Alan Roberts
Joined
Visits
55
Last Active
Roles
Community Administrator

Comments

  • The new version improves the installation, supporting add-in registration for Office 2013,
  • Hi Yes this does appear to be caused by one of the recent updates. The solution seems to be to delete the *.exd files that Excel creates. With Excel closed please try deleting any *.exd files from the "%APPDATA%MicrosoftForms" folder. On Window…
  • Hi The case scores are indeed calculated from the standardised raw data (standardised to mean = 0 and for analyses using the correlation matrix to SD = 1). These are then multiplied by the Eigenvectors (the Component Score Coefficients matrix. in…
    in PCA Comment by Alan Roberts April 2011
  • statistiXL is only supported on the 32 bit version of Excel 2010. Microsoft currently recommend using the 32 bit version of Office 2010 unless you need spreadsheets larger than 2GB in size (the only real advantage of moving to 64bit). The main re…
  • Hi Jansen I'm not quite sure I'm following your query. Would it be possible to email a sample spreadsheet to support@statistixl.com showing me what you are wanting to do? Could you please include output of each of the different test methods you …
  • Hi Eric That shouldn't be an issue. I have 4 version of Excel on my machine and statistiXL runs without issue. Can you please install the latest build from http://www.statistixl.com/downloads/files/sxlsetup.exe and let me know if the issue persi…
  • Hi John Do you know if this issue is specific to you machine or does it happen on multiple machines? If you don't have a second machine to test it with can you send a copy of one of your problem sets to support@statistixl.com so I can run a test …
  • Unfortunately you're breaking new ground here so I can't offer any advice. I can't see why it shouldn't work but it is not something I have tried. Best Regards Alan
  • Yes it looks like some of the tests in statistiXL don't like R1C1 notation. This isn't an issue I was aware of so I will add this to out to-do list! Thanks for the feedback Alan
  • Hi Mat It shouldn't be a language issue as we have a lot of users in Spanish speaking (and other non-English) countries. Do the test datasets included with the help file work (you can click on the links within the help file itself to open the sam…
  • Sorry I missed this one. Yes that is the only way to do it in statistiXL. Cheers Alan
  • Hi Jennifer Did you enter the purchased key into the trial version to unlock it or did you uninstall the trial and install the purchased one? There is no difference between the two so you could simply enter the key. From the sounds of things tho…
  • There is a minor update to statistiXL at http://www.statistixl.com/downloads/files/...xlsetup18v4.exe that fixes a couple of issues with Clustering. This may solve your problem.
  • We hope to provide both options in future versions of statistiXL, i.e. the static tests we currently provide and formula for some values/tests also.
  • I'm probably not the best person to list features on other packages but I can give you a quick overview of statistiXL. Basically we try to provide a good selection of the most frequently used/requested statistical test in an interface that is simp…
  • Hi Factor Analysis currently only supports the orthogonal Varimax, Quartimax and Equimax rotations. We hope to add Promax in a later release. Alan
  • The plots should appear to the top right of any printed output. i.e. you will get the normal text based output and then level with the top of that and off to the right should be the plots.
  • That's a bit of an odd one! I take it that you aren't getting any error messages raised? If you run through the example included with statistiXL (rather than using your own dataset) do the plots appear? Is there a statistixl.log or statistixl.txt f…
  • Hi Mathangir please see my reply to your earlier email. Cheers Alan
  • Hi Hai Liang It looks like CCleaner has removed a file or registry entry that statistiXL needs to run. Without seeing your machine it is hard to know exactly what it might be. It would probably be worth reinstalling (or repairing) Microsoft Offic…
  • Hi Joe Lance is right, 2007 is your only real option for breaking the pre 2007 column limit. Cheers Alan
  • Hi. Does this problem happen on multiple machines or just on one? If you like we can arrange a time for me to connect remotely to the box and have a look (as long as it has Internet access)? Email me if you want to set this up. Alan
  • Hello, this is not an issue I have come across before. Can you please try disabling the other add-ins and see if the problem persists? Also, can you please confirm that you are using the latest version of statistiXL (1.8)? Cheers Alan
  • statistiXL should work with no special permissions once installed (admin rights are needed for the install). Have you tried the latest build from the web site downloads section? Have you configured statistiXL to run automatically as an Add-In or …
  • Unfortunately not. Star Office contains Excel's basic spreadsheet functionality but has nothing like Excel's powerful macro and programming support, nor does it afford easy linking to external applications. As Star Office develops it may eventual…
  • All that is happening here is that the DLL is trying to paste the output into the location specified by spPCA.OutputRange. Make sure that the range can be written to and it should work. This will fail if part of the output range contains part of …
  • Quite possibly, it's not something I've done, I always call from within Excel....
  • Yes statistiXL will throw an exception if you try to analyse a dataset with columns with no variance. What routine is throwing the exception when you run the code from VB. The SXLMain DLL needs to reference an instance of Excel that has a copy …
  • What statistiXL DLLs have you set references to? You will need references to the SXLMain.dll in addition to the SXLPCA.dll. If statistiXL isn't loaded the SXLMain.Excel object will need to be set to an instance of Excel (eg from within the Excel …
  • QUOTE I have also learned that SPSS and SAS are set up to handle missing values, although I don't know exactly what they do. That's the main reason we haven't implemented missing values in statistiXL yet, i.e. we don't want it to be doing things wi…