Horses and Ponies Residing at Dividing Ridge Farm April 1, 2022 Average Age Median Age Lowest Oldest Total of all Ages C

[answerhappygod]

Horses and Ponies Residing at Dividing Ridge Farm April 1, 2022 Average Age Median Age Lowest Oldest Total of all Ages Combined Name DOB Age Not Registered/Angel 12/4/10 9 Not Registered/Bailey 10/8/12 7 Excels Black Tie/BamBam 4/11/05 14 DRF Beaux K/Beau 5/16/08 11 Achaius Bellwether/Bell 5/6/09 10 Celtic Harp/Celtic 4/29/94 25 Excel's First Class/Classy 3/9/01 18 Rockin Chocolate/CoCo 2/17/12 7 Caddo Cowboy/Cowboy 6/23/97 22 Divides Two To Tango/Deuce 4/16/01 18 DRF Fleur de Lis/LeLe 3/6/07 12 Independence Charger/Outlaw 7/4/00 19 Purely My Pleasure/Pearly 4/3/90 29 Divides A Wildflower/Rosie 3/9/05 14 DRF Zips Hot Tamale/Tamale 3/12/04 15 DRF Wright on Time/TicToc 6/10/04 15 All Unzipped/Zip 4/22/00 19
Please use the data to calculate the following formulas – please include the formulas in the highlighted cells:
1) Calculate the Average Age
2) Calculate the Median Age
3) Calculate the Youngest Age
4) Calculate the Oldest Age
5) Calculate the Total of All Ages Combined
Part B
Please use data to create a 2D Clustered Column Graph showing the name of the horses and the age. Please include the following Elements:
1) Axes
2) Axis titles: X-axis should be title “Name” and y-axis should be title “Age”
3) Chart Title: Age of Horses
4) Data Labels
5) Trendline