Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A supermarket sells pre-packaged bags of spices.A customer wants to determine if there is a linear relationship between the price ($/gram) of a bag of

A supermarket sells pre-packaged bags of spices.A customer wants to determine if there is a linear relationship between theprice ($/gram) of a bag of spices and the weight (grams) per bag.The customer collects a random sample of bags and records thepriceandweight.

Excel was then used to establish a simple linear regression ofpriceonweight. Here is a table of the sample data, with the Excel regression output:

image text in transcribed
Weight (grams) Price ($/gram) SUMMARY OUTPUT 250 15 1,000 10 Regression Statistics 4,000 7 Multiple R 0.8793823 1,000 10 R Square 0.7733132 350 13 Adjusted R Square |0.7582008 500 12 Standard Error 1.6860956 5,000 6 Observations 17 1,000 10 5,000 6 ANOVA 1,000 10 df MS F Significance F 350 16 Regression 1 145.473869 145.5 51.1706 3.319E-06 5,000 6 Residual 15 42.6437781 2.843 500 12 Total 16 188.1176471 400 15 4,000 7 Coefficients Standard Error t Stot P-value Lower 95% Upper 95% 1,000 10 Intercept 13.481395 0.575159301 23.44 3.1E-13 12.255472 14.707318 500 15 Weight (grams) -0.001594 0.000222872 -7.153 3.3E-06 -0.0020693 -0.0011192

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

College Algebra Enhanced With Graphing Utilities (Subscription)

Authors: Michael Sullivan, Michael Sullivan III

6th Edition

0321849167, 9780321849168

More Books

Students also viewed these Mathematics questions

Question

2. I try to be as logical as possible

Answered: 1 week ago