Analyze the data using multiple regression

Assignment Help Basic Statistics
Reference no: EM13236806

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 4x8 sheets and the independent variables are

Number of building permits issued in the county

Five year mortgage rates (in percentage points)

Vacancy rate in apartments (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

g. Predict next month's drywall sales with 95% confidence if the number of building permits is 50,the 5-year mortgage rate is 9.0% and the vacancy rates are 3.6% in apartments and 14.3% in office buildings.

Drywall

Permits

Mortgage

A Vacancy

O Vacancy


328

49

8.35

2.98

13.43


376

79

8.08

5.6

14.51


373

79

7.9

2.25

14.24


144

50

7.69

4.26

14.3


194

37

7

2.6

11.64


220

53

7.32

2.97

10.61


126

22

8.4

5.35

18.45


301

69

8.28

3.13

18.52


54

21

8

5.6

10.29


252

46

8.95

4.81

11.91


381

79

8.21

5.88

17.75


173

30

7.24

2.98

18.16


152

38

7.35

5.69

17.14


351

73

7.27

4.86

16.11


233

55

7.08

5.68

18.54


35

12

7.76

4.46

19.46


290

62

8.21

2.23

19.26


5

12

7.76

5

17.28


335

60

7.2

2.42

15.15


280

49

7.57

3.25

19.94


101

14

8.44

3.61

15.47


297

66

8.43

2.13

12.75


309

62

8.14

4.35

12.24


233

40

8.81

2.31

18.65


 

Reference no: EM13236806

Questions Cloud

Find the competitive equilibrium relative price : Consider a two-good exchange economy with two individuals, A and B. A's preference is represented by uA(xA1, xA2) = 0.3ln(xA1) + 0.7ln(xA2), and B's is represented by uB(xB1, xB2) = 0.8ln(xB1) + 0.2ln(xB2).
Explain why current account deficit must be financed : The United States is a debtor nation, just like the poorest states in Africa, Latin America, and Asia. For most of the past 30 years the United States has been piling up large trade deficits. The current account has now reached a deficit
Why was clerk willing to offer a buy one get one free deal : The clerk answered, "I can't do that." When the customer started to leave the store, the clerk hastily offered, "However, I am authorized to give you a 40 percent discount on any pair in the store.
What is the current flowing in the ring : Imagine that in a certain proton accelerator, roughly 1011 protons at a time go around a ring having a radius of 4.0 km, What is the current flowing in the ring, in amperes
Analyze the data using multiple regression : Analyze the data using multiple regression and what is the standard error of estimate? Can you use this statistic to assess the model's fit?
What is naoh solution volume : An NaOH solution contains 2.6 mol of NaOH, and its concentration is 1.3 M. What is its volume?
Define mass os nabr can be dissolved in 300 grams of water : If the solubility of NaBr at 25 degree C is 14.3 g/100 g H2O, what mass os NaBr can be dissolved in 300 grams of water
What is janets demand function for gasoline per week : Janet spends 5% of her income on gasoline and her utility function is Cobb-Douglas. If her income is $1000 per week, what is her demand function for gasoline per week
Graph the relationship between the two variables : Graph the relationship between the two variables and is there sufficient evidence to infer that height and length of index fingers are linearly related?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd