Statistics - Assessment Questions

Question:2

1. The mean of every retail industry group turnover is calculated by using the average function in excel. standard deviation of every retail industry group turnover is calculated by using the STDEV.S function in excel.
2. The minimum value has been calculated by using the “MIN” function in excel, the first quartile by using the “QUARTILE.INC” function, median by using “median” function, quartile 3 by using the same function which is used for quartile 1 but the difference is that used to put 3 instead of 1. The maximum value has been calculated by using the MAX function in excel.
3. Data of household’s goods turnover is positively skewed, the data of clothing, footwear, and personal items turnover is negatively skewed, the turnover data of department store is almost symmetric, the turnover data of other retailing is positively skewed, and the turnover data of cafes, etc. is negatively skewed.

We’ll write customized paper for you.
Get Upto 30% OFF on your Order!

Order Now Whatsapp Now