• Round final answers to 2 decimal places,unless otherwise specified.
• Exponents can be displayed with the use of the "^" symbol (shift 6)...(Ex: "4 to the exponent 2" = 4^2)
• Expressalternate hypotheses withthe following symbols "/=" for two-tailed, ">=" for left-tailed, and "<=" for right-tailed
• Belowis an Excel data set linkfor questions 5, 6, 7 and 8...no work is submitted in Excel...

*** TO BE DONE WITH THE USE OF EXCEL***

***FOR MATCHED PAIR DO: BEFORE - AFTER***

***FOR INDEPENDENT SAMPLES DO:BEFORE AS SAMPLE 1 AND AFTER AS SAMPLE 2***

In a sales pitch TriCon, a strategic marketing company, claims they have been able to increase the sales of their previous clients by any average of 3%.A sample of quarterly sales reports of other companies before and after hiring TriCon is provided below (also available for download here Sales.xlsx).Given BEFORE = 3.48 and AFTER = 2.67, at a 5% level of significance can you conclude that, for other companies, hiring TriCon has lead to a growth in sales?YOU CAN ASSUME THE POPULATION TO BE NORMALLY DISTRIBUTED.

Quarterly sales (in millions)

Before TriCon Plan After TriCon Plan

6.67 7.96

4.39 8.83

4.51 7.22

7.85 7.59

6.74 8.68

4.2 8.92

5.76 8.7

4.57 8.87

7.42 8.12

6.87 6.17

5.63 7.49

4.43 7.47

5.29 8.31

4.56 8.6

4.69 7.22

4.29 6.27

7.82 7.47

6.26 6.89

7.01 8.77

5.91 7.31

5.87 7.02

7.23

8.68

8.85

8.15

7.41

a) Properly state the mathematical hypotheses:

b) p-value:

c) Conclusion: (YOU MUST EXPLAIN YOUR ANSWER MATHEMATICALLY)

Answer

a)

b)

PLEASE SHOW YOUR WORK BY COMPLETING THIS TABLE

FUNCTION:

FIELD 1:

FIELD 2:

FIELD 3:

FIELD 4:

ANY ADDITIONAL CALCULATIONS CAN BE SHOWN HERE

FINAL ANSWER: ANSWER TO 4 DECIMALS

c)