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! Considerthe following set of dependent and independent variables. Complete parts a throughc below. 10 11 14 14 19 24 28 32 X1 16 6 9 12 17 20 16 10 13 11 3 88 3a. Using technology, construct a regression model using both independent variables.A = 9.4705 + 1.1516 X1 + - 0.2047 X2 ( Roundto four decimal places as needed.)State thE CEIFICIUSlDH tIZIl' the tESt Elf

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

significance fEIl' K1. Reject the null hypothesis. There is sufficient evidence toconclude that there is a relationship between H1 and tr. c. Interpretthe pyalue for each independent variable. Interpret the pyalue forthe hypothesis testcorresponding to x1 and 0:: 0.10. Since pyalue= 0005' is less than' oz, reject ' the null hypothesis. There is sufficient evidence toconclude that there is ' a relationship between x1 and y. (Roundto three decimal places as needed.) Interpret the pyalue forthe hypothesis testcorresponding to x2 and 0;: 0.10. Since pyalue= 0562' is greaterthan 0:,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!