The case presents five potential allocation bases for assigning the company's 300,000 in Plant' administration cost. Using the five year data presented in the case you should conceptually hypothesize which potential base would be the best choice. You need to look for the best correlation, or regression fit, with plant=administration cost. How do I put this in excel for a regression analysis? What data do I use on the Y and X axis?