1.Use the book's/Powerpoint's computational formula(s) and not excel formula(s).

Do the Work in excel then copy and paste your results to replace the table below. Truncate to one Decimal point, for example 7.289 -> 7.2 (excel has a truncate function).

QUAN-227 Fall 2019 2, Supplementary Problem 3 40 Here is the dota I want you to use (I changed it a bit). I even sorted it, Add 5 recards between 52 and 80 of your chaice (Be careful, date must stay sorted). Lee the beck's/Powerpoint's computational formula(s) and not excel formula(ik your chewers should be Very simlar to the worked solution to damaratration problem 3,2 19 21 22 22 25 25 26 27 28 29 29 31 31 3.2 39 34 35 BE 38 38 18 40 41 42 42 47 48 50 52 Compute Pio IN-40 Location i= Pic= Compute Pro, Compute Q Compute Qu Compute IQRBLAN-227 Fall 2015 3. Here is the date I went you to use, I gwen sorted it 21 21 22 22 28 24 25 29 29 25 26 31 26 35 31 32 27 38 38 38 38 34 48 40 50 41 42 47 Part-4: Use My Of- 25 8 95-40, draw the bex plot, using the box plot, doas the data have outher, if 50 Part-be Use My Mean-12_ofday-7, ine the empirical formula, at the 95% coverage of the data, dogs the dalla have any audiers, if you, give an example Part-2: Like My Mean-32_yday-7. Using chubachaxkinaqual by at the 95% coverage of the data, doas the data have any outliers, if yes, give an example. Part-4: Use My Mean-32, gogy-7, Calculate the 2-Score for the min and the max values in the data