Wal-Mart data 05) The data in sheet Q5 contains information on the monthly stock price for Wal- Mart. The data includes the date, low price for the month, high price for the month, closing price for the month, and number of shares traded during the month. Create a time-series graph that shows the closing price for the month and the volume for the month on a single graph. Don't forget to use the date as labels. Date Nov-97 Dec-97 Jan-98 Feb-98 Mar-98 Apr-98 May-98 Jun-98 Jul-98 Aug-98 Sep-98 Oct-98 Nov-98 Dec-98 Jan-99 Feb-99 Mar-99 Apr-99 May-99 Jun-99 Jul-99 Aug-99 Sep-99 Oct-99 Nov-99 Dec-99 Jan-00 Feb-00 Mar-00 Apr-00 May-00 Jun-00 Jul-00 Aug-00 Sep-00 Oct-00 Nov-00 Dec-00 Jan-01 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01 Sep-01 Oct-01 Open 17.9498 19.7263 19.3605 20.0968 22.9196 24.9825 25. 1976 27.3793 30.309 30.8629 29.2936 26.619 34. 1672 36.6012 40.278 42.3135 42.9919 46.1549 45.3214 42.1723 47.4148 41.8511 43.8293 47.5272 56.6861 57.1193 67.752 54.4989 52.2694 56.1797 55.9316 56.6757 56.8618 53.6338 47.24 47.914 46.2361 52.3263 52.8896 56.5483 49.0317 49.8513 51.5662 51.3867 48.8744 55.3145 48.1556 49.5 High 20.0327 20.5534 20.5877 23.5332 25.6503 26.5189 27.7174 30.9552 34.3092 34.3708 31.9182 34.2289 38.08 40.8331 42.6527 44.1639 48.5939 52.7617 47.0502 47.9711 50.4439 47.9093 47.5272 57.9238 60.0897 69.6099 68.3713 59.5772 60.2722 64.4268 59.5281 59.5901 62.5107 57.2343 54.3787 48.349 51.8913 55.62 58.4896 56.5483 51.67 53.1415 54.5872 52.294 56.4128 56.6824 49.95 54.75 Low 17.5209 18.0411 18.44 19.7286 22.8275 23.6919 24.4601 27.2257 29.4167 28.1859 26.5574 25.8488 32.9349 35.2148 38.1808 39.7228 41.2649 42.6663 40.5052 41.6784 41.7893 38.4511 43.0875 47.094 54.4583 56.4386 53.0126 43.0417 45.2093 51.343 49.1107 51.219 53.8821 46.8054 46.6089 41.2023 42.3209 46.7295 50.214 47.8371 45.0656 47.269 50.8483 47.8572 46.6379 47.1671 41.9352 48.14 Close Volume 19.6345 2845300 19.3605 2404900 19.5445 2829400 22.7355 2872700 24.9825 3096200 24.8596 2843500 27.1028 2558200 29.909 2936600 31.0783 3041900 29.0475 3975200 26.9271 4749300 34.044 4397300 37.1249 3265000 40.1854 2740800 42.4368 3459300 42.4985 3423900 45.5375 3882600 45.4449 6775100 42.1106 8154600 47.7239 5954000 41.7893 5016500 43.8293 5815300 47.094 5069000 55.7578 7238300 57.0574 5713800 68.4952 6231100 54.2512 6787500 48.3058 11502000 56.0557 10073400 54.9395 7178400 57.1718 6563900 57.2343 5891900 54.8754 5364600 47.3021 8368500 47.8518 7547500 45.1174 9878800 51.8913 9351400 52.8896 8639300 56.5483 8567800 49.868 7207900 50.3498 7702100 51.5861 7487100 51.5961 6662200 48.7247 5827100 55.8137 7334600 47.9758 6585000 49.5 11621800 51.4 8171000
