Please use the data below after the question to answer the question

For each of the scenarios below, use Excel to access the data (See the instructions of this assignment for the link to download the data in the le MSIT71007HW7Data.xls), construct the appropriate scatterplot(s), and produce the regression output relating y to x('s). Provide the values of the regression coefcients from each regression output, as well as predictions, and interpret your results. (Round all numeric answers to two decimal places.) (a) Pricing Communications Nodes: Build a regression model to predict the cost of installing a communication node (COST) from the number of access ports (NUMPORTS), bandwidth (BANDWIDTH), and portspeed (PORTSPEED). The COST is measured in U.S. dollars. The data are in the worksheet named COMNODE. Therefore, the cost of installing a new communication node is estimated to increase on average by S dollars for every one unit increase in bandwidth (holding all other variables xed). Furthermore, the estimated fixed cost of installing a new communication node is estimated to be on average I: dollars, however this may not be a valid estimate due to lack of data in that region. The predicted total cost of installing a new communication node with 50 access ports and a bandwidth of 100 and a portspeed of 500 is \\:| dollars. (b) Cost Control: The Apex Corporation wants to improve is cost control program. Build a regression model to predict the total manufacturing cost per month from the variables identied in the table below. The data are contained in the worksheet named COST. y, total manufacturing cost per month in thousands of dollars (COST) x1, total production of paper per month in tons (PAPER) x2, total machine hours used per month (MACHINE) x3, total variable overhead costs per month in thousands of dollars (OVERHEAD) x4, total direct labor hours used each month (LABOR) 9= M |X1+i |X2+i iXs+i X4 The total monthly cost is estimated to increase by E dollars for a one hour increase in total machine hours used per month . The predicted total monthly cost for a month with 550 tons of total paper production, 300 total machine hours, $120,000 in overhead costs, and 500 direct labor hours is S thousands of dollars.