Mean Median Minimum Maximum 75th percentile 25th percentile Interquartile Range Variance Standard Deviation 1 Convert the data into an Excel Table. 2 3 Create the same analysis completed in A3 to post the 4 summary statistics above each table column. But reference 5 6 the table columns with structured references (use the "Black Downward Arrow"pointing to the column header to reference the data table column) rather than highlighting the range of 3 8 cells within the table. 9 LO 11 SALE TYPE HOME TYPE ADDRESS 12 MLS Listing 13 MLS Listing 4 MLS Listing 5 MLS Listing 6 MLS Listing 17 MLS Listing 18 MLS Listing 19 MLS Listing 20 MLS Listing Mobile/Manufactured Home Single Family Residential Single Family Residential Single Family Residential Single Family Residential Single Family Residential Single Family Residential Single Family Residential Mobile/Manufactured Home 300 NW MAIN St 111 SE RONALD St 824 NW ORCHARD Dr 651 NE CHRISTIAN St 1787 UPPER CAMAS Rd 12661 LOOKINGGLASS Rd 100 KENYA Ct 1 MLS Listing 22 MLS Listing 23 MLS Listing 24 MLS Listing 25 MLS Listing 26 MLS Listing Single Family Residential Single Family Residential Mobile/Manufactured Home Mobile/Manufactured Home Mobile/Manufactured Home Mobile/Manufactured Home Single Family Residential 7 MLS Listing 1160 BROCKWAY Rd 401 SE GREGORY Dr 1068 RICE CREEK Rd 4546 MELODY Ln 2205 SE BOOTH Ave 4690 COOS BAY WAGON Rd 119 RUBY MAY Way 282 RIVER PLACE Dr Unit SP 62 1178 SE MYRTLE VIEW Dr 524 NE BROADWAY St 1740 RIVERSIDE Dr 170 SE WOODY Ct 330 NE BROADWAY St 867 NE HOLLY St 417 NE BROADWAY St 152 NE DEBBIE Way 600 NW T St 28 MLS Listing Single Family Residential 29 MLS Listing 30 MLS Listing 31 MLS Listing 12 MLS Listing 13 MLS Listing 4 MLS Listing Single Family Residential Single Family Residential Mobile/Manufactured Home Single Family Residential Single Family Residential Single Family Residential Single Family Residential Single Family Residential Multi-Family (2-4 Unit) Single Family Residential 5 MLS Listing 16 MLS Listing 17 MLS Listing 18 MLS Listing 237 HARMONY Dr 228 NW CIVIL BEND Ave 135 NE PLUM RIDGE Ct CITY Winston Winston Myrtle Creek Myrtle Creek Camas Valley Roseburg Winston Winston Winston Winston Roseburg Roseburg Roseburg Roseburg Roseburg Myrtle Creek Myrtle Creek Myrtle Creek Myrtle Creek Myrtle Creek Myrtle Creek Myrtle Creek Myrtle Creek Winston Roseburg Winston Winston i 1 Myrtle Creek 1.5 Camas Valley 3 1 Roseburg 5 3
