Small Statistical Analysis Spreadsheet

Small Statistical Analysis Spreadsheet

Cancelled

Job Description

We have two numbers with a nominal value and step size, and need to have a spreadsheet to analyze the distribution of the typical delta of these two numbers.

For example, suppose number one is typically 100,200,300,400 and 500 +/-10
Suppose number two is typically 125, 250, 375, 500 +/- 15

What is the typical minimal difference between these two numbers we could expect?


For one instance -
Number set 1: 105, 197, 305, 408, and 502
Number set 2: 133, 244, 379, 504

One would find the closest set of numbers between set 1 and set 2. In this case it would be 502 and 504, with a difference of 2.

Repeating this in a spreadsheet 1000 times and coming up with a distribution of the minimum number between these sets of numbers is what we'd like.

We'd like to be able to change the following:

1) Min number of set 1
2) max number for set 1
3) step size of set 1
4) variation of set 1 (i.e. +/- 15)
5) Min number of set 1
6) max number for set 1
7) step size of set 1
8) variation of set 1 (i.e. +/- 15)

Other open jobs by this client