Question

Number Of Course	Number of Students
6	80
9	70
13	60
27	50
100	40
34	30
11	20

a- Calculate the simple (unweighted) average size of students.

b- Calculate the weighted average size of students.

Can you please tell me how to solve on excel.

Thank You

Answer 1

steps for simple average of students on excel:

data entry -> click on a empty cell -> "=AVERAGE(select column of number of students)" -> Enter

simple average size of students= 50

steps for weighted average size of students on excel:

data entry -> click on empty cell -> "=(number of course * number of students)" -> Enter

result obtain=

480

630

780

1350

4000

1020

220

-> "=sum( select column of number of course * number of students)" -> Enter

sum=8480

-> "=sum(select the column of number of course)" -> Enter

sum=200

->"=(select the column of sum of number of course*number of students) / (select the sum of the column of number of course)" -> Enter

weighted average size of the student=42.4

for any further comment,please comment below.thank you