• /  238
  • 下载费用: 20.00积分  

using excel for principles of econometrics3e

'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
 天天文库所有资源均是用户自行上传分享,仅供网友学习交流,未经上传用户书面授权,请勿作他用。
关于本文
本文标题:using excel for principles of econometrics3e
链接地址: https://www.wenku365.com/p-40984893.html
关于我们 - 网站声明 - 网站地图 - 资源地图 - 友情链接 - 网站客服点击这里,给天天文库发消息,QQ:1290478887 - 联系我们

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

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

粤ICP备19057495号 

收起
展开