๐๐ฑ๐๐๐ฅ ๐๐ญ๐๐ง๐๐๐ซ๐ ๐๐๐ฏ๐ข๐๐ญ๐ข๐จ๐ง ๐๐ซ๐๐ฉ๐ก
------------------------------------------------------------
Excel Standard Graph is used to visualize, data spread. Excel is a powerful tool for creating graphs and visualizing data so creating the bell graph can be used.
๐๐ญ๐๐ฉ๐ฌ ๐ญ๐จ ๐๐ซ๐๐๐ญ๐ ๐๐ญ๐๐ง๐๐๐ซ๐ ๐๐๐ฏ๐ข๐๐ญ๐ข๐จ๐ง ๐๐ซ๐๐ฉ๐ก ๐ข๐ง ๐๐ฑ๐๐๐ฅ
----------------------------------------------------------------------------------------
#1 - Select the data and go to the tab INSERT, then select smoother scatter chart under the chart scattered.
#2 - The chart will be displayed.
#3 - You can change the axis of the chart and its title if needed.
๐๐ก๐ข๐ง๐ ๐ฌ ๐ญ๐จ ๐๐๐ฆ๐๐ฆ๐๐๐ซ ๐๐๐จ๐ฎ๐ญ ๐๐ญ๐๐ง๐๐๐ซ๐ ๐๐๐ฏ๐ข๐๐ญ๐ข๐จ๐ง ๐๐ซ๐๐ฉ๐ก ๐ข๐ง ๐๐ฑ๐๐๐ฅ
-----------------------------------------------------------------------------------------------------------
#1 - MEAN or AVG values are always the middle of the standard deviation graph in Excel.
#2 - Approximately 68.2 % of the data series will be fitted within the range (MEAN – SD to MEAN + SD. (65-70).
#3 - Approximately 95.5% of the data series will be fitted within range i.e. 2 * (MEAN –SD) + 2 * (MEAN + SD)
#4 - Approximately 99.7% of the data series will be fitted within range i.e. 3 * (MEAN –SD) + 3 * (MEAN + SD).
#5 - The shape of the Excel Standard Deviation Chart depends on the SD value, the wider the bell curve, the lower the SD value, the slimmer the curve of the bell.
To know more about ๐๐ญ๐๐ง๐๐๐ซ๐ ๐๐๐ฏ๐ข๐๐ญ๐ข๐จ๐ง ๐๐ซ๐๐ฉ๐ก ๐ข๐ง ๐๐ฑ๐๐๐ฅ, you can go to this ๐ฅ๐ข๐ง๐ค ๐ก๐๐ซ๐:-
Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe -
0 Comments