Page 267 - AI Computer 10

To calculate standard deviation in Python:

import statistics
num = [10,20,30,40,50,60,60,70,70,70,80]
m = statistics.stdev(num)
print(“The standard deviation of numbers
is:”,round(m,2))
Output:

The standard deviation of numbers is: 23.0
AI Activity
AI Activity
Statistical Analysis
Excel, with its collection of functions and database capabilities offers tools to perform statistical
operations on data and analyse the results. Let us learn how to use Excel for data analysis with the
help of a simple activity.
Step 1: Download the activity template using the following link: https://docs.google.com/
spreadsheets/d/1f5G-JXyP7EV2fy1hax47YVaH5gyq8KZy/edit?gid=1552557748#g
id=1552557748

Step 2:
Step 2: Go to the File menu and Click on Options button.Go to the File menu and Click on Options button.

Step 3: Select the Add-ins option and click on Analysis ToolPak under Inactive Application Add-ins.
At the bottom, select Excel Add-ins in the Manage box and click on the Go button.

The Add-in pop-up window will appear.

133
133