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 C 1 (118.57 KiB) Viewed 18 times

Horses and Ponies Residing at Dividing Ridge Farm April 1, 2022 Average Age Median Age Lowest Oldest Total of all Ages Combined Name Not Registered/Angel Not Registered/Bailey Excels Black Tie/BamBam DRF Beaux K/Beau Achaius Bellwether/Bell Celtic Harp/Celtic Excel's First Class/Classy Rockin Chocolate/CoCo Caddo Cowboy/Cowboy Divides Two To Tango/Deuce DRF Fleur de Lis/LeLe Independence Charger/Outlaw Purely My Pleasure/Pearly Divides A Wildflower/Rosie DRF Zips Hot Tamale/Tamale DRF Wright on Time/Tic Toc All Unzipped/Zip DOB 4/12/10 8/10/12 11/4/05 16/5/08 6/5/09 29/4/94 9/3/01 17/2/12 23/6/97 16/4/01 6/3/07 4/7/00 3/4/90 9/3/05 12/3/04 10/6/04 22/4/00 Age 9 7 14 11 10 25 18 7 22 18 12 19 29 14 15 15 19 COMP92 - Business Computer Applications Instructor: Rayan Yousif Assignment #2 - Microsoft Excel Due Date: Friday, July 8, 2022 @ 5:00pm Please download and perform the following functions to the document called - Assignment #2 - Data Set, available in week 10 on the E-Learning portal. Each task will be worth 1 point. Late assignments will NOT be graded. Please submit the document as an Excel document and save using the following naming convention: LastName_FirstName_Assignment2. Make sure to save your completed assignment as a .xlsx file Part A 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