School District To Parents — Buy Office 2007

WS Nick writes "Batavia school district in Illinois is recommending that parents of high school students upgrade their home computers to Microsoft Office 2007. Why not use one of the free alternatives and relieve parents of some of the financial burden they face to buy all the stuff for their children the school requires?" A comment from a reader points out how easy it is to interoperate with Office 2007 from earlier versions.

Comments

Re:BECAUSE THERE IS NO FREE ALTERNATIVE

[nameer]

You shouldn't be using the "display equation" in Excel, since it doesn't have any notion of significant figures, and can give you crap results if the intercept and the slope differ by orders of magnitude. You should be using the slope() and intercept() functions for linear fits (which also exist in Calc) so that you have the numbers in cells. You can format the cells to display the proper number of sig-figs, and have the numbers available in a cell for further calculations.

If you need to fit more than a line, then you should know how to transform the data into a linear problem. If you need something more sophisticated than the ordinary least-squares fit to the transformed problem, then you probably should be using a tool other than a spreadsheet.

Displaying the equation on the graph will only work if you have few sig-figs and all parameters of the fit are of equal orders of magnitude. And even then, you won't be able to DO anything with the numbers other than display them.