Excellent explanation! Clear & concise! - Thankyou from Oz!
@kevinq66283 жыл бұрын
best video on data normalization, to the point
@jdosses Жыл бұрын
Awesome! Very useful, finally understood the concepts
@siktrading31172 жыл бұрын
Excellent video & fantastic explanation!!! Thank you very much!!!
@Geek743 жыл бұрын
Use F4 key to select "Absolute Cell Reference" :)
@Artharjan3 жыл бұрын
Learnt a lot through this video...thanks so much...God bless you.
@spreadsheetgeek40703 жыл бұрын
Thank you!
@JohanaSellersConner2 жыл бұрын
Thank you!!!!! Great video!!!!!
@dheeraj39453 жыл бұрын
Absolutely Mesmerizing, Thanks a lot for such an amazing description
@ssgstatswithexcel49662 жыл бұрын
Thanks a lot sir. Beyond doubt learnt a lot.
@TarunGuptaCA3 жыл бұрын
excellent Really!!
@camiblos2 жыл бұрын
Very helpful! thanks a lot!
@narijodeco68693 жыл бұрын
Your video is great. Thank you :)
@HtheKing Жыл бұрын
top lad nice one g
@datacool2 жыл бұрын
Hello sir, I'm confused about the norm.dist and standardize functions, as far as I know the norm.dist function is also to find zscore, but doesn't standardization also use the same formula to find zscore? Then why are the results different? CMIIW
@diaconescutiberiu75352 жыл бұрын
Q: why did you normalise & standardise with the % change and not actual (closing) data? Is there a reason to chose one over the other?
@zyzznatural23302 жыл бұрын
@Keshav Agrahari hi Kesh
@FenderAddict93 Жыл бұрын
Legit question. Would like to know as well.
@didierleprince61062 жыл бұрын
A big merci (:
@ireneantillano12 жыл бұрын
Hi, thank you for your video, it was very informative and useful. I have a problem that I am trying to resolve... Maybe you can help me. I have historical data of balances on my accounting books. I am trying to figure out what the "normal balance range" should be for each account, for example the account should have a balance between -100,000 and 200,000, this way I will have an interval that will trigger further investigation of the balance in case it is ever outside this range. The first thing I did was standardize the data, but now I need to return to the original values to construct the "normal range", how can you do this?
@mohamed.montaser3 жыл бұрын
the formula u showed for STANDARDIZE is the formula for z-score
@KoldFiyure3 жыл бұрын
When you said "Lets go ahead and populate that down to the bottom..." what did you hit to make the numbers autofill down like that?
@spreadsheetgeek40703 жыл бұрын
I double left mouse clicked on the "autofill handle"...that little green square at the lower right of the selected cell.
@tinashemukota14312 жыл бұрын
How do you deal with negative numbers after calculating the percentage change? All your negative numbers are in brackets and represented as positive.
@xerxessultanian81622 жыл бұрын
thank you for real. i wonder if there are some zero price data or some messing price data, must we delete these days or make them somehow? i hear there is a approach and we can make five days data by running a geometric codes in mathlab but i don't know how...? i wonder if you know more details about what i'm talking about...
@michaelabghari2392 Жыл бұрын
Great analysis, I personally questioning return of BRK shares under performing compare to spy , he benefiting his fame ,
@mahamsaleem45332 жыл бұрын
hy if i have a likert scale questionaire response like high moderate low and no how can i normalized in values to calculate minimum and maximum plz reply
@ABC770772 жыл бұрын
Can you normalize promotion type that has qualitative info ?
@suhasjadhav16102 жыл бұрын
Lucid explanation.
@CxJr3603 жыл бұрын
How did you get the max and min values
@spreadsheetgeek40703 жыл бұрын
Use the Excel MIN and MAX functions which will give the min and max values in a range =MIN(A1:A100)
@JR-ly6bx3 жыл бұрын
showed how to do these 2 operations... but didnt explain why/when you would use 1 over the other on your data
@dara_19893 жыл бұрын
how did u get brackets instead of - symbol
@spreadsheetgeek40703 жыл бұрын
I'm not sure what you're talking about. What is the time elapsed when you observe the brackets?
@antoniofemia51192 жыл бұрын
I think the above comment is asking how to change the representation of a negative number from the minus symbol preceding the number to the brackets, which is how you have it. OP, right click on a cell(s) you’d like to change and click on the format cells option in the drop down. From there, go to the number category and there will be a list of how you would like negative numbers represented. Hope that helps :D
@fweddyfwintsone44913 жыл бұрын
So, how do they "normalize" data (ie. closing price) to map to a range, ie: oscillators where prices may be "normalized" between -100 and 100 (overbought and oversold)?
@spreadsheetgeek40703 жыл бұрын
Once they convert the set of numbers to values between 0 and 1, just multiply each number by 200 then subtract 100. .25 becomes -50, .75 becomes 50, 0 becomes -100...and so on.