Historical data show that customers who download music from a popular Web service spend approximately $26 per month, with a standard deviation of $8, normally distributed, but never spend more than $30. Assuming that each customer is independent of the others, predict the average amount of the next ten transactions. (Hint: Develop a method to ensure that the random variate is limited to $30.)

Please show step by step in excel and explain answer