The excel file is here : (For Gender 1= Female, handedness 1=Right and Result 1=Win)

Group	Attempt	Extractions	Time	participant	gender	dom_hand	highest_ed	major	version	result	duration
1	1	3	52	01-2	0	1	BACHELORS	BIOMEDICAL SCIENCES	2	0	52
1	1	0	7	01-3	0	1	BACHELORS	PSYCHOLOGY	2	0	7
2	1	11	68	02-5	0	1	MASTERS	COMPUTER SCIENCE	1	1	68
3	1	11	59	03-3	0	1	OD	OPTOMETRY	1	1	59
3	1	6	26	03-4	0	1	MASTERS	OPTOMETRY	1	0	26
4	1	2	16.809999999999999	04-3	0	1	PHD	VECTOR MEDICINE	2	0	16.81
4	1	7	57.73	04-4	0	1	MASTERS	BIOTECH	2	0	57.73
4	1	6	89.13	04-5	0	1	BACHELORS	MATH & PHYSICS	2	0	89.13
6	1	2	13.28	06-1	0	1	BACHELORS	CHEMICAL ENGINEERING/ MUSIC PERFORMANCE	2	0	13.28
6	1	2	28.26	06-2	0	1	BACHELORS	BIOMEDICAL ENGINEERING	2	0	28.26
6	1	1	9.65	06-3	0	1	MD	BIOLOGY	2	0	9.65
7	1	11	40.79	07-2	0	1	MASTERS	INDUSTUSTRIAL ENGINEERING	1	1	40.79
7	1	3	20.84	07-3	0	1	BACHELORS	COMPUTER SCIENCE ENGINEERING	1	0	20.84
1	1	2	29	01-1	1	0	BACHELORS	LATIN	2	0	29
1	1	2	43	01-4	1	1	BACHELORS	NEUROSCIENCE	2	0	43
2	1	11	86	02-1	1	1	MASTERS	CHEMISTRY	1	1	86
2	1	11	75	02-2	1	1	MASTERS	DATA SCIENCE	1	1	75
2	1	11	52	02-3	1	1	BACHELORS	BIOMEDICAL ENGINEERING	1	1	52
2	1	11	35	02-4	1	1	MASTERS	BIOTECHNOLOGY	1	1	35
3	1	4	11	03-1	1	1	BACHELORS	COMPUTERSCIENCE	1	0	11
3	1	3	8	03-2	1	1	MASTERS	PSYCHOLOGY	1	0	8
3	1	2	8	03-5	1	1	OD	OPTOMETRY	1	0	8
4	1	3	20.43	04-1	1	1	BACHELORS	STATISTICS	2	0	20.43
4	1	3	21.78	04-2	1	1	MASTERS	BIOTECH	2	0	21.78
5	1	2	20.93	05-1	1	1	MASTERS	ENVIRONMENTAL HEALTH SCIENCE	2	0	20.93
5	1	6	69.239999999999995	05-2	1	1	MASTERS	MATHEMATICS	2	0	69.24
5	1	1	10.8	05-3	1	1	MASTERS	STATISTICS	2	0	10.8
5	1	5	48.93	05-4	1	0	MASTERS	MEDICINE	2	0	48.93
5	1	2	56.3	05-5	1	1	MASTERS	NEUROSCIENCE	2	0	56.3
6	1	0	5.0999999999999996	06-4	1	1	BACHELORS	BIOMEDICAL ENGINEERING	2	0	5.1
7	1	11	41.34	07-1	1	1	MASTERS	MATHEMATICS	1	1	41.34
7	1	11	42.62	07-4	1	1	BACHELORS	BIOMEDICAL ENGINEERING	1	1	42.62

Please solve all the problems using the excel file pls.

1. A class completed a group project earlier this semester, where everyone played a modified version of the board game Operation. Each participant played the game 3 times and multiple characteristics of the attempts were recorded. These characteristics included participant gender (male/female), result of the game (win/loss), number of objects extracted, and total time played (measured in seconds). A simplified version of the dataset named project_round1_midterm is provided for you, and this dataset presents the results of every participant's first attempt at the game. Use this to answer 1a-1d. (24 points total) a. We want to compare the total game time of the first attempt between men and women. Determine how many men and women participated and determine the sample mean and standard deviation of the game times for men and for women. (6 points) b. Display the distributions of the total game time for men and women by using graphical methods and present them below (boxplots are preferred, but you may choose a different graphical representation as long as it is appropriate and helps to illustrate the distributions). (6 points) c. Use your answer from (a) and (b) to visually assess whether the distribution of game times for men differs from women. This is a subjective interpretation so justify your answer. (2 points) d. It is important to assess whether the variance of total game times are similar for men and women. Construct 95% confidence intervals for the variance of total game time for men and women separately. (8 points) 1. A class completed a group project earlier this semester, where everyone played a modified version of the board game Operation. Each participant played the game 3 times and multiple characteristics of the attempts were recorded. These characteristics included participant gender (male/female), result of the game (win/loss), number of objects extracted, and total time played (measured in seconds). A simplified version of the dataset named project_round1_midterm is provided for you, and this dataset presents the results of every participant's first attempt at the game. Use this to answer 1a-1d. (24 points total) a. We want to compare the total game time of the first attempt between men and women. Determine how many men and women participated and determine the sample mean and standard deviation of the game times for men and for women. (6 points) b. Display the distributions of the total game time for men and women by using graphical methods and present them below (boxplots are preferred, but you may choose a different graphical representation as long as it is appropriate and helps to illustrate the distributions). (6 points) c. Use your answer from (a) and (b) to visually assess whether the distribution of game times for men differs from women. This is a subjective interpretation so justify your answer. (2 points) d. It is important to assess whether the variance of total game times are similar for men and women. Construct 95% confidence intervals for the variance of total game time for men and women separately. (8 points)