Question: Answers are given in blue. Please Solve ONLY USING EXCEL! Consider the following set of dependent and independent variables. Complete parts a through c below.







Answers are given in blue. Please Solve ONLY USING EXCEL!








Consider the following set of dependent and independent variables. Complete parts a through c below. 10 11 14 14 19 24 28 32 X1 1 6 6 9 12 17 20 16 10 13 11 3 8 8 3a. Using technology, construct a regression model using both independent variables. A = 9.4705 + 1.1516 X1 + - 0.2047 X2 ( Round to four decimal places as needed.)State thE CEIFICIUSlDH tIZIl' the tESt Elf significance fEIl' K1. Reject the null hypothesis. There is sufficient evidence to conclude that there is a relationship between H1 and tr. c. Interpret the pyalue for each independent variable. Interpret the pyalue forthe hypothesis test corresponding to x1 and 0:: 0.10. Since pyalue= 0005' is less than ' oz, reject ' the null hypothesis. There is sufficient evidence to conclude that there is ' a relationship between x1 and y. (Round to three decimal places as needed.) Interpret the pyalue forthe hypothesis test corresponding to x2 and 0;: 0.10. Since pyalue= 0562' is greaterthan 0:, do not reject the null hypothesis. There is insufficient evidence to conclude that there is ' a relationship between x2 and y. (Round to three decimal places as needed.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
