Please tell me how to get all these answers by Using EXCEL
Use technology together with data filtering or querying to separate the data into the yearly data for each month, and then create sparklines for each month's median sales price by year.
The data available here ( 2 ) includes the median sales price of new single-family houses sold in the United States recorded at the end of each month from January 2000 through December 2016. Complete parts (a) through (c) below. a. Construct sparklines of new home sales prices by year. Graph the sparkline for the January median house sale prices. Choose the correct answer below. A. OB. OC. OD Graph the sparkline for the February median house sale prices. Choose the correct answer below. OA . OC. Homessold 68 77 88 77 77 71 77 74 70 70 63 66 72 85 94 85 80 80 76 75 Period Jan-2000 Feb-2000 Mar-2000 Apr-2000 May-2000 Jun-2000 Jul-2000 Aug-2000 Sep-2000 Oct-2000 Nov-2000 Dec-2000 Jan-2001 Feb-2001 Mar-2001 Apr-2001 May-2001 Jun-2001 Jul-2001 Aug-2001 Sep-2001 Oct-2001 Nov-2001 Dec-2001 Jan-2002 Feb-2002 Mar-2002 Apr-2002 May-2002 Jun-2002 Jul-2002 Aug-2002 Sep-2002 Oct-2002 Nov-2002 Dec-2002 Jan-2003 Feb-2003 Mar-2003 Apr-2003 May-2003 Jun-2003 Jul-2003 Aug-2003 Sep-2003 Oct-2003 Nov-2003 Dec-2003 66 67 68 67 66 84 90 Home Sale Price ($) 174699 166601 164701 160100 161999 162401 163500 169001 162600 171499 165099 176299 168099 173699 175300 179399 180201 169099 171300 174999 175199 166401 166301 171300 181199 178900 181001 190600 197600 191101 187099 175600 187100 177501 183399 189199 207101 190500 195499 187900 196000 186999 181700 190199 189501 192001 185099 194100 86 89 83 83 89 83 76 73 70 77 83 98 92 102 108 98 104 91 89 77 74 The data available here ( 2 ) includes the median sales price of new single-family houses sold in the United States recorded at the end of each month from January 2000 through December 2016. Complete parts (a) through (c) below. a. Construct sparklines of new home sales prices by year. Graph the sparkline for the January median house sale prices. Choose the correct answer below. A. OB. OC. OD Graph the sparkline for the February median house sale prices. Choose the correct answer below. OA . OC. Homessold 68 77 88 77 77 71 77 74 70 70 63 66 72 85 94 85 80 80 76 75 Period Jan-2000 Feb-2000 Mar-2000 Apr-2000 May-2000 Jun-2000 Jul-2000 Aug-2000 Sep-2000 Oct-2000 Nov-2000 Dec-2000 Jan-2001 Feb-2001 Mar-2001 Apr-2001 May-2001 Jun-2001 Jul-2001 Aug-2001 Sep-2001 Oct-2001 Nov-2001 Dec-2001 Jan-2002 Feb-2002 Mar-2002 Apr-2002 May-2002 Jun-2002 Jul-2002 Aug-2002 Sep-2002 Oct-2002 Nov-2002 Dec-2002 Jan-2003 Feb-2003 Mar-2003 Apr-2003 May-2003 Jun-2003 Jul-2003 Aug-2003 Sep-2003 Oct-2003 Nov-2003 Dec-2003 66 67 68 67 66 84 90 Home Sale Price ($) 174699 166601 164701 160100 161999 162401 163500 169001 162600 171499 165099 176299 168099 173699 175300 179399 180201 169099 171300 174999 175199 166401 166301 171300 181199 178900 181001 190600 197600 191101 187099 175600 187100 177501 183399 189199 207101 190500 195499 187900 196000 186999 181700 190199 189501 192001 185099 194100 86 89 83 83 89 83 76 73 70 77 83 98 92 102 108 98 104 91 89 77 74
