You can use JMP to save both graphs and tabular output. You can easily save and share your JMP output. JMP supports a variety of image file formats, such as JPEG, PNG, and TIFF. Once the export dialog box appears, select the “Image” option and then choose the file format that you want to use. This can be done by selecting the “File” menu and then choosing “Export”. One of the features of JMP is the ability to save graphs as images. JMP or minitab).JMP is a statistical software package that is used for data analysis. Please note: The statistical analysis in JMP, Minitab and Excel is slightly different in terms of the inclusion of outliers or not! If you are serious about data analysis, I recommend using the right tools (i.e. Finally, I have also changed the font colour and the chart lines to grey. You could also reduce the number of decimal places for the primary Y axis to 2 e.g. For the finishing touches, you could delete the legend, and the secondary Y axis.Change the marker type to a line, increase the size to 11, then click on Close. Then left click on marker options and choose Built in. Left click on line color and choose No line. With the formatting menu open, left click on the median series.In the menu that appears, ensure that fill is selected and choose No fill. Remove the interconnecting line of the median series.Change the fill of the box plot to none.There are a few more formatting points to do. In the menu that apears, change the graph type to line and choose the 4th option (Line with markers). Then right click on the blue filled median data on the graph and select change series chart type. In the menu that apears, ensure that Axis options is selected, then change the maximum value from Auto to Fixed and enter a value of 4.0. both go from 0 to 4.0.ĭouble click on the left axis. The first step is to adjust the two Y axes so that they are identical, i.e. This is not exactly what we want, so we will have to do some formatting. You will need five series of values to create the graph).Įxcel will automatically create the graph below. Click on the 4th chart in the Stock section (Volume-Open-High-Low-Close. To do this, first select the data table shown above, then on the Insert tab, click on the small down arrow next to Other Charts in the charts section. Since excel doesn’t have a box plot chart we are going to have to create one. The order they appear in, (median, Q1, Min, Max, Q3) is very important! Do not change this or the graph will be wrong! The Q1 and Q3 values will form the top and bottom of the box. Once again, repeat this for each site (and tab) to form rows 3 and 6 of the table also shown below. Row 6 ( Upper quartile, Q3) is calculated by: The value after the comma (in blue above) show that we want the lower quartile (Q1) Row 3 ( Lower quartile, Q1) is calculated by: Excel has a built in function “quartile” which we can use for the calculation for this row and for row 6. The minimum and maximum values will be used to create the whiskers of the box plot. I will come back to row 3 in a moment, for now let’s skip on to rows 4 and 5.Īgain, repeat this for each site (and tab) to form rows 4 and 5 of the table above. The $ symbol ensures that the range used for column C never changes when you copy / paste the calculation across the row. Repeat this for each site (and tab) by changing the figure ‘1’ to ‘2’, then ‘3’ etc to form row 2 of the table below. ‘1’ refers to tab “1” and it is looking at the values in column C from lines 2 to 13. You can see this on the “Box plot” tab of the excel sheet attached. The first thing you need to do is calculate the median, minimum, maximum and upper quartile values for each site. You can of course use just one tab for all if you prefer! In the example attached, I have created a tab in excel for each site (labelled 1 to 10). For clarification, I have also uploaded the excel file, so please feel free to have a look! In this example, I have 10 sites, with values by month for the year 2011. So I thought I would post this technique to allow you to perform a box plot analysis using Excel.įirst you need to gather your data together. For those who rely on Excel to do their data analysis (rather than mini-tab or JMP), occasionally the charts available are a little limiting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |