## [answered] BUSS 3303 Homework Chapter 13 1. A regional planner is stud

need the answer to this homework asap thanks

ok please let me now if you can do it?

BUSS 3303 Homework Chapter 13

1. A regional planner is studying the demographics in a region of a particular state. She has

gathered the following data on nine counties.

County

A

B

C

D

E

F

G

H

J Median Income

\$48,157

48,568

46,816

34,876

35,478

34,465

35,026

38,599

33,315 Median Age

57.7

60.7

47.9

38.4

42.8

35.4

39.5

65.6

27.0 Coastal

1

1

1

0

0

0

0

0

0 a) Which variable is the ?dependent? variable?

b) Use excel software to determine the regression equation. Interpret the value of the slope in a

simple regression equation.

c) Include the aspect that the county is ?coastal? or not in a multiple linear regression analysis

using a ?dummy? variable. Does it appear to be a significant influence on incomes?

d) Test each of the individual coefficients to see if they are significant.

2. A real estate developer wishes to study to relationship between the size of home a client will

purchase (in square feet) and other variables. Possible independent variables included the

family income, family size, whether there is a senior adult parent living with the family (1 for

yes, 0 for no), and the total years of education beyond high school for the husband and wife.

The sample information is reported below.

Family

1

2

3

4

5

6

7

8

9

10 Square Feet

2,240

2,380

3,640

3,360

3,080

2,940

4,480

2,520

4,200

2,800 Income(000s)

60.8

68.4

104.5

89.3

72.2

114

125.4

83.6

133

95 Family Size

2

2

3

4

4

3

6

3

5

3 Senior Parent

0

1

0

1

0

1

0

0

0

0 Education

4

6

7

0

2

10

6

8

2

6 a) Use excel software to develop an appropriate multiple regression equation? Interpret the value

of the slope in a simple regression equation.

b) Test each of the individual coefficients to see if they are significant. Interpret your results.

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001005903.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor