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.
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.
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).