Question

Exercise 5: Insert an new sheet and rename the sheet to EX5. (22 pts.)

Consider the data below. The table A shows the number of voices for each candidate in a single region.

Table A

Number of Voices	Sect	Candidate First Name	Percentage	Status
2330	Maronite	Maria	4.07%	Failed
2121	Catholic	Dima	3.71%	Failed
7922	Catholic	Elias	13.84%	Passed
324	Maronite	Gihad	0.57%	Failed
4332	Sunny	Abboud	7.57%	Passed
1332	Orthodox	Soubhi	2.33%	Failed
6021	Chiite	Iskandar	10.52%	Passed
3020	Druze	Choukri	5.28%	Failed
247	Orthodox	Rana	0.43%	Failed
5031	Maronite	Paul	8.79%	Passed
762	Maronite	Peter	1.33%	Failed
5228	Catholic	Nagib	9.14%	Passed
2690	Druze	Yarla	4.70%	Failed
4102	Catholic	Samira	7.17%	Passed
7017	Catholic	Henriette	12.26%	Passed
2763	Chiite	Youmna	4.83%	Failed
1987	Sunny	Antoinette	3.47%	Failed

Table B

	Voices	Names
Total number of voices for all candidates	57229
Total number of voices for Maronites	8447
Number of voices and the Name of 1st runner up	7922	Elias
Number of voices and the Name of 2nd runner up	7017	Henriette
Accepted as Deputy if cadidate percent is above	4.30%
Number of accepted as Deputy	10

Answer the question below.

1. Calculate the percentage values for Iskandar. (Hint: the ‘percentage value’ is equal to the number of voices divided by the Total Number of voices for all candidates. Its format is in %) (2 pts).
2. Explain what changes are to be done to the formula when you calculated the percentage value of Iskandar in order to get the correct percentages for the remaining candidates? (2 pts).
3. Use the function to calculate the Total number of voices for all candidates. (2pts)
4. Write the function to find Total number of voices for Maronites candidates (2 pt).
5. Write two functions to find the Number of voices and the Name of 1^st runner up respectively (4 pts).
6. Write two functions to find the Number of voices and the Name of 2^nd runner up respectively (4 pts).
7. Write the function to display “Passed” for each candidate having percentage value is greater then 4.3% otherwise the function displays “Fail”. (Hint do not use values in the formula) (3 pts)
8. Write the function to Number of accepted as Deputy who passed (2 pt).
9. Draw the pie chart for the number of voices (2 pts).

Answer 1

Number of Invoices	Sec	Name	First Percentge	Status
2330	Maronite	Maria	4%	Failed
2121	Catholic	Dima	4%	Failed
7922	Catholic	Elias	14%	Passed
324	Maronite	Gihad	1%	Failed
4332	Sunny	Abboud	8%	Passed
1332	Orthodox	Soubhi	2%	Failed
6021	Chiite	Iskandar	11%	Passed
3020	Druze	Choukri	5%	Failed
247	Orthodox	Rana	0%	Failed
5031	Maronite	Paul	9%	Passed
762	Maronite	Peter	1%	Failed
5228	Catholic	Nagib	9%	Passed
2690	Druze	Yarla	5%	Failed
4102	Catholic	Samira	7%	Passed
7017	Catholic	Henriette	12%	Passed
2763	Chiite	Youmna	5%	Failed
1987	Sunny	Antoinette	3%	Failed
Total num of Invoics	57229
Perentage of Iskandar	11%
Changes to be made are Numerator should b 57229-6021
Total number of Invoices of all candidates - Funtion to be used is =SUM()	57229
Total number of Invoices of Maronites - Funtion to be used is =SUMIF()
Total number of Invoices of Maronites - Funtion to be used is =SUMIF() for highest Percentage
Function to genrate pass or fail is - =IF("PERCENTAGE IS > 3.30%",PASS),FALSE)

Pie chart