Please show the following question with working out and explanation

see the data for excel below

Use Excel, and appropriate hypothesis tests, to address the following research questions.

Assume all the test assumptions are verified

Part 1

Is there any difference between men's team and women's team in the average number of corporate sponsors?

Which test are you going to use?

a)One sample t-test

b)Two-sample t-test

c) Z-test

d) paired T-test

e) T-test

Report the absolute Value of the test statistic (use at least 2dp) ? report the p-value (use 3dp)?

What is a suitable conclusion about the difference between men's team and women's team in the average number of corporate sponsors?

a)There is sufficient evidence to suggest that the average number of corporate sponsors is 38

b)There is insufficient evidence to suggest that the average number of corporate sponsors is 38

Part 2

Is the average number of corporate sponsors equal to 38 ?

Which test are you going to use?

a)Paired t-test

b). Two sample t test

c) Z- test

c) One sample t-test

d) t-test

Report the absolute value of the test statistic (use 2dp)

Report the p-value (use 3dp)

What is the decision of the test

a)Reject H0

b)Accept H0

c)Do not Reject H0

d)Do not Accept H0

What is a suitable conclusion?

a)There is sufficient evidence to suggest that the average number of corporate sponsors is 38

b)There is insufficient evidence to suggest that the average number of corporate sponsors is 38

SEX men women women women men women women women men men women men women men women men men men women women men men men women women women women women women women women women men women men women numSgonsors RercentWin 22 21 21 48 21 13 19 26 52 23 18 59 22 56 33 54 11 27 14 31 40 19 21 33 52 38 34 53 49 41 46 30 59 52 24 25 57.84 80.45 64.26 81.42 47.94 54.24 41.58 59.54 85.73 43.72 56 76.26 70.55 |61.99 73.05 73.52 47.86 54.86 49.55 72.05 74.53 61.4 57.8 48.65 |67.84 49.3 75.24 77.08 82.24 62.77 62.35 62.45 83.79 71.86 58.69 |60.41 subj37 subj38 subj39 subj40 subj41 subj42 subj43 subj44 subj45 subj46 subj47 subj48 subj49 subjSO subjSl subj52 subj53 subj54 subj55 subj56 subj57 subj58 subj59 subj60 subj61 subj62 subj63 subj64 subj65 subj66 subj67 subj68 subj69 subj70 subj71 subj72 subj73 subj74 subj75 subj76 men women women women women women men women men women men women men men men women women men men women women women women men women men men women women women men women women men women men women men women men 22 34 60 41 39 60 12 48 39 27 38 49 31 33 59 35 35 12 46 20 30 29 32 39 45 23 12 16 44 44 32 41 28 44 26 33 58 13 10 45 51.75 55.77 81.59 67.04 54.36 77.78 45.7 81.11 67.2 51.09 68.43 68.97 72.73 82.48 72.05 74.17 69.45 47.42 87.4 50.05 73.34 61.72 45.84 72.37 69.06 51.74 47.84 47.75 73.92 63.36 56.25 62.88 50.73 57.97 74.02 65.27 72.35 37.95 38.69 64.89 subj77 subj78 subj79 subj80 subj81 subj82 subj83 subj84 subj85 subj86 subj87 subj88 subj89 subj90 subj91 subj92 subj93 subj94 subj95 subj96 subj97 subj98 subj99 subj100 subj101 subj102 subj103 subj104 subj105 subj106 subj107 subj108 subj109 subj110 subj111 subj112 subj113 subj114 subj115 subj116 women men men women women women men women women women men men men women women men men women men women men men men men women women women women women women men women women men women men women women women men 28 44 43 50 41 45 14 22 47 23 34 16 24 56 46 50 26 30 33 34 48 58 60 32 13 55 53 26 28 32 23 56 48 54 42 50 38 41 55 37 64.45 70.09 72.25 75.41 67.85 87.03 42.64 68.73 79.73 54.14 63.43 46.57 58.96 86.5 88.47 79.87 62.82 70.94 64.55 65.46 61.27 100 67.89 71.37 46.79 58.33 78.97 38.41 57.33 57.61 36.58 69.62 84.22 73.66 54.22 86.93 46.5 60.6 75.58 67.18 subj117 subj118 subj119 subj120 subj121 subj122 subj123 subj124 subj125 subj126 women men women women men men women women women men 18 49 15 44 42 57 55 24 49 14 43.12 76.46 70.27 73.09 73.43 79.89 83.18 54.68 78.31 64.31