Simulation of Pareto Distributed Budgets+Peak over Threshold

IN PROGRESS
Bids
7
Avg Bid (USD)
$73
Project Budget (USD)
$30 - $250

Project Description:
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: www.quantitativeskills.com/sisa/rojo/distribs.htm but

Skills required:
Excel, Mathematics, Statistics
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 100
in 3 days
$ 100
in 5 days
Hire Naachiz
$ 100
in 3 days
$ 30
in 2 days
Hire arda6
$ 50
in 1 days
Hire maleen89
$ 30
in 5 days
$ 100
in 5 days