Practice in Excel
To analyze the outcome of many experiments carried out in sciences, it is
necessary to apply statistical analysis, perform mathematical calculations, and present the result in graphical form. An ideal environment to perform these tasks and more is a spread sheet program such as Microsoft Excel. The following is a brief tutorial to get you started. In the course of this practice you will learn about the basic operations of excel including data entry and manipulation and graphing. If you are an experienced excel user, you are not required to follow this tutorial, however you must work out the exercises given at the end of each section as a proof of your proficiency.
Data entry and editing
The basic screen i n Excel is referred to as the “Work Sheet”, organized in
columns identified by single, double,…, letter such as column “A”, “B”,….”AA”, “AB”,…and rows identified by numbers. Each basic cell of the work sheet is specified by the combination of a column and a row address. A cell addressed as C12, for instance, refers to the cell at the intersection of column “C” and row “12”.
Entering a Formula
One of the major strengths of excel is its number crunching capabilities. Data entered in a worksheet can be manipulated according to prescribed formulae to generate new sets of data or results. The formula could be a built-in function defined in excel, a function defined by the user, or a direct formula composed by the user. To demonstrate this, clear all the entries in your worksheet or start a new worksheet (note the worksheet tab at the bottom left corner of the screen).
The objective of this exercise is to graph a given set of data and use different built-in features of excel to fit your data with standard curves. Furthermore, excel provides you with the tools to determine the algebraic equations representing your data. Click on the shee2 tab at the lower left corner of the worksheet to start a new worksheet. Using the fill option of the editing group of the home tab enter the values 1 through 20 in cells A1 through A20. Now enter the following values in the cells B1 through B20, respectively.
Enter a linear series of numbers 1, 2, 3, . . . . . 100 in column A from A1 to A100. Enter a second series of numbers 20, 22, 24, . . . . . 218 in Column “B” from B1 to B100. Plot Column “B” as a function of column “A”. Use a linear trend-line and find the equation of the line. Specify the slope and the y-intercept of the line. Save your file and submit it in the submission folder by the due date.
Need assistance with a similar excel project? Order now https://write-myessays.net/home/order_now for instant expert services.