Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic College Mathematics With Early Integers (Subscription)

Authors: Elayn Martin Gay

4th Edition

0135181267, 9780135181263

More Books

Students also viewed these Mathematics questions