Initial Publication Date: September 10, 2008

Data Analysis Techniques

  • Excel
    • Analyze a single variable (i.e. pie chart, histogram)
    • Analyze two variables
    • Relate two variables to each other across time (i.e. column-line graph)
    • Use formulas to simplify calculations (i.e. averaging a column of data)
    • Graph data in "real-time" (setting up a graph, erasing the data, and leaving a template)
    • Import data from a table and format in columns (i.e. text to columns feature)
    • Export data into different formats (i.e. comma separated values, csv) as a preparation step for using the data in a GIS
  • ImageJ
    • Measure distance and area on an image
    • Save and export measurements so they can be graphed in Excel
    • Annotate an image
    • Adjust the brightness and contrast of an image
    • Analyze the frequency distribution of the pixels in an image (i.e. histogram)
    • Animate a series of images
    • Create an animation from an image montage
    • Select pixels in an image that fall within a specific range of pixel values (i.e.thresholding)
  • AEJEE GIS
    • Layer GIS data (in point, line, or area format) appropriately to build a GIS map
    • Turn GIS data layers on and off or move layers up and down on a GIS map
    • Add image data to a GIS map
    • Identify features on a GIS map
    • Select features on a GIS map
    • Sort and select records of an attribute table linked to a GIS map
    • Change the projection of a GIS map
    • Import lat/long data into a GIS
    • Query GIS data to find features matching a given criteria
    • Buffer GIS data to find features within a distance of other features