Calculate Absence in a Time sheet based on working days per week!

The attached table shows 3 Group of employees, each group have different count of employees. And each group work on a different schedule, one on M-T-W, another from Mon-Fri, and another on Sat-Sun.

The table is to calculate how many employees were absent per week (Average and Percent), BUT based on the sessions (Workdays per week) in Column E
and how many were present.

Absence Average ?
Absence Percentage ?
Present ?

The numbers in columns F to L is the number of employees that were absent on that day of the week.

It could be so simple but with my knowledge in Excel I couldn't figure it out with a formula.

I appreciate your help.
Thanks

Excel 2016 (Windows) 32 bit

	M	N
2	Absence Average	Absence Percentage
3	1.333333333	13%
4	1.2	20%
5	3.5	35%

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	M	N
2	Absence Average	Absence Percentage
3	=AVERAGE(Table1[@[Mon]:[Wed]])	=SUM(Table1[@[Mon]:[Wed]])/[@[Employees total]]
4	=AVERAGE(Table1[@[Mon]:[Fri]])	=SUM(Table1[@[Mon]:[Fri]])/[@[Employees total]]
5	=AVERAGE(Table1[@[Sat]:[Sun]])	=SUM(Table1[@[Sat]:[Sun]])/[@[Employees total]]

Sheet: Sheet1

I did not complete the last column because I don't understand your needs. Please explain your criteria/logic for this item as it could vary depending upon your needs.