Business Data Analytics Using Excel by Dr. A N sah

Business Data Analytics Using Excel by Dr. A N sah

Author:Dr. A N sah [sah, Dr. A N]
Language: eng
Format: epub
Publisher: UNKNOWN
Published: 2017-01-10T08:00:00+00:00


Y 

1 2

1 Xeu (4.27)2 Where Y = output

X1 = labour

X2 = capital

e = base of natural logarithm

u = error term

α, β1and β2 are parameters of the model

Model (4.21) is non-linear and can not be estimated in its original form. We can make it linear by logarithmic transformation as:

In(Y) = In (α) +β1In(X1) +β2In(X2) +μ (4.28) The model (4.22) is linear in parameters α, β1and β2 and is estimated by OLS method. Three important points to ne noted here regarding Cobb-Douglas production function:

a)1 is the elasticity of output with respect to labour, assuming capital as constant

b)2is the elasticity of output with respect to capital, assuming labour as constant.

c) ( 2 ) tells us about the returns to scale. If the sum of ( 2 )1 1 equals to 1, then output follows constant returns to scale. In other words, when labour and capital both increases by 5%, output will also increases by 5%. If the sum is less than 1, that means, there are decreasing returns to scale. A 5% increase in inputs will give less than 5% increase in output.

To illustrate Cobb-Douglas production function, we collected data relating to output, labour input and capital input of National Thermal Power Corporation (NTPC) as shown in Table 4.3

Table 4.3: Output, Labour and capital data of NTPC

Year Output(Rs. mn) Labour Cost Capital Cost (Rs.mn) (Rs.mn)

1998-99 143039 4763 10830

1999-00 167685 6212 9828

2000-01 199054 7640 10918

2001-02 184878 8036 8680

2002-03 194511 8268 9916

2003-04 249994 8835 33697

2004-05 249225 8835 16955

2005-06 287507 9684 17632

2006-07 353766 11580 18594 Source: NTPC Annual Reports

Based on the above data in table 2, we estimated (4.22) model by the OLS method. The results are as follows:

In (Y) = 2.8001+0.86 In (labour) + 0.17 In(capital)

se = (1.11) (0.14) (0.08)

t = (2.50) (5.95) (2.11)

R2=0.92 adj R2 =0.89 df =6 From the above output, it is clear that output elasticity of labour is 0.86 which means that when labour input increases by 1%, output of NTPC will increase by 0.86% holding capital input as constant. Similarly, output elasticity of capital is 0.17 which implies that when capital input increases by 1%, output will increase by only 0.17% holding labour input constant. The sum of both the slope coefficients is 1.03 which indicates more or less constant returns to scale. Thus, it is evident, NTPC is characterized by constant returns to scale over the sample period 1998-99 and 2006-07. Before we close, please note here that for log-log regression model which contains more than two independent variables, the coefficient of each independent variable measures the elasticity of the dependent variable with respect to that independent variable. Hence, in a k-variable log-log model such as given below:



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Popular ebooks
Eco-friendly approach of bio-indigo synthesis and developing purification methods towards isolation of indigo from indirubin and bacterial fragments by Ramalingam Manivannan & Kaliyan Prabakaran & Young-A Son(209744)
Personalized inhaled bacteriophage therapy for treatment of multidrug-resistant Pseudomonas aeruginosa in cystic fibrosis by unknow(178065)
CONSORT 2025 statement: updated guideline for reporting randomized trials by unknow(86562)
Critical evaluation of the ProfiLER-02 study design and outcomes by Vivek Subbiah & Razelle Kurzrock(86151)
Cardiac gene therapy makes a comeback by Oliver J. Müller & Susanne Hille & Anca Kliesow Remes(85962)
Whisky: Malt Whiskies of Scotland (Collins Little Books) by dominic roskrow(74442)
Unveiling the design rules for tunable emission in graphene quantum dots: A high-throughput TDDFT and machine learning perspective by Şener Özönder & Mustafa Coşkun Özdemir & Caner Ünlü(50895)
A yeast-based oral therapeutic delivers immune checkpoint inhibitors to reduce intestinal tumor burden by unknow(40265)
Covalent hitchhikers guide proteins to the nucleus by Alexander F. Russell & Madeline F. Currie & Champak Chatterjee(40217)
Meet the Authors: Christopher R. Mansfield and Emily R. Derbyshire by Christopher R. Mansfield & Emily R. Derbyshire(40099)
Alkaline-earth metals promote propane dehydrogenation with carbon dioxide through geometric effects: Altering the reaction pathway by unknow(32736)
Induced iron vacancies boosting FeOOH loaded on sustainable Fenton-like collagen fiber membrane for efficient removal of emerging contaminants by unknow(32510)
Efficient electric-field-assisted photochemical conversion of methane to n-propanol exclusively over penetrated TiO2Ti hollow fibers by Guanghui Feng(32455)
Bi2SiO5 nanosheets as piezo-photocatalyst for efficient degradation of 2,4-Dichlorophenol by Hangyu Shi & Yifu Li & Lishan Zhang & Guoguan Liu & Qian Zhang & Xuan Ru & Shan Zhong(32391)
A novel NDIPTA organic heterojunction photocatalyst with built-in electric field for efficient hydrogen production by Jiahui Yang & Baojun Ma & Yongfa Zhu(32366)
Enhanced conversion of methane to liquid-phase oxygenates via hollow ferrite nanotube@horseradish peroxidase based photoenzymatic catalysis by Jun Duan & Shiying Fan & Xinyong Li & Shaomin Liu(32333)
Ordered macroporous superstructure of defective carbon adorned with tiny cobalt sulfide for selective electrocatalytic hydrogenation of cinnamaldehyde by Xiao-Shi Yuan & Sheng-Hua Zhou & San-Mei Wang & Wenbo Wei & Xiaofang Li & Xin-Tao Wu & Qi-Long Zhu(32260)
What's Done in Darkness by Kayla Perrin(27152)
Topological analysis of non-conjugated ethylene oxide cored dendrimers decorated with tetraphenylethylene: Insights from degree-based descriptors using the polynomial approach by A Theertha Nair & D Antony Xavier & Annmaria Baby & S Akhila(26533)
Investigation of mechanical and self-healing properties of hydroxyl-terminated polybutadiene functionalized with 2-ureido-4-pyrimidinone by Mohsen Kazazi & Mehran Hayaty & Ali Mousaviazar(26460)