MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
Bartleby Related Questions Icon

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.
expand button
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
Check Mark
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman