Question

ill Sprint Wi-Fi 9:52 PM 59% X Excel Lab 5: Attempt 1 myLearn Take Test: Excel Lab 5 QUESTION 9 Use the Manufacturing database from "Excel Databases.xls" on Blackboard. Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, Number of Products, Value Added by Manufacture, New Capital Expenditures, and End-of-Year Inventories. Use Excel to perform a backward elimination regression analysis at a 5% level of significance. What independent variables are included in your final model? Check all that apply. Number of Employees Number of Products Value Added by Manufacture

Answer 1

an multiple Regression model one Dependendent variable = y more than one Independent variable = x,xa.... Here. Y=predicted value = cost of material by number of employee x = Number of product X 2= value added by manufactan x 3= new capital expediture x 4 = End of year inventories. in Independent variable are x = Number of product X2= value added by manufacture