Question: (please show your work for each question (including equations used and how to use them and the answers) Thank you PLEASE DONT JUST USE EXCEL

(please show your work for each question (including equations used and how to use them and the answers) Thank you PLEASE DONT JUST USE EXCEL show all the formulas that are used to get the answers please

2. 17.3 Xr17-03 The president of a company that manufactures drywall wants to analyze the variables that affect demand for his product. Drywall is used to construct walls in houses and offices. Consequently, the president decides to develop a regression model in which the dependent variable is monthly sales of drywall (in hundreds of 4 8 sheets) and the independent variables are as follows:

Number of building permits issued in the county

Five-year mortgage rates (in percentage points) Vacancy rate in apartments (in percentage points) Vacancy rate in office buildings (in percentage points)

To estimate a multiple regression model, he took monthly observations from the past 2 years.

a. Analyze the data using multiple regression.

b. What is the standard error of estimate? Can you use this statistic to assess the model's fit? If so, how?

c. What is the coefficient of determination, and what does it tell you about the regression model?

d. Test the overall validity of the model.

e. Interpret each of the coefficients.

f. Test to determine whether each of the independent variables is linearly related to drywall demand in this model.

Drywall

328

376

373

144

194

220

126

301

252

381

173

152

351

233

290

335

280

101

297

309

233

------------------------

Permits

---------------------------------

Mortgage

8.35

8.08

7.9

7.69

7.32

8.4

8.28

8.95

8.21

7.24

7.35

7.27

7.08

7.76

8.21

7.76

7.2

7.57

8.44

8.43

8.14

8.81

-------------------------

A Vacancy

2.98

5.6

2.25

4.26

2.6

2.97

5.35

3.13

5.6

4.81

5.88

2.98

5.69

4.86

5.68

4.46

2.23

2.42

3.25

3.61

2.13

4.35

2.31

-------------------------

O Vacancy

13.43

14.51

14.24

14.3

11.64

10.61

18.45

18.52

10.29

11.91

17.75

18.16

17.14

16.11

18.54

19.46

19.26

17.28

15.15

19.94

15.47

12.75

12.24

18.65

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!

(please show your work for each question (including equations used and how to use them and the answers) Thank you 2. 17.3 Xr17-03 The president of a company that manufactures drywall wants to analyze...

United Way of the Desert ' s Links to an external site. mission is to break the cycle of poverty in the Coachella Valley through engaging the caring power of the community. United Way of the Desert...

I ONLY need the formulas and excel function. I dont need the solutions for the answers I just need the appropriate formulas and excel function to solve the problem. Please show all work and use excel...

Hello I need help with this. Please answer the question with the formulas and excel function ONLY ! I dont need the solutions for the answers I just need the appropriate formulas and excel function...

I need more help with LP model then is provided i need the formulas in excel to complete this which this and other solutions di not have. Rick Eldridge is the new vice president for operations at the...

Hi, I need help with Part D and Part E. Please show all work, I need formulas and equations. Thank you in advance! On these Excel sheets, you will need to prepare a complete projected income...

SOLVE THE QUESTION ON EXCEL AND SHOW FORMULAS!!! Given the following - information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $8,625,000 NOI Growth...

1a. Jones Inc. issued a ten year bond that pays a coupon rate of 6.10 percent. Coupons are payable annually . If the market rate of interest is 5.75 percent, what is the market value of the bond? 1b....

*(Important Note) Please explain thoroughly and show your work in each question including how you get the mean, standard deviation and the sketches with your data. No rush and take your time to get...

United Way of the Desert 's (Links to an external site.) mission is to break the cycle of poverty in the Coachella Valley through engaging the caring power of the community. United Way of the Desert...

From the following data calculate the resulting discrepancy ratio. A forward measurement of 199.95 ft was recorded followed by a reverse measure of 200.05 ft between points A and B. a, 1/5000 b....

A local service entity is a popular business enterprise where many customers choose to patronize because of its superb brand of service. The owner, who is related to most people on island, is so...

BE20.17 (LO 3) Use the information for Rodgers Corporation and Packers, Inc. from BE20.16. Assume that for Packers, Inc., the lessor, the collectibility of the lease payments is probable, and the...

11.15 Management has stated that it will tolerate one stockout per year. The forecast of annual demand for a particular SKU is 100,000 units, and it is ordered in quantities of 10,000 units. The lead...

9. Take four examples from your own everyday life where someone has tried to influence you. Which of the seven influencing techniques mentioned above were used? Did they use any other influencing...

10. First test yourself and then let another member of the group test you in relation to the following questions. If deviations occur, discuss why this might be. What can the results of this test be...

5. Based on your desired future, answer the following questions: (a) What do you want, i.e. what goals have you set yourself? Set up three goals in order of priority. (b) Why do you want this? (c)...