![]() ![]() 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 |