#### Weibull function in Excel

I have a survival dataset (see below). I want to fit to Weibull function
S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and
gamma=2.32. If I use a method tranforming probability to Ln(Ln(1/S(t)) which
will be a linear function of Ln (t). But I got a different alpha and gamma.
When I compared two alphas adn gammas, the Solver results had a better
goodness of fit. What is the problem? THanks

Month      Probability of survival
0	1
1	1
2	0.92
3	0.90
4	0.88
5	0.83
6	0.76
7	0.74
8	0.69
9	0.57
10	0.48
11	0.39
12	0.27
13	0.27
14	0.13

 0
Utf
6/5/2010 1:44:21 AM
excel.worksheet.functions 4936 articles. 2 followers.

3 Replies
2637 Views

Similar Articles

[PageSpeed] 29

Barbo  -

> What is the problem? <

There is no problem. You should expect a difference.

Your Solver method (which I prefer) minimizes sum of squared deviations
between actual S and fitted S.

The other method uses transformed values, so it does not yield a better fit.

(Excel's trendline features use transformations to fit the logarithmic,
power, and exponential functions. The approach appears to be a computational
convenience. Better fits are obtained using Solver.)

-  Mike
http://www.MikeMiddleton.com
Mike@DecisionToolworks.com

"Barbo" <Barbo@discussions.microsoft.com> wrote in message
news:CFCE454F-D077-4526-BFE5-66902FFE0A12@microsoft.com...
> I have a survival dataset (see below). I want to fit to Weibull function
> S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and
> gamma=2.32. If I use a method tranforming probability to Ln(Ln(1/S(t))
> which
> will be a linear function of Ln (t). But I got a different alpha and
> gamma.
> When I compared two alphas adn gammas, the Solver results had a better
> goodness of fit. What is the problem? THanks
>
> Month      Probability of survival
> 0 1
> 1 1
> 2 0.92
> 3 0.90
> 4 0.88
> 5 0.83
> 6 0.76
> 7 0.74
> 8 0.69
> 9 0.57
> 10 0.48
> 11 0.39
> 12 0.27
> 13 0.27
> 14 0.13
>
 0
Mike
6/5/2010 3:36:07 AM
Hi Mike, thanks for the reply. So if I want to find a function with best fit,
adding a trendline is not an proper method.

I got the weibull function estimates from someone else and then try to
replicate the results in Excel. When I used Solver, most of the time I can
get the parameter estimates with the best fit. I was told there is no
feasible solution. How to properly use Solver? Thanks

Barbo

"Mike Middleton" wrote:

> Barbo  -
>
> > What is the problem? <
>
> There is no problem. You should expect a difference.
>
> Your Solver method (which I prefer) minimizes sum of squared deviations
> between actual S and fitted S.
>
> The other method uses transformed values, so it does not yield a better fit.
>
> (Excel's trendline features use transformations to fit the logarithmic,
> power, and exponential functions. The approach appears to be a computational
> convenience. Better fits are obtained using Solver.)
>
> -  Mike
> http://www.MikeMiddleton.com
> Mike@DecisionToolworks.com
>
>
> "Barbo" <Barbo@discussions.microsoft.com> wrote in message
> news:CFCE454F-D077-4526-BFE5-66902FFE0A12@microsoft.com...
> > I have a survival dataset (see below). I want to fit to Weibull function
> > S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and
> > gamma=2.32. If I use a method tranforming probability to Ln(Ln(1/S(t))
> > which
> > will be a linear function of Ln (t). But I got a different alpha and
> > gamma.
> > When I compared two alphas adn gammas, the Solver results had a better
> > goodness of fit. What is the problem? THanks
> >
> > Month      Probability of survival
> > 0 1
> > 1 1
> > 2 0.92
> > 3 0.90
> > 4 0.88
> > 5 0.83
> > 6 0.76
> > 7 0.74
> > 8 0.69
> > 9 0.57
> > 10 0.48
> > 11 0.39
> > 12 0.27
> > 13 0.27
> > 14 0.13
> >
> .
>
 0
Utf
6/5/2010 1:51:03 PM
Barbo  -

> How to properly use Solver? <

Solver's success with nonlinear functions may depend on the initial values
for the changing cells.

For simple functions, like the Weibull, you may have some idea of reasonable
initial values.

-  Mike
http://www.MikeMiddleton.com
Mike@DecisionToolworks.com

"Barbo" <Barbo@discussions.microsoft.com> wrote in message
news:BD2F239D-B24A-49BD-9274-B09576D1F741@microsoft.com...
> Hi Mike, thanks for the reply. So if I want to find a function with best
> fit,
> adding a trendline is not an proper method.
>
> I got the weibull function estimates from someone else and then try to
> replicate the results in Excel. When I used Solver, most of the time I can
> get the parameter estimates with the best fit. I was told there is no
> feasible solution. How to properly use Solver? Thanks
>
> Barbo
>
>
> "Mike Middleton" wrote:
>
>> Barbo  -
>>
>> > What is the problem? <
>>
>> There is no problem. You should expect a difference.
>>
>> Your Solver method (which I prefer) minimizes sum of squared deviations
>> between actual S and fitted S.
>>
>> The other method uses transformed values, so it does not yield a better
>> fit.
>>
>> (Excel's trendline features use transformations to fit the logarithmic,
>> power, and exponential functions. The approach appears to be a
>> computational
>> convenience. Better fits are obtained using Solver.)
>>
>> -  Mike
>> http://www.MikeMiddleton.com
>> Mike@DecisionToolworks.com
>>
>>
>> "Barbo" <Barbo@discussions.microsoft.com> wrote in message
>> news:CFCE454F-D077-4526-BFE5-66902FFE0A12@microsoft.com...
>> > I have a survival dataset (see below). I want to fit to Weibull
>> > function
>> > S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and
>> > gamma=2.32. If I use a method tranforming probability to Ln(Ln(1/S(t))
>> > which
>> > will be a linear function of Ln (t). But I got a different alpha and
>> > gamma.
>> > When I compared two alphas adn gammas, the Solver results had a better
>> > goodness of fit. What is the problem? THanks
>> >
>> > Month      Probability of survival
>> > 0 1
>> > 1 1
>> > 2 0.92
>> > 3 0.90
>> > 4 0.88
>> > 5 0.83
>> > 6 0.76
>> > 7 0.74
>> > 8 0.69
>> > 9 0.57
>> > 10 0.48
>> > 11 0.39
>> > 12 0.27
>> > 13 0.27
>> > 14 0.13
>> >
>> .
>>
 0
Mike
6/5/2010 11:19:02 PM

Similar Artilces:

Disable COPY function
Does anyone know how can I avoid/restrict people Copying-n- pasting data from my excel spread-sheet. I am trying to lock down an excel spread-sheet to "Read Only" - in its true sense and dis-allow even copying data from this sheet to any other. Basically I want to turn off the COPY function. Secondly, if a person saves this sheet locally under another file name, how would I still disallow the COPY function. Is there any VBA module (which I can later password protect) which takes care of this. I do not have admin rights to set folder/file server permissions and the hiararch...

Excel 2000 problem #2
I have a problem on a file that was recived via e-mail, when i try to open it on excel 2000 it gives me the following error "The workbook you opened contains automatic links to information on another workbook, do you want to update this workbook to changes made to the other workbook" it then gives me the option to ""update all linked information" or to "keep the existing information Hi Chose the option to keep the existing information. That will have the data at the time the file was sent to you. If you need to have the information updated, you will need t...

Calculating turaround time using IF function
I'm just learning to use the IF function, and it is not calculating correctly, so am looking for help. I'm using Excel 2000. For my spreadsheet, if a document is made available after 1700 hours or before 0700 hours the following day, I want it to calculate the turnaround time for those reports to begin at 0700 hours; otherwise calculate the remainder of the reports from the time the report became available to completion. Here's the IF statement I'm attempting to use with little success. E=Time report available I=Finish time =IF(OR(E>"17:00:00",E&l...

Excel Searching
Searching in excel What is the best program or way to search in excel? (other than using simple find) I'd like to be able to see all of the results in one area and then click on to jump to it. Is there anything out there that has search function that is smarter than "find." Like a "google" typ search. I need to be able to search multiple sheets at once. Thanks -- Message posted from http://www.ExcelForum.com xl2002 added an option to find in workbook. in xl2k, you could group your worksheets and do edit|find. But in all versions, you can use Jan Karel Pieterse&...

excel trying to add rows +col
am trying to add rows and clumnes of fig for end of year accounts, am clicking sum, highlighting the row hit return then nothing am i missing some thing Try selecting (highlighting) and then click the auto sum icon -- Don Guillett SalesAid Software dguillett1@austin.rr.com "mowerman" <mowerman@discussions.microsoft.com> wrote in message news:417B9C47-E58E-4A69-9946-EC349684D199@microsoft.com... > am trying to add rows and clumnes of fig for end of year accounts, > am clicking sum, highlighting the row hit return then nothing am i missing > some thing ...

How to call a non static function from a static function
Hi I need to go to a non static function from a static function?can anybody suggest me how to do it?any kind of help will be greatly appreciated. You need to pass the object whose function you want to call. static void s_foo( A* a ); class A{ public: A(); ~A(); void funcA(); }; main() { ... A a; s_foo(&a); } static void s_foo( A* a ) { a->funcA(); } -Seetharam ...

Embedded excel worksheets in word
Since Office v. X I have been unable to embed excel worksheets in word that contain more than five columns. Can anyone tell me that I have been doing something wrong OR tell me if 2004 fixes this problem? Thanks, Mike in article BCD52774.75C7%mcgetrick@lfoconnell.com, Mike McGetrick at mcgetrick@lfoconnell.com wrote on 22/05/04 21:51: > Since Office v. X I have been unable to embed excel worksheets in word that > contain more than five columns. Can anyone tell me that I have been doing > something wrong OR tell me if 2004 fixes this problem? > > Thanks, > Mike > A...

Importing web data to Excel 2003
I have built a flight planning program for aviation using Excel 2003. I am trying to find a function to import winds aloft from NavCanada's aviation weather site, to avoid manual entries. Is there a web site where raw text data from NavCanada's site to import, or a way to import it from their normal web display? Below there is a link to NavCanada's normal display of data. http://www.flightplanning.navcanada.ca/cgi-bin/Fore-obs/fd.cgi Any help would be appreciated. thanks I get an access denied on your URL................no permission. But have you tried Dat...

Why Excel 2007 not responding after saving
I have reinstalled Excel 2007 (Office Home & Student) but it is worse. Now having problems even opening files. If I click on a cell it pauses for ages and then says it is not responding. Try looking for help here: http://support.microsoft.com/?scid=ph;en-gb;8753#tab3 "Xandersmum" wrote: > I have reinstalled Excel 2007 (Office Home & Student) but it is worse. Now > having problems even opening files. If I click on a cell it pauses for ages > and then says it is not responding. ...

Importing from Excel
Hello, does Money have the ability to create invoices by importing from Excel? I don't think it does, perhaps I am missing something. Thanks in advance! ...

I'm making a payroll journal, it has a column for the names, and the the cheque amt, cheque no., and some other stuff. In a separate sheet I need to pull up individual information pe employee and total. Eg. Payroll Journal: Name: cheque amt: cheque no: date: jane doe 2000.00 0001 01/01/01 john doe 1500.00 0002 01/01/01 jane doe 1800.00 0003 15/01/01 Employee Details: Name: cheque amt: cheque no: date: jane doe 2000.00 0001 0...

How to work with CSV files in Excel without warnings?
We work with a lot of CSV files in Excel and would like to turn off the warning that the file "may contain features that are incompatible..". Is it possible to allow saving a CSV file without warnings? Thanks, Sam ------------------------------------------------------------ We're hiring! B-Line Medical is seeking .NET Developers for exciting positions in medical product development in MD/DC. Work with a variety of technologies in a relaxed team environment. See ads on Dice.com. Sam, You could use a macro: Sub TryNow() Dim myFName As String myFName = Application.GetSaveA...

Excel Cell Autocomplete
Is there any function, so we can use auto complete while entering similar entry in to cell, which saves lot's time when entering similar data. DEFAULT AUTO COMPLETE WORKS VERY LIMITED, WILL NOT WORK IF SEQUENCE WILL BREAK, ALSO FOR NUMBERS (A/C) IS NOT WORKING. I have tried with alt+down arrow, but it's giving entry which below of that cell...better if we have some thing to lookup which can shows us all entry in to that column( up & below). -- smd111 ------------------------------------------------------------------------ smd111's Profile: http://www.excelforum.com/member...

sum function 04-18-10
Hi, How can I sum the numbers in a column in Excel where some numbers carry a "<" sign in front of them (such as <1) and I want to include numbers such "<1" in calculation as "1". For Example if numbers are entered as follows 0.5 <1 0.5 I would like to value to be returned as "2" when I apply "sum" function. Thanks =SUM(IF(LEFT(A2:A4)="<",--RIGHT(A2:A4,LEN(A2:A4)-1),A2:A4)) as an array formula (Control Shift Enter). -- David Biddulph "Vijay Dhawan" <Vijay Dhawan@discussions...

excel files will not open
I cannot open my excel files without first opening excel. I have tried going through properties to make sure it is opening with the right program and it is. Any other thoughts. I had a similar problem a while back, had to reinstall office. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6261 View this thread: http://www.excelforum.com/showthread.php?threadid=496750 Sometimes one of these works: Tools|Options|General|Ignore other applications (unch...

How do you stop excel from charting empty cells/null values as zer
I'm trying to create several charts from my excel data. Several of the chart's reference cell (established range) contains formuals. When the cell's formula returns a null value, chart display's as zero. How do I setup chart to display null as nothing versus zero? The workaround for charting calculated cells when you may have missing data is to use an If formula that selects NA() if there is missing data. Something like -- = If( d2 = "", NA(), b2*d2) You'll need to replace your actual cell references and formula. This formula will place a #N/A in tho...

function
The function is as follows: =IF(SMALL(C6:V6,2)="#NUM!","",SMALL(C6:V6,2)) Explanation Purpose: Try to compare a series of numbers, finding out the second smallest number. If: The answer is error (ie #NUM!) since there is no number in the row Then: show nothing (ie "") Else: show the answer as usual ** Problem ** However this function doesn't work. When there is an error, it will show as #NUM! instead of nothing (ie ""). How to solve? Thanks. -- Additional information: - I'm using Office XP - I'm using Windows XP maybe: =IF(ISERROR(...

CRM Functionality does not appear in Outlook
Hi all... Hope someone can help here - I am a non-technie looking after the install of CRM for a small sales organisation. I have succesfully installed the outlook client on all laptops but on 1 desktop I am getting a problem. I have installed all pre-requisites and passed all pre-install checks, and the installation appears to go smoothly. However, the additional functionality does not appear in outlook. No error codes are generated so I can't be more specific than this I'm afraid, any ideas would be greatly appreciated. Cheers Holmesy in outlook go to tools options..then get t...

SumIf Function #3
I'm trying to use the SumIf Function (as I understand its use) and I keep running into the same problems -- in many cases I have more than one criterion for addind a specific cell. Is there a way to modify SumIf to allow for multiple criteria? I try to do it in the insert function box and it gets spit back out at me. Any ideas? Jay Jay look at SUMPRODUCT Look at the Help and search the Archives for examples Regards Trevor "jayceejay" <jayceejay@discussions.microsoft.com> wrote in message news:39CB49F6-4459-4A4B-8856-E3E8BE615FFB@microsoft.com... > I'm...

EXCEL.exe
I can not open excel get dr watson err. but if I login admin it work. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements See the suggestions at www.cpearson.com/excel/startuperrors.htm , specifically the one about removing the customized toolbar file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "slukas" <...

working with excel and other program
hi, We basically feed the data in excel sheet from other application (business objects) . The data that we enter is purely numbers. however we need to move up and down between two applications. To move in Business objects i have to click in the application and then agin to enter that data in excel i have to click in excel sheet.............we enter huge amout of data and this is time consuming. could u please let me know if it is possible to move in both the application without clicking . In other words can we have two application active at the same time, may be in mouse hover can...

Excel graph
How do I create a line graph showing the means and standard deviations for a series of measures. I would like the line to connect the mean scores, and have an error variance bar above & below each mean to show the sd. ...

Consistent function of Utilities logon screen when applying hotfix
When our users attempt to install a hotfix roll-up, when they are logging into Dynamic Utilities for the first time, the user interface is very touchy. What I mean is that they must click the username field and then type. Then, they must use the mouse again to click the password field and type. Then, they must click the OK button. If they try to use backspace, enter key, tab key, etc., extra characters are inserted. The only way that they can "edit" their username and password information during logon is to use the mouse to highlight and the type over the information. ...

Conditional Formatting in Excel Help Please.....
Newbie to VBA I need to use Conditional Formatting to format a range of cells to have Wheat background and Red text (Bold) if a text string is contained in each cell. For example, all cells in a range that contain the text string "LLC" or "Inc" or "Corp" or "Corporation" or "Company" , etc. If cell E2 contains Acme, LLC I need to give that cell (E2) the condition formatting If cell E3 contains John Brown That cell does not get the condition formatting If cell E4 contains Joe's Pool Hall, Inc Cell E4 gets the condition formatting Thanks ...

IF Function Problem
Hello All, I am using Office XP and have the following problem I have a worksheet which uses lookup to extract names from range name Codes as follows Col O=IF(ISNA(VLOOKUP(D2,CODES,6,FALSE)),"",(VLOOKUP(D2,CODES,6,FALSE))) I wish to add another IF condition to the above formula to test that: If Col D2 = EGSP AND Col A = date greater than or equal to 15-Nov-2005 then it should display the name as 'Jack' otherwise 'James'. All other values should remain unchanged Thanks a lot Rashid =IF(D2="EGSP",IF(A2>=--"2005-11-15","Jack",&q...