Finance/Excel Nerds? - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

Finance/Excel Nerds?

Moderator: Baseball Moderators

Finance/Excel Nerds?

Postby cafe_58 » Fri Oct 22, 2004 8:32 pm

I have this horrible finance assignment to do. It's estimating Beta's (don't worry about it if you don't understand what it is). My problem is that I don't know how to make graphs on excel. I've done most of the important stuff in excel, I just don't know how to graph it. If any knows how I could do it, it'll be a great help! I have to hand it in tomorrow morning, so the sooner you could post up some advice the better.................thanks! :-)
cafe_58
Minor League Mentor
Minor League Mentor

User avatar

Posts: 956
Joined: 28 May 2004
Home Cafe: Baseball
Location: You can find me in da dome, chillin wit Jarome.......

Postby Amazinz » Fri Oct 22, 2004 8:47 pm

I have little experience with finance other than my personal budget so I can't help you with specifics but making graphs in Excel is pretty easy. Just Insert->Chart from the menu or down on the sheet tabs and a wizard will walk you through it. They aren't that tough but the ones I make are usually pretty simplistic.
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby Madison » Fri Oct 22, 2004 8:59 pm

Nothing like waiting until the last minute. :-b

Good luck! :-o
Yes doctor, I am sick.
Sick of those who are spineless.
Sick of those who feel self-entitled.
Sick of those who are hypocrites.
Yes doctor, an army is forming.
Yes doctor, there will be a war.
Yes doctor, there will be blood.....
Madison
Mod in Retirement
Mod in Retirement

User avatar
ExecutiveEditorCafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterInnovative MemberCafe MusketeerPick 3 ChampionMatchup Meltdown SurvivorLucky Ladders Weekly Winner
Posts: 53856
(Past Year: 1)
Joined: 29 Apr 2003
Home Cafe: Baseball
Location: Taking Souls...

Postby cafe_58 » Fri Oct 22, 2004 9:06 pm

Thanks Amazinz..... that seems to be what I need. But, after making a scatter plot I still need to put a line-of-best-fit............hrmmmmm...... i'll keep at it.

Thanks alot Amazinz! ;-D
cafe_58
Minor League Mentor
Minor League Mentor

User avatar

Posts: 956
Joined: 28 May 2004
Home Cafe: Baseball
Location: You can find me in da dome, chillin wit Jarome.......

Postby JTWood » Fri Oct 22, 2004 10:42 pm

If you want to e-mail me the docs, I can take a look at it and see what I can do to get you going in the right direction. I've taken the class it sounds like you're taken, so I think I should be able to help.

Just PM me if you want some help, and I'll PM you my e-mail address.

;-D
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Postby Baseballer02 » Fri Oct 22, 2004 10:43 pm

cafe_58 wrote:Thanks Amazinz..... that seems to be what I need. But, after making a scatter plot I still need to put a line-of-best-fit............hrmmmmm...... i'll keep at it.

Thanks alot Amazinz! ;-D


If you have a TI graphing calc, you can get the line of best fit from that. And then just put the given function into the Excel chart.
Baseballer02
Major League Manager
Major League Manager

User avatar
Sweet 16 Survivor
Posts: 2006
Joined: 27 Jun 2003
Home Cafe: Baseball
Location: Pitching from the left side.

Postby SaintsOfTheDiamond » Fri Oct 22, 2004 10:52 pm

cafe_58 wrote:Thanks Amazinz..... that seems to be what I need. But, after making a scatter plot I still need to put a line-of-best-fit............hrmmmmm...... i'll keep at it.

Thanks alot Amazinz! ;-D


I know it can be done, I just did it the other day for some physics lab report, but I can't remember how. Big help huh? :-° Or just do what Baseballer said. :-D
Image
Member #4 of the Inaugural Yadier Molina Fan Club!!!
SaintsOfTheDiamond
Hall of Fame Hero
Hall of Fame Hero

Fantasy ExpertCafe WriterCafe Ranker
Posts: 6480
Joined: 6 May 2004
Home Cafe: Baseball
Location: Swiping second

Postby JTWood » Fri Oct 22, 2004 10:57 pm

SaintsOfTheDiamond wrote:
cafe_58 wrote:Thanks Amazinz..... that seems to be what I need. But, after making a scatter plot I still need to put a line-of-best-fit............hrmmmmm...... i'll keep at it.

Thanks alot Amazinz! ;-D


I know it can be done, I just did it the other day for some physics lab report, but I can't remember how. Big help huh? :-° Or just do what Baseballer said. :-D

Wow...

8-o

That was a worthless post. Are you trying to run up your post count? Who do you think you are? Madison?

:-b
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Postby Madison » Fri Oct 22, 2004 11:03 pm

JTWood wrote:Just PM me if you want some help, and I'll PM you my e-mail address.


You do realize that your email address is availiable by clicking the little "email" button at the bottom of your posts, right? :-o

JTWood wrote:That was a worthless post. Are you trying to run up your post count? Who do you think you are? Madison?


I'm not anywhere near as bad as Rico.

B-)
Yes doctor, I am sick.
Sick of those who are spineless.
Sick of those who feel self-entitled.
Sick of those who are hypocrites.
Yes doctor, an army is forming.
Yes doctor, there will be a war.
Yes doctor, there will be blood.....
Madison
Mod in Retirement
Mod in Retirement

User avatar
ExecutiveEditorCafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe SpotterInnovative MemberCafe MusketeerPick 3 ChampionMatchup Meltdown SurvivorLucky Ladders Weekly Winner
Posts: 53856
(Past Year: 1)
Joined: 29 Apr 2003
Home Cafe: Baseball
Location: Taking Souls...

Postby JTWood » Fri Oct 22, 2004 11:04 pm

Madison wrote:
JTWood wrote:Just PM me if you want some help, and I'll PM you my e-mail address.


You do realize that your email address is availiable by clicking the little "email" button at the bottom of your posts, right? :-o

The one that's not there?

:-?
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Next

Return to General Talk

Who is online

Users browsing this forum: No registered users and 4 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Monday, Sep. 22
(All times are EST, weather icons show forecast for game time)

Kansas City at Cleveland
(7:05 pm)
Baltimore at NY Yankees
(7:05 pm)
Seattle at Toronto
(7:07 pm)
Chi White Sox at Detroit
(7:08 pm)
Pittsburgh at Atlanta
(7:10 pm)
St. Louis at Chi Cubs
(8:05 pm)
Houston at Texas
(8:05 pm)

Sunday, Aug. 31

Cleveland at Cody
(8:07 pm)
indoors

Monday, Sep. 22

Arizona at Minnesota
(8:10 pm)
LA Angels at Oakland
(10:05 pm)
San Francisco at LA Dodgers
(10:10 pm)
Colorado at San Diego
(10:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact