Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You own a bakery and decide to compare your weekly flour consumption in pounds (x - input variable) and the sales you make in dollars

You own a bakery and decide to compare your weeklyflour consumptionin pounds (x - input variable) and thesalesyou 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.

ReferencingFigure 1 Excel summary outputshown, predict sales based on consuming 5000 lbs. of flour.

image text in transcribed
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 6129.716 6129.716 10.472 0.012 Residual 8 4682.784 585.348 Total 9 10812.500 Co- Standard t Stat P-value Lower Upper Lower Upper efficients Error 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 9.48 1.59 9.48

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

Physics For Scientists And Engineers

Authors: Raymond A Serway, John W Jewett

10th Edition

1337671711, 9781337671712

More Books

Students also viewed these Mathematics questions