Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help select best answer You own a bakery and decide to compare your weekly flour consumption in pounds (x - input variable) and the sales

Help select best answer

image text in transcribed
You own a bakery and decide to compare your weekly flour consumption in pounds (x - input variable) and the sales you make in dollars (y -output variable) each week. You enter your raw data into Excel and run a simple linear regression. Below are your summary output results. Referencing Figure 1 Excel summary output shown, predict sales based on consuming 5000 lbs. of flour. Summary Output Regression Statistics Multiple R 0.7021 R Square 0.4929 Adjusted R Square 0.5120 Standard Error 24.1940 Observations 10 ANOVA df SS MS F Significance F Regression 1 6129.716 6129.716 10.472 0.012 Residual CO 4682.784 585.348 Total 10812.500 Co- Standard efficients Error t Stat P-value Lower Upper Lower Upper 95% 95% 95.0% 95.0% Intercept -245.42 113.65 -1.89 0.10 -476.54 47.63 476.54 47.63 X Variable 1 2.65 1.71 3.24 0.01 1.59 87'6 1.59 87'6 Select one: O a. $13,004.58 O b. $1,079.58 O c. Not enough information to determine sales. O d. $1,979.40

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

Fundamentals Of Business Mathematics In Canada

Authors: F. Ernest Jerome, Jackie Shemko

3rd Edition

1259370151, 978-1259370151

More Books

Students also viewed these Mathematics questions

Question

1 cu. decimetre is the same as litro(a)

Answered: 1 week ago

Question

What is sociology and its nature ?

Answered: 1 week ago

Question

What is liquidation ?

Answered: 1 week ago

Question

Explain the different types of Mergers.

Answered: 1 week ago

Question

What is dividend payout ratio ?

Answered: 1 week ago