I’ll make use an example to illustrate a potential approach. You are also looking to set specifications. To get reasonable results you need to have roughly normal distributions of the before and after data sets. You have essentially a 2 sample t-test situation, however…Ī two sample t-test is looking to see if there is a statistical difference between the 2 sets of data in the mean value. This situation raises a number of questions. Let ‘MatchWtSum’ = pars(weight*(‘Criteria1’=’Criteria2’))Īfter these manipulations the worksheet would look like:Ĭriteria1 Weight Criteria2 MatchWt MatchWtSum Name C7 ‘MatchWtSum’ # Cummulative sum of weights with matching criteria Let ‘MatchWt’ = weight*(‘Criteria1’=’Criteria2’) Name C6 ‘MatchWt’ # Column with 0 for non match or weight if criteria match Once that is done the manipulations are straightforward:
#HOW TO USE MINITAB 16 HOW TO#
See the post for How To > Data Manipulation > Padding columns. If the columns have different numbers of rows you need to pad them to equal length. In this example you would want to sum the weights for matching colours. If I’ve understood your question you have 3 columns, for example: Positive numbers but that is getting complicated!). This data you could plot the negative values but labels the ticks with (If you were creating a macro to routinely plot The only difference from the example is that the depths will be negative Double click on the data label and change Alignment > Postion >.Right click on graph and Add > Data Labels... > Use Values from.Show > Major Tick Labels to High Side and Options > Connection Order is “Increasing Y”. We right click on the connect line and edit it so that the.We create a scatterplot with connect line of YVal vs ‘Depth (m)’.We use the calculator function to create a column of Depth * (-1) so.Let’s say we have 2 numeric columns Depth and YVal and a 3rd column ……., at National Institute of Oceanography There was a post in LinkedIn a few days ago which was removed Scatterplot with Y axis “on top”, along with data labels… I’m not that familiar with more than the basic data analysis add-in for Excel, but Minitab out of the box “excels” at graphical analysis. the ability to overlay distribution curves, the ability to sub-set the data graphed, smooth ability to handle missing data, etc.
statistically powerful graphs – ECDF graphs, Box Plots, Individual Values Plots, Matrix Plots, etc.proper histograms without having to define bin ranges!.no need to adjust data ranges for graphs if your dataset grows.the ability to easily create panelled graphs and multiple graphs from one dialog.These opportunities are often solved in practical ways without the need for formal statistical methods.Ĭonsider the benefits Minitab brings to graphical analysis: From my experience in manufacturing, graphical methods uncover most of the opportunities which get pursued. Graphical analysis is at the heart of the practice of statistics. Here are some thoughts I posted in another forum: One example is the power of the “word” function mentioned in the previous post.
If you are “fluent” in both you may find yourself using Minitab more than you thought for data manipulation. I am a fan of Minitab(r) and Excel(r) but which to use?