Data Analysis and Visualization
with Excel, R and Google Tools
Analysis, Chart and Map Tools to Better Understand
Note To Readers: The time has
come for me to overhaul this site, a task I dread. When
I started this site in February, 2006 I had a vague idea
about what I wanted to do, show readers how to make more
effective charts with Excel. That mission has morphed to
include Google Map tools, global warming data analysis,
time series analysis and R.
I am converting my
site from FrontPage to Microsoft Expression Web and hope to shift
from using tables for layout control to CSS. Along the
way, I will be dropping material that I once thought
important but is now just digital junk. Please bear with
me through this process. I plan to do it page by page
over several weeks.
Excel provides useful analysis and charting
tools that can help to analyze and understand time series data.
These pages present tutorials and workbooks on how to use Excel
to analyze and chart time series/ trend data.
Regression Analysis with Excel
Trend/ Control Charts
is an integrated suite of statistical and graphical
analysis tools. It is based on the S language which was
developed by Bell Laboratories.
These pages present information, resources and tutorials on
As an environmental engineer, I have been concerned
about the environment since I started working as a water
These pages, combining my data analysis and environmental
interests, present Excel charts that show global environmental