Wednesday 22 February 2017

Histograms Etc - Easy Histograms, Probability Plots and Statistics



This Spreadsheet...
  • This spreadsheet allows you to quickly create professional looking histograms, probability plots and statistics of data.
  • Plots histograms and cumulative probability plots for up to 10 distributions of data.  
  • Calculates statistics for each data set.
  • Calculates best fit normal and lognormal distribution.  

Wednesday 15 February 2017

X-Y Plots Spreadsheet - An Easy Way To Explore Your Data

This Spreadsheet...

  • This spreadsheet allows you to quickly create professional looking plots of data.
  • This spreadsheet is useful for looking for trends and relationships in your data.
  • You just paste in the data to the data sheet, name the columns and select which columns you want to plot in the Chart sheet.
  • With this spreadsheet it is easy to:
    • plot separate series (different colour points) categorized by one of your data fields.
    • filter the data you want to plot.
    • plot regression lines through the different series.
    • plot bin averages for scattered data.
    • annotate the data with labels automatically.


Wednesday 8 February 2017

Regression Modeling Spreadsheet (automatic stepwise multiple linear regression)


This spreadsheet does:
  • Multiple linear regression.
  • Can use linear, square and interaction terms for all the variables you enter.
  • Stepwise multiple linear regression to find the best model automatically.
  • Provides results and many useful diagnostic plots.
  • Provides a suggestion of which independent terms may be confounded (useful for regression of experimental design data).