Numbers entering

If you enter a fraction less than 1, such as 1/3, it will be interpreted as a date ( 3-Jan ). To prevent Excel from converting the fraction to a date, enter a zero and a space before the fraction (0 1/3). The zero indicates that the entry is a number, and the value will appear in the formula bar as 0.333333333333333. 

---

On all scientific calculators it is possible to enter numbers in exponential notation. The method used depends on the brand of calculator. Most often, it involves using a key labeled [exp), [ ee 1, or [eex]. Check your instruction manual for the procedure to be followed. To make sure you understand it, try entering the following numbers ... 

Enter Number of Runs in this dataset (NRUN)... 

You must be able to enter numbers easily and unerringly into your calculator using scientific notation With most calculators, this would be accomplished as follows. 

Some calculators make it possible for you to choose in advance that all results be displayed in scientific notation (or decimal notation), regardless of which notation you use for entering numbers You can also choose how many decimal places (usually up to a maximum of 8) will be displayed in decimal notation, or in the lefthand factor of scientific notation If your calculator has... 

In practice, we perform mathematical operations on numbers in scientific notation according to the simple rules that follow. It is not necessary to know these rules when calculations are done with a calculator (you need only know how to enter numbers), but many calculations are so simple that no calculator is needed, and you should be able to handle these operations when your calculator is broken down or not available. The simple rules are the following. 

You will probably use your calculator for most calculations. It is critical that you learn to use the scientific notation feature of your calculator properly. Calculators vary widely, but virtually all scientific calculators have either an EE key or an EXP key that is used for scientific notation. Unfortunately, these calculators also have a 10 key, which is the antilog key and has nothing to do with scientific notation, so don t use it when entering numbers in scientific... 

The online statistical calculations can be performed at http //members.aol.com/ johnp71/javastat.html. To carry out linear regression analysis as an example, select Regression, correlation, least squares curve-fitting, nonparametric correlation, and then select any one of the methods (e.g., Least squares regression line, Least squares straight line). Enter number of data points to be analyzed, then data, x and y . Click the Calculate Now button. The analytical results, a (intercept), b (slope), f (degrees of freedom), and r (correlation coefficient) are returned. 

Method 1. From Recipe Edit Screen select Create New Recipe 2. Enter a value In each field 3. Print screen and verify each field against entered values 4. Select Save Recipe 5. Exit Recipe Editor 6. Re-enter Recipe Editor 7. From Recipe Edit Screen select View Recipe 8. Enter Number of newly created recipe 9. Confirm that values are correct... 

You can also enter numbers (values) in cells for use in calculations. Many programs let you enter numbers in more than one way and you must decide which method you prefer. The way you enter the number does not affect the way it is displayed on the screen as this is controlled by the cell format at the... 

Specify entering numbers Fao.Fbd.Fco,Fpij and final values V , S, Us an ODE solver. 

In order to use logarithms one must be able to evaluate them. The simplest way to do this is to use a scientific calculator. Such a calculator will ordinarily have two keys, one marked LOG, which will give the common logarithm of the entered number, and the other LN, which will give the natural logarithm. 

You can enter numbers in E format but they will automatically be converted to floating point. You can t enter numbers as percentages the percent symbol has another meaning in VBA (see "VBA Data Formats" later in this chapter). 

PRINT"ENTER NUMBER OF TEST TO LOAD " INPUTN... 

PRINT" DOVJN ENTER NUMBER OF TEST " POKE649,10 IN PUTX rem 159... 

ENTER OPTION NAME (OR COMMAND BY PRESSING USER KEY "1H> atonsize ENTER NUMBER OF DATA ITEMS 4... 

Students sometimes make mistakes when they try to enter numbers into their calculators in scientific notation. Suppose you want to enter the number 4.36 X 10 . On most calculators, you would... 

To keep things simple, we will use Gaussian curves to generate our mock spectra, but you are welcome to modify the instructions by substituting other shapes, or even by drawing them by hand by entering numbers. 

The Hope Diamond, which is shown in Figure 2.6, contains approximately 460,000,000,000,000,000,000,000 atoms of carbon. Each of these carbon atoms has a mass of 0.00000000000000000000002 g. If you were to use these numbers to calculate the mass of the Hope Diamond, you would find that the zeros would get in your way. Using a calculator offers no help, as it won t let you enter numbers this large or this small. Numbers such as these are best expressed in scientific notation. Scientists use this method to conveniently restate a number without changing its value. 

---