Exercise 2.xlsx - Guests Confirmed Attending Adults x 2 x 3 Kids 0 1 x x x 1 1 2 0 2 3 x 4 3 x x 2 1 0 0 x x x 3 3 4 3 4 6 x x x x 2 1 1 4 1 1 2 0 x 2 3

# Exercise 2.xlsx - Guests Confirmed Attending Adults x 2 x 3...

• 3

This preview shows page 1 - 3 out of 3 pages.

Guests Confirmed Attending Adults Kids Invited By x 2 0 Bride's Parents x 3 1 Bride Groom's Parents x 1 0 Groom's Parents x 1 2 Groom x 2 3 Groom Bride's Parents Bride x 4 3 Bride's Parents Bride x 2 0 Bride x 1 0 Bride Groom Bride Bride's Parents x 3 3 Groom x 3 4 Groom's Parents x 4 6 Groom Groom x 2 1 Bride x 1 1 Bride x 1 2 Bride x 4 0 Groom's Parents Groom x 2 3 Groom
6- Draw a bar chart showing the sum results of question 5. You are helping a couple prepare their wedding reception, and you need complete the following data. Do the following steps to achieve your goal a new table whenever needed): 1- Write 1 in the "Attending" column if the guest confirmed their attenda 0 otherwise. Calculate the total number of confirmations using 2 differen formulas. 2- Calculate the total number of adults and the total number of kids atten and the total number of all guests. Draw a pie chart showing the number