This preview shows page 1. Sign up to view the full content.
Chem 227 – Fall 2010
Homework 1
Part 1:
visit your professor in his office by the end of the week
Part 2, C1:
Basic Spreadsheet Operations
Due Tuesday, September 7
Objective:
This exercise will introduce you to basic spreadsheet operations to perform multistep
calculations.
Instructions:
Import (x,y) data for a buret calibration from the file
lstsqrs.csv
in the homework data
section of the class website into a spread sheet.
Square each xvalue and each yvalue, and also
find the product of x and y for each data point.
Next, find the sum and averages of each of these
columns of numbers (x, y, x
2
, y
2
, and xy).
Lastly, have the spreadsheet count the number of
entries in each set.
Format the sheet to look nice and include appropriate column labels (e.g., x, y, x
2
, y
2
,
sum x, …).
You may check your results, as you work, against the key posted under Course
Materials in the course Blackboard site.
In your workbook, include a sheet that shows the formulas used for your spreadsheet
This is the end of the preview. Sign up
to
access the rest of the document.
 Fall '10
 StevenGoates

Click to edit the document details