Keywords: absolute and relative cell references, chi-squared, Excel, formulas, graphing, model, OpenOffice Calc, simulating data, Solver, spreadsheets, trend line, uncertainties
Want a quick way to do calculations, simulate data and draw graphs? Here are some quck tips on using spreadsheets to do this!
In this activity, we will use an accepted physical model, that of an object falling in a vacuum, to create simulated data that could result from an experiment. We will then graph this data and fit a trend line to it.Read More...
|6 years 46 weeks ago|
Keywords: bicycle, chi-squared, power, spreadsheets
How can you measure the mechanical power required to pedal a bicycle by observing how it slows down when you stop pedalling?
The forces acting on a bicycle can be estimated by observing the rate at which it slows down when you stop pedalling. This technique can, in principle, be used for any transportation vehicle.Read More...
|5 years 9 weeks ago|