Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Density

Iron Contributor

Dear Experts,

                 I want to compare the Latency for two different scenarios as in attached worksheet.(Latency_1 and Latency_2) how can I check in which case Latency is better( less)

anupambit1797_0-1707596957190.png

anupambit1797_1-1707596969716.png

Merely looking at the distribution seems same(similar) but what can be done to check in which case Latency is lesser(Better)?

 

Any function to check which is less dense etc?

 

Thanks in Advance,

Br,

Anupam

1 Reply
best response confirmed by anupambit1797 (Iron Contributor)
Solution

@anupambit1797 

You might calculate the average and standard deviation of both scenarios.

HansVogelaar_0-1707651415605.png

As you see, the first one has a much lower (better) average, and the variation is less too (although still large relative to the average).

1 best response

Accepted Solutions
best response confirmed by anupambit1797 (Iron Contributor)
Solution

@anupambit1797 

You might calculate the average and standard deviation of both scenarios.

HansVogelaar_0-1707651415605.png

As you see, the first one has a much lower (better) average, and the variation is less too (although still large relative to the average).

View solution in original post