Question
Name DOB Gender Math Science English Scholarship Dray 1/27/1989 Female 8 10 9 900 Vivian 9/2/1981...
|
Name |
DOB |
Gender |
Math |
Science |
English |
Scholarship |
|
Dray |
1/27/1989 |
Female |
8 |
10 |
9 |
900 |
|
Vivian |
9/2/1981 |
Female |
6 |
9 |
7 |
100 |
|
Tucker |
3/8/1985 |
Male |
5 |
6 |
7 |
200 |
|
Beta |
2/9/1979 |
Male |
5 |
5 |
7 |
0 |
|
Lisa |
11/5/1984 |
Female |
9 |
6 |
5 |
300 |
|
Lulu |
8/17/1976 |
Female |
10 |
5 |
9 |
500 |
Using only 1 excel function, calculate the average of students who are: (1) female and (2) receive at least two grades of 6 in any subject. Please post your full formula along with the result.
Homework Answers
Answer #1
Formula:
=IF(AND(C2="Female",COUNTIF(D2:F2,">=6")>=2),AVERAGE(D2:F2)," ")
/* PLEASE UPVOTE */
Not the answer you're looking for?
Similar Questions
The following data contains monthly U.S. domestic air miles traveled during the years 1970-2004 , determine...
The following data contains monthly U.S. domestic air miles
traveled during the years 1970-2004 , determine the trend and
seasonality for the years 1995-2004 and Try both additive and
multiplicative models and for the multiplicative model, use only
one constraint: the average of seasonal indices set to 1
Year
Month
DATA
1970
1
9764490
1970
2
8163943
1970
3
9875362
1970
4
9289053
1970
5
10029494
1970
6
11821707
1970
7
12630952
1970
8
13495546
1970
9
10283314
1970
10...
Identification Number Field Choice Gender 1 Business Male 2 Other Female 3 Business Female 4 Science...
Identification Number
Field Choice
Gender
1
Business
Male
2
Other
Female
3
Business
Female
4
Science
Female
5
Science
Male
6
Other
Female
7
Business
Male
8
Science
Male
9
Science
Male
10
Business
Female
11
Other
Female
12
Other
Male
13
Business
Male
14
Business
Female
15
Science
Male
16
Business
Female
17
Science
Male
18
Science
Female
19
Science
Female
20
Business
Female
21
Other
Male
22
Business
Male
23
Business
Female
24
Other
Male
25
Other
Male...
1. It has been suggested that global warming may increase the frequency of hurricanes. The table...
1. It has been suggested that global warming may increase the
frequency of hurricanes. The table given below shows the number of
major Atlantic hurricanes recorded annually before and after
1990.
before 1995
after 1995
year
# of
storms
year
# of
storms
1976
2
1996
6
1977
1
1997
1
1978
2
1998
3
1979
2
1999
5
1980
2
2000
3
1981
3
2001
4
1982
1
2002
2
1983
1
2003
3
1984
1
2004
6
1985...
StudentNO Gender Height in inchese 1 Female 63 2 Female 64.0 3 Male 67.0 4 Female...
StudentNO
Gender
Height in inchese
1
Female
63
2
Female
64.0
3
Male
67.0
4
Female
59
5
Male
60
6
Female
61
7
Female
62
8
Female
63
9
Female
63
10
Female
64
11
Male
64
12
Female
65
13
Female
65
14
Female
65
15
Female
65
16
Female
66
17
Female
66
18
Male
67
19
Male
67
20
Male
67
21
Female
67
22
Male
67
23
Male
67
24
Female
67.5
25
Male
68...
Yes Maybe No Male 18 2 34 Female 8 6 42 1, Write an appropriate null...
Yes
Maybe
No
Male
18
2
34
Female
8
6
42
1, Write an appropriate null hypothesis for this analysis.
2. What is the value of the chi-square statistic?
3. What are the reported degrees of freedom?
4. What is the reported level of significance?
5. Based on the results of the chi-square test of independence
is there a statistically significant relationship between gender
and attitude toward cooperative learning?
6. What percent of male favor compulsory cooperative learning in
schools?...
Pair 1 2 3 4 5 6 7 8 9 10 Medication 7 8 9 5...
Pair 1 2 3 4 5 6 7 8 9 10
Medication 7 8 9 5 6 7 7 8 8 7
Placebo 5 5 7 6 8 7 5 9 3 7
(Note: If you’re going to subtract, choose the order medication
- placebo.)
A sample of patients with similar weight and age characteristics
were put in pairs. One patient in the pair was given medication
while the other patient was given a placebo. After a month patients
were...
Case Hospitalized? Gender Age Insured Count of Patients 1 Yes Male >65 Yes 10 2 Yes...
Case
Hospitalized?
Gender
Age
Insured
Count of Patients
1
Yes
Male
>65
Yes
10
2
Yes
Male
<65
Yes
20
3
Yes
Female
>65
Yes
30
4
Yes
Female
<65
No
40
5
No
Male
>65
No
20
6
No
Male
<65
No
40
7
No
Female
>65
No
60
8
No
Female
<65
No
80
Using the above data answer the following questions:
What is the probability of hospitalization given that you are
male? Select all males and count...
Q P TR MR TC MC 0 10 ---- 4 1 9 8 2 8 11...
Q
P
TR
MR
TC
MC
0
10
----
4
1
9
8
2
8
11
3
7
13
4
6
14
5
5
16
6
4
19
7
3
24
8
2
30
What profit should this firm be earning?
Let p = (8, 10, 3, 11, 4, 0, 5, 1, 6, 2, 7, 9) and...
Let p = (8, 10, 3, 11, 4, 0, 5, 1, 6, 2, 7, 9) and let q = (2,
4, 9, 5, 10, 6, 11, 7, 0, 8, 1, 3) be tone rows. Verify that p =
Tk(R(I(q))) for some k, and find this value of k.
HouseholdGroupAnnual IncomeSex of Head of Household #1$65,000Female #2$43,000Male #3$48,000Female #4 $52,000Male #5$40,000Male #6$52,000Female #7$45,000Male #8$42,000Female #9$63,000Male...
HouseholdGroupAnnual IncomeSex of Head of Household
#1$65,000Female
#2$43,000Male
#3$48,000Female
#4 $52,000Male
#5$40,000Male
#6$52,000Female
#7$45,000Male
#8$42,000Female
#9$63,000Male
a.Is there an earnings gap based on sex in this
neighborhood?
b.If there is an earnings gap, does it favor female or male
headed households?
c.If there is an earnings gap, can you conclude that it is due
to sex-based labor market
discrimination? Why or why not? Be specific.
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 7 minutes ago
asked 16 minutes ago
asked 33 minutes ago
asked 42 minutes ago
asked 55 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago