create account

[VIDEO] How to use Excels STANDARDIZE function to calculate ZScores by theexcelclub

View this thread on: hive.blogpeakd.comecency.com
· @theexcelclub ·
$1.25
[VIDEO] How to use Excels STANDARDIZE function to calculate ZScores
https://www.youtube.com/watch?v=hyM3f1_ejqA 
<br />


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<br />



<center><img src='https://i.imgur.com/SAXfzqa.png' /></center><br />



<center><a href='https://youtube.com/channel/UCQEO63TKG1moSUxAu07cP-A/'>Paula Guilfoyle Youtube Channel</a></center><br />



<center><img src='https://i.imgur.com/SAXfzqa.png' /></center><br />



<center><sup>Posted from <a href='https://www.youtube.com/watch?v=hyM3f1_ejqA'>YouTube</a> via <a href='https://share2steem.io/?ref=theexcelclub'>Share2Steem</a></sup></center>

👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 336 others
properties (23)
authortheexcelclub
permlinktheexcelclub-1554120970152-how-to-use-excels-standardize-function-to-calculate-zscores
categoryshare2steem
json_metadata{"tags":["share2steem","excel","tricks","standardize","in"],"image":["https://i.ytimg.com/vi/hyM3f1_ejqA/hqdefault.jpg"],"app":"share2steem/1.1.0","format":"markdown"}
created2019-04-01 12:16:09
last_update2019-04-01 12:16:09
depth0
children1
last_payout2019-04-08 12:16:09
cashout_time1969-12-31 23:59:59
total_payout_value1.026 HBD
curator_payout_value0.221 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,926
author_reputation49,417,421,433,400
root_title"[VIDEO] How to use Excels STANDARDIZE function to calculate ZScores"
beneficiaries
0.
accountcryptoyzzy
weight400
1.
accountshare2steem
weight600
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id82,305,238
net_rshares2,019,118,267,088
author_curate_reward""
vote details (400)
@steemitboard ·
Congratulations @theexcelclub! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

<table><tr><td>https://steemitimages.com/60x70/http://steemitboard.com/@theexcelclub/voted.png?201904011839</td><td>You received more than 7000 upvotes. Your next target is to reach 8000 upvotes.</td></tr>
</table>

<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@theexcelclub) and compare to others on the [Steem Ranking](http://steemitboard.com/ranking/index.php?name=theexcelclub)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>



###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!
properties (22)
authorsteemitboard
permlinksteemitboard-notify-theexcelclub-20190401t195220000z
categoryshare2steem
json_metadata{"image":["https://steemitboard.com/img/notify.png"]}
created2019-04-01 19:52:18
last_update2019-04-01 19:52:18
depth1
children0
last_payout2019-04-08 19:52:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length848
author_reputation38,975,615,169,260
root_title"[VIDEO] How to use Excels STANDARDIZE function to calculate ZScores"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id82,326,379
net_rshares0