Home Insert Draw Page Layout Formulas Data Review View Tell me Share com Calibri (Body) v 11 VA A ab v General Conditional Formatting Insert v Paste E Format as Table Ex Delete BIUVV MVAv 2 7 V ~ % 9 Cell Styles v Editing Analyse Format v Data H16 X V fx B C D E F G H 1 J K L M N 0 P Q R S Last_Name First_Name Property_Type Purchase_Price BIN Peters Gail Residential 195,909.00 80,000.00 Cannon Elizabeth Commercial 168,101.00 90,000.0 Welch Stephanie Residential 162,757.00 100,000.00 5 Walton Sylvia Residential 142,549.00 150,000.00 6 Luca Kathleen Commercial 369,966.00 200,000.00 7 Love Beverly Commercial $42,643.00 250,000.00 8 Burke Dawn Commercial 431,133.00 300,000.00 9 Baldwin Carl Commercial 131,638.00 350,000.00 10 Hill eronica Residential 405,006.00 400,000.00 11 Smith Gloria Rental 142,631.00 12 Stone Helen Rental 264,196.00 $ 50,904,084.00 13 Mcco regory Rental 133,003.00 14 Knight Antonio Commercial 191,552.00 Chart Title 15 Price Dale Residential 208,599.00 16 Schneider Shawn Rental 186,184.00 17 Ramse Christine Rental 119,203.00 18 llia Commercial 346,521.00 19 Frazier Joanne Commercial 416,807.00 20 Adam Victoria Residential 117,817.00 21 Love Villie Residential 375,597.00 22 Mullins Sara Residential 103,139.00 23 Berry Ella Residential 359,590.00 24 Cohen Sheila Rental 254,402.00 25 Newton Dolores Residentia 90,787.00 26 S Marcus Residential 223,802.00 ( $144,435.00... ( $278,435.00.. ( $412,435.00.. 27 Wolfe Florence Residential [ $77,435.00 ,... 248,013.00 ( $211,435.00... ( $345,435.00... 28 Taylor Alice Residential 124,902.00 29 Rodriquez Alice Rental 386,697.00 30 Mann Rose Commercia 409,437.00 31 Marshall tanley Residential 236,841.00 32 Keller Katherine Rental 120,982.00 33 Benson Richard Commercial 256,480.00 34 Ingram Tina Residential 147,766.00 35 Bishop rederick Rental 366,512.00 36 Williamson Erica Commercial 110,442.00 37 Bowman Brittany Commercial 226,438.00 38 Knight Samantha Rental 113,850.00 39 Morris Marion Residential $70,003.00 40 Lawson Joanne Residentia 317,150.00 41 Glove William Commercial 13,889.00 42 Schmid ason Rental 77,435.00 13 Adams Todd Renta $92,466.00 44 Munoz Leroy Residential 181,568.00 45 Lynch Eugene Rental 311,122.00 an 1 Clients For_Sale Mortgage_Calculations Forecast +0n the Clients worksheet. use Data Analysis tools to calculate descriptive statistics for the purchase price data in the range D2:D201. Be sure to include column headings and summary statistics. Place the results in cell G12 and resize the columns as needed. Use the Data Analysis Tools to create a histogram of the purchase price data in the range D1 :D201. Include labels. chart output. and percentages. Place the output in J1 and position the chart so the upper-left comer starts inside the borders of cell J13. Using the range A1 :D201 on the Clients worksheet, create a PivotTable on a new worksheet. Add mm to the rows area and mm the values area. Apply Accounting Number Format to the range 34:36. Create a 2-D pie PivotChart based on the data. Edit the chart title to Purchase Price by Property Type. Insert a slicer the starts inside the border of cell A9 based on property type