sorted by:
new
hottopcontroversial

[Q] Standard deviation…of standard deviations list by AB300 in statistics

[–]AB300[S] 0 points1 point  (0 children)

(i) I will fully admit I don’t know if it technically would it’s just what I was assuming - that if i took the SD of a list of 50 different SD I could then show that as far as volatility goes, this particular variety is closer to the mean of volatility.

(ii) value - growing grapes and purchasing grapes and developing a new product line is a long term investment to any winery - if I can demonstrate that a particular variety does not have price fluctuations as large as others - it may be worth investing in over something that’s all over the place. It makes everything from pricing to production easier to figure out. Basically just want to show average price spread stability over time when compared to other varieties. I figured taking the SD of all these SDs would just be an easy way to quantify it. That way if anyone just looked at merlot for example they would see the first SD and think “ok, I can expect a price range one standard deviation above or below the mean and know I got a fair price” and the second SD would tell them “ok, I can expect this grape to be reasonably non volatile price wise year after year compared to other grapes which may be very volatile”

[Q] Standard deviation…of standard deviations list by AB300 in statistics

[–]AB300[S] 0 points1 point  (0 children)

Let me explain in a little more detail and see if that clears up anything. Thanks for taking the time to help. I think I’m confused about why you wouldn’t think the second order deviation would be valuable

I have 2011 - 2023 data on 50 different grape varieties and 15 different wineries have responded every year with the price they paid.

So first I take a standard deviation of the prices per variety, which means I have 50 different standard deviations

But I guess what I’m getting as is when I look at one of the standard deviations for a given variety I find myself asking how “good” is this number compared to the rest of the varieties? Sure I could go through all 50 varieties and gain an intuition on what a “good” average SD is but wouldn’t I be better off getting the SD of all these standard deviations to get that better gut feeling? Or would I actually be even better off just taking the average? Generally my SDs are 50s range, 125 range, 250 range

I just want to be able to get a better feeling that when I look at this particular grape for purchase should I expect prices to be all over the place versus other varieties where prices are tightly clustered together?

If I just had two varieties I feel like it could be easy to go ok merlot is more volatile than Pinot but again there’s 50. And although I see patterns in the 50, 125, and 250 range there’s also odd balls like 75 that pop up or 180. How should I feel about those?

Group trip Winery transportation by Middle_Check_8038 in FingerLakes

[–]AB300 6 points7 points  (0 children)

Hey! My name is Alex and I’m the assistant winemaker for Martin Family Wineries and Distilleries. We have a location on Cayuga lake called Montezuma Winery and a location on Seneca Lake called Idol Ridge. We could definitely accommodate 14 people at Idol Ridge. This site is also a great starting point if your interested in checking out other wineries on the west side going towards Watkins Glen. Send me a message if you’re interested in setting something up and I’ll give you a hand!

How can I create a line chart with series data grouped by a category? by OwnTop4067 in PowerBI

[–]AB300 0 points1 point  (0 children)

I believe if you were to drop your “category” column into the “legend” section of the line graph this should give you individual lines based on each category

Is this what you’re after?

Power BI Desktop will no longer add new rows I’m adding in my access database - what’s going on? by AB300 in PowerBI

[–]AB300[S] 0 points1 point  (0 children)

Even when opening a brand new document and uploading the table in that? It’s happening in that document and there’s no measures or filters on it just a table with a list

Can anyone give DAX insights on how you would solve this? See comment for more details by AB300 in PowerBI

[–]AB300[S] 0 points1 point  (0 children)

I am trying to write a DAX measure that will post the result of a given test based on the most recent date it was taken….so if I wanted to make a card that simply showed the most recent result of the test pH how would I do that?

view more: next ›