I am unable to calculate value of b and t in survival of vehicle queations.

prativa gautam
prativa gautam used Ask the Experts™
on
How to calculate single value of b and t from the plot of multiple points in vehicle questions
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SteveCost Accountant
Top Expert 2012

Commented:
Could you provide a lttile more information...
Maybe some sample data?

if b and t are intercept and gradient functions then LINEST in Excel will allow for calculation by the least squares method.
Then PEARSON can be used to determine the accuracy of the LINEST result.

But to give an accurate answer we will require a little more information to get us started.

Thanks,
Steve.

Author

Commented:
Thanks for your cooperation sir.
I will provide the sample data.
Book1.xlsx
Cost Accountant
Top Expert 2012
Commented:
Attached is a file with some rough analysis.

But without an understanding of 'b' or 't' it is not possible to answer the question from the information provided.

Maybe the file will be of assistance, or maybe not.

But without more information on the question, such as what b and t are, this is as much of an answer as can be provided.

ATB
Steve.
Book1-R.xlsx
TracyVBA Developer

Commented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Steve (https:#a42411659)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

broomee9
Experts-Exchange Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial