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
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
Get Answers For Free
Most questions answered within 1 hours.