Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Cardweb.com, Inc, is a leading online publisher of information pertaining to pay

ID: 3259181 • Letter: C

Question

Cardweb.com, Inc, is a leading online publisher of information pertaining to payment cards (e.g., credit, debit smart prepaid and phone cards).the company tracked purchases in the United States in 2005. Data for two variables were collected The amount (in dollars) of each purchase and (2) the type of card used (American Express, Discover, Mastercard or VISA. The most appropriate Microsoft Excel Data Analysis tool for determining whether the type of card used has an effect on the amount of purchase is: Regression F-Test Two-Sample for Variances Anova Single Factor z-Test Two Sample for Means

Explanation / Answer

here there are two variables, suppose X be the type of cards used for payments. And other variable is Y is the amount (in $) of each purchase.

Y is the response variable depends on the predictor variable X.

And for determining whether the type of cards used has an effect on the amount of purchases, in such problems we generally used regression analysis.

In MS Excel Data analysis used Regression for such study.