Dr. Roe asked me to generate a pot map for her growth chamber experiments. Since she will do the experiments again and again. One fixed map is not good. I wrote some VBA code in Excel and create an Excel Add-in. This program can generate pot layout randomly. All you have to do is put [...]
It is pretty easy to do Chi Square Test in Excel. First you need arrange your dat in table with one or two categories, then calculate the theretical value for each interactions (cells). Then just put the actual data and theoretical data into CHITEST worksheet function. Sometimes that you need deal with your raw data [...]
Today (Sept. 25, 2002), my major advisor asked me to extract citation data from one text file he created and sent me through email. After I looked at the data, I realized that the data came from the citation databases, such as AGRICOLA, Biological Abstract, CAB, and so on. The requirements that you asked me [...]
More often, we need find the maximum or minimum value of a function within a given range. In Excel, we can develop a user-defined worksheet function to fulfill this goal. Here provides a user-defined function called minmax. This function is very powerful because it can be applied to any polynomial equation. The definition of the [...]
Here provides a user-defined function to estimate predicted values of the dependent variable and corresponding confidence interval for a given dataset with linear relationship. The function definition is the following: yhat(Y, X, XNew, CI, alpha) Where, Y includes values of the dependent variable; X includes values of independent variables (can includes multiple columns (variables)); XNew [...]