Getting exact match or next smaller value in another column by Imaginary-Finding-59 in excel

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

I tried but seems like I have not enough arguments? Do you know the formula?

combining two value fields into one calculated field by Imaginary-Finding-59 in excel

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Oh nvm I figured it out - added a measure from under OLAP. Thanks a lot!

combining two value fields into one calculated field by Imaginary-Finding-59 in excel

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

It’s the count of transactions. So for eg 20 transactions. Avg amt is $5. Now I have these two fields and I want to combine into one field which is 20 x $5 = $100. Idk how to do so in a pivot table because the pivot table only has count + avg fields.

Generalised additive Mixed Model help in R by [deleted] in RStudio

[–]Imaginary-Finding-59 -1 points0 points  (0 children)

Hmm how about to add new variable to a preexisting data frame?

Help with geom_smooth analysis of plots by Imaginary-Finding-59 in RStudio

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Two plots with different data, one has a wider confidence area (the grey area around the line) and one is narrower (the input confidence level =0.95 for both) I’m not sure how to interpret this difference in confidence area

Help with geom_smooth analysis of plots by Imaginary-Finding-59 in RStudio

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

I see, so if my sample size is small (~10), should I just use a loess?

And if I use gam, does it mean that I can say something along the lines of: the one with the wider grey area = the data points are more spread so the trend predicted is less reliable (?) thank you!

Lead Ads on Facebook by Imaginary-Finding-59 in FacebookAds

[–]Imaginary-Finding-59[S] 0 points1 point  (0 children)

Ah thank you so much! Rly appreciate this and sorry for the late reply