Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following multiple regression is constructed to estimate monthly sales for BEL furniture Stores in Texas. SUMMARY OUTPUT Regression Statistics Multiple R R Square

image text in transcribed

The following multiple regression is constructed to estimate monthly sales for BEL furniture Stores in Texas. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.936584 0.953179 0.931556 17.64924 27 ANOVA df Regression 5 Residual 21 Total 26 SS 952538.9 6541.41 959080.4 MS 190507.8 311.4957 F 611.5904 Significance F 5.39731E-22 Coefficients Standard Error Intercept 18000 30.15023 t Stat -0.62551 P-value 0.538372 Lower 95% -81.56024554 Sq. Ft. Inventory Advertising Market Size #of Competitors 16.20 3.544437 4.570986 0.000166 8.830512669 0.17 0.057606 3.031541 0.006347 0.054836778 11.53 2.532103 4.552053 0.000174 6.260471952 13.58 1.770457 5000.00 1.705427 7.670514 -3.11416 1.61E-07 0.005249 9.898446822 8.857600053 Find estimated sales for a store with 20,000 sq. ft. of showroom, $4,000,000 in inventory, $80,000 in advertising, market size of 15,000 families, and 25 local c 2,023,100 2.005.100

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial statements

Authors: Stephen Barrad

5th Edition

978-007802531, 9780324186383, 032418638X

More Books

Students also viewed these Finance questions

Question

EXCEL

Answered: 1 week ago