Provide Step by Step excel solution to the whole problem (all parts) and final picture of excel with explanation:

Question 3(10+20=30 points ) The manager of a large appliance store records the number of microwave ovens sold each day over a period of 100 days, as summarized below. 3.1 Use the given data to create the empirical frequency distribution of daily sales. Calculate the sample-based mean and standard deviation. 3.2 Based on the sample, use RAND() and the VLOOKUP function to simulate daily sales for 500 days. Create the empirical frequency distribution of the simulated daily sales