Can I please have the excel formula for this question! badly need help please!

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Can I please have the excel formula for this question! badly need help please!

Post by answerhappygod »

Can I please have the excel formula for this question! badly
need help please!
Can I Please Have The Excel Formula For This Question Badly Need Help Please 1
Can I Please Have The Excel Formula For This Question Badly Need Help Please 1 (56.37 KiB) Viewed 10 times
Question 5 - 25 marks The reliability of 500 components was measured over a total time interval of 1000 hours. At the beginning of the interval all components were working to specification. The cumulative number of failures were noted at the times indicated in the table below. Timet (hrs) 0 200 500 550 750 800 900 910 920 930 940 950 960 1000 Cumulative total of failures, n 0 20 40 100 350 380 460 470 478 480 481 482 483 485 Determine 1) Unreliability F and Reliability Rat each time interval 2) Plot R vst, note plot talong x-axis 3) Determine 8.7 and model the data using Weibull model by. a. Calculate and plot Inln(1/(1-F)] and Int and determine constants B and ŋ b. Calculate Rſwei) and plot R[wei) vst, on the same graph in 2) 4) Comment whether the original trend follows early-life failure, constant rate (normal-life) failure or wear-out failure.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply