This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have data of sales in multiple cities. I need to see the effects on the mean and stdev of sales if you exclude each city. Attached a sample workflow that filters out each city and then finds the mean and stdev. In the example there are only three cities. In the actual data, the number of cities is large and is not fixed. In the example, there is also a macro that does the same thing to make it dynamic. Is there any way to make it dynamic without building a macro that filters out each city then calculate the mean and stdev? I don't want to use a macro for performance concerns since I have a large number of cities and I don't want the workflow to do cities one by one. I thought if there is a way where you can group by city, and then do the mean and stdev, not for each city, but for all cities except each, if that makes sense.
You can definitely do this without a macro, but the computational complexity will probably still exist and therefor I don't think the result would be much faster, but here is how you could do it (example attached).
Hi @ahmedalra , if this resolves your issue can you please mark this post as an accepted solution, not only will that help me catch @jdunkerley79 but it will also help priortize this search result should others have a similar issue in the future.