New 2009 2010 BMW Z4 - ZPOST
BMW Garage BMW Meets Register Search Today's Posts Mark Forums Read


Go Back   New 2009 2010 BMW Z4 - ZPOST > BIMMERPOST Universal Forums > Off-Topic Discussions Board

Post Reply
 
Thread Tools Search this Thread
      03-31-2011, 08:04 AM   #23
BTM
Banned
United_States
479
Rep
10,309
Posts

Drives: A///MERICAN!!!
Join Date: Mar 2010
Location: A///MERICA!!!

iTrader: (11)

Garage List
Quote:
Originally Posted by NYCGP View Post
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
Appreciate 0
      03-31-2011, 11:20 AM   #24
Buegie
Captain
Buegie's Avatar
United_States
48
Rep
714
Posts

Drives: 330xi
Join Date: Feb 2008
Location: CT/DC

iTrader: (2)

Quote:
Originally Posted by silvergray545 View Post
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).
__________________
Black Dakota | Aluminum | Sport | Premium | Cold | iDrive | CA
Appreciate 0
      03-31-2011, 12:40 PM   #25
silvergray545
Skittles, OT OG
silvergray545's Avatar
Lebanon
2337
Rep
649
Posts

Drives: Lots of M cars
Join Date: Aug 2008
Location: Cleveland, OH

iTrader: (1)

Garage List
2016 BMW M3 ZCP  [0.00]
2000 BMW M Roadster  [0.00]
2004 BMW M3  [0.00]
2014 VW GLI  [0.00]
Quote:
Originally Posted by BTM View Post
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!
Quote:
Originally Posted by Buegie View Post
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!
Appreciate 0
      03-31-2011, 12:45 PM   #26
BMWinNorthdakota
Banned
242
Rep
1,106
Posts

Drives: 2007 bmw 335i e90
Join Date: Jun 2009
Location: Fargo ND

iTrader: (0)

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

Today I have a 68%


Fuck Stat exams......... GAAAAAA
Appreciate 0
      03-31-2011, 04:07 PM   #27
silvergray545
Skittles, OT OG
silvergray545's Avatar
Lebanon
2337
Rep
649
Posts

Drives: Lots of M cars
Join Date: Aug 2008
Location: Cleveland, OH

iTrader: (1)

Garage List
2016 BMW M3 ZCP  [0.00]
2000 BMW M Roadster  [0.00]
2004 BMW M3  [0.00]
2014 VW GLI  [0.00]
Quote:
Originally Posted by BMWinNorthdakota View Post
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.
Appreciate 0
      03-31-2011, 04:40 PM   #28
BMWinNorthdakota
Banned
242
Rep
1,106
Posts

Drives: 2007 bmw 335i e90
Join Date: Jun 2009
Location: Fargo ND

iTrader: (0)

Quote:
Originally Posted by silvergray545 View Post
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
Appreciate 0
      01-19-2022, 08:05 AM   #29
vreihen16
Recovering Perfectionist
vreihen16's Avatar
Ukraine
14906
Rep
938
Posts

Drives: 2015 BMW i3 BEV
Join Date: Jun 2019
Location: Orange County, NY

iTrader: (0)

Garage List
Quote:
Originally Posted by 16HC View Post
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.....
__________________
2015 BMW i3 BEV, Giga World (Lodge interior), Tech/Driving Assist Packages, 30K miles
Appreciate 1
cmyx6go15581.00
      01-19-2022, 09:37 AM   #30
Hawkeye
Brigadier General
Hawkeye's Avatar
No_Country
2070
Rep
4,365
Posts

Drives: '07 Z4 Coupe, '21 X3, '16 GMC
Join Date: Aug 2007
Location: Iowa

iTrader: (0)

Garage List
Quote:
Originally Posted by silvergray545 View Post
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.
__________________
2007 Z4 3.0si Coupe • 6 MT • Black Saphire Metallic • PP • SP
2016 GMC Sierra SLT Z71 Premium Plus 4x4
2017 Harley StreetGlide • Denim Black • V&H Tune
2021 BMW x30i • Phytonic Blue Metallic • Fully loaded
Appreciate 1
vreihen1614906.00
      01-19-2022, 10:01 AM   #31
3.0L
Colonel
3.0L's Avatar
8904
Rep
2,011
Posts

Drives: M235i, 20k miles
Join Date: Apr 2014
Location: California

iTrader: (0)

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.
__________________
///M235i | Mineral Grey Metallic | Premium Package | Technology Package | Driver Assistance Package | Dakota Coral Red/Black Leather | Harman/Kardon Premium 360 watt sound system | 8-speed automatic

When writing your life's plan, use a pencil with an eraser
Appreciate 1
vreihen1614906.00
      01-19-2022, 10:32 PM   #32
19M5
Private
United_States
40
Rep
52
Posts

Drives: 2019 BMW M5
Join Date: Dec 2019
Location: Nevada

iTrader: (0)

Quote:
Originally Posted by vreihen16 View Post
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!
__________________
2019 BMW M5

2016 Dodge Charger HC
2005 E55 AMG Wagon
Appreciate 1
vreihen1614906.00
Post Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -5. The time now is 07:16 AM.




zpost
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST