A supermarket chain analyzed data on sales of a particular brand of snack cracker at 104 stores...

50.1K

Verified Solution

Question

Basic Math

A supermarket chain analyzed data on sales of aparticular brand of snack cracker

at 104 stores for a certain one week period. The analystdecided to build a regresion model to predict the sales of thesnack cracker based on the total sales of all brands in the snackcracker category.

f. Produce a 90% confidence prediction interval for thesales of the cracker

   in a store where the category sales is1005. Also produce the90 %

   confidence prediction interval in astore where category sales is 900.

  Can you with 90% confidence claim whichstore has higher cracker sales?

CategorySalesSales
1348394
1110388
1096357
1208385
1063346
1097326
1277358
1275359
1328360
1281374
1127362
1339406
1055354
1263368
1158391
1286370
1401372
1085381
1178371
1248353
1241372
1320375
1353369
1173353
1208364
1280371
1214391
1213381
1291371
1230335
1095338
1149320
1305370
1134351
1127328
1053295
1107318
1054296
1141327
1190313
1071346
1147361
1127350
1204367
1301411
1184390
1214367
1132341
1213380
1173347
1226365
1261352
1118341
1096321
1211329
1033336
1228361
1241386
1381408
1332359
1253375
1043330
1456341
1099340
1044336
1230341
1143371
1238378
1357371
1150378
1218386
1215357
1238376
1196349
1193364
1282361
1317365
1157346
1294356
1198343
1436358
1278368
1124312
1116315
1109338
1285327
1189309
1197330
1091345
1251344
1124355
1130346
1067328
1150352
1238375
1409370
1264377
1151340
1206350
1297375
1164364
1108370
1187365
1459396

Answer & Explanation Solved by verified expert
4.0 Ratings (743 Votes)
I used Excel for fitting regression lineOutputCategorySales xSalesx xbar2134839420380418111038890706576SUMMARYOUTPUT109635711933378120838576176Regression    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