Greetings;
I searched the forums and didn't find anything, so I hope this hasn't been asked before:
How do you write code to automate a single factor ANOVA using the Tools > Data Analysis function? I have enabled both the Analysis ToolPak and Analysis ToolPak - VBA add-ins, but when I try to record a macro using this function, nothing appears.
I plan to attach the code to a command button in a template that will be used to randomize subjects into groups and test whether significant differences exist between the groups based on a single variable.
Thanks in advance for any and all help.
I searched the forums and didn't find anything, so I hope this hasn't been asked before:
How do you write code to automate a single factor ANOVA using the Tools > Data Analysis function? I have enabled both the Analysis ToolPak and Analysis ToolPak - VBA add-ins, but when I try to record a macro using this function, nothing appears.
I plan to attach the code to a command button in a template that will be used to randomize subjects into groups and test whether significant differences exist between the groups based on a single variable.
Thanks in advance for any and all help.