Question: can u please explain how to do this question in an excel with formulas Problem Statement: A sample of 55 students is selected. Data is

can u please explain how to do this question in an excel with formulas
can u please explain how to do this question in an excel
with formulas Problem Statement: A sample of 55 students is selected. Data
is collected on the students' GPA, the # of hours studying per
week, the # of hours sleeping per night and gender. Divide the

Problem Statement: A sample of 55 students is selected. Data is collected on the students' GPA, the # of hours studying per week, the # of hours sleeping per night and gender. Divide the sample into two samples based on gender (Females versus Males). Calculate the statistics for all variables and answer the following questions: a) Decide at the level of significance of 5% if there is any difference between the average GPA of females and males. b) Decide at the level of significance of 5% if there is any difference between the average # of hours studying per week of females and males. c) Decide at the level of significance of 5% if there is any difference between the average # of hours sleeping per night of females and males. I> E F N 3 9 A B C D 1 gpa studyweek sleepnigh gender 3.89 50 6 female 3 3.9 15 6 female 4 3.75 15 7 female 5 3.6 10 6 male 6 4 25 7 female 7 3.15 20 7 male 8 3.25 15 6 female 3.925 10 8 female 10 3.428 12 8 female 11 3.8 2 8 male 12 3.9 10 8 female 13 2.9 30 6 female 14 3.925 30 7 female 15 3.65 21 9 female 3.75 8.5 female 17 4.67 14 6.5 male 18 3.1 12 7.5 male 19 3.8 12 8 female 20 3.4 4 9 female 21 3.575 45 6.5 female 22 3.85 6 7 female 23 3.4 10 7 female 24 3.5 12 8 male 0 CO 1 BBBBBENSBNB SM 16 10 A CI 00 B E 1 13 25 26 3.6 3.825 35 27 3.925 10 28 4 40 29 3.425 14 30 3.75 30 31 3.15 00 8 32 8 33 34 3.4 3.7 3.36 3.7 3.7 20 40 35 15 D 6 female 8 female 8 female 8 female 9 female 6 female 6 female 6.5 female 7 female 7 female 7 male 5 female 7 female 7 female 6 female 8 male 7 female 6 female 7 female 5 male 7.5 female 5 female 7 male 9 male 8 male 36 25 8 on con 8 10 18 15 30 37 38 39 40 41 42 43 44 45 46 47 48 49 3.6 3.825 3.2 3.5 3.5 3 3.98 3.7 3.81 st 11 28 4 4 25 42 3 42 25 4 3.1 3.4 3.5 A B C 3.65 20 51 3.7 N 6 female 8 female 8 female 7 female 3.1 6 53 4 20 54 3.35 45 55 3.541 30 6 female 7.5 female 6 female 2.9 20 57 Problem Statement: A sample of 55 students is selected. Data is collected on the students' GPA, the # of hours studying per week, the # of hours sleeping per night and gender. Divide the sample into two samples based on gender (Females versus Males). Calculate the statistics for all variables and answer the following questions: a) Decide at the level of significance of 5% if there is any difference between the average GPA of females and males. b) Decide at the level of significance of 5% if there is any difference between the average # of hours studying per week of females and males. c) Decide at the level of significance of 5% if there is any difference between the average # of hours sleeping per night of females and males. I> E F N 3 9 A B C D 1 gpa studyweek sleepnigh gender 3.89 50 6 female 3 3.9 15 6 female 4 3.75 15 7 female 5 3.6 10 6 male 6 4 25 7 female 7 3.15 20 7 male 8 3.25 15 6 female 3.925 10 8 female 10 3.428 12 8 female 11 3.8 2 8 male 12 3.9 10 8 female 13 2.9 30 6 female 14 3.925 30 7 female 15 3.65 21 9 female 3.75 8.5 female 17 4.67 14 6.5 male 18 3.1 12 7.5 male 19 3.8 12 8 female 20 3.4 4 9 female 21 3.575 45 6.5 female 22 3.85 6 7 female 23 3.4 10 7 female 24 3.5 12 8 male 0 CO 1 BBBBBENSBNB SM 16 10 A CI 00 B E 1 13 25 26 3.6 3.825 35 27 3.925 10 28 4 40 29 3.425 14 30 3.75 30 31 3.15 00 8 32 8 33 34 3.4 3.7 3.36 3.7 3.7 20 40 35 15 D 6 female 8 female 8 female 8 female 9 female 6 female 6 female 6.5 female 7 female 7 female 7 male 5 female 7 female 7 female 6 female 8 male 7 female 6 female 7 female 5 male 7.5 female 5 female 7 male 9 male 8 male 36 25 8 on con 8 10 18 15 30 37 38 39 40 41 42 43 44 45 46 47 48 49 3.6 3.825 3.2 3.5 3.5 3 3.98 3.7 3.81 st 11 28 4 4 25 42 3 42 25 4 3.1 3.4 3.5 A B C 3.65 20 51 3.7 N 6 female 8 female 8 female 7 female 3.1 6 53 4 20 54 3.35 45 55 3.541 30 6 female 7.5 female 6 female 2.9 20 57

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!