For the least-squares analysis of data having multiple uncertain variables, the generally accepted best solution comes from minimizing the sum of weighted squared residuals over all uncertain variables, with, for example, weights in x[subscript i] taken as inversely proportional to the variance [delta][subscript xi][superscript 2]. A complication…

The oxidation of iron is an important reaction due to its high economic impact. In this laboratory exploration, the total order of this reaction was determined using commercially available handwarmer packets that rely on the iron-oxygen reaction to generate heat. The active ingredient in the handwarmer packet is iron, which interacts with…

Throughout the general chemistry lab curriculum, a common shortcoming is the way in which students measure, record, and manipulate quantitative data. From initial measurements with different digital and analog instruments to proper conversions, calculations, and comparisons, students are often expected to be experts before they have been taught…

A visual regression analysis using the least absolutes method (LAB) was developed, utilizing an interactive approach of visually minimizing the sum of the absolute deviations (SAB) using a bar graph in Excel; the results agree very well with those obtained from nonvisual LAB using a numerical Solver in Excel. These LAB results were compared with…

Equilibrator is a Microsoft Excel program for learning about chemical equilibria through modeling, similar in function to EQS4WIN, which is no longer supported and does not work well with newer Windows operating systems. Similar to EQS4WIN, Equilibrator allows the user to define a system with temperature, initial moles, and then either total…

A description of the Microsoft Excel spreadsheet simulation, Anharmonicity.xls that can be used to smoothly and continuously switch a plotted function and its quadratic approximation is presented. It can be used in a classroom demonstration or incorporated into a student-centered computer-laboratory exercise to examine the qualitative behavior of…

Describes two spreadsheets for producing acid-base titration curves, one uses relatively simple cell formulae that can be written into the spreadsheet by inexperienced students and the second uses more complex formulae that are best written by the teacher. (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)

Described are several spreadsheet templates which use the functions of iteration and logical look-up which allow students to calculate and graph quantum mechanical functions and to simulate rotational and vibrational energy level and spectra. The templates are listed in the appendix. (KR)

Discussed are the possible uses of spreadsheets in the undergraduate curriculum in chemical engineering classes. The advantages and flexibility of spreadsheets, spreadsheet instruction, graphing capabilities, assignment examples, and conclusions are described. (KR)