Hello FrancillaAm new how can i get help in calculating the median age group for this group data
=SUM($C$5:C5)
=SUM($C$5:$C$22)
=$C$24/2
=INDEX($B$5:$B$22, MATCH(TRUE, $D$5:$D$22>=$F$5,0))
=LEFT($F$8,2)+($F$5-INDEX($D$5:$D$22, MATCH(VLOOKUP($F$8, $B$5:$D$22, 3, TRUE),$D$5:$D$22, 0) - 1))*(RIGHT($F$8,2)-LEFT($F$8,2))/$C$24
=IFERROR(LEFT($F$8,2)+($F$5-INDEX($D$5:$D$22, MATCH(VLOOKUP($F$8, $B$5:$D$22, 3, TRUE), $D$5:$D$22, 0) - 1))*(RIGHT($F$8,2)-LEFT($F$8,2))/$C$24,LEFT($F$8,2)+($F$5-INDEX($D$5:$D$22, MATCH(VLOOKUP($F$8, $B$5:$D$22, 3, TRUE), $D$5:$D$22, 0) - 1))*4/$C$24)
Grateful for your assistanceHello Francilla
Thanks for reaching out and posting your query. You wanted to calculate the median age group for a grouped dataset. I am delighted to inform you that I have solved your mentioned problem. I will introduce you to a mini calculator regarding your issue with error handling.
When solving your issue, I went through an article and found it very helpful. I recommend you go through the Article by clicking the following link.
Steps:
1. Cumulative Frequency
2. Total Frequency
3. Median Position
4. Median Age Group
5. Median Age
You can use the following formula to handle Errors when calculating the Median Age.
I have attached the solution Workbook to help you understand better. Don't hesitate to contact us again if you have any more questions.
Regards
Lutfor Rahman Shimanto
Greetings from ExcelDemy Forum. You are most welcome! Francilla.Grateful for your assistance
Grateful for your assistance
Dear FrancillaGood day i would like some help in solving these calculations i am not getting the final part of the formula correct
Dear FrancillaGrateful for your assistance am having difficulties reaching the final stage of the calculations
Median = l + (n / 2 - c) / f × h
=LEFT($C$28,2)+($D$24-INDEX($E$5:$E$21, MATCH(VLOOKUP($C$28, $C$5:$E$21, 3, TRUE), $E$5:$E$21, 0) - 1))*(RIGHT($C$28,2)-LEFT($C$28,2))/$D$22
Dear FrancillaI am so thankful for your help, yes i would like to learn the process
=LEFT($G$8,2)+($G$5-INDEX($D$5:$D$22, MATCH(VLOOKUP($G$8, $B$5:$D$22, 3, TRUE), $D$5:$D$22, 0) - 1))*(RIGHT($G$8,2)-LEFT($G$8,2))/VLOOKUP(G8,B5:D21,2,FALSE)