The hiring managers for this organization want to plan their recruitment budget for the next year, but they have not yet heard from upper management about how much funding they will receive for hiring purposes. Therefore, they want to predict how much management will allot based on the trends of past funding First, you will need to transpose your data so the months are aligned vertically. I recommend pasting it into a different sheet and saving the original data set. Your transposed data set should have the months in one column and the employment source as different columns. E.g., this snippet: A B Billboard $520.00 $520.00 $520.00 $520.00 1 Employment Source 2 January 3 February 4 March 5 April 6 May 7 June 8 July 9 August . September .1 October .2 November .3 December $- $- D E F Careerbuilde Company Int Diversity Job Employ $410.00 $- $- $- $410.00 $- $5,129.00 $- $410.00 $- $- $- $820.00 $- $- $- $820.00 $- $- $- $410.00 $- $- $- $410.00 $- $- $- $820.00 $- $4,892.00 $- $820.00 $- $- $- $1,230.00 $- $- $- $820.00 $- $- $- $410.00 $- $- $- $612.00 $612.00 $729.00 $749.00 $910.00 $500.00 Then you will need to re-code the months so that they are numeric. Make January a 1, February a 2, March a 3, and so on until December is 12. Last, run a simple regression predicting Newspaper/Magazine funding from Month. (Only use the months 1-12). What is the value the b efficient that describes the relationship between Months and Newspaper/Magazine funding? Round to 1 decimal place