In: Math
I need to time series plot the following data. I am confused since there are multiple sections (441, 442, 443, 444, 445, 452, 4521. This is just two years worth of the data.
Year | Month | Period | 441 | 442,443 | 444 | 445 | 448 | 452 | 4521 |
1992 | Jan | 1 | 1.84 | 1.85 | 1.83 | 0.88 | 2.58 | 2.39 | 2.60 |
1992 | Feb | 2 | 1.83 | 1.85 | 1.83 | 0.89 | 2.62 | 2.34 | 2.53 |
1992 | Mar | 3 | 1.87 | 1.90 | 1.83 | 0.88 | 2.63 | 2.35 | 2.53 |
1992 | April | 4 | 1.89 | 1.91 | 1.91 | 0.89 | 2.60 | 2.37 | 2.56 |
1992 | May | 5 | 1.88 | 1.93 | 1.88 | 0.89 | 2.64 | 2.33 | 2.50 |
1992 | June | 6 | 1.88 | 1.90 | 1.90 | 0.89 | 2.61 | 2.37 | 2.54 |
1992 | July | 7 | 1.94 | 1.90 | 1.92 | 0.88 | 2.63 | 2.43 | 2.62 |
1992 | Aug | 8 | 1.95 | 1.92 | 1.90 | 0.87 | 2.62 | 2.36 | 2.54 |
1992 | Sept | 9 | 1.88 | 1.92 | 1.90 | 0.88 | 2.59 | 2.36 | 2.54 |
1992 | Oct | 10 | 1.87 | 1.90 | 1.91 | 0.88 | 2.59 | 2.36 | 2.54 |
1992 | Nov | 11 | 1.89 | 1.93 | 1.93 | 0.88 | 2.66 | 2.33 | 2.52 |
1992 | Dec | 12 | 1.91 | 2.00 | 1.90 | 0.88 | 2.65 | 2.27 | 2.47 |
1993 | Jan | 13 | 1.84 | 1.91 | 1.89 | 0.88 | 2.62 | 2.37 | 2.55 |
1993 | Feb | 14 | 1.92 | 1.94 | 1.89 | 0.88 | 2.73 | 2.41 | 2.62 |
1993 | Mar | 15 | 2.00 | 1.97 | 1.94 | 0.89 | 2.80 | 2.47 | 2.69 |
1993 | April | 16 | 1.86 | 1.94 | 1.90 | 0.89 | 2.71 | 2.41 | 2.61 |
1993 | May | 17 | 1.83 | 1.93 | 1.85 | 0.89 | 2.69 | 2.39 | 2.60 |
1993 | June | 18 | 1.85 | 1.96 | 1.87 | 0.89 | 2.69 | 2.39 | 2.59 |
1993 | July | 19 | 1.80 | 1.93 | 1.86 | 0.88 | 2.66 | 2.36 | 2.56 |
1993 | Aug | 20 | 1.76 | 1.95 | 1.86 | 0.88 | 2.70 | 2.37 | 2.56 |
1993 | Sept | 21 | 1.80 | 1.95 | 1.88 | 0.88 | 2.67 | 2.36 | 2.56 |
1993 | Oct | 22 | 1.79 | 1.94 | 1.87 | 0.88 | 2.67 | 2.34 | 2.53 |
1993 | Nov | 23 | 1.77 | 1.95 | 1.82 | 0.87 | 2.69 | 2.35 | 2.54 |
1993 | Dec | 24 | 1.76 | 2.02 | 1.80 | 0.87 | 2.69 | 2.33 | 2.53 |
You can also change the scaling in Excel that is represented on the Y-Axis if required.