I need to create a scatter plot of d2H vs d18O data, as shown in columns D and E in the attached spreadsheet. I also need to show, using symbols and/or colors, which "category" (from column A) each data point belongs to and which "site" (from column B) each data point belongs to. Finally, I need to be able to show the ID of the point (column C).
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …