Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Browse Open Actuarial Jobs

Life  Health  Casualty  Pension  Entry Level  All Jobs  Salaries


Reply
 
Thread Tools Display Modes
  #11  
Old 08-02-2017, 02:29 PM
ALivelySedative's Avatar
ALivelySedative ALivelySedative is offline
Member
CAS
 
Join Date: Dec 2013
Location: Land of the Pine
College: UNC-Chapel Hill Alum
Favorite beer: Red Oak
Posts: 1,396
Default

speaking of god awful array functions, how would i replace a 'GROWTH' or 'TREND' array function with something less terrible that still gives exponential or linear predictors?
__________________
1/P | 2/FM | 3F/MFE | LC | ST |4/C | 5 | 6 || 7 | 8 | 9
VEE: Econ, Fin, Stat
OC1, OC2
COP
Reply With Quote
  #12  
Old 08-02-2017, 02:33 PM
MountainHawk's Avatar
MountainHawk MountainHawk is offline
Member
CAS AAA
 
Join Date: Dec 2001
Location: Salem, MA
Studying for Nothing!!!!
College: Lehigh University Alum
Favorite beer: Yuengling
Posts: 64,796
Default

Quote:
Originally Posted by ALivelySedative View Post
speaking of god awful array functions, how would i replace a 'GROWTH' or 'TREND' array function with something less terrible that still gives exponential or linear predictors?
Logest and linest.
__________________

Play in the AO Prediction Game now!



1
Reply With Quote
  #13  
Old 08-02-2017, 03:05 PM
ALivelySedative's Avatar
ALivelySedative ALivelySedative is offline
Member
CAS
 
Join Date: Dec 2013
Location: Land of the Pine
College: UNC-Chapel Hill Alum
Favorite beer: Red Oak
Posts: 1,396
Default

EDIT: nvm...google.
__________________
1/P | 2/FM | 3F/MFE | LC | ST |4/C | 5 | 6 || 7 | 8 | 9
VEE: Econ, Fin, Stat
OC1, OC2
COP

Last edited by ALivelySedative; 08-02-2017 at 03:18 PM..
Reply With Quote
  #14  
Old 08-04-2017, 10:33 AM
dumples dumples is offline
Member
CAS
 
Join Date: Sep 2003
Posts: 1,240
Default

Quote:
Originally Posted by MountainHawk View Post
Logest and linest.
If you use these as array functions you can get multiple parameters returned with one calculation cycle.
Reply With Quote
Reply

Tags
data, excel, finance, intern

Thread Tools
Display Modes

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 -4. The time now is 07:38 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.26631 seconds with 9 queries