Campaign Vs Control significance tests, what's the easy approach Excel or SAS?

Accepted Solution Solved
Reply
Contributor
Posts: 40
Accepted Solution

Campaign Vs Control significance tests, what's the easy approach Excel or SAS?

Hi All,

Just wanted to have your views on how you do Significance tests, do you prefer Excel or SAS? I have recently learnt doing t-tests and ANOVA in SAS Base but at work, we use Z-Scores in Excel to compare different groups for our Campaign analysis. I find it hard to understand the excel Z Scores and find t-tests in SAS much easier. Just wanted to know what's the best practice to do group comparisons.

Many thanks.

Regards.

SS


Accepted Solutions
Solution
‎08-11-2014 12:00 PM
Trusted Advisor
Posts: 1,228

Re: Campaign Vs Control significance tests, what's the easy approach Excel or SAS?

This is usually done using proc ttest to compare two groups.

View solution in original post


All Replies
Solution
‎08-11-2014 12:00 PM
Trusted Advisor
Posts: 1,228

Re: Campaign Vs Control significance tests, what's the easy approach Excel or SAS?

This is usually done using proc ttest to compare two groups.

Respected Advisor
Posts: 2,655

Re: Campaign Vs Control significance tests, what's the easy approach Excel or SAS?

Granted this is now 15 years old, but you should look at http://users.df.uba.ar/cobelli/materias/laboratorios/excel97.pdf.  The last line in the abstract is:

Persons desiring to conduct statistical analyses of data are advised not to use Excel.

Now there have been improvements, but a search on BD McCullough reveals the following http://www.forecastingprinciples.com/paperpdf/McCullough.pdf from 2006.

There is a reason SAS, R, SPSS, S Plus, Matlab, Mathematica, Python, Ruby and Java apps all exist.  A large part of them have to do with the statistical inadequacy of Excel.

Steve Denham

Contributor
Posts: 40

Re: Campaign Vs Control significance tests, what's the easy approach Excel or SAS?

I agree that SAS is much more accurate but I have seen many companies using Z-score calculations in their marketing reports to do significance tests. I just wanted to know what's the common practice...

Will be good to have some views from different people. Anyone?

Respected Advisor
Posts: 2,655

Re: Campaign Vs Control significance tests, what's the easy approach Excel or SAS?

Just because it is common doesn't always mean that the results are the best you could get for the money.  Note Bruce McCullough's point about tabulating the normal distribution and calculating p values.

I use Excel a lot, but I don't trust it to give me statistical answers.

Steve Denham

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 681 views
  • 0 likes
  • 3 in conversation