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

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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

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.
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman