It is an experiment in projectile motion, showing the position of a projectile after being given an initial velocity and angle. Practice Experiment In order to demonstrate many of the tools in Excel, you will be analyzing data from a fictional experiment. It is also a good idea to and save this section for future reference. Each of theses tools will be used extensively throughout the laboratory, so it is very important that you understand how and why these tools are used. After completing this tutorial you should be able to navigate through Excels menus, have an understanding of the usefulness of Excel, and understand concepts such as copying and pasting, entering formulas, absolute and relative cell referencing, graphing, and regression analysis. This tutorial will cover many of the tools available in Excel that will be used during the laboratory experiments to analyze data.
Many of the experiments performed in lab require the use of Excel in order to analyze the collected data. Objective The purpose of this lab is to become familiar with the Microsoft Excel spreadsheet program. No part of this publication may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, or any information storage or retrieval system, without permission in writing from the author. Parks Department of Physics and Astronomy 401 Nielsen Physics Building The University of Tennessee Knoxville, Tennessee Copyright August, 2000 by James Edgar Parks* *All rights are reserved.