1. The marketing manager of a large supermarket chain would like to use shelf space to...

90.2K

Verified Solution

Question

Basic Math

1. The marketing manager of a large supermarket chain would liketo use shelf space to predict the sales of a specialty pet food.Data are collected from a random sample of 8 equal-sized stores,with the following results:

Store

Shelf Space (in square feet)

Weekly Sales (in Dollars)

1

4

120

2

4

150

3

8

160

4

8

180

5

12

200

6

16

210

7

16

240

8

20

260

Use Excel to find the regression results for this problem.Include Excel results with your submission.

a. at the 0.05 level of significance, is there evidence of alinear relationship between shelf space and weekly sales?

b. construct a 95% confidence interval estimate of thepopulation slope, β1.

Answer & Explanation Solved by verified expert
3.6 Ratings (370 Votes)
Data Analysis Data RegressionOutput using excelSUMMARY OUTPUTRegression StatisticsMultipleR096199242RSquare092542941AdjustedR    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students