Note: the below was originally written and published in January 2019. I edited the post for clarity and added a few notes on using the Tidyverse suite of packages to do summarize data in R, but you can still find the original here. Not an R user but need an efficient way to average plot… Continue reading Averaging Plot Data in R– Updated Blog Post
Tag: Office
DPI and Image Quality
Have you ever made a map or graph and been disappointed with the image quality or resolution? It happens to all of us, so today I'm sharing two quick tips for what to check the next time this happens. Low image resolution happens more frequently with large graphics, since some software programs have a default… Continue reading DPI and Image Quality
Averaging Plot Data in Excel
Back in January I shared my favorite way to average plot data in R, but some of my lab mates don't use R and are looking for an alternative. They keep averaging their plot data by highlighting 10 cells at a time and using the AVERAGE function, which is rather inefficient and introduces human error.… Continue reading Averaging Plot Data in Excel
Table of Figures
Back to the Word example document-- this time to make a table of figures. I've already captioned photos here, so this is pretty quick and easy. If you're looking for more Word formatting tips, check out the permanent page added to the main menu-- Writing. It starts really similarly to making a Table of Contents.… Continue reading Table of Figures
Navigation Pane
Two quick things I forgot to add last week when I wrote about tables of contents (catch up on the previous post here). First, you can use the "Heading 2" or "Heading 3" buttons to make subheadings. Subheadings can have different text formatting from the main headings and can be indented on the table of… Continue reading Navigation Pane
Table of Contents
More writing about writing! I expanded the example word document from the examples on adding captions to figures and line numbers. Now it has two different headings-- I'm going to format the headings and make a table of contents. To format the headings, I'm going to highlight the text and select the "Heading 1" option… Continue reading Table of Contents
Tips for Table Formatting: Rotating Data in Excel and Pages in Word
I'm working through the last chapter of my thesis this week and ran into some little challenges with table formatting. Originally I had site-year as my rows and soil property as my columns for a particular table, but I decided rotating the table 90 degrees made sense. I didn't want to have to move data… Continue reading Tips for Table Formatting: Rotating Data in Excel and Pages in Word
Line Numbers
Another little Word tip! When I collaborate on a document, I like to have line numbers in the margin. Then I can call people and ask them, "What do you think about page 5 line 15?" instead of, "What do you think about the 3rd sentence of the 2nd paragraph on page 5?" Is it… Continue reading Line Numbers
Averaging Plot Data in R
In agronomy research, its very common to collect 10 plants from a single plot, take measurements on them, and average those measurements. The plot average is the value we run statistics on, whether that means building a regression or running an ANOVA. I've recently seen a lot of my fellow grad students averaging measurements by… Continue reading Averaging Plot Data in R
Making Figures in PowerPoint
There are a lot of good ways to compile different images into a single figure. For me, the print composer in QGIS works to get my map, scales, and legends into a single TIFF to embed in a word document or send as an attachment 90 percent of the time. The other 10 percent of… Continue reading Making Figures in PowerPoint
Spatially Challenged 