http://theexcelclub.com/standardize-in-excel-lets-compare-apples-with-oranges/
This video is the solution to an Earn and learn activity on The Excel Club. Visit the blog to download the data and submit your solution to the activity to earn steem rewards.
Can you compare apples with oranges? Generally speaking, the answer is no. However, if we use standard deviation as a measure, then we can. Using standard deviation to compare data with different units is called standardizing. By standardizing data, you are calculating the Z score. Standardized values have no units and hence allow you to compare apples with oranges. In Excel, this is easily done using Standardize.
The Excel Club Blog has been powered with #STEEM. That means we are a tokenized website and you can earn while you learn Excel, PowerBI and DAX. All you have to do is engage with the post on The Excel Club Blog, so if you have any questions or comments I would encourage you to post them on the blog and not here on the video
Sign up to our newsletter
http://theexcelclub.com/newsletter/
Watch more Power BI videos
https://www.youtube.com/playlist?list=PLJ35EHVzCuiEsQ-68y0tdnaU9hCqjJ5Dh
Watch more Excel Videos
https://www.youtube.com/playlist?list=PLJ35EHVzCuiFFpjWeK7CE3AEXy_IRZp4y
#share2steem #excel #powertools #steem #exceltips #tutorial
#powerpivot #powerbi #powerquery #powerview
Posted from YouTube via Share2Steem