Excel statistics exercise

Extract

[...] 4,5 because for a fair-play score of they make 10 fouls, so for a fair-play score of the person will make 4,5 fouls How high would the amount of fouls made be if she would have a score of 8.0 on fair play? 8,75. In fact, two individuals have a fair play score of with 7.5 and 10 fouls respectively. Averaging the two fouls of these individuals, we get 8.75. What individual outperforms the others in the combination on fair play and amount of fouls? How did you check this? The 19th person outperforms the other. [...]

[...] Judging from this who has higher scores on fair play? Gender Mean of Fair Play Score Male 8,78 Female 6,22 Overall Average 7,85 Male have a higher score on fair play Gender Standard Deviation of Fair Play Score Male 3,05 Female 1,47 Overall Standard Deviation 2,84 2). Is there a difference between the score of fair play between frisbee and Football players? Formulate the null-hypothesis and alternative hypothesis. H0: Score of fair player of frisbee players H1: Score of fair player of football players Is there a difference between Score on fair play between frisbee and football players? [...]

[...] We focus on the sum of fair play score and the amount of fauls 4. Is there a sign difference between men and woman for football or frisbee players? Thus, did more female or male frisbee or football players fill out the survey? Formulate your conclusion. Sum of Amount of fouls Frisbee/Football player Gender Total Male Female Total Male have a higher amount of fouls than female, whether they're a soccer player or a Frisbee player. [...]

[...] Excel statistics exercise Our sample is made up of 30 individuals, including 11 women (36.6%) and 19 men (63.3%). Our database includes 4 variables: gender, which is a binary variable (male or female); fair-play score, where the higher the value, the better the individual; number of fouls, where the higher the value, the better the individual's performance; frisbee or soccer player, which is a binary variable, taking the value 0 for frisbee and 1 for soccer. 1). Drawing a histogram minute of fair play score: Formulate the null hypothesis and alternative: H0: Fair Play Score from male H1: Fair Play Score from female Calcul Outliers (with the quartiles) of « score of fair play » and draw a boxplot: The bottom of the boxplot (the rectangle) corresponds to the first quartile: 5 The top of the boxplot (the rectangle) corresponds to the third quartile: 9.5 The middle of the boxplot (the rectangle) corresponds to the second quartile, i.e. [...]