Use the SUMIF function in cell J10 to determine the total number of free throws made...
Use the SUMIF function in cell J10 to determine the total number of free throws made by students with black hair.
Use the SUMIF function in cell J17 to determine the total number of free throws made by students with brown eyes.
Use the AVERAGEIF function in cell K10 to determine the average number of free throws made by students with black hair.
Use the AVERAGEIF function in cell K17 to determine the average number of free throws made by students with brown eyes.
Students with "Red" hair had the highest average number of free throws made on the "Hair Color Summary" table and students with "Hazel" eyes had the highest average number of free throws made on the "Eye Color Summary" table. Use the OR function in cell F9 to determine if Student 1 gets a t-shirt. Students get a t-shirt if they have either "Red" hair or "Hazel" eyes. Design your function to return TRUE if an individual student gets a t-shirt and FALSE if they do not.
Use an appropriate function or formula in cell K22 to calculate the number of t-shirts that will be given away.
Homework Answers
Formulas to copy:
|
Cell |
Formula |
|
J10 |
=SUMIF(C9:C308,"Black",E9:E308) |
|
J11 |
=SUMIF(C9:C308,"Brown",E9:E308) |
|
J12 |
=SUMIF(C9:C308,"Red",E9:E308) |
|
J13 |
=SUMIF(C9:C308,"Blond",E9:E308) |
|
J17 |
=SUMIF(D9:D308,"Brown",E9:E308) |
|
J18 |
=SUMIF(D9:D308,"Blue",E9:E308) |
|
J19 |
=SUMIF(D9:D308,"Hazel",E9:E308) |
|
J20 |
=SUMIF(D9:D308,"Green",E9:E308) |
|
K10 |
=AVERAGEIF(C9:C308,"Black",E9:E308) |
|
K11 |
=AVERAGEIF(C9:C308,"Brown",E9:E308) |
|
K12 |
=AVERAGEIF(C9:C308,"Red",E9:E308) |
|
K13 |
=AVERAGEIF(C9:C308,"Blond",E9:E308) |
|
K17 |
=AVERAGEIF(D9:D308,"Brown",E9:E308) |
|
K18 |
=AVERAGEIF(D9:D308,"Blue",E9:E308) |
|
K19 |
=AVERAGEIF(D9:D308,"Hazel",E9:E308) |
|
K20 |
=AVERAGEIF(D9:D308,"Green",E9:E308) |
|
F9 |
=OR(C9="Red",D9="Hazel") |
|
K22 |
=COUNTIF(F9:F308,"TRUE") |
Formulas to copy:
|
Cell |
Formula |
|
J10 |
=SUMIF(C9:C308,"Black",E9:E308) |
|
J11 |
=SUMIF(C9:C308,"Brown",E9:E308) |
|
J12 |
=SUMIF(C9:C308,"Red",E9:E308) |
|
J13 |
=SUMIF(C9:C308,"Blond",E9:E308) |
|
J17 |
=SUMIF(D9:D308,"Brown",E9:E308) |
|
J18 |
=SUMIF(D9:D308,"Blue",E9:E308) |
|
J19 |
=SUMIF(D9:D308,"Hazel",E9:E308) |
|
J20 |
=SUMIF(D9:D308,"Green",E9:E308) |
|
K10 |
=AVERAGEIF(C9:C308,"Black",E9:E308) |
|
K11 |
=AVERAGEIF(C9:C308,"Brown",E9:E308) |
|
K12 |
=AVERAGEIF(C9:C308,"Red",E9:E308) |
|
K13 |
=AVERAGEIF(C9:C308,"Blond",E9:E308) |
|
K17 |
=AVERAGEIF(D9:D308,"Brown",E9:E308) |
|
K18 |
=AVERAGEIF(D9:D308,"Blue",E9:E308) |
|
K19 |
=AVERAGEIF(D9:D308,"Hazel",E9:E308) |
|
K20 |
=AVERAGEIF(D9:D308,"Green",E9:E308) |
|
F9 |
=OR(C9="Red",D9="Hazel") |
|
K22 |
=COUNTIF(F9:F308,"TRUE") |
Add Answer to:
Use the SUMIF function in cell J10 to determine the total number
of free throws made...
Use the SUMIF function in cell J10 to determine the total number of free throws made...
Use the SUMIF function in cell J10 to determine the total number
of free throws made by students with black hair.
Use the SUMIF function in cell J17 to determine the total number
of free throws made by students with brown eyes.
Use the AVERAGEIF function in cell K10 to determine the average
number of free throws made by students with black hair.
Use the AVERAGEIF function in cell K17 to determine the average
number of free throws made by...
- Use the COUNTIF function in cell I10 to determine the number of students with black...
- Use the COUNTIF function in
cell I10 to determine the number of students with black hair. Be
sure to build a formula can be reused by copying down.
- Copy your function in cell I10 and paste it down to complete
the "Count" column of the "Hair Color Summary" table.
- Use the COUNTIF function in cell I17 to determine the number
of students with brown eyes. Be sure to build a formula
can be reused by copying down.
-...
- Use the COUNTIF function in cell I10 to determine the number of students with black hair. Be sure to build a formula c...
- Use the COUNTIF function in
cell I10 to determine the number of students with black hair. Be
sure to build a formula can be reused by copying down.- Copy your function in cell I10 and paste it down to complete
the "Count" column of the "Hair Color Summary" table.- Use the COUNTIF function in cell I17 to determine the number
of students with brown eyes. Be sure to build a formula
can be reused by copying down.- Copy your function...
1.Use the VLOOKUP function in cell F9 to determine the number of days it will take...
1.Use the VLOOKUP function in cell F9 to determine the number of
days it will take to ship order 1. Use the distance in cell E9 to
lookup the appropriate value on the "Delivery Information"
reference table (range K10:M15). Make sure to use relative and
absolute references appropriately.
2.Use the VLOOKUP function in cell G9 to calculate the delivery
price for order 1. The delivery price can be referenced on the
"Delivery Information" lookup table. Use appropriate relative and
absolute...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty pl...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty plant types in the Category column. 9 In cell H13, type Stock Level. In cell H14, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 50, the Value if true is Order. Otherwise the Value if false is OK. Fill the formula down through cell H42. 10 Apply Conditional Formatting to the Stock Level...
Human Genetics Although we humans are fantastically made, are quite complex, and our traits are often...
Human Genetics Although we humans are fantastically made, are quite complex, and our traits are often coded by many genes, some traits are coded by single gene pairs. The following table is a survey to help you determine your genotype, based on phenotype traits. Keep in mind the terms homozygous dominant (AA) will have the dominant trait, homozygous recessive (aa) will have the recessive trait, and heterozygous (Aa) will have the dominant trait. If you have the dominant trait, you...
Match the following terms with the appropriate description below: a. alleles b. autosomes c. dominant allele...
Match the following terms with the appropriate description
below:
a. alleles b. autosomes c. dominant allele d. genotype e.
heterozygous f. homozygote g. phenotype h. recessive allele i. sex
chromosomes
1. ________________ genetic make-up
2. ________________ how genetic make-up is expressed
3. ________________ chromosomes that dictate most body
characteristics
4. ________________ alternative forms of the same gene
5. ___________an individual bearing two alleles that are the same
for a particular trait 6. ________________ an allele that is
expressed, whether in...
Mountain Paths (Part 1) Objectives 2d arrays Store Use Nested Loops Parallel data structures (i.e...
Mountain Paths (Part 1) in C++ Objectives 2d arrays Store Use Nested Loops Parallel data structures (i.e. parallel arrays … called multiple arrays in the zyBook) Transform data Read from files Write to files structs Code Requirements Start with this code: mtnpathstart.zip Do not modify the function signatures provided. Do not #include or #include Program Flow Read the data into a 2D array Find min and max elevation to correspond to darkest and brightest color, respectively Compute the shade of...
Please use own words. Thank you. CASE QUESTIONS AND DISCUSSION > Analyze and discuss the questions...
Please use own words. Thank you.
CASE QUESTIONS AND DISCUSSION > Analyze and discuss the questions listed below in specific detail. A minimum of 4 pages is required; ensure that you answer all questions completely Case Questions Who are the main players (name and position)? What business (es) and industry or industries is the company in? What are the issues and problems facing the company? (Sort them by importance and urgency.) What are the characteristics of the environment in which...
While reading the story, consider the culture (or sub culture) and related communication styles the story...
While reading the story, consider the culture (or sub culture)
and related communication styles the story reveals.
Consider too, possibly, the values, behavioral norms, social
practices, social artifacts, etc.
After reading the story through the lens of this idea, please
compose a full academic length (evidence-based 7 to 11 sentence
long) paragraph which addresses the following prompt:
What does the story reveal about the culture it portrays
and/OR the communication styles the culture shares?
In other words, what does the...
Use the SUMIF function in cell J10 to determine the total number
of free throws made by students with black hair.
Use the SUMIF function in cell J17 to determine the total number
of free throws made by students with brown eyes.
Use the AVERAGEIF function in cell K10 to determine the average
number of free throws made by students with black hair.
Use the AVERAGEIF function in cell K17 to determine the average
number of free throws made by...
- Use the COUNTIF function in
cell I10 to determine the number of students with black hair. Be
sure to build a formula can be reused by copying down.
- Copy your function in cell I10 and paste it down to complete
the "Count" column of the "Hair Color Summary" table.
- Use the COUNTIF function in cell I17 to determine the number
of students with brown eyes. Be sure to build a formula
can be reused by copying down.
-...
- Use the COUNTIF function in
cell I10 to determine the number of students with black hair. Be
sure to build a formula can be reused by copying down.- Copy your function in cell I10 and paste it down to complete
the "Count" column of the "Hair Color Summary" table.- Use the COUNTIF function in cell I17 to determine the number
of students with brown eyes. Be sure to build a formula
can be reused by copying down.- Copy your function...
1.Use the VLOOKUP function in cell F9 to determine the number of
days it will take to ship order 1. Use the distance in cell E9 to
lookup the appropriate value on the "Delivery Information"
reference table (range K10:M15). Make sure to use relative and
absolute references appropriately.
2.Use the VLOOKUP function in cell G9 to calculate the delivery
price for order 1. The delivery price can be referenced on the
"Delivery Information" lookup table. Use appropriate relative and
absolute...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty plant types in the Category column. 9 In cell H13, type Stock Level. In cell H14, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 50, the Value if true is Order. Otherwise the Value if false is OK. Fill the formula down through cell H42. 10 Apply Conditional Formatting to the Stock Level...
Match the following terms with the appropriate description
below:
a. alleles b. autosomes c. dominant allele d. genotype e.
heterozygous f. homozygote g. phenotype h. recessive allele i. sex
chromosomes
1. ________________ genetic make-up
2. ________________ how genetic make-up is expressed
3. ________________ chromosomes that dictate most body
characteristics
4. ________________ alternative forms of the same gene
5. ___________an individual bearing two alleles that are the same
for a particular trait 6. ________________ an allele that is
expressed, whether in...
Please use own words. Thank you.
CASE QUESTIONS AND DISCUSSION > Analyze and discuss the questions listed below in specific detail. A minimum of 4 pages is required; ensure that you answer all questions completely Case Questions Who are the main players (name and position)? What business (es) and industry or industries is the company in? What are the issues and problems facing the company? (Sort them by importance and urgency.) What are the characteristics of the environment in which...
While reading the story, consider the culture (or sub culture)
and related communication styles the story reveals.
Consider too, possibly, the values, behavioral norms, social
practices, social artifacts, etc.
After reading the story through the lens of this idea, please
compose a full academic length (evidence-based 7 to 11 sentence
long) paragraph which addresses the following prompt:
What does the story reveal about the culture it portrays
and/OR the communication styles the culture shares?
In other words, what does the...
Most questions answered within 3 hours.
-
Suppose that you know that in the population of full-time
employees in the United States, the...
asked 1 minute from now -
This experiment was designed originally to sample various meat and carcass quality
aspects of Ontario pigs...
asked 42 seconds from now -
) Raw materials are studied for contamination. Suppose that
the number of particles of contamination per...
asked 13 minutes ago -
After running a regression analysis we calculated an F test and
the significance level was 0.15....
asked 9 minutes ago -
----Can someone please help me solve this one using JAVA
----I thank you in advance
Create...
asked 13 minutes ago -
1. What force primarily attracts the potassium ion to
the nitrate ion?
a. London forces...
asked 15 minutes ago -
What are the negative effects of abruptly stopping the use of
all fossil fuels? Give at...
asked 22 minutes ago -
Given that many conflict are the result of different parties having
different interests, is it possible...
asked 27 minutes ago -
A 750 g block can slide uniformly along the horizontal track
when a string attached to...
asked 30 minutes ago -
In 2017, Juan entered into a contract to write a book. The
publisher advanced Juan $50,000,...
asked 43 minutes ago -
Determine the number of kinds of protons in each molecule (w/
respect to NMR spectroscopy). Drawing...
asked 54 minutes ago -
A jeweler whose near point is 68 cm from his eye uses a
magnifying glass as...
asked 52 minutes ago