Introduction to Mathematical Sciences Homework

Math 1930 Introduction to Mathematical Sciences Homework on the IF and related Functions All of these problems center on the class data spreadsheet. Get a clean copy of it and add a column to the spreadsheet for each of the following problems. 1. Some people can see more colors than other people. Usually peopie whose favo1ite color is a primary color (red, green, blue) cannot see as many colors. Classify each person as “Color Poor” (favo1ite M & M color is one of red, green and blue) or “Color Rich” (everyone else). Write an English sentence that starts with the word· “If” that describes how to determine who is Color Poor. Now add a column to your spreadsheet to compute who is Color Poor. 2. A person whose foot length is exactly the same as his/her forearm length is evenly proportioned. Identify those people who “Evenly Proportioned”. W1ite an English sentence that starts with the word “If” that describes how to determine who is Evenly Proportioned. Now add a column to your spreadsheet to compute who is Evenly Propo1tioned. 3. People who spend a iot of money on a haircut and come from big families are likely to spend a lot of money on all of those haircuts. The average family size in the U.S. is 2.6 children. Let’s call any family with four or more children a “Big Family.” Let’s call a haircut expensive if it cost more . who are· potentially going to go broke paying for haircuts. than $10. Identify all the people in class Write an English sentence that starts with the word “If” that describes how to determine those who might go broke paying for haircuts. Now add a column to your spreadsheet to identify those · 4. Someone has “Exceptional Height” if their height is outside of the range from two standard deviations below the average to one standard deviation above the average. Write an English sentence that starts with the word “If” that describes how to determ ine those people with exceptional height. Now add a column to your spreadsheet to identify those people. First Name Age(in Months) Height(in Shoe Size centimenters) Becky 660 167.64 Jessie 318 165.09 7 9 Foot (in centimeters) Academic Forearm(in Status(freshman,soph centimeters) more,Junior,senior,gra d, or special) Amount you Favorite # of siblings paid for your # of miles Color including Birthday(day/month/Year) last haircut M&M yourself ($) 26.67 27.94 special blue 5 27/06/1965 $4.00 10 22.86 24.13 special blue 3 7/13/1994 $12.00 140 Ben 237 182.88 13 28 31 freshman green 4 16/03/2001 $18.00 8 Tiffany 258 157.48 6.5 23 22 freshman yellow 5 7/7/1999 $0 4.7 15 Morgan 264 162.56 9 22.86 23 freshman blue 3 3/5/1998 $25 Amanda 480 167.005 8 24 24 special green 5 2/28/1980 $65 93 Zeina 372 157.48 8 24 24 freshman blue 4 14/04/1989 $30 207 Victor 435 167.64 8 24 24 freshman blue 3 9/9/1984 $22 15 Gina 456 170 9.5 24 9 special red 3 10/19/1982 $60 174 Elizabeth 480 165.1 11 26.7 20 special red 5 12/20/1980 $60 16 Tammy 576 165 8.5 22 22 Sophmore green 5 12/22/1972 $32 38 Jacqueline 492 179.26 7 1/2 23.8 23 special green 3 24/9/1979 $41 223 Taylor 258 180.3 11.5 27.4 23 Sophmore blue 3 7/2/1999 $20 82 Samantha 480 170.2 9 24.7 24 freshman blue 4 1/15/1981 $40 236 Illeana 228 160.02 7 23.5 22 freshman yellow 7 12/21/2001 $25 33 Mari 456 170.18 10 25.9 25.5 Senior blue 7 6/20/1982 $25 3 Allison 228 162.56 8 24 24 Freshman Blue 3 9/11/2001 $0 41 h Please do not to edit this except for entering your data
Purchase answer to see full attachment