Advanced excel for MBA's- 't' test

Advanced Excel for MBA's - Calculating the Mean using Excel

Calculating mean of the datasets using Excel.

Problem1 :

Calculate the mean sales of Prasad industries's sales executive for the month MAY 2020.

Company : Prasad Industries.
	Sales for May 2020(in '000s)
Sales Executive 1	72
Sales executive 2	35
Sales Executive 3	45
Sales Executive 4	52
Sales Executive 5	61
Sales Executive 6	63
Sales Executive 7	48
Sales Executive 8	59
Sales Executive 9	71
Sales Executive 10	74

Answer

 Step 1: Click on formula

 Step 2: Insert functions

Step 3:

Step 4: Click on Average

Step 5; 

Select the sales executive 1 to 10 sales data

Step 6; The answer 58 will appear on the window.