Lognormal distribution of subjects by income XL5A-V0G 26 Mar 2017 - PDF document

Lognormal distribution of subjects by income XL5A-V0G 26 Mar 2017 XL5A: 0G XL5A: 0G 2014 Schield Log-Normal Income1 1 2014 Schield Log-Normal Income1 2 Lognormal Distribution Log-Normal Distributions of Subjects by Income The log of a Normal distribution is not symmetric. It is never Milo Schield negative and it typically has a long right tail. Augsburg College Some things are distributed log-normally: Editor: www.StatLit.org • People by income, assets, weight and blood pressure US Rep: International Statistical Literacy Project • Cities by population; insurance claims by amount ASSIGNMENT: Output, slides and data at www.StatLit.org/ pdf/2014-Schield-LogNormal-Income1-Excel2013-Demo.pdf 1) Create the table shown on slide 4 (See demo output) pdf/2014-Schield-LogNormal-Income1-Excel2013-Slides.pdf 2) Create the graph shown on slide 5. Upload results. XLS/2014-Schield-LogNormal-Income1-Excel2013-Data.xlsx 3) Review the questions shown on slide 6. XL5A: 0G XL5A: 0G 2014 Schield Log-Normal Income1 3 2014 Schield Log-Normal Income1 4 Enter data and formulas 1) Copy C9; Paste into C14. for top section Enter formula in B14, D14, E14. 2) Select B14:E14. Pull down to bottom row: row 28. Check results against demo output. Enter 50 (median income) and 80 (average income) in B4 and B5. Note: If you copy D9 into C14, column C will give wrong values. Copy C9 into C14. Enter formulas in G2:G5. Enter formulas in B9 & C9. Check values against demo output. XL5A: 0G XL5A: 0G 2014 Schield Log-Normal Income1 5 2014 Schield Log-Normal Income1 6 Create this graph. CDF Percentages; Data: Col B, D & E; Rows 13-28 Practice Problems a and b If X is income, then CDF(X) is the percentage of Log-Normal: PDF and CDF . Household Incomes: Mean = 80K, Median = 50K subjects who have LESS than X thousand dollars 100% in income [Cumulative Distribution Function] If median = $50K and mean = $80K, Cumulative Distribution Function (CDF): 75% Percentage of Households with Incomes below price what percentage of subjects have incomes … 50% a. below 10K? 4.8%. Distribution of Households by Household Income Probability Distribution Function (PDF): Solution: Find 10K in column B in row 15. 25% Percentage of the Modal PDF Find matching CDF in same row, column E, 0% 0 50 100 150 200 250 300 350 400 450 500 b. ABOVE 10K? 100% - 4.8% = 95.2% Household Incomes ($1,000) 2014-Schield-LogNormal-Income1-Excel2013-Slides.pdf 1

XL5A: 0G 2014 Schield Log-Normal Income1 1 Lognormal Distribution of Subjects by Income Milo Schield Augsburg College Editor: www.StatLit.org US Rep: International Statistical Literacy Project Output, slides and data at www.StatLit.org/ pdf/2014-Schield-LogNormal-Income1-Excel2013-Demo.pdf pdf/2014-Schield-LogNormal-Income1-Excel2013-Slides.pdf XLS/2014-Schield-LogNormal-Income1-Excel2013-Data.xlsx

XL5A: 0G 2014 Schield Log-Normal Income1 2 Log-Normal Distributions The log of a Normal distribution is not symmetric. It is never negative and it typically has a long right tail. Some things are distributed log-normally: • People by income, assets, weight and blood pressure • Cities by population; insurance claims by amount ASSIGNMENT: 1) Create the table shown on slide 4 (See demo output) 2) Create the graph shown on slide 5. Upload results. 3) Review the questions shown on slide 6.

XL5A: 0G 2014 Schield Log-Normal Income1 3 Enter data and formulas for top section Enter 50 (median income) and 80 (average income) in B4 and B5. Enter formulas in G2:G5. Enter formulas in B9 & C9. Check values against demo output.

