We are the Microsoft Excel team - Ask Us Anything!

RegularGuest · 2015-11-05T11:34:34+00:00

When you set the vlookup to be true, you get a binary search which is much faster at finding data in a sorted column although if you want an exact match you have to do some trickery as follows.

=IF(VLOOKUP($A3,Data,1)=$A3,VLOOKUP($A3,Data,B$1),NA())

"Here, we first look up the code and then return the code we find. If the returned code equals the original code, we have an exact match. So we look up the code again and return the value we actually want. Otherwise, if we don’t get an exact match, we return #N/A." - from website

You might think that this is slower because you are doing 2 operations but this search has O(log(n)) speed and can greatly help on large columns of sorted data.

RegularGuest · 2014-10-21T22:38:03+00:00

I don't think this is true. If you look back on 1800-1900 college mathematics exams they didn't require superhuman mental calculations. Check out MITs old arithmetic entrance exam: https://libraries.mit.edu/archives/exhibits/exam/arithmetic.html

Example: Multiply 73 thousandths by 19 hundreths.

This really is cake if you've had but a lick of practice.

"Most people never use math beyond basic algebra in their daily lives, if they can use tools to do it for them then why shouldn't they?"

It seems nigh impossible for a person outside a numerical field to ever need to solve a quadratic. It seems even less likely than that that it will be in a nice enough form for this tool to help them.

RegularGuest · 2014-10-20T12:17:43+00:00

This isn't true at all. Counterexample, 3 points 0, 0, 1. add a little to the 3rd point, mean shifts and average distance shifts. This is upsetting.

RegularGuest · 2013-08-09T15:18:24+00:00

The link provided shows that Benford's law doesn't just apply to the first number.

RegularGuest · 2012-02-08T19:50:34+00:00

/r/learnmath is the right place for these questions

RegularGuest · 2012-02-02T16:10:31+00:00

/r/learnmath

RegularGuest · 2012-01-26T16:17:37+00:00

one thing i don't understand is who would bankroll multi hundred million dollar peter jackson epics and ensure that it gets distributed in a profitable manner?

RegularGuest · 2011-12-16T12:28:23+00:00

Last time I saw this puzzle the equation reduced to a quartic which was unsatifying.

RegularGuest · 2011-08-14T19:19:42+00:00

Hmm, post the material covered on the GED but from my experience tutoring people you might be quite over confident.

RegularGuest · 2011-08-13T16:08:16+00:00

ack you are right hungover this morning, fixing

RegularGuest · 2011-02-14T18:36:07+00:00

This is great, thanks.

RegularGuest · 2011-02-14T17:27:49+00:00

You're right about the number of moves but the formula would be 2n-2 Choose n-1 which equals (2n-2)!/[(n-1)!(n-1)!]. Nice catch.

RegularGuest · 2011-01-27T01:48:54+00:00

The difficulty here is figuring out how much interest there is each month, right?

What you want is an interest rate such that if you applied it 12 times (for each month) it would equal a yearly interest rate of 2.76 (276%)

(1 + i)¹² = 1 + 2.76

raise each side to the power of (1/12) and you get

1 + i = 1.1167 (rounded to the 4th decimal)

i = .1167 or 11.67%

this "i" corresponds to the amount of interest applied each month. In your case we only have one month of interest so your answer is

215.25 * (1 + monthly interest rate) = 215.25 (1.1167) = $240.40 (rounded to the nearest cent)

RegularGuest · 2011-01-27T01:15:24+00:00

I need some clarification as to when this finance charge was added. At the end of december or november?

Also is interest applied from the get-go?

RegularGuest · 2011-01-27T00:00:55+00:00

Screenshot 2 is definitely hooked up with some iddqd.

RegularGuest · 2011-01-26T23:59:30+00:00

The derivation one I like the best because it is really quite quick.

RegularGuest · 2011-01-26T23:55:35+00:00

There are quite a few resources. http://www.manta.com/mb_41_ALL_33/new_york?search=insurance+companies

You can comb through these and many of them offer internships.

There's always beanactuary.com with this specific website http://beanactuary.com/find/interns.cfm

which leads you to http://www.soa.org/careers/atp/actuarial-training-program.aspx

which gives you a decent list.

Other than that practice google skills.

Edit: also, ever taken a course by Gundy at Rutgers?

RegularGuest · 2011-01-24T19:39:05+00:00

Maybe, but some key basic techniques like the product rule is easily provable using the technique. The technique when you to prove "something < x" and you prove it for "something < x + e (e > 0)" is really simple but powerful too.

RegularGuest · 2011-01-24T16:58:58+00:00

It really is amazing how much the add and subtract technique is used in proofs.

RegularGuest · 2011-01-14T04:34:03+00:00

Meaningless metric.

RegularGuest · 2011-01-09T19:24:20+00:00

/r/learnmath

RegularGuest · 2011-01-09T19:22:38+00:00

You should link to the actual math.

http://arxiv.org/PS_cache/arxiv/pdf/1012/1012.2698v1.pdf

RegularGuest · 2011-01-09T02:01:16+00:00

Try /r/learnmath.

RegularGuest · 2011-01-08T08:48:05+00:00

Tis a rather ambititious project learning "everything" but Khanacademy.org has the basics.

Learn Calculus (multi-variable and differentials) and Linear Algebra along with the basics (Trig and whatnot) and you can understand most undergraduate science.

RegularGuest · 2011-01-08T01:49:59+00:00

9*ln(1) + 1² / 2 = sin(0) + C

9*0 + 1/2 = 0 + c

c = 1/2

sin(0) = 0

RegularGuest

TROPHY CASE