Question: please do in python. make sure the output displays the corect value Exercise 1: Standard deviation Open the file lab.sy. This file has 3 numbers

please do in python. make sure the output displays the corect value  please do in python. make sure the output displays the corect
value Exercise 1: Standard deviation Open the file lab.sy. This file has
3 numbers per-line, separated by commas. Calculate the mean and standard deviation

Exercise 1: Standard deviation Open the file lab.sy. This file has 3 numbers per-line, separated by commas. Calculate the mean and standard deviation of each column of the file using the formula: (2-2) is an element of the dataset at spoti. Where is standard deviation, is the mean of the dataset, N is the number of elements in the dataset, and You will need to: 1. Open the file 2. Initialize 3 list accumulators 3. Iterate over the lines of the file in a for loop and accumulate the values in the columns. 4. Compute the average (either do this inside the loop with a running sum or use the sun function on your lists). Once you have the mean I calculate the standard deviation using a second for loop Your output should look like: The mean of column 1 is 50.30, and the standard deviation is 28.81 The mean of column 2 is 499.29, and the standard deviation is 290.16 The mean of column 3 is 5011.12, and the standard deviation is 2874.15 Exercise 2: Standard deviations from the mean Add to your program from the previous part to ask for numerical input from the user. Find how many standard deviations from the mean the input is. The formula for deviations from the mean is: deviations FromMean Where is the standard deviation, is the mean of the dataset, and is the data the user provided. Give me a number : > 50 This number is 2000.0104 standard deviations from the mean for column 1. This number is 2001.5501 standard deviations from the mean for column 2. This number is 8001.7261 standard deviations from the mean for column 3. Spyder (Python 3.7) File Edit Search Source Run Debug Consoles Projects Tools View Help Editor C:\ProgramData ASUS ASUS Live Update Temp Comp 1012ab4.com lab.csv lab.py Activity 4.py 3 996061.47996325779939, 196.2025689610195,8887.147787713882 9961 28.57713428742,76.25952474840881,6517.491791240355 9962 49.51403409481273,529.1596176538562,3599.267828297701 9963 74.59746003306347,993.27774286794,7909.510777488588 9964 38.96308543781279,242.65871234112524,6020.215662248768 9965 12.958541796871359,154.83818572881037,9643.561707989866 9966 4.963933785124586,394.3658249402267, 3126.34538134133 9967 56.55742548021021, 386.69490185097635,7775.415954062594 9968 28.001224270633607,686.2917753262644,8398.745820419255 9969 14.1222712332714,621.3729313085317,1363.6501686092495 9970 9.556225964436093,949.3881369069536,7564.853523883586 9971 40.701948244422844,715.6640338097559,611.3434589226819 9972 7.779986026408854,535.558472019478,5574.943136227562 9973 74.28239368808765,449.33876120984335,9158.657276824566 9974 26.574124291379654,364.6149788603545,8268.300554911782 9975 52.9181327438493,496.24299701627684,7011.325532143825 9976 44.10673714969724,413.9768020758664,4782.812260140528 9977 44.611616571295755,19.68581144852166, 7191.667516122519 9978 42.39790183122294,695.3809978396195, 2124.235775629257 9979 83.20968056172025,542.1666926388035,7327.962125330365 9980 89.224250132491,490.4251831368964,9267.939716992983 9981 11.618061724586271,885.1937447175784, 7909.191385180884 9982 23.672945561661668,230.91477482611845,1027.5822773358057 9983 35.70558481408863,529.8766337585188, 1628.3038493529461 9984 81.99785984121807,841.9175488222629,7604.974038068988 9985 12.469076016152503,160.12993083665538,910.1663676026062 9986 9.441389675700119,282.46371000694205,6635.200528729649 9987 49.68704283249829,847.7019843893705,9846.483230774547 9988 80.79146684525647,28.108461894776096,6156.25942143046 9989 84.53451992142087,941.0770293845843, 316. 14850597425084 9990 57.72455486311808, 209.5869563630416, 3520.5958510599135 9991 95.40322237385092,592.248650371762,708.7150722702828 9992 66.39592511795469,893.8607385437046,5105.122319881165 9993 8.1189556294467,781.7734295035436, 2475.9720842186916 999434.64577520508756,136.21796481141047,6718.9451889901575 9995 0.40608092714041755,605.7243117634048, 4634.176726934915 9996 50.44627268035272,556.9209277949119,4802.49922386394 9997 66.29845093175794,384.95007977483147,6912.153480908207 9998 24.66854170939612,264.71209664591044,6299.066467219542 9999 38.469106236630054,687.0209147808065, 3008.9932833575917 10000 77.07710251887862,881.7757279192992,248.61493797295964 18881

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!