Anyone good at Statistics?

[BTM]

Originally Posted by NYCGP

B's pants shrink when he sees statistics...

Mainly sabermetrics and econometrics but yes BONER

Someone bump the hangover at work thread....slight hangover rocking out too late to WMC sets last night

[Buegie]

Originally Posted by silvergray545

Ok, here's a more detailed post. I think I figured out the problem. You need to subtract 1 from the equation on excel to get the probability. But I still don't understand why I'm getting 1's, 0's and other weird numbers. Doing it by hand doesn't work either. The z scores are completely off the chart. I'll incude the case study and the work I've done.

I appreciate the responses guys. Thanks

the 0's and 1's aren't a bad thing, they aren't technically whole numbers, in reality they are something like .00000000001 or .9999999999, but excel just rounds because there is really no difference. When it returns 0 it means that there is basically a 0% chance of something occurring.

Ex. your fixed annuity would never return more than 20%, the std dev is tiny,so excel returns a 0 (E2). Also there is a 100% chance that it will return more than 5% so it displays a 1 in the cell (D2).

I would take another look at G, H, and I. You must have messed up a sign in the formula because your are essentially saying that all of the investments are likely to have a negative return. All of the probabilities are >75%. You need to subtract the values from 1 to get the answers.

You need to think these through, 99% chance of a t-bond losing >20% doesn't make sense (I4).

[silvergray545]

Originally Posted by BTM

Looks like you got this figured out. Zell is much better at statistics than I am...more of an occasional dorky hobby for me and took a fair amount in undergrad...but yea I've seen some of Zell's posts and he knows whats up.

Thanks for looking it over!

Originally Posted by Buegie

the 0's and 1's aren't a bad thing, they aren't technically whole numbers, in reality they are something like .00000000001 or .9999999999, but excel just rounds because there is really no difference. When it returns 0 it means that there is basically a 0% chance of something occurring.

Ex. your fixed annuity would never return more than 20%, the std dev is tiny,so excel returns a 0 (E2). Also there is a 100% chance that it will return more than 5% so it displays a 1 in the cell (D2).

I would take another look at G, H, and I. You must have messed up a sign in the formula because your are essentially saying that all of the investments are likely to have a negative return. All of the probabilities are >75%. You need to subtract the values from 1 to get the answers.

You need to think these through, 99% chance of a t-bond losing >20% doesn't make sense (I4).

It makes sense now!

I can't do anything about G because the X value I'm using is 0. But I corrected H and I. The probability of those two are much more realistic now. Putting it in words helped a lot! Thanks!

Now that part one is done, I have to move on to part two. But there isn't anything in the book or the powerpoints over part two. I'm guessing that I just need to make up my own problem and the solutions? My prof is fresh off the boat from Africa and it's his first semester teaching. I'm trying to cut him some slack but he's not doing a very good job of going over this stuff!

[BMWinNorthdakota]

Yesterday I had an 82% in my stats class....

Today I have a 68%


Fuck Stat exams......... GAAAAAA

[silvergray545]

Originally Posted by BMWinNorthdakota

Yesterday I had an 82% in my stats class....

Today I have a 68%


Fuck Stat exams......... GAAAAAA

I know dude they suck. But I think my prof knows he isn't that great because he is so new, he give his exams open note, open book. But they are still hard as hell! I got a 93% on my first exam and an 89% on my second exam.

I'll post up the correct answers to the case study after I get out of class.

[BMWinNorthdakota]

Originally Posted by silvergray545

I know dude they suck. But I think my prof knows he isn't that great because he is so new, he give his exams open note, open book. But they are still hard as hell! I got a 93% on my first exam and an 89% on my second exam.

I'll post up the correct answers to the case study after I get out of class.

FUUUUUU!!!!!

Not fair. Open book stats exam plzz

[vreihen16]

Originally Posted by 16HC

Brilliant! Have others do your homework! You are now at a bar right?

More like sleeping in a cardboard box, since this thread is 11 years old and was woken up by a spambot.....

[Hawkeye]

Originally Posted by silvergray545

Ok, here's a more detailed post. I think I figured out the problem. You need to subtract 1 from the equation on excel to get the probability. But I still don't understand why I'm getting 1's, 0's and other weird numbers. Doing it by hand doesn't work either. The z scores are completely off the chart. I'll incude the case study and the work I've done.

I appreciate the responses guys. Thanks

I really should have looked at the date stupid spam bots.

[3.0L]

Statics seem pretty easy to me. Consider rain. There is always a 50/50 chance of rain. It will either rain or it won't.

[19M5]

Originally Posted by vreihen16

More like sleeping in a cardboard box, since this thread is 11 years old and was woken up by a spambot.....

Brilliant! Spambots doing work of trolls!