书签 分享
• /  238
• 下载费用： 20.00积分

# using excel for principles of econometrics3e i Using Excel For Principles of Econometrics, Third Edition Version 1.0 ii Using Excel For Principles of Econometrics, Third Edition ASLI K. OGUNC Texas A and we can apply mathematical and statistical functions to the data in our worksheet. To illustrate, highlight Columns A combine numbers; and produce numeric results, use the following arithmetic operators. Arithmetic operator Meaning (Example) + (plus sign) Addition (3+3) – (minus sign) Subtraction (3–1)Negation (–1) * (asterisk) Multiplication (3*3) / (forward slash) Division (3/3) % (percent sign) Percent (20%) ^ (caret) Exponentiation (3^2) To create a new variable Y2, select cell E2 and enter the formula =C2^2. This command instructs Excel to square the value in cell C2. The new value is Y2 = 4. Select this cell, and click Copy (or the shortcut Ctrl+C) Introduction to Excel 9 The border of the cell begins to rotate. Move the cursor to the lower right corner of the cell until the “plus” sign appears. Hold the left mouse button down and drag the plus down to cell E6. Release the left button and you will find the new values of Y2. What you have done is Copy the formula in E2 to the new cells, and Excel calculates the square of each Y value. 1.3.2 Mathematical functions There are a large number of mathematical functions, most of which you will never use. Find the right function is fairly simple using Help. Search for math functions. Among the results returned is “Find functions and enter arguments” which is an online training session video, which you might find useful. 10 Chapter 1 Another entry is “List of worksheet functions”. A partial list of the functions available is listed on the next page. These are taken from the Excel help result. Introduction to Excel 11 Math and trigonometry functions Function Description ABS Returns the absolute value of a number CEILING Rounds a number to the nearest integer or to the nearest multiple of significance COMBIN Returns the number of combinations for a given number of objects EVEN Rounds a number up to the nearest even integer EXP Returns e raised to the power of a given number FACT Returns the factorial of a number FACTDOUBLE Returns the double factorial of a number FLOOR Rounds a number down, toward zero GCD Returns the greatest common divisor INT Rounds a number down to the nearest integer LCM Returns the least common multiple LN Returns the natural logarithm of a number LOG10 Returns the base-10 logarithm of a number ODD Rounds a number up to the nearest odd integer PI Returns the value of pi POWER Returns the result of a number raised to a power PRODUCT Multiplies its arguments QUOTIENT Returns the integer portion of a division RAND Returns a random number between 0 and 1 RANDBETWEEN Returns a random number between the numbers you specify ROUND Rounds a number to a specified number of digits ROUNDDOWN Rounds a number down, toward zero ROUNDUP Rounds a number up, away from zero SERIESSUM Returns the sum of a power series based on the formula S

usingexcelforprinciplesofeconometrics3e 天天文库所有资源均是用户自行上传分享，仅供网友学习交流，未经上传用户书面授权，请勿作他用。

## 当前资源信息 新起点 • ## 机械制造质量分析与控制.pdf

• 本站为“文档C2C交易模式”，即用户上传的文档直接卖给(下载)用户，本站只是中间服务平台，本站所有文档下载所得的收益归上传人(含作者)所有【成交的100%(原创)】。本站是网络服务平台方，若您的权利被侵害，侵权客服QQ：1290478887 欢迎举报。

1290478887@qq.com 2017-2027 https://www.wenku365.com 网站版权所有

收起
展开