Problem 2. (7 points total). X-act Global Manufacturing (XGM) is trying to budget for its Shipping Department costs for 2023 . To predict those cost, XGM is examining 2022 costs. Exhibit 1 shows Shipping Department cost for every month in 2022 and the associated tons shipped for that month. Exhibit 1. Shipping Cost and Tons Shipped, 2022 A. ( 3 points). Create a scattergraph of Shipping Department cost and tons shipped in 2022 and insert below. Label and put "Shipping Cost" on the vertical axis and the "Tons Shipped" on the horizontal axis. Please insert a regression line through the data points and insert the regression cost formula and R2 calculation on to the graph. Adjust the intersection of X and Y axis to $500,000 of shipping cost and 5,000 tons shipped. Remove borders and all gridlines. Do not set the regression intercept to 0. When complete, INSERT the Excel graphic here. B. (1 points). What percent of the variability in monthly Maintenance Department cost is explained by the number of setups? C. (2 points). Based on the regression analysis, what would be the predicted Shipping Department costs for January 2023 if 20,000 tons of product are shipped? SHOW CALCULATION OR NO POINTS WILL BE GIVEN D. (1 point). Based on analysis of linear regression and visual inspection of the data, how might the cost formula for XGM be improved