DATA SET ANALYSIS
In looking at data sets we will be exploring different families of functions. To view the different functions and their data sets click the following links:
Linear Data Set
Quadratic Data Set
Exponential Data Set
Logarithmic Data Set
Periodic Data Set

Microsoft Excel can be be very useful in Data Set Analysis.
 CLICK HERE to download all data sets used to create this page.

What can you do with data in Microsoft Excel? Click the following to
download your own exploration of data.
Looking Deeper at Data in Excel!


























LINEAR DATA!


The following is data from the U.S. Bureau of the Census, International Data Base.  It is great representation
of linear data.  The data is describing the the world population from the year 1950 to 2003.  Data such as
this can prove to be very useful is predicting future population counts for construction, city planning, density
and natural resource control, and many other vital issue that face us and future generations.


Click here for the data set source.

BACK TO TOP OF PAGE   |    Linear Data Set     |      Quadratic Data Set     |     Exponential Data Set
 Logarithmic Data Set   |  Periodic Data Set































QUADRATIC DATA SET

This quadratic data set shows the effect of what man is doing to adjust to the phenominon of inflation
We saw from the exponential data set that minimum wage was dramatically increasing, however, as
minimum wage increases the value of the dollar is deacreasing to adjust.  Such data is very usefull
in many economic issues.


Click here for the data set source.




BACK TO TOP OF PAGE   |    Linear Data Set     |     Quadratic Data Set     |     Exponential Data Set
Logarithmic Data Set   |  Periodic Data Set



























EXPONENTIAL DATA SET

Exponential data such as this gives us a broad picture of what is going on in our economy.  It is very useful in
looking at the idea of inflation.  We see from the year 1955 to the year 1997 minimum wage with in the US
has increased by approximately $5.50 and continuously climbing. Economist constantly analyze like data to
fluctuate and make changes that effect everybody.


Click here for the data set source.




BACK TO TOP OF PAGE   |    Linear Data Set     |     Quadratic Data Set     |     Exponential Data Set
Logarithmic Data Set   |  Periodic Data Set






































LOGARITHMIC DATA SET

This data comes from Bureau of Labor Statistics.  Data consumer products such as gasoline
can be very informative and useful in all areas of the world.  In looking at year-by-year, long
range data trends can help predict behaviors during world events like war or depression.
Month-month data such as the graph below provides insight on annual trends.


Click here for the data set source.


BACK TO TOP OF PAGE   |    Linear Data Set     |     Quadratic Data Set     |     Exponential Data Set  
Logarithmic Data Set   |  Periodic Data Set





























Periodic Data Set

Periodic data sets can be found in many natural settings.  The data set below is an example of periodic data looking
at changes in the tide.  These two graphs are a wonderful example of how data can be useful in forecasting.
The first graph is that of a 48 hourtime span.  Below is a graph of the tides on a 30 day scale.
Click here to see the data and graphs created in Microsoft Excel.
 

SOURCE of periodic data     http://www7320.nrlssc.navy.mil/pctides/em1/


BACK TO TOP OF PAGE   |    Linear Data Set     |      Quadratic Data Set     |     Exponential Data Set
 Logarithmic Data Set   |  Periodic Data Set















A Deeper Look At Data in Excel

Microsoft Excel has uses in many fields.  Through this look at data, the goal is to become
familiar with with the functions and uses of Excel.  We will be looking at the data set dealing with
the price of gasoline.  When analysising data from numeric, algebraic and graphic standpoint we can
have a better grasp of how data is used and also become familiar with Microsoft Excel.