Please help me to solve and understand this.

thank you

Before

1. $3,487.00
2. $7,500.50
3. $2,500.85
4. $6,990.75
5. $4,192.00
6. $7,580.25
7. $10,750.00
8. $4,411.00
9. $7,945.50
10. $4,575.85

After

1. $4,680.00
2. $6,730.00
3. $3,539.95
4. $7,105.75
5. $4,320.50
6. $7,595.70
7. $12,085.45
8. $4,220.75
9. $7,880.50
10. $5,340.65

The Insurance company recently conducted an aggressive and expensive advertising campaign. The manager is trying to figure out how this campaign affected branch's profits. The branch manager is pretty skeptical about the campaign and asked you to check whether there was any significant influence (positive or, maybe, negative). A sample is randomly selected of sales reps and calculated monthly combined profits of the policies sold by them before and after the advertising campaign. The sample is small, but as far as all conditions are satisfied we can use t-test for matched pairs. See the data in the data file. Provide Excel output.

a.Write the null and alternative hypotheses for this test using d = Before After:

b.What is the value of the t-test statistic?

c.What is the associated P-value?

d.State the conclusion using = 0.02. Do it using both P-value and critical value.