Finance Blogs
- Scott Adams on Board Governance
-
From Financial Rounds
January 19, 2008 4:40 PM
- Corporate governance survey conducted (Pakistan)
-
From Inside Sarbanes Oxley
January 19, 2008 12:13 AM
- Enron-driven reforms are unraveling
-
From Inside Sarbanes Oxley
January 19, 2008 12:06 AM
- More...
The Finance Institute
- Tackling T&E Expense Reports
-
Webcasts
- Performance Management – It's Not Just About Technology
-
Webcasts
- More...
Diverts
- Dancing Goes to the Dogs
- Canine freestyle dancing, a competitive sport in which dogs perform dance routines with human partners, originated in British Columbia in 1989 and has gained international popularity. [more]
- Quirky Festivals Around the U.S.
- Looking for vacation ideas? [more]
- Candy Attack
- Sean McGuire, a college student from Illinois, was arrested earlier this week after assaulting a Des Moines, Iowa, police officer with an unusual weapon -- M&Ms. [more]
- More Diverts
Business Purchasing
Business Finance has partnered with BuyerZone.com to make it easy for you to find advice and tools for your business purchases. BuyerZone's free Request for Quotes service quickly connects you with suppliers of over 150 product, service and equipment categories. They also have hundreds of articles full of purchasing advice and insider tips. Click here to review some of the most common purchases that face your business.
On Your Desktop
Add SearchFinance to your desktop using the Yahoo! Widget Engine:
From the Blogosphere
December 22, 2007 10:32 PM
From Financial Rounds
As a finance guy, I'm pretty good with Microsoft Excel. MOst of my immediate peers use it for grading. But if you do, here are a few functions that you might find useful:
1) The IF function is useful if you have two different weighting schemes. For example, to give the poorly performing students incentives to push hard in studying for the final, I often tell the students that I will grade them using two different weightings on their grades - in one I put greater weight on the exams and quizzes that take place throughout the cours, and in the other I put more weight on the final (I assign them the higher of the two grades).
Use the syntax =IF(Scheme1>=Scheme2, Scheme1, Scheme2) where Scheme1 and Scheme2 reference the cells containg the scores under the two weighting schemes, and you'll get the higher of the two cells.
2) The LARGE function is very helpful when you want to pick N out of K scores (for example, if you calculate the average of quizzes after trhrowing out the lowest N scores). The Syntax LARGE(A1:J1,2), will identify the 2nd highest score out of the 10 elements soted in the array from A1 to J1. To calculate the average of the 8 largest scores in the cells from A1 to J12, I'd use the following syntax:
=(SUM(A1:J1) - LARGE(A1:J1,10) - LARGE(A1:J1,0)) / 8
In other words, I calculate the sum of all ten, then subtract the two lowest scores,and then divide by eight (make sure you keep track of the parentheses).
[ Read the entire post at Financial Rounds ]
Other recent entries from Financial Rounds:
Webcasts
Podcasts
Research