LanceGary

About

Username
LanceGary
Joined
Visits
0
Last Active
-
Roles
Community Member

Comments

  • QUOTE (danja @ 11 Sep 2008, 07:59)There is a lot of mention in the Statistixl help file about the three models (I, II, III) of ANOVA, but it doesn't seem to explain how to change the model. When I choose to do an ANOVA it seems to be preset on mode…
  • I am afraid StatistiXL is not the kind of program you are looking for - it is a traditional stats program. You might want to investigate BUGS. See for example: http://www.mrc-bsu.cam.ac.uk/bugs/ Lance
  • Repeated measures ANOVA? Each set of beach data is one level of a larger variable called time. Each elevation could be analogous to one subject. Alternatively, if you have enough "slopes" could you not treat that as a data set and examine change …
  • The obvious answer is to upgreade to Excel 2007. Lance
  • QUOTE (Alan Roberts @ 12 Oct 2007, 19:10) 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 without the user being aware of what is going on and the implications of whatever tak…
  • Here are some additional resources for dealing with missing data: Acock, A. C. (2005). Working with missing values. Journal of Marriage and Family, 67, 1012-1028. Donders, A. Rogier T., van der Heijden, Geert J.M.G., Stijnen, T., & Moons,…
  • QUOTE (LanceGary @ 3 Oct 2007, 20:51) It is a good document on missing values, I agree. But there are additional methods that are sometimes used. Simply using the mean, for example, can reduce the variance of a data set. Eliminating values (cases wi…
  • It is a good document on missing values, I agree. But there are additional methods that are sometimes used. Simply using the mean, for example, can reduce the variance of a data set. Eliminating values (cases wise etc) can reduce the sample size qu…
  • I am not sure I understand you, so my reply may be quite wrong. Anyway, in factor analysis, especially before the development of cluster analysis, it was quite common to use the technique as a means of clustering people rather than finding a way o…
  • I found the following using a Google search: homepages.gold.ac.uk/aphome/correlnotes.doc There were also several other urls that looked as though they could have useful material - one referred to excel: www.stat-help.com/spreadsheets/ Comparing%…
  • I think statisticians will tell you to use the Fisher transform on your correlations and then test for differences. (I am presuming that you are tracking correlations between your groups and some variable across time). In meta-analysis, however, th…
  • Check that Excel has not, for its own reasons, disabled StatistiXL. Lance
  • OK - I think I've got to eat some humble pie. I found a small error that I had inadvertantly copied across several spreadsheets (there was a "minus sign" in front of the STDEV function). Even with 2000 resamples I have not got any negative standa…
  • I have been experimenting with bootstrapping using Excel's data table feature (not original to me). In bootstrapping it is common to estimate the standard error of the bootstrapped means (if you are bootstrapping means) by taking the standard devia…
  • There is a free excel add-in (mixlogit) that does logistic regression (and some additional add-ins as well) available here: http://faculty.fuqua.duke.edu/~kamakura/bi...raDownloads.htm I find it rather cryptic and not very user friendly, but perh…
  • Hi Alan - The specifics of the calculations don't differ much at all. But since the investigator trying to use this method must enter variables in a specific sequence and estimate the added contributions they make in order to assess interactions o…
  • Hmm. That should be "showing" (not "howing") the effects of additional varaibles as they are added. Two web sites dealing with this technique for researching interactions ("moderators") and intervening variables ("mediators") are the following: h…
  • P S Another nice addition for contingency tables Sorry to keep bothering you but since I had mentioned a number of additions for the contingency table routines I thought it might be worth mentioning another relatively simple one that can be very u…