Simple numerical data analysis is described, using a standard spreadsheet program, to determine distance, velocity (speed) and acceleration from voltage data generated by a skateboard/longboard speedometer (Hare 2012 "Phys. Educ." 47 409-17). This simple analysis is an introduction to data processing including scaling data as well as…

Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared. (Contains 7…

Presents a new approach for the determination of the temperature coefficient of resistance of a resistor and a thermistor. Advantages include teaching students how to linearize data in order to utilize least-squares techniques, continuously taking data over desired temperature range, using up-to-date data-acquisition techniques, teaching the use…

Presents an experiment that investigates the temperature of tungsten filaments using a car headlamp. Uses a spreadsheet program that facilitates extensive data manipulation. Gives students an awareness of the many mathematical techniques used in data analysis. (Author/JRH)

Demonstrated in this article are some of the capabilities of a spreadsheet program using data obtained in gas law experiments and a computer interface system. The ability to organize and analyze data which a computer can provide for the student is emphasized. (KR)