I have data output that consists of both categorical and continuous data. The descriptive statistics function of the data analysis tool does a great job by providing most of the information I need (except confidence intervals) for the continuous data. Is it possible to develop a VBA code that would run the descriptive statistics function on whichever column is highlighted as well as produce a Confidence interval output?
For the categorical data, I was thinking it would be more useful to use pivot table in a VBA for the descriptive statistics as the output would be more reader friendly.
My questions are:
1) Is there already a way to do this?
2) If not, is it feasible to do this?
3) If it is feasible, what are your recommendations to go about doing so?