How is Excel used in Science? Today
we'll learn
how to use Microsoft Excel in Science. Viscosity measurements of
polymer solutions, for example, help us to determine molecular weights
of the polymers in question. Here we have viscosity measurements of a
polymer solution at different concentrations using a viscometer. Now
let's see how we can create a graph and perform calculations on this
data to derive more information from our experiment.
 First we convert the viscosity measurements into
logarithmic values using the function '=ln(cell address containing the
number)
 Next we do an autofill to convert all the
measurements into
the logarithmic values.
 Then we select the concentration values which will
form the
xaxis of our graph, press 'ctrl' from the keyboard and select the
logarithmic values of the viscosity measurements which will form the
yaxis of our scattered xygraph.
 We then click on the chart wizard, select the
'xyscatter'
chart and press the button 'Press and hold to view sample'.
After clicking on next twice we assign the 'titles' to the x and y
axis.  We place the created chart in sheet1 and edit it so
that we
can view the details properly.
 We scale the xaxis appropriately as shown in the
video.
 We then rightclick on our data points in the chart
and add
a trendline which shows how the values deviate from the 'exact'
straight line also called 'residuals'.
 We also add an equation on our chart by clicking on
'options' in the 'Add Trendline' window and check 'Display equation on
chart'. You can add other interesting information also.
 Next click in your measurement data area, select
'tools'
from the menu bar, select 'data analysis...' and finally 'regression'
 In the 'Regression' window you define the various
input
data, confidence level,output range, residuals and residual plots by
checking the appropriate as shown in the training video.
 The statistical data and graph displayed by Excel
gives the
user good information!
