ch1_estimating_parameter_values

Ch1_estimating_param - Estimating Parameter Values Example This handout shows an example how to estimate parameter values for the learning curve

This preview shows pages 1–2. Sign up to view the full content.

Estimating Parameter Values: Example This handout shows an example how to estimate parameter values for the learning curve. Type the following on an Excel spreadsheet in cells A3 to B13: Step 1: Compute logarithmic values We shall compute natural logarithms. Note that the choice between natural logarithm (base e ) and common logarithm (base 10) is related to the formula for parameter a . If common logarithm is used, the formula for a must be changed from what we use. The Excel function for natural logarithm is LN(). To get the natural logarithm of the number typed in cell A6, choose a cell, say A18 and enter the following formula: = LN(A6) Now, using copy and paste all the other natural logarithms may be obtained. The resulting values are shown below: Step 2: Compute the slope and intercept To get the slope and intercept, enter the following formula in two different cells, say B29 and B30: = INTERCEPT(B18:B25,A18:A25) = SLOPE(B18:B25,A18:A25) The resulting values are shown below: 1 A B

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/30/2008 for the course MGMTSC 73-331 taught by Professor Baki during the Summer '08 term at Windsor.

Page1 / 2

Ch1_estimating_param - Estimating Parameter Values Example This handout shows an example how to estimate parameter values for the learning curve

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online