Quotation Table

44. FILE Quotations. The labor estimation group at Sturdy Electronics, a contract electronics manufacturer of printed circuit boards, wants to simplify the process it uses to quote production costs to potential customers. It has identified the primary drivers for production time and thus production cost) as being the number of electronic parts that can be machine-installed and the number of parts that must be manually installed. Accordingly, it wishes to develop a multiple regression model to predict production time, measured as minutes per board, using a random sample of 25 recent product quotations. A portion of the data is shown in the accompanying table. Manual Parts Production Time 9.1 Machine Parts 275 14 10.8 446 12 : 15.5 618 16 What is the sample regression equation? b. Predict production time for a circuit board with 475 machine-installed components and 16 manually installed components. C. What proportion of the sample variability in production time is explained by the two predictor variables? d. At the 5% significance level, are the predictor variables jointly significant? Are they individually significant? explain the dependent/response and independent/predictor variables in this example; solve the regression using Excel answer parts a,b,c,d, A B D E Manual Parts 14 12 18 7 15 18 17 24 20 15 11 Production Time 9.1 10.8 16.2 9.7 12.7 15.5 15.6 18.4 19.2 11.1 10.6 17.8 9.9 12.9 14.5 16.6 18.1 18.9 9.8 10.7 16.7 10.1 12.6 15.3 15.5 Machine Parts 275 446 631 388 511 579 622 334 493 325 435 642 393 533 555 630 325 476 288 444 655 398 502 577 618 18 8 15 17 18 22 19 14 12 19 9 15 17 16