5:13 5:13 5:13 Take Quiz Exit Take Quiz Exit Take Quiz Exit Let's open the data. D Question 4 1 pts Question 5 1 pts 2. Arithmetic mean of satisfaction is The variance is 3. Median of satisfaction is This data is about customers' satisfaction and the mode is after visiting a cafe. (round up to two decimal points). Then, the standard deviation is ID: Survey participants' ID (round up to two decimal Here are some functions for Excel. Gender: Survey participants' gender points). Median --> =MEDIAN(.., ...) Brand: Visited brand Mode --> =MODE(.. ..) Satisfaction: Participants' satisfaction after their visit Here are some functions for Excel. Mean --> =average(.... ....) 1. Minimum of satisfaction is Variance --> =VAR.S(.., ..) and maximum of Standard Deviation --> =STDEV.S(..., ...) Question 6 1 pts satisfaction is meaning that the range is 4. Let's try to calculate z-score by using the following formula. (Hint: see slide 15 on Chapter #10 (Part 1)) D Question 5 1 pts X - H Z= 3. Median of for be