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 50 weeks ago|
|Commuting by car or cycle - which is better?||
Keywords: bicycle, Carbon footprint, consumption, cycling, energy, Food, spreadsheets
It's not actually that clear...
We set out to find how much of a change it would make environmentally if one cycled instead of drove to work and then further expanded our findings to include the variables of diet composition and material goods ownership.Read More...
|5 years 5 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 13 weeks ago|