|How is Excel used in Science? Today
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
- Next we do an autofill to convert all the
the logarithmic values.
- Then we select the concentration values which will
x-axis of our graph, press 'ctrl' from the keyboard and select the
logarithmic values of the viscosity measurements which will form the
y-axis of our scattered xy-graph.
- We then click on the chart wizard, select the
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
- We place the created chart in sheet1 and edit it so
can view the details properly.
- We scale the x-axis appropriately as shown in the
- We then right-click on our data points in the chart
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
from the menu bar, select 'data analysis...' and finally 'regression'
- In the 'Regression' window you define the various
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
user good information!