Question

In: Math

Problem 1 An automobile manufacturer employs sales representatives who make calls on dealers. The manufacturer wishes...

Problem 1

An automobile manufacturer employs sales representatives who make calls on dealers. The manufacturer wishes to compare the effectiveness of four different call-frequency plans for the sales representatives. Thirty-two representatives are chosen at random from the sales force and randomly assigned to the four call plans (eight per plan). The representatives follow their plans for 6 months, and their sales for the 6-month study period are recorded. These data are listed in the file P19_01.xlsx.

Do the sample data support the hypothesis that at least one of the call plans helps produce a higher average level of sales? Perform an appropriate statistical test and report a p-value.

If the sample data indicate the existence of mean sales differences across the call plans, which plans produce significantly different average sales levels at the 95% level?

the data:

Plan A Plan B Plan C Plan D
36 39 44 31
40 45 43 43
32 54 38 46
44 53 40 43
35 46 41 36
41 42 35 49
44 35 37 46
42 39 37 48

please, i need the answer by using SPSS program. if you display the steps, it will be appreciated.

Solutions

Expert Solution



Related Solutions

Use excel only, please! problem #1 data contains data on automobile manufacturer who employs sales representatives...
Use excel only, please! problem #1 data contains data on automobile manufacturer who employs sales representatives who make calls on dealers. The manufacturer wishes to compare the effectiveness of four different call-frequency plans for the sales representatives. Thirty-two representatives are chosen at random from the sales force and randomly assigned to the four call plans for six months, and their sales for the 6-month study period are recorded. Do the sample data support the hypothesis that at least one of...
An automobile manufacturer who wishes to advertise that one of its models achieves 30 mpg (miles...
An automobile manufacturer who wishes to advertise that one of its models achieves 30 mpg (miles per gallon) decides to carry out a fuel efficiency test. Six nonprofessional drivers were selected, and each one drove a car from Phoenix to Los Angeles. The resulting fuel efficiencies (in miles per gallon) are given below. 27.3 29.4 31.2 28.4 30.2 29.6 Assuming that fuel efficiency is normally distributed under these circumstances, do the data contradict the claim that true average fuel efficiency...
company, claims that the sales representatives makes an average of 20 calls per week on professors....
company, claims that the sales representatives makes an average of 20 calls per week on professors. Several representatives say that the estimate is too low. To investigate, a random sample of 28 sales representatives reveals that the mean number of calls made last week was 44 and variance is 2.41. Conduct an appropriate hypothesis test, at the 5% level of significance to determine if the mean number of calls per salesperson per week is more than 40. (a)     Provide the hypothesis...
A manufacturer is considering a switch from manufacturers’ representatives to an internal sales force. The following...
A manufacturer is considering a switch from manufacturers’ representatives to an internal sales force. The following cost estimates are available. Manufacturers’ reps are paid 8.1% commission and incur $600,000 in fixed costs, while an internal sales force has fixed costs projected at $1,900,000 and would receive 2.6% commission. Assume that sales revenue is double the breakeven volume or the point at which the manufacturer would be indifference between reps and an internal sales force. At this volume, how much would...
The annual commissions earned by sales representatives of Machine Products Inc., a manufacturer of light machinery,...
The annual commissions earned by sales representatives of Machine Products Inc., a manufacturer of light machinery, follow the normal probability distribution. The mean yearly amount earned is $40,000 and the standard deviation is $5,000. a. What percent of the sales representatives earn more than $42,000 per year? b. What percent of the sales earn less than 28,000 per year? c. The sales manager wants to award the sales representatives who earn the largest commissions a bonus of $1,000. He can...
The annual commissions earned by sales representatives of Machine Products Inc., a manufacturer of light machinery,...
The annual commissions earned by sales representatives of Machine Products Inc., a manufacturer of light machinery, follow the normal distribution. The mean yearly amount earned is $40,000 and the standard deviation is $5000. a. What percentage of sales representatives earn between $32,000 and $42,000 per year? b. What percentage of sales representatives earn more than $42,000 per year? c. The sales manager wants to award the sales representatives who earn the largest commissions a bonus of $1000. He can award...
The annual commissions earned by sales representatives of Machine Products Inc. a manufacturer of light machinery,...
The annual commissions earned by sales representatives of Machine Products Inc. a manufacturer of light machinery, follow the normal probability distribution. The mean yearly amount earned is $42,000 and the standard deviation is $4000. a. What percent of representatives earn less than $45,000? b. What percent of representatives earn between $32,000 and $45,000? c. How much is the annual commission for the top 15% of the sales representatives?
A manufacturer of small appliances employs a market research firm to look into sales of its...
A manufacturer of small appliances employs a market research firm to look into sales of its products. Shown below are last month's sales of electric can openers from a random sample of 50 stores. The manufacturer would like to know if there is convincing evidence in these data that the mean can opener sales for all stores last month was more than 22. Sales 19 19 16 19 25 26 24 63 22 16 13 26 34 10 48 16...
A life-insurance company claims that 10% of the sales calls their agents make result in a...
A life-insurance company claims that 10% of the sales calls their agents make result in a successful sale. Which of the following is the correct null and alternative hypotheses to test for this claim? Multiple Choice H0 : ? = 0.10; Ha : ? ? 0.10 H0 : ? ? 0.10; Ha : ? = 0.10 H0: ? ? 0.10; Ha : ? < 0.10 H0 : ? ? 0.10; Ha : ? > 0.10
A manufacturer wishes to make and sell 1.1 million units per year of an aviation part...
A manufacturer wishes to make and sell 1.1 million units per year of an aviation part for 12 years with interest fixed at 14% per year. Option A is to build a manufacturing plant in the United States at a cost of $7 million, with endof-year expenses of $2 million per year. In order to meet environmental regulations, the manufacturer will need to invest $0.5 million for pollution control at the end of the fifth year. Option B is to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT