Question

1. The management of Discount Furniture designed an incentive plan for salespeople. To evaluate this innovative plan, 12 salespeople were selected at random, and their weekly incomes before and after the plan were recorded.

Salesperson	Before	After
Sid Mahone	$320	$340
Carol Quick	290	285
Tom Jackson	421	475
Andy Jones	510	510
Jean Sloan	210	210
Jack Walker	402	500
Peg Mancuso	625	631
Anita Loma	560	560
John Cuso	360	365
Carl Utz	431	431
A. S. Kushner	506	525
Fern Lawton	505	619

Was there a significant increase in the typical salesperson’s weekly income due to the innovative incentive plan? Use the 0.05 significance level. Estimate the p-value, and interpret it.

PLEASE SOLVE IT ON EXCEL STEP BY STEP. APPRECIATE IT, THANK YOU

Answer 1

Excel calculations are as follows

TTEST gives pvalue .If pvalue < 5% we reject Ho