Create an Excel workbook with worksheet templates (similar to the Excel workbook Confidence Intervals) for one-sample hypothesis tests for means 1. 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 2.57 with a standard deviation of 3.67. 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,376.54 with a standard deviation of $183.89. 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 $70.00. Formulate a hypothesis test to determine if the mean spending in these categories has statistically increased.
a.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 $75.86, with a standard deviation of $50.90.
b.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 $68.53 and $45.29, respectively. Is there sufficient evidence to conclude that the advertising strategy significantly increased sales in this age group?
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post excel-4-questions-with-attachment appeared first on Essay Fount.
What Students Are Saying About Us.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."