XL5A: 0G 2014 Schield Log-Normal Income1 4 1) Copy C9; Paste into C14. Enter formula in B14, D14, E14. 2) Select B14:E14. Pull down to bottom row: row 28. Check results against demo output. Note: If you copy D9 into C14, column C will give wrong values. Copy C9 into C14.

XL5A: 0G 2014 Schield Log-Normal Income1 5 Create this graph. Data: Col B, D & E; Rows 13-28 Log-Normal: PDF and CDF . Household Incomes: Mean = 80K, Median = 50K 100% Cumulative Distribution Function (CDF): 75% Percentage of Households with Incomes below price 50% Distribution of Households by Household Income Probability Distribution Function (PDF): 25% Percentage of the Modal PDF 0% 0 50 100 150 200 250 300 350 400 450 500 Household Incomes ($1,000)

XL5A: 0G 2014 Schield Log-Normal Income1 6 CDF Percentages; Practice Problems a and b If X is income, then CDF(X) is the percentage of subjects who have LESS than X thousand dollars in income [Cumulative Distribution Function] If median = $50K and mean = $80K, what percentage of subjects have incomes … a. below 10K? 4.8%. Solution: Find 10K in column B in row 15. Find matching CDF in same row, column E, b. ABOVE 10K? 100% - 4.8% = 95.2%

Lognormal distribution of subjects by income XL5A-V0G 26 Mar 2017 - PDF document

Lognormal distribution of subjects by income XL5A-V0G 26 Mar 2017 XL5A: 0G XL5A: 0G 2014 Schield Log-Normal Income1 1 2014 Schield Log-Normal Income1 2 Lognormal Distribution Log-Normal Distributions of Subjects by Income The log of a

Lognormal distribution of subjects by income XL5A-V0H XL5A: 0H XL5A: 0H 2014 Schield

The Lognormal Distribution V1A July 20, 2018 1A 1A 2018 ASA 1 2018 ASA 2 Statistical

Exploring Lognormal Income Distributions 11 Oct, 2014 1C 1C 2014 NNN2 1 2014 NNN2 2

Exploring Lognormal Incomes V1D 20 Nov, 2014 1D 1D 2014 NNN+ 1 2014 NNN+ 2 Exploring

Analyzing Income Distribution Changes: Anonymous versus Panel Income Approaches Gary S. Fields

Contents PART I: POVERTY AND INEQUALITY Income poverty, income distribution and the challenge

Congressional Budget Office August 6, 2012 Trends in The Distribution of Household Income,

and Income Section 2: Population and Economic Growth Section 3: Poverty and the Distribution of

2020/2021 Which Subjects do you choose? Irish, English, Maths. 4 Other Subjects. Level -

A Brief History of Lognormal and Power Law Distributions and an Application to File Size

Income inequality in Ireland The distribution of individual earnings Outline Historical

http://ctfs.si.edu/datasets/bci/ http://www.uwm.edu/People/schnitze/BCIcanopy2.jpg Prestons

Core Subjects Evening 27 th September 2017 catchpolek@lytchett.org.uk Why Core Subjects? All

ASSESSING INCOME DISTRIBUTION FOR INDIA AT S ON O N A A THE DISTRICT LEVEL USING THE

Improving the Measure of the Distribution of Personal Income Dennis Fixler (BEA), Marina

Approximations of the Laplace Transform of a Lognormal Random Variable Leonardo Rojas Nandayapa

Ten Years of the CDF Silicon Vertex Detector: Ten Years of the CDF Silicon Vertex Detector:

Probability and Statistics for Computer Science Can we call the e exci-ng ? e

Lecture 10 : Continuous Random Variables 0/ 21 In this section you will compute probabilities by

Anna Karlin Most Slides by Alex Tsun Poisson RV Example The Zoo of Discrete RVs The

General structure Here we suppose that the consequences are wealth amounts denoted by W , which can

The Top Quark We Observe Gustaaf Brooijmans Indirect Searches for New Physics at the Time of the

Tomasz Skwarnicki On behalf of the LHCb collaboration, including results from CMS experiment

completeness corrections and the small scale issues of the Milky Way Stacy Kim Small Galaxies,