Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the Starbucks data in the BBUS 502 Final Exam Data.xlsx Download BBUS 502 Final Exam Data.xlsxdataset. Using the descriptive statistics, but also with
Refer to the Starbucks data in theBBUS 502 Final Exam Data.xlsxDownload BBUS 502 Final Exam Data.xlsxdataset. Using the descriptive statistics, but also with the raw data if you want to use it, you should be able to determine that there is one response error in one variable of the dataset. What variable has an error and how do you know it is an error?
Dollar Amt. | Age | Days | Cups | Satisfaction | Income ($2000) | Starbucks Distance | Pets | Local (Yes=1) | Prefer DriveThru | Days (after promotion) | Cups (after promotion) | Variable | Description | ||
5 | 25 | 4 | 1 | 4 | 20 | 0 | 1 | 0 | 1 | 6 | 7 | Dollar Amt. | Card reload amounts | ||
25 | 30 | 12 | 5 | 4 | 35 | 2 | 1 | 1 | 0 | 23 | 10 | Age | customer's age | ||
10 | 27 | 10 | 4 | 2 | 30 | 3 | 1 | 1 | 0 | 21 | 6 | Days | number of days per month the customer makes a purchase at Starbucks | ||
5 | 42 | 8 | 5 | 1 | 30 | 3 | 1 | 0 | 1 | 7 | 10 | Cups | number of cups of coffee the customer drinks per day | ||
15 | 29 | 11 | 8 | 2 | 25 | 4 | 1 | 1 | 1 | 12 | 3 | Satisfaction | A recent customer service survey score for Starbucks (1=Low and 7 =High). | ||
50 | 25 | 12 | 5 | 1 | 60 | 4 | 1 | 1 | 0 | 9 | 6 | Income ($2000) | customer's income (multiply by 2000) | ||
10 | 50 | 8 | 3 | 5 | 30 | 3 | 1 | 0 | 0 | 8 | 2 | Local (Yes=1) | Binary variable indicating if the customer considers him/herself to be local (1=Yes, 0 = No) | ||
15 | 45 | 6 | 5 | 1 | 35 | 1 | 1 | 1 | 0 | 21 | 7 | Pets | Categorical data indicating primary pet ownership (1=Cat, 2=Dog, 3 = Other) | ||
5 | 32 | 16 | 7 | 5 | 25 | 1 | 1 | 0 | 0 | 9 | 1 | Starbucks Distance3 | Miles the Starbucks location is from work/school in miles (0 to 4 miles reported) | ||
5 | 23 | 10 | 1 | 4 | 20 | 4 | 1 | 0 | 0 | 18 | 3 | Prefer DriveThru | Binary variable indicating if the customer prefers the drive thru over indoor service (1=Yes, 0 = No) | ||
20 | 40 | 18 | 5 | 4 | 40 | 0 | 2 | 1 | 0 | 5 | 6 | Days (after promotion) | After running a promotion (post test), this is the number of days per month the customer makes a purchase at Starbucks | ||
35 | 35 | 12 | 3 | 5 | 40 | 3 | 2 | 1 | 1 | 9 | 11 | Cups (after promotion) | After running a promotion (post test), this is the number of cups of coffee the customer drinks per day | ||
40 | 28 | 10 | 3 | 7 | 50 | 4 | 2 | 1 | 1 | 23 | 3 | ||||
15 | 33 | 12 | 2 | 6 | 30 | 1 | 2 | 0 | 0 | 15 | 10 | ||||
200 | 40 | 15 | 5 | 6 | 80 | 0 | 2 | 1 | 0 | 6 | 2 | ||||
15 | 37 | 3 | 1 | 7 | 30 | 3 | 2 | 1 | 1 | 14 | 1 | ||||
40 | 51 | 10 | 8 | 6 | 35 | 2 | 2 | 1 | 0 | 24 | 2 | ||||
5 | 20 | 8 | 4 | 5 | 25 | 2 | 2 | 0 | 1 | 23 | 1 | ||||
30 | 26 | 15 | 5 | 7 | 35 | 0 | 2 | 1 | 1 | 17 | 5 | ||||
100 | 38 | 19 | 10 | 2 | 45 | 0 | 2 | 1 | 0 | 21 | 4 | ||||
30 | 27 | 12 | 3 | 2 | 35 | 2 | 3 | 1 | 1 | 20 | 8 | ||||
25 | 29 | 14 | 6 | 3 | 35 | 4 | 3 | 0 | 1 | 24 | 8 | ||||
25 | 34 | 10 | 4 | 3 | 45 | 3 | 3 | 1 | 4 | 11 | 6 | ||||
50 | 30 | 6 | 3 | 2 | 55 | 4 | 3 | 1 | 0 | 19 | 6 | ||||
15 | 22 | 8 | 5 | 4 | 30 | 2 | 3 | 0 | 1 | 15 | 3 | ||||
Dollar Amt. | Age | Days | Cups | Satisfaction | Income ($2000) | Starbucks Distance | Pets | Local (Yes=1) | Prefer DriveThru | Days (after promotion) | Cups (after promotion) | |||
Mean | 31.6 | 32.72 | 10.76 | 4.44 | 3.92 | 36.8 | 2.2 | 1.8 | 0.64 | 0.6 | 15.2 | 5.24 | ||
Standard Error | 8.16 | 1.68 | 0.80 | 0.45 | 0.39 | 2.69 | 0.29 | 0.15 | 0.10 | 0.17 | 1.31 | 0.62 | ||
Median | 20 | 30 | 10 | 5 | 4 | 35 | 2 | 2 | 1 | 0 | 15 | 6 | ||
Mode | 5 | 25 | 12 | 5 | 4 | 35 | 3 | 1 | 1 | 0 | 23 | 6 | ||
Standard Deviation | 40.82 | 8.40 | 4.01 | 2.24 | 1.96 | 13.45 | 1.47 | 0.76 | 0.49 | 0.87 | 6.53 | 3.11 | ||
Sample Variance | 1666.08 | 70.63 | 16.11 | 5.01 | 3.83 | 181.00 | 2.17 | 0.58 | 0.24 | 0.75 | 42.67 | 9.69 | ||
Kurtosis | 12.58 | -0.21 | -0.14 | 0.44 | -1.15 | 3.37 | -1.26 | -1.14 | -1.76 | 9.49 | -1.52 | -1.03 | ||
Skewness | 3.31 | 0.68 | 0.14 | 0.53 | 0.05 | 1.60 | -0.29 | 0.37 | -0.62 | 2.59 | -0.13 | 0.29 | ||
Range | 195 | 31 | 16 | 9 | 6 | 60 | 4 | 2 | 1 | 4 | 19 | 10 | ||
Minimum | 5 | 20 | 3 | 1 | 1 | 20 | 0 | 1 | 0 | 0 | 5 | 1 | ||
Maximum | 200 | 51 | 19 | 10 | 7 | 80 | 4 | 3 | 1 | 4 | 24 | 11 | ||
Sum | 790 | 818 | 269 | 111 | 98 | 920 | 55 | 45 | 16 | 15 | 380 | 131 | ||
Count | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | ||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started