
1. Re: Custom trend lines i.e. null model
Scott Tennican Nov 4, 2011 10:44 AM (in response to Helen Greatrex)Hi Helen,
It sounds like you are looking for a seasonal model.
For example, you might use a linear regression model with ARIMA as the error term as you can do with the arima function in R.
Tableau doesn't have any sort of seasonal model yet.
A linear trend through your data will give you an insignificant pvalue if there is no significant slope.
However, in 7.0, we have added ttests for the significance of each term in the regression in addition to the ftest which gives you the pvalue for the line. With 7.0, you would see that your intercept term has a significant pvalue.
But, I recommend adding reference lines instead. You could add a reference line for the average and another for a confidence band at the 95% level. This gives you the information you would get from a constant model. You could also add the standard deviation band and show your students how the confidence band changes width as either the number of observations or the standard deviation of the observations changes.
With regards to ANOVA, Tableau currently only has multifactor ANOVA for regressions. This is used to test the significance of categorical variables in the trend line model when you use them to partition your data.
If you are using a 7.0 beta, I have five workbooks that I use for teaching statistics with Tableau.
A couple of them use references lines as I described above and another shows how to use trend line ANOVA feature to select the correct categorical variable to use in your model.
I've attached a couple just in case.
Remember, you need the 7.0 beta to view the workbooks.
good luck, Scott

summarystatsdemo.twbx 95.7 KB

anovademo.twbx 137.4 KB


2. Re: Custom trend lines i.e. null model
guest contributor Nov 7, 2011 2:25 AM (in response to Helen Greatrex)Hi Scott,
That's fantastic  thanks for the help and advice
Cheers
Helen

3. Re: Custom trend lines i.e. null model
Scott Tennican Nov 28, 2011 12:34 PM (in response to Helen Greatrex)Hi Helen,
The materials from the Tableau Customer conference 2011 (TCC11) Session presentations are now online.
Here is the link to a zip of the powerpoint and all the demos for my Statistics session:
http://www.tableausoftware.com/sites/default/files/pages/tcc11demystifyingstats.zip
Scott
Scott