In Progress

Simulation of Pareto Distributed Budgets+Peak over Threshold

I would like to use Excel to simulate a Pareto distribution of corporate budgets (Monte-Carlo simulation) and vary the degree of inequality.

You start with a list of 60 000 firms. They are ranked in size, beginning with the largest firm. The list is generated by the following rules:

The biggest firm has a size of N0=600 000 employees.

The size of each subsequent firm has the size of

N = (1/Rank * N0) (Zipf Plot)

In each size class, the average budget of each firm is calculated like this:

The average budget per employee equals the logarithm of firm-size multiplied by a factor of x0=1008 €

Within each size group, the budgets of the firms are Pareto distributed, most have a small budget, very few have a big budget. The degree of the inequality a is a function of the company size. It is smaller among the big firms and increases among smaller firms. (Small firms differ more among each other)

After the list is finished, you need to perform a “peak over threshold analysis”

You take the 500 largest budgets of the list (peak over the threshold = budget of the spender nr 1000) and compare them with the attached list.

Change the inequality a(size) and/or the value of x0 until the simulation ideally matches the 1000 budgets.

Draw a diagram of the 1000 simulated firms (budget per employee on y axis, size on x-axis) and a diagram of the firms from my list

Inform me, how you found the values for a(size) and x0 and send me the Excel sheet.

(On the Internet I found an Excel spreadsheet that calculates the probability density function of the Pareto function: [url removed, login to view] but

Skills: Excel, Mathematics, Statistics

See more: peak threshold, peak threshold excel, simulate pareto excel, pareto distributed, simulate pareto distribution excel, peak threshold analysis excel, pareto distribution excel, excel monte carlo distribution pareto, pareto budgets, excel simulation pareto, pareto simulation excel, x-axis, n equals, matches statistics, matches list, list matches, analysis group, excel probability density, excel probability density function, simulation, probability and statistics, peak to, monte, compare spreadsheet, big budget

About the Employer:
( 8 reviews ) Karlsruhe, Germany

Project ID: #1149403

6 freelancers are bidding on average $68 for this job

WebDesignall

Please check your PM

$100 USD in 3 days
(42 Reviews)
6.6
saninfotech

Dear sir/madam, Please check pm for more details. Thanks San

$100 USD in 5 days
(17 Reviews)
4.4
Naachiz

I am interested. Give me a chance.

$100 USD in 3 days
(4 Reviews)
3.4
Hnnghia

Hello, I can do it. I can start it now.

$30 USD in 2 days
(3 Reviews)
2.7
arda6

Hi, check Your PM

$50 USD in 1 day
(1 Review)
1.0
danielvargas

Please check PM.

$100 USD in 5 days
(1 Review)
2.2
maleen89

Hi, I am an engineering student. who has specialized in statistical analysis. I could satisfy your requiremnt.

$30 USD in 5 days
(0 Reviews)
0.0