[Steps Shown] The following table contains 25 observations by year of these variables. year Revenue per dollar Number of offices Profit Margin 1 3.92 7298


Question: The following table contains 25 observations by year of these variables.

year Revenue per
dollar
Number of
offices
Profit Margin
1 3.92 7298 0.75
2 3.61 6855 0.71
3 3.32 6636 0.66
4 3.07 6506 0.61
5 3.06 6450 0.7
6 3.11 6402 0.72
7 3.21 6368 0.77
8 3.26 6340 0.74
9 3.42 6349 0.9
10 3.42 6352 0.82
11 3.45 6361 0.75
12 3.58 6369 0.77
13 3.66 6546 0.78
14 3.78 6672 0.84
15 3.82 6890 0.79
16 3.97 7115 0.70
17 4.07 7327 0.68
18 4.25 7546 0.72
19 4.41 7931 0.55
20 4.49 8097 0.63
21 4.70 8468 0.56
22 4.58 8717 0.41
23 4.69 8991 0.51
24 4.71 9179 0.47
25 4.78 9318 0.32
  1. Develop an estimated regression equation that can be used to predict the annual profit margin using the information about revenue per dollar and number of offices.
  2. Interpret coefficients. How profit margin will change when the number of offices increases by 100?
  3. Compute the coefficient of determination and interpret it.
  4. At 95% confidence, determine which variables are significant and which are not.
  5. At 95% confidence, is the regression model significant?
  6. If in a given year, the number of offices is 9000 and revenue per dollar is $5, what would you expect the profit margin to be?

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in