Homework Answers
excel o/p for regression-
| Regression Statistics | ||||||
| Multiple R | 0.9169 | |||||
| R Square | 0.8407 | |||||
| Adjusted R Square | 0.8319 | |||||
| Standard Error | 46.7294 | |||||
| Observations | 20 | |||||
| ANOVA | ||||||
| df | SS | MS | F | Significance F | ||
| Regression | 1 | 207441.7 | 207441.7 | 95.00 | 0.0000 | |
| Residual | 18 | 39305.5 | 2183.6379 | |||
| Total | 19 | 246747.2 | ||||
| Coefficients | Standard Error | t Stat | P-value | lower 95% | upper 95% | |
| Intercept | 69.908 | 30.269 | 2.310 | 0.0330 | 6.3146 | 133.502 |
| X | 0.146 | 0.015 | 9.747 | 0.0000 | 0.1147 | 0.1777 |
b)
Ŷ = 69.908 +
0.146 *x
=================
intercept= 69.908
-------------------------
slope interpretation=0.146
c)
R² = (Sxy)²/(Sx.Sy) = 0.841 with no units
Se=46.729 unit of thousand dolaars
answer for blanks : 84.1 % , 46.7 thousand dollars
d) option B)
value increases by=0.146 *511 = 74.7 thousand dollars
e)
Predicted Y at X= 2726 is
Ŷ = 69.9083 +
0.1462 *2726= 468.35
residual = 547000 - 46835 = 78.7thousand dollars
a home with this square footage and listing price is not a good deal. because it costs $78700 than most house of this size on average
Add Answer to:
(is/is not) (more/less)
Square_Feet Price_($000)
1,166 262
3,079 608
1,565 281
1,066 223
2,067 328
2,386...
Tests A division of a multinational retail company prepared a presentation to give at the home...
Tests A division of a multinational retail company prepared a presentation to give at the home office in Paris, France. The presentation includes a scatterplot that shows the relationship between square footage and annual sales in retail outlets owned by the chain. The units in the plot show the size in thousands of square feet and the response in thousands of dollars. A fitted line in the plot is y = 48 +683x. Complete parts a through d below. (a)...
Engine_Size Horsepower 5.9 488 6.0 404 6.2 416 3.4 249 3.0 251 3.5 262 3.8 299...
Engine_Size Horsepower
5.9 488
6.0 404
6.2 416
3.4 249
3.0 251
3.5 262
3.8 299
4.0 304
4.2 309
1.4 124
1.5 154
3.6 268
1.6 139
1.8 148
5.9 466
2.0 185
2.3 183
2.4 191
2.5 228
2.8 247
The accompanying data table includes the engine size (in liters) and horsepower (HP) of 20 types of cars sold last year. Complete parts (a) through (9) below. Click the icon to view the data table. (a) Create a...
Assets R&D_Expense 2,198.673 200.083 3,870.615 418.398 1,494.774 138.476 711.152 71.067 1,569.469 135.273 2,832.213 245.403 2,183.012 195.474...
Assets R&D_Expense
2,198.673 200.083
3,870.615 418.398
1,494.774 138.476
711.152 71.067
1,569.469 135.273
2,832.213 245.403
2,183.012 195.474
461.679 45.484
803.496 84.213
3,776.297 372.948
3,965.887 332.381
927.246 85.546
2,176.368 195.359
7,533.595 653.399
1,336.162 132.614
2,274.862 236.087
289.846 32.028
2,544.071 270.175
638.382 58.371
9,605.452 975.159
667.469 74.888
1,702.442 156.826
183.616 22.811
1,572.785 163.298
581.639 64.847
3,444.067 320.042
For 26 companies operating in several technology industries, the accompanying data gives the expenses on research and development (R&D) and the total assets of the companies....
File_Size_(MB) Transfer_Time_(sec) 48 17.3 59 30.3 81 27.8 74 24.3 22 8.3 21 12.9 31 16.4...
File_Size_(MB) Transfer_Time_(sec)
48 17.3
59 30.3
81 27.8
74 24.3
22 8.3
21 12.9
31 16.4
49 18.6
99 32.5
22 19.6
51 29.2
99 31.6
68 26.7
69 23.6
98 44.6
32 23.8
87 35.1
81 29.6
29 14.6
97 32.9
Before taking the plunge into videoconferencing, a company ran tests of its current internal computer network. The goal of the tests was to measure how rapidly data moved through the network given the current demand on the network....
(Just need help with part F) File_size_(MB) Time_(sec) 77 31.1 93 35.1 85 35.3 94 35.7...
(Just need help with part F)
File_size_(MB) Time_(sec)
77 31.1
93 35.1
85 35.3
94 35.7
20 14.4
74 28.9
68 29.6
88 33.5
42 21.7
20 15.3
72 28.4
24 11.5
95 35.7
59 25.6
93 36.6
71 29.1
87 34.3
92 37.2
90 35.6
67 26.8
87 32.6
83 31.2
80 34.1
57 22.8
52 25.4
76 28.9
96 38.7
70 31.8
59 24.2
57 28.1
Before taking the plunge into videoconferencing, a company ran tests of its...
Number_Of_Accounts Profit_From_Sales_($) 21 9232.93 18 18762.13 37 22865.68 15 11633.12 32 18140.04 41 32943.84 26 29576.92...
Number_Of_Accounts Profit_From_Sales_($)
21 9232.93
18 18762.13
37 22865.68
15 11633.12
32 18140.04
41 32943.84
26 29576.92
18 19703.92
35 25807.72
41 31237.05
10 3253.59
6 15075.03
24 14574.02
12 12445.49
9 12723.51
9 14512.76
10 21364.92
28 28498.28
7 9050.42
28 8610.41
11 10294.72
11 9929.32
5 9895.91
12 3856.93
18 15990.73
48 30129.54
38 31284.61
13 21861.74
6 16140.46
24 12031.41
15 16484.17
7 19620.39
25 16535.41
32 35548.76
22 22145.01
26 28670.93
Afirm that operates a large, direct-to-consumer...
Use the following information for the next two problems. A real estate agent is interested in...
Use the following information for the next two problems. A real estate agent is interested in the relationship between the size of a home (in square feet) and Y-the selling price in thousands of dollars). The equation of the least squares regression line is 47.82 +0.061x Which one of the following gives the correct interpretation of the slope? O a. Each additional square foot in the size is accompanied by an increase of 0.061 thousand dollars in the price O...
One of the biggest factors in determining the value of a home is the square footage....
One of the biggest factors in determining the value of a home is the square footage. The accompanying data represent the square footage and selling price (in thousands of dollars) for a random sample of homes for sale in a certain region. Complete parts (a) through (h) below. Square Footage Selling Price ($000s), y 2095 362.9 3122 364.9 1085 183.2 1935 331.9 3149 626.8 2772 370.3 3963 604.3 2170 370.5 2710 440.8 1695 296 1763 267.5 3723 675.7 (a) Which...
One of the biggest factors in determining the value of a home is the square footage....
One of the biggest factors in determining the value of a home is the square footage. The accompanying data represent the square footage and selling price (in thousands ofdollars) for a random sample of homes for sale in a certain region. Complete all parts below (A.) Which variable is the explanatory variable? a. selling price b. square footage Square Footage, x Selling Price ($000s), y 2221 382.7 3046 353.4 1175 197.2 1938 332.2 3166 630.2 2857 383.9 4086 623.6...
C) Interpret the summary values r2 and se associated with the fitted question. Attach units to...
C) Interpret the summary values r2 and se associated with the
fitted question. Attach units to these summary statistics as
appropriate.
r^2=
Se=
(Round to three decimal places as needed.)
D) What is the estimated difference in price (on average)
between diamond rings with diamonds that weigh 0.18 and 0.28
carat?
The difference is _ _ _ dollars.
(Round to the near dollar as needed.)
------
Weight (carats) Price (dollars)
0.15 284
0.21 470
0.34 1,017
0.12 206
0.30 893...
Tests A division of a multinational retail company prepared a presentation to give at the home office in Paris, France. The presentation includes a scatterplot that shows the relationship between square footage and annual sales in retail outlets owned by the chain. The units in the plot show the size in thousands of square feet and the response in thousands of dollars. A fitted line in the plot is y = 48 +683x. Complete parts a through d below. (a)...
Engine_Size Horsepower
5.9 488
6.0 404
6.2 416
3.4 249
3.0 251
3.5 262
3.8 299
4.0 304
4.2 309
1.4 124
1.5 154
3.6 268
1.6 139
1.8 148
5.9 466
2.0 185
2.3 183
2.4 191
2.5 228
2.8 247
The accompanying data table includes the engine size (in liters) and horsepower (HP) of 20 types of cars sold last year. Complete parts (a) through (9) below. Click the icon to view the data table. (a) Create a...
Assets R&D_Expense
2,198.673 200.083
3,870.615 418.398
1,494.774 138.476
711.152 71.067
1,569.469 135.273
2,832.213 245.403
2,183.012 195.474
461.679 45.484
803.496 84.213
3,776.297 372.948
3,965.887 332.381
927.246 85.546
2,176.368 195.359
7,533.595 653.399
1,336.162 132.614
2,274.862 236.087
289.846 32.028
2,544.071 270.175
638.382 58.371
9,605.452 975.159
667.469 74.888
1,702.442 156.826
183.616 22.811
1,572.785 163.298
581.639 64.847
3,444.067 320.042
For 26 companies operating in several technology industries, the accompanying data gives the expenses on research and development (R&D) and the total assets of the companies....
File_Size_(MB) Transfer_Time_(sec)
48 17.3
59 30.3
81 27.8
74 24.3
22 8.3
21 12.9
31 16.4
49 18.6
99 32.5
22 19.6
51 29.2
99 31.6
68 26.7
69 23.6
98 44.6
32 23.8
87 35.1
81 29.6
29 14.6
97 32.9
Before taking the plunge into videoconferencing, a company ran tests of its current internal computer network. The goal of the tests was to measure how rapidly data moved through the network given the current demand on the network....
(Just need help with part F)
File_size_(MB) Time_(sec)
77 31.1
93 35.1
85 35.3
94 35.7
20 14.4
74 28.9
68 29.6
88 33.5
42 21.7
20 15.3
72 28.4
24 11.5
95 35.7
59 25.6
93 36.6
71 29.1
87 34.3
92 37.2
90 35.6
67 26.8
87 32.6
83 31.2
80 34.1
57 22.8
52 25.4
76 28.9
96 38.7
70 31.8
59 24.2
57 28.1
Before taking the plunge into videoconferencing, a company ran tests of its...
Number_Of_Accounts Profit_From_Sales_($)
21 9232.93
18 18762.13
37 22865.68
15 11633.12
32 18140.04
41 32943.84
26 29576.92
18 19703.92
35 25807.72
41 31237.05
10 3253.59
6 15075.03
24 14574.02
12 12445.49
9 12723.51
9 14512.76
10 21364.92
28 28498.28
7 9050.42
28 8610.41
11 10294.72
11 9929.32
5 9895.91
12 3856.93
18 15990.73
48 30129.54
38 31284.61
13 21861.74
6 16140.46
24 12031.41
15 16484.17
7 19620.39
25 16535.41
32 35548.76
22 22145.01
26 28670.93
Afirm that operates a large, direct-to-consumer...
Use the following information for the next two problems. A real estate agent is interested in the relationship between the size of a home (in square feet) and Y-the selling price in thousands of dollars). The equation of the least squares regression line is 47.82 +0.061x Which one of the following gives the correct interpretation of the slope? O a. Each additional square foot in the size is accompanied by an increase of 0.061 thousand dollars in the price O...
C) Interpret the summary values r2 and se associated with the
fitted question. Attach units to these summary statistics as
appropriate.
r^2=
Se=
(Round to three decimal places as needed.)
D) What is the estimated difference in price (on average)
between diamond rings with diamonds that weigh 0.18 and 0.28
carat?
The difference is _ _ _ dollars.
(Round to the near dollar as needed.)
------
Weight (carats) Price (dollars)
0.15 284
0.21 470
0.34 1,017
0.12 206
0.30 893...
Most questions answered within 3 hours.
-
1. What is the meaning of the term communication style?
2. What are the benefits to...
asked 37 minutes ago -
9.) You are buying a car that cost $26,500. You make payments of
$412 each month...
asked 1 hour ago -
. Suppose a discrete random variable has probability
distribution
P(x) = .2 if x = 0...
asked 2 hours ago -
Problem #1
The area between Z = 0 and Z = 2.50
The area between Z...
asked 1 hour ago -
Under the influence of its drive force, a snowmobile is moving
at a constant velocity along...
asked 2 hours ago -
Why do organizations decline? What steps can top
management take to halt, decline, and restore organizational...
asked 2 hours ago -
What mechanisms Drive speciation??
(I.e. what was Dawins theory on the orgin of species, and how...
asked 4 hours ago -
The manager at a car assembly plant believes that the mean
assembly time for a car...
asked 5 hours ago -
Which of the following is true of electron capture?
A) It decreases the nuclide's mass number...
asked 6 hours ago -
Assuming an efficiency of 43.10%, calculate the actual yield of
magnesium nitrate formed from 114.9 g...
asked 7 hours ago -
The highly pathogenic bacterium Clostridium
perfringens causes gangrene, a disease that results in the
destruction of...
asked 8 hours ago -
In the context of situation analysis, which of the following is
a category for analysis in...
asked 8 hours ago