https://www.reliawiki.com/index.php?action=history&feed=atom&title=Perform_Life_Data_Analysis_on_External_Data_Source%2FVBA 2026-04-09T01:51:54Z Revision history for this page on the wiki MediaWiki 1.44.0 https://www.reliawiki.com/index.php?title=Perform_Life_Data_Analysis_on_External_Data_Source/VBA&diff=64727&oldid=prev 2016-09-07T15:28:04Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:28, 7 September 2016</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>{{Template:API}}</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">{{DISPLAYTITLE:Perform Life Data Analysis/VBA}}</ins>{{Template:API}}</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Tutorial: Life Data Analysis==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Tutorial: Life Data Analysis==</div></td></tr> </table>

Kate Racaza https://www.reliawiki.com/index.php?title=Perform_Life_Data_Analysis_on_External_Data_Source/VBA&diff=64725&oldid=prev 2016-09-07T15:26:00Z

<p>Created page with &#039;{{Template:API}} ==Tutorial: Life Data Analysis== Below is the VBA version of the <a href="/index.php/Perform_Life_Data_Analysis_on_External_Data_Source" title="Perform Life Data Analysis on External Data Source">tutorial</a>. &#039;&#039;&#039;VBA&#039;&#039;&#039; {{APIPrefix|Sub…&#039;</p> <p><b>New page</b></p><div>{{Template:API}}<br /> <br /> ==Tutorial: Life Data Analysis==<br /> Below is the VBA version of the [[Perform_Life_Data_Analysis_on_External_Data_Source|tutorial]].<br /> <br /> &#039;&#039;&#039;VBA&#039;&#039;&#039;<br /> <br /> {{APIPrefix|Sub}} Main()<br /> <br /> {{APIComment|&#039;Declare a new WeibullDataSet object.}} <br /> {{APIPrefix|Dim}} WDS {{APIPrefix|As New}} WeibullDataSet<br /> <br /> {{APIComment|&#039;Add the failure times to the data set.}}<br /> {{APIPrefix|Call}} WDS.AddFailure(16, 1)<br /> {{APIPrefix|Call}} WDS.AddFailure(34, 1)<br /> {{APIPrefix|Call}} WDS.AddFailure(53, 1) <br /> {{APIPrefix|Call}} WDS.AddFailure(75, 1)<br /> {{APIPrefix|Call}} WDS.AddFailure(93, 1)<br /> <br /> {{APIComment|&#039;Add the suspensions to the data set.}}<br /> {{APIPrefix|Call}} WDS.AddSuspension(120, 5) <br /> <br /> {{APIComment|&#039;Use the 2-parameter Weibull distribution and the rank regression on X (RRX) analysis method.}}<br /> {{APIComment|&#039;Keep all other analysis settings at default.}}<br /> WDS.AnalysisSettings.Distribution = WeibullSolverDistribution_Weibull<br /> WDS.AnalysisSettings.Parameters = WeibullSolverNumParameters_MS_2Parameter<br /> WDS.AnalysisSettings.Analysis = WeibullSolverMethod_RRX<br /> <br /> {{APIComment|&#039;Analyze the data set.}}<br /> {{APIPrefix|Call}} WDS.Calculate()<br /> <br /> {{APIComment|&#039;Calculate the probability of failure at 226 hrs and display the result.}}<br /> {{APIPrefix|Dim}} r {{APIPrefix|As}} Double<br /> r = WDS.FittedModel.unreliability(226)<br /> MsgBox({{APIString|&quot;Prob. Fail: &quot;}} &amp; r)<br /> <br /> {{APIPrefix|End Sub}}</div>

Kate Racaza