Homework Help is Here – Start Your Trial Now!
Math
Statistics
2. supermarket manager is interested in customer transactions to assist with budgeting as well as product placement throughout the store. Of particular interest to the manager is how long the customer spends in the store and whether the customer uses a self- service register for their transaction, Data has been collected from 50 customers and is provided in the fie FAT 1 Version A data.xlsx a) Use Linear Regression Excel to state the 95% confidence interval for the proportion of all Customers who use a self-service register. b) Interpret the confidence interval stated in part a) The supermarket manager is also interested to know if there is a difference in average shopping time for customers using the self-serve register and those using an assisted register. C. Use Linear Regression in Excel to conduct a hypothesis test at the 1% level of significance to determine if the shopping time is the same for customers using self-serve and assisted registers

2. supermarket manager is interested in customer transactions to assist with budgeting as well as product placement throughout the store. Of particular interest to the manager is how long the customer spends in the store and whether the customer uses a self- service register for their transaction, Data has been collected from 50 customers and is provided in the fie FAT 1 Version A data.xlsx a) Use Linear Regression Excel to state the 95% confidence interval for the proportion of all Customers who use a self-service register. b) Interpret the confidence interval stated in part a) The supermarket manager is also interested to know if there is a difference in average shopping time for customers using the self-serve register and those using an assisted register. C. Use Linear Regression in Excel to conduct a hypothesis test at the 1% level of significance to determine if the shopping time is the same for customers using self-serve and assisted registers

Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter7: Distance And Approximation
Section7.3: Least Squares Approximation
Problem 31EQ
See similar textbooks
icon
Related questions
Question

Please Answer fast all part in 30 minutes i'm needed if u can under 30 minutes is good..... Please no reject and the Table maybe can help u....

FAT 1 Version A D Time spent in shop (mins) Self-serve Number of items purchased 5 18 13 12 5 13 21 24 36 8 9 1 10 11 11 12 13 15 14 19 15 14 12 16 17 18 19 20 7 21 20 32 22 4 23 11 18 24 11 14 25 16 26 20 27 1. 28 1 11 6 18 22 12 13 3 10 1 40 3 1 42 16 22 43 12 10 21 17 45 24 23 46 16 1 12 12 10 48 6 15 1 11 11 369 N O 6345 さ=S 的 的
Transcribed Image Text:FAT 1 Version A D Time spent in shop (mins) Self-serve Number of items purchased 5 18 13 12 5 13 21 24 36 8 9 1 10 11 11 12 13 15 14 19 15 14 12 16 17 18 19 20 7 21 20 32 22 4 23 11 18 24 11 14 25 16 26 20 27 1. 28 1 11 6 18 22 12 13 3 10 1 40 3 1 42 16 22 43 12 10 21 17 45 24 23 46 16 1 12 12 10 48 6 15 1 11 11 369 N O 6345 さ=S 的 的
2. supermarket manager is interested in customer transactions to assist with budgeting as well as product placement throughout the store. Of particular interest to the manager is how long the customer spends in the store and whether the customer uses a self- service register for their transaction, Data has been collected from 50 customers and is provided in the fie FAT 1 Version A data.xlsx a) Use Linear Regression Excel to state the 95% confidence interval for the proportion of all Customers who use a self-service register. b) Interpret the confidence interval stated in part a) The supermarket manager is also interested to know if there is a difference in average shopping time for customers using the self-serve register and those using an assisted register. C Use Linear Regression in Excel to conduct a hypothesis test at the 1% level of significance to determine if the shopping time is the same for customers using self-serve and assisted registers
Transcribed Image Text:2. supermarket manager is interested in customer transactions to assist with budgeting as well as product placement throughout the store. Of particular interest to the manager is how long the customer spends in the store and whether the customer uses a self- service register for their transaction, Data has been collected from 50 customers and is provided in the fie FAT 1 Version A data.xlsx a) Use Linear Regression Excel to state the 95% confidence interval for the proportion of all Customers who use a self-service register. b) Interpret the confidence interval stated in part a) The supermarket manager is also interested to know if there is a difference in average shopping time for customers using the self-serve register and those using an assisted register. C Use Linear Regression in Excel to conduct a hypothesis test at the 1% level of significance to determine if the shopping time is the same for customers using self-serve and assisted registers
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Paths and Circuits
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
SEE MORE TEXTBOOKS