Question

In: Statistics and Probability

The file bank.xls has data from a midsized local bank. The bank has recently begun offering...

The file bank.xls has data from a midsized local bank. The bank has recently begun offering online banking services to its clients and is curious about the level of interest in the new product. The two columns contain data on the number of online banking brochures distributed on a sample of weekdays and Saturdays. Management has claimed that about 330 people are taking brochures about the new service every day.

a. Use use Excel to calculate the sample mean and standard deviation for each column of data XL to calculate the sample mean and standard deviation for each column of data

b. Test the managements claim for weekdays using a=0.05

c. Test the management claim for Saturday’s using a=0.05

d. Use XL‘s t-test function to test if a difference exists in the number of brochures distributed on a weekday and Saturdays using a=0.05. Do these results make any sense given your answers to parts b and c?


Data

Weekday Saturday
334 272
247 206
261 261
347 167
311 275
300 389
432 239
265 294
348 368
425 313
380 354
416 379
313 223
431 258
327 226
389 257
265 247
327 266
293 382
408 417
414 300
291 320
419 272
256 361
432 403
348 407
353 411
404 396
352 275
362 293
289 389
434 347
363 402
281 261
414 353
383 305
415 262
295 339
264 358
395 249
302 317
321 325
247 262
269 264
322 408
261 289
311 260
257 411
292 269
356 313
400 249
253 412
377 335
422 254
439 389
424 339
244 333
384 364
278 283
262 252
309 242
314 320
334 381
285 373
431 330
353 383
299 268
308 300
327 264
386 368
303 314
283 392
421 324
382 251
288 374
252 404
386 380
280 341
340 387
394 361
281 387
308 224
375 282
366 353
307 241

Solutions

Expert Solution



Related Solutions

Jill has recently begun working at a local florist. In addition to creating floral arrangements, Jill...
Jill has recently begun working at a local florist. In addition to creating floral arrangements, Jill spends a good deal of her time talking to customers and ringing up sales. Over time, she identifies a weakness in the procedures for ringing up voids. No approval is neces- sary to void a sale, and the void slip collects very little information about the sale. After Jill has completed a sale and the customer has left, she voids the sale and pockets...
. A bank has recently begun a new credit program. Customers meeting a certain credit requirement...
. A bank has recently begun a new credit program. Customers meeting a certain credit requirement can obtain a credit card accepted by participating area merchants that carries a discount. Past data show that about 35% of all applicants for this card are rejected. If we let X represent the number of applicants who are approved for this credit card, the probabilities for the values of X can be calculated using the binomial probability distribution. Please answer the following questions...
An online bank is offering to pay 0.25​% interest per month on deposits. Your local bank...
An online bank is offering to pay 0.25​% interest per month on deposits. Your local bank offers to pay 0.65​% interest quarterly​ (every 3​ months). Which is the higher interest​ rate?
Ms. Caterina Weldon has applied for a loan from a local bank and the bank has...
Ms. Caterina Weldon has applied for a loan from a local bank and the bank has agreed to extend to her a personal loan of $ 1,500,000/= over a period of 21/2 years. This loan will be repaid in monthly installments at the end of each month over the loan period. The proposed interest rate is 14.5% p.a. Required: Prepare a loan repayments schedule for Ms. Matemo’s loan indicating: The Model Drivers    The constant payment Interest payment Principal payment,...
The manager of a pizza restaurant has recently begun experimenting with a new method of baking...
The manager of a pizza restaurant has recently begun experimenting with a new method of baking pepperoni pizzas. He personally believes that the new method produces a better-tasting pizza, but he would like to base the decision on whether to switch from the old method to the new method on customer reactions. Therefore, he performed an experiment. For 100 randomly selected customers who order a pepperoni pizza for home delivery, he included both an old-style and free new-style pizza in...
Your local bank is offering a new type of retirement savings account. An initial deposit is...
Your local bank is offering a new type of retirement savings account. An initial deposit is made to the account when it is opened. This money and any accumulated interest must be left in the account for 29 years. No additional deposits can be made. On the day the account is opened and on each annual anniversary of the initial deposit, the account balance is reviewed and the following terms apply: If the account balance is less than or equal...
Your local bank is offering a new type of retirement savings account. An initial deposit is...
Your local bank is offering a new type of retirement savings account. An initial deposit is made to the account when it is opened. This money and any accumulated interest must be left in the account for 20 years. No additional deposits can be made. On the day the account is opened and on each annual anniversary of the initial deposit, the account balance is reviewed and the following terms apply: If the account balance is less than or equal...
Your local bank is offering a new type of retirement savings account. An initial deposit is...
Your local bank is offering a new type of retirement savings account. An initial deposit is made to the account when it is opened. This money and any accumulated interest must be left in the account for 27 years. No additional deposits can be made. On the day the account is opened and on each annual anniversary of the initial deposit, the account balance is reviewed and the following terms apply: If the account balance is less than or equal...
Banks have expanded from what were traditional services (checking, savings, and loans) and have begun offering...
Banks have expanded from what were traditional services (checking, savings, and loans) and have begun offering many other services for customers. What are some banking strategies to not only attract customers, but retain them from a loyalty perspective? What services do you find important in a bank? How have banks leveraged technology to deliver a more convenient experience? Do you think this is good?---why or why not?
The following data give the starting salary for students who recently graduated from a local university...
The following data give the starting salary for students who recently graduated from a local university and accepted jobs soon after graduation. The starting salary, grade-point average (GPA), and major (business or other) are provided. SALARY $29,500 $46,000 $39,800 $36,500 GPA 3.1 3.5 3.8 2.9 Major Other Business Business Other SALARY $42,000 $31,500 $36,200 GPA 3.4 2.1 2.5 Major Business Other Business Using a computer, develop a regression model that could be used to predict starting salary based on GPA...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT