Math Problem Statement

how do i find the answer with excel Part 2 Is the average number of corporate sponsors equal to 38? Which test are you going to use? Answer 5 Question 1 Report the absolute value of the test statistic [use at least 2dp]: Answer 6 Question 1 Report the đť‘ť p -value [use at least 3dp]: Answer 7 Question 1 What is the decision of the test? Answer 8 Question 1 What is a suitable conclusion? this is the data set: SubID,sex,numSponsors,percentWin subj1,women,55,90.67 subj2,men,13,63.26 subj3,men,16,36.13 subj4,women,57,60.18 subj5,women,51,52.34 subj6,women,13,54.54 subj7,men,21,49.08 subj8,women,27,56.02 subj9,women,38,57.43 subj10,men,42,62.87 subj11,men,14,62.7 subj12,men,32,69.41 subj13,men,18,48.88 subj14,men,18,55.08 subj15,men,24,39.2 subj16,men,32,52.04 subj17,men,32,74.01 subj18,men,11,50.09 subj19,women,58,61.05 subj20,men,38,64.58 subj21,women,36,60.31 subj22,men,23,44.88 subj23,men,13,60.49 subj24,men,32,64.66 subj25,women,20,35.88 subj26,men,31,64.51 subj27,men,48,79.69 subj28,women,40,68.82 subj29,women,49,68.43 subj30,men,48,90.16 subj31,women,51,79.12 subj32,women,56,61.24 subj33,men,59,75.49 subj34,women,15,36.47 subj35,women,42,82.05 subj36,men,40,82.01 subj37,women,31,65.56 subj38,men,31,54.55 subj39,women,40,85.84 subj40,women,47,55.4 subj41,men,26,73.17 subj42,women,24,60.52 subj43,women,17,64.88 subj44,men,48,99.15 subj45,women,40,80.54 subj46,women,23,53.65 subj47,men,34,71.94 subj48,women,30,57.41 subj49,women,47,67.43 subj50,men,37,61.47 subj51,men,26,72.16 subj52,men,31,66.51 subj53,men,57,66.1 subj54,women,34,56.38 subj55,men,17,44.51 subj56,men,24,38 subj57,women,37,63.99 subj58,women,39,60.19 subj59,men,15,55.02 subj60,women,40,63.2 subj61,men,42,73.11 subj62,men,41,56.2 subj63,women,17,49.16 subj64,men,16,57.34 subj65,men,34,68.77 subj66,men,14,52.26 subj67,men,58,85.99 subj68,men,59,64.99 subj69,men,18,49.14 subj70,women,57,71.66 subj71,women,36,84.22 subj72,men,17,64.08 subj73,women,48,76.06 subj74,men,45,73.44 subj75,women,34,51.2 subj76,men,17,50.12 subj77,men,44,67.55 subj78,women,13,48.97 subj79,women,25,41.64 subj80,men,22,60.9 subj81,women,12,42.23 subj82,men,54,60.02 subj83,women,58,69.63 subj84,women,24,45.85 subj85,men,26,53.06 subj86,men,59,63.81 subj87,men,11,53.39 subj88,women,60,60.13 subj89,women,30,66.42 subj90,men,16,50.47 subj91,men,23,54.29 subj92,women,37,58.03 subj93,women,57,81.1 subj94,men,35,55.66 subj95,women,58,78.45 subj96,men,54,71.4 subj97,men,51,62.09 subj98,women,46,70.83 subj99,men,13,56.73 subj100,men,23,65.89 subj101,women,23,34.98 subj102,men,57,83.27

Solution

Ask a new question for Free

By Image

Drop file here or Click Here to upload

Math Problem Analysis

Mathematical Concepts

Statistics
Hypothesis Testing
One-sample t-test

Formulas

Sample mean formula: x̄ = (Σxi)/n
Sample standard deviation formula: s = sqrt[(Σ(xi - x̄)^2)/(n-1)]
Test statistic formula: t = (x̄ - μ) / (s/sqrt(n))
P-value formula using T.DIST.2T in Excel

Theorems

Central Limit Theorem
t-distribution

Suitable Grade Level

College-level statistics or advanced high school (Grades 11-12)