Leadership Assignments

In

Exce

l

,

calculate and

create

Bar Graphs

by month

(January

-

December)

for attendance and giving

based on the da

t

a below

.

Adult

Average Weekly Attendance

ye

ars 2018

-

2021

20

18

total

Adult

att

e

ndees for

Sunday

and

Wedn

esday

=

1,989

20

1

9

total

Adult

att

e

ndees for

Sunday

and

Wedn

esday

=

2,511

20

20

total

Adult

att

e

ndees for

Sunday

and

Wedn

esday

(

primari

ly

virtual)

=

4,388

20

21

total

Adult

att

e

ndees for

Sunday

and

Wedn

esday

(

primari

ly

virtual)

=

3,230

Kin

gdom Ki

ds

Average Weekly Attendance

for ye

ars 2018

-

2021

20

18

total att

e

ndees for Sunday Ser

vices

20

1

9

total att

e

ndees for Sunday Ser

vices

20

20

total att

e

ndees for Sunday Ser

vices

20

21

total att

e

ndees for Sunday Ser

vices

Christian Ed.

Average Weekly Attendance

for ye

ars 2018

-

2021

20

18

total att

e

ndees for Sunday

20

1

9

total att

e

ndees for Sunday

20

20

total att

e

ndees for Sunday

20

21

total att

e

ndees for Sunday

G

iving

Exce

l

Graph

s

:

Average Weekly Giving

20

18

total

gi

ving

=

$

141,025.53

20

1

9

total

giving

=

$

158,878.43

20

20

total

giving

=

$

182,790.33

20

21

total

giving

=

$

188,16

2.61

Average

weekly

Giving

Per Capita

Year

20

1

8

-

2021

In Excel, calculate and create Bar Graphs by month (January- December) for attendance and giving

based on the data below.

Adult Average Weekly Attendance years 2018-2021

2018 total Adult attendees for Sunday and Wednesday= 1,989

2019 total Adult attendees for Sunday and Wednesday = 2,511

2020 total Adult attendees for Sunday and Wednesday (primarily virtual)= 4,388

2021 total Adult attendees for Sunday and Wednesday (primarily virtual)= 3,230

Kingdom Kids Average Weekly Attendance for years 2018-2021

2018 total attendees for Sunday Services

2019 total attendees for Sunday Services

2020 total attendees for Sunday Services

2021 total attendees for Sunday Services

Christian Ed. Average Weekly Attendance for years 2018-2021

2018 total attendees for Sunday

2019 total attendees for Sunday

2020 total attendees for Sunday

2021 total attendees for Sunday

Giving Excel Graphs:

Average Weekly Giving

2018 total giving= $141,025.53

2019 total giving= $158,878.43

2020 total giving= $182,790.33

2021 total giving= $188,162.61

Average weekly Giving Per Capita

Year2018-2021