The file P03_15.xlsx contains monthly data on the various components of the Consumer Price Index (CPI). The source claims that these data have not been seasonally adjusted. The following parts ask you to check this claim.

a. Create a new Month Name variable with values Jan, Feb, and so on. (Use Excel’s MONTH function and then a lookup table.)

b. Create side-by-side box plots of each component of the CPI (including the All Items variable), broken down by the Month Name variable from part a. What results would you expect for “not seasonally adjusted” data? Are your results in line with this?

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"