The managers in the region are interested in opening a new store with expected revenues of $22.5 million. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-17), what are the estimated store costs for store SE-17 using the results from this regression? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places. Store cost
The managers in the region are interested in opening a new store with expected revenues of $22.5 million. Assuming the data and cost estimates from the current stores are appropriate for the new store (SE-17), what are the estimated store costs for store SE-17 using the results from this regression? Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places. Store cost
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Hardev
![!
Required information
[The following information applies to the questions displayed below.]
Waveney DIY Centers (WDC) operates a few dozen stores in the eastern United States. The stores are popular with home
remodelers, contractors, and do-it-yourself customers. The managers at Waveney are interested in understanding what
drives costs as well as getting better cost estimates when planning new stores. The area manager for the Southeast
Region is interested in new data analysis approaches to management and offered to run a test using data from the 14
stores in the region.
The initial thoughts of the managers and the financial analysts in the region were that two primary factors drove store
costs: store area (square footage) and revenue. The following data were collected from the most recent year of operations
(revenues and costs in thousands of dollars).
Store
SE-01
SE-02
SE-03
SE-04
SE-05
SE-06
SE-07
SE-08
SE-09
SE-10
SE-11
SE-12
SE-13
SE-14
Revenues
($000)
$ 21,245
16, 182
26,421
20,089
20,366
18,456
25,205
13,401
23,781
16,530
21, 058
17,820
14,374
23,604
Area
(Square Feet)
Store cost
69,847
52,117
84,031
68,074
59,209
68,074
96,448
46,798
78,712
62, 755
66,301
73,393
62,755
75, 166
Costs
($000)
$16,499
13,195
19,910
15,779
15,812
14,799
19,391
11,447
18,153
13,564
16,333
14,497
12,270
17,994
Results from a regression of store costs on revenues are as follows.
Equation:
Store costs = $2,941.22 (in thousands) + (71.6 % × Revenue)
Statistical data
Correlation coefficient
0.999
0.998
R²
Required:
The managers in the region are interested in opening a new store with expected revenues of $22.5 million. Assuming the data and
cost estimates from the current stores are appropriate for the new store (SE-17), what are the estimated store costs for store SE-17
using the results from this regression?
Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffb099cd5-593f-478c-8f3a-c7e347055560%2Fe54e70be-76aa-4eaa-99dc-2e9b8805fc92%2F3r2qmbh_processed.jpeg&w=3840&q=75)
Transcribed Image Text:!
Required information
[The following information applies to the questions displayed below.]
Waveney DIY Centers (WDC) operates a few dozen stores in the eastern United States. The stores are popular with home
remodelers, contractors, and do-it-yourself customers. The managers at Waveney are interested in understanding what
drives costs as well as getting better cost estimates when planning new stores. The area manager for the Southeast
Region is interested in new data analysis approaches to management and offered to run a test using data from the 14
stores in the region.
The initial thoughts of the managers and the financial analysts in the region were that two primary factors drove store
costs: store area (square footage) and revenue. The following data were collected from the most recent year of operations
(revenues and costs in thousands of dollars).
Store
SE-01
SE-02
SE-03
SE-04
SE-05
SE-06
SE-07
SE-08
SE-09
SE-10
SE-11
SE-12
SE-13
SE-14
Revenues
($000)
$ 21,245
16, 182
26,421
20,089
20,366
18,456
25,205
13,401
23,781
16,530
21, 058
17,820
14,374
23,604
Area
(Square Feet)
Store cost
69,847
52,117
84,031
68,074
59,209
68,074
96,448
46,798
78,712
62, 755
66,301
73,393
62,755
75, 166
Costs
($000)
$16,499
13,195
19,910
15,779
15,812
14,799
19,391
11,447
18,153
13,564
16,333
14,497
12,270
17,994
Results from a regression of store costs on revenues are as follows.
Equation:
Store costs = $2,941.22 (in thousands) + (71.6 % × Revenue)
Statistical data
Correlation coefficient
0.999
0.998
R²
Required:
The managers in the region are interested in opening a new store with expected revenues of $22.5 million. Assuming the data and
cost estimates from the current stores are appropriate for the new store (SE-17), what are the estimated store costs for store SE-17
using the results from this regression?
Note: Do not round your intermediate calculations. Enter your answer in thousands of dollars rounded to 2 decimal places.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman