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)
Related Recommendation
Hypothesis Testing for Corporate Sponsors in International Teams
Hypothesis Testing for Corporate Sponsorship and Sporting Success Using a Z-Test
Hypothesis Testing: Conducting a One-sample t-test
t-Test Critical Value Calculation: Testing Mean with Student Sample Data
Hypothesis Testing: Comparing Corporate Sponsors of Men’s and Women’s Teams