LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default How should I calculate elasticity by using excel?

This stuff also works wonders for getting rid of people or putting them to
sleep.

"Dave F" wrote:

What he said.
--
Brevity is the soul of wit.


"JMB" wrote:

Basically, it is a measure of the responsiveness in the quantity demanded of
a commodity (education) at any point on the Engel curve due to a change in
income (and assumes that all factors affecting the income demand for
education remain constant). But, IMO, I don't think a definition is really
of much help - perhaps he is looking for the formula?

The OP did not give any cell references for his data, but the income
elasticity can be measured by:

–²Q/Q
_______

–²I/I


or

(Q2 - Q1) I1
________ x ____
(I2 - I1) Q1

which gives you the Income Elasticity Coefficient for education between two
data points (Q being quantity demanded for education and I being Income).

Generally, negative coefficients refer to inferior goods and positive to
normal goods (for that particular income level). Some folks believe it can
be further broken down as:
E< 0 - Inferior Good
0 < E < 1 - Necessity
E 1 - Luxury

but those are just general guidelines.


" wrote:

JoAnn Paules [MVP] wrote:
Elasticity of Expenditures sounds like making your money stretch to fit your expenses. :-)

Or you could take 5 sec to do a google search and get a reasonable
understanding. I found the following definition:

"In economics, elasticity is the ratio of the incremental percentage
change in one variable with respect to an incremental percentage change
in another variable. Elasticity is usually expressed as a positive
number (i.e., an absolute value) when the sign is already clear from
context." See en.wikipedia.org/wiki/Elasticity_(economics) .




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
How do I get Excel to automatically calculate salaries actually received in financial year? Kei Excel Discussion (Misc queries) 0 March 3rd 06 10:26 AM
how to calculate the hours and minutes in excel Mital Excel Discussion (Misc queries) 3 February 14th 06 06:49 PM
how to calculate surface area in excel chart k Charts and Charting in Excel 1 January 18th 06 03:07 PM


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"