With examples from the world of science and engineering, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Physicists and engineers can learn the tips and techniques of Excel—and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more. Ideal for students and professionals alike, this handbook will enable greater productivity and efficiency.
I am a scientist, writer, speaker, and consultant, working at the interface of science, philosophy, and religion. By training, I am human geneticist who also earned a doctorate in the philosophy of science. I studied and worked at universities in Europe and the United States. In 1994, I moved permanently with my wife, Trudy, to the USA, and live now in the southern part of the State of New Hampshire, USA.