1. Create an Excel workbook with worksheet templates (similar to the Excel workbook Confidence Intervals) for one-sample hypothesis tests for means and proportions Apply your templates to the example problems in this chapter (For subsequent problems, you should use the formulas in this chapter to perform the calculations, and use this template only to verify your results!)
2. A business school has a goal that the average number of years of work experience of MBA applicants is at least 3 years Based on last year’s applicants, it was found that among a sample of 47, the average number of years of work experience is 257 with a standard deviation of 367 What conclusion can the school reach?
3. A bank has historically found that the average monthly charges in recent years on its credit card were $1,350 With an improving economy, they suspect that this has increased A sample of 42 customers resulted in an average monthly charge of $1,37654 with a standard deviation of $18389 Does this data provide statistical evidence that the average monthly charges have increased?
4. A retailer believes that its new advertising strategy will increase sales Previously, the mean spending in 15 categories of consumer items in both the 18-34 and 35+ age groups was $7000.
a. Formulate a hypothesis test to determine if the mean spending in these categories has statistically increased
b. After the new advertising campaign was launched, a marketing study found that the mean spending for 300 respondents in the 18-34 age group was $7586, with a standard deviation of $5090 Is there sufficient evidence to conclude that the advertising strategy significantly increased sales in this age group?
c. For 700 respondents in the 35+ age group, the mean and standard deviation were $6853 and $4529, respectively Is there sufficient evidence to conclude that the advertising strategy significantly increased sales in this age group? Get Finance Help Today