Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Mathematical Economics Volume 19

Authors: Shigeo Kusuoka, Toru Maruyama

1st Edition

4431554890, 9784431554899

More Books

Students also viewed these Mathematics questions

Question

How are standard costs used in the control process?

Answered: 1 week ago