A. Multibase does not support Excel 2003 and its previous versions. Excel2007 can be used but some graphs may be distorted. Excel 2010 or 2013 are desirable
A. To remove Multibase from Excel Add-in, click "File", "options", "Add-ins" and "Go ...." in turn. When the dialog box opens, check off "Multibase 2015" and click "OK".
A. Dependent variables can be assigned at "Sample" tab in Method and Preparation dialog box. Choose dependent variables in the list and click "Set as Variable(Y)", then they will be recognized as Y.
A. PLS-EDA is original analytical tool of Multibase. It is based on O-PLS algorithm but enhances separation of two categories.
A. The colors of graphs are inherited from the cell colors of the preparation sheet. When you change the cell colors, the colors of graphs will be changed. (You have to regenerate graphs again.)
A. To draw Box Whisker plot, prior categorization is necessary. Categorization can be done at "Method and Preparation". Detail information can be obtained from "help".
A. Multibase can handle 30,000 variables and 1,000 samples. However since more than 1,000 variables put an extra load on a computer, you should gradually increase the number of variables.
A. The variables whose values are all zero destabilize calculation. They should be removed in advance on Variable page in "Method and Preparation" dialog box.
A. We haven't reached the cause. Some Excel version seem not to work properly.
A. Please write "Cluster analysis (or PCA, PLS analysis) was performed using the Excel add-in Multibase package (Numerical Dynamics, Japan)".
2-3-1 Marunouchi Chiyoda Tokyo Japan