Question
Customers who made online purchases last quarter from an Internet retailer were randomly sampled from the retailer's database. The dollar value of each customer's quarterly
Customers who made online purchases last quarter from an Internet retailer were randomly sampled from the retailer's database. The dollar value of each customer's quarterly purchases along with the time the customer spent shopping the company's online catalog that quarter were recorded. The sample results are in the file Online.
a. Create scatter plot of the variables Time (x) and Purchases (y). What relationship, if any, appears to exist between the two variables?
b. Compute the correlation coefficient for these sample data. What does the correlation coefficient measure?
c. Conduct a hypothesis test to determine if there is a positive relationship between time viewing the retailer's catalog and dollar amount purchased. Use a level of significance equal to 0.025. Provide a managerial explanation of your results.
Customer Account Number | Time (Minutes) | Purchases ($) |
62638 | 54.69 | 259 |
58499 | 13.42 | 24 |
79902 | 15.78 | 177 |
85784 | 75.70 | 207 |
99619 | 2.28 | 37 |
88286 | 14.13 | 20 |
60330 | 232.36 | 336 |
10702 | 285.93 | 364 |
8368 | 5.97 | 281 |
2787 | 36.80 | 166 |
27378 | 212.46 | 302 |
97299 | 229.68 | 260 |
65737 | 8.68 | 22 |
78745 | 185.31 | 225 |
52943 | 25.33 | 75 |
18225 | 104.55 | 202 |
94205 | 50.27 | 187 |
91908 | 128.32 | 142 |
38996 | 78.19 | 216 |
67406 | 144.20 | 156 |
94791 | 150.97 | 287 |
76076 | 76.93 | 214 |
67091 | 105.34 | 183 |
91924 | 136.62 | 238 |
83629 | 14.91 | 128 |
50371 | 79.72 | 111 |
78488 | 4.53 | 116 |
26783 | 80.52 | 169 |
7965 | 142.43 | 159 |
70751 | 200.18 | 233 |
48503 | 163.15 | 215 |
56695 | 56.37 | 117 |
1467 | 23.96 | 136 |
33100 | 233.67 | 279 |
75810 | 13.25 | 85 |
51309 | 225.41 | 322 |
99825 | 268.36 | 312 |
3797 | 183.13 | 201 |
95458 | 4.86 | 53 |
35026 | 48.39 | 166 |
18926 | 62.24 | 88 |
18917 | 70.76 | 111 |
9407 | 94.85 | 97 |
79396 | 245.09 | 290 |
64588 | 152.27 | 247 |
72038 | 113.97 | 160 |
95227 | 93.25 | 96 |
74097 | 85.13 | 157 |
22661 | 203.94 | 372 |
54912 | 169.48 | 304 |
51421 | 64.02 | 311 |
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