Tag: Mathematics

  • [Solved] Crituqe

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering Crituqe.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] tax

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering tax.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] Mathematics homework help

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    I need support with a math question. I will attach the document for review. – ## math216week2hw.pdf **## math216week2hw.pdf** Borough of Manhattan Community College Mathematics Department Name___________________________ Instructor L. Erstenyuk Date ____________…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    I need support with a math question. I will attach the document for review.

    – ## math216week2hw.pdf

    **## math216week2hw.pdf**

    Borough of Manhattan Community College

    Mathematics Department

    Name___________________________ Instructor L. Erstenyuk

    Date ___________________________ MAT 216-_____________

    EXAM 1 REVIEW

    Instructions. Show all steps and label answers. Papers will be graded on clarity, neatness

    and organization as well as correctness. You may use a regular scientific calculator during

    the exam.

    1. Create a tree diagram to represent the possible combinations of outfits for a school

    dress code. The pants must be either navy or tan and the shirts must be white, red, or

    blue.

    2. Create a product table illustrating the possible outcomes of rolling two four-sided dice

    (with numbers 1 – 4). Then answer the questions.

    a.) List the ways that both dice are show even numbers?

    b.) What is the probability that both dice are showing even numbers?

    c.) What is the probability the sum of the dice is at most seven?

    d.) What are the odds in favor of the dice summing to at most seven?

    Die 1 (down),

    Die 2 (across)

    Yvonne Logan

    6/4/25

    Red shirt

    white shirt

    blue shirt

    Navy pants

    tan pants

    Navy pants

    tan pants

    navy pants

    tan pants

    1

    2

    3

    4

    1

    2

    3

    4

    2

    4

    6

    8

    3

    4

    5

    3

    4

    5

    5

    6

    5

    7

    6

    7

    ( 2,2) (4,4)

    50% because there are an equal amount of even and odd numbers

    Evaluate without using a calculator.

    3. 4!

    4. 6!

    5.
    10!

    8!

    6.
    12!

    9! ∙ 3!

    7. How many odd four-digit numbers exist in our Hindu-Arabic number system?

    8. How many odd four-digit numbers that do not contain the digits 2 or 4 exist in our Hindu-

    Arabic number system?

    9. The town of Holmdel, NJ has three prefixes (the first three digits of a 7-digit phone

    number), 946, 739, and 264. Assuming no other restrictions, how many phone numbers

    can be given to residents of Holmdel?

    4x3x2x1

    =24

    6x5x4x3x2x1

    =720

    10x9x /8!

    8!

    10 x 9 = 90

    12 x 11 x 10 9 x 8 x 7 x 6 x 5 x4 3!

    9! x 3!

    79,833,600

    362,880

    220

    four digit A, B, C, D must be odd 1, 3, 5, 7, 9

    10. Write the formula, substitute, then evaluate:

    a) ⬚13𝑃3

    b) ⬚21𝐶18

    11. The Stand Up Comedy Club at Webber College has 6 members:

    {Abe, Bart, Carl, Homer, Lisa, Marge}

    ai.) How many ways could they be ordered for a show?

    aii.) What is the probability the first comedian will be female?

    bi.) How many ways could two people be chosen to attend a Laugh-a-Minute workshop?

    bii.) What is the probability the two people chosen for the workshop are both male?

    12. How many different Golf hands could be dealt from a standard deck of 52 cards if in

    the game of Golf each player receives 4 cards?

    p( n,r)= n!
    (n-r)!

    13!
    (13-3) !

    21!
    18! 3!

    2 female
    4 males
    6 total members

    2 female
    4 males
    6 total members

    13. Utah’s license plates have two letters followed by three numbers followed by another

    letter. How many possible combinations of Utah license plates exist (before not

    allowing inappropriate plates)?

    14. Find the number of distinguishable arrangements of the letters of the word

    HAVANNAH.

    15. Refer to Pascal’s Triangle. Suppose seven fair coins are tossed.

    a) How many ways could the 7 coins land total?

    b) Find the number of ways there could be exactly two heads.

    c) What is the probability exactly two coins will land on heads?

    d) What is the probability that at least two coins will land on heads?

    16. Consider the standard deck of 52 cards.

    a) If a single card is chosen from the deck, what is the probability it will be a ten or a

    red card?

    b) If two cards are dealt from a deck of cards, then what is the probability they will

    both be face cards?

    17. If an integer is chosen at random from 1 – 38, what is the probability it is a multiple

    of 3 or a multiple of 4?

    18. There are 9 black, 6 navy, and 5 green marbles in a bag. One marble is chosen at

    random and its color is recorded. A second marble is drawn and its color is recorded.

    Create a probability tree representing this information.

    a) What is the probability of choosing two green marbles?

    b) What is the probability at least one marble is black?

    c) What is the probability of selecting one navy marble and one black marble (in either

    order, that is, navy then black or black then navy)?

    d) What is the probability neither marble is black?

    19. The owner of a restaurant serving Continental-style entrees was interested in studying

    ordering patterns of patrons for the Friday-to-Sunday weekend time period. Records

    were maintained that indicated the demand for dessert during the same period of time:

    DEMAND FOR DESSERT

    Desert Ordered Male Female Total

    Yes 96 40 136

    No 224 240 464

    Total 320 280 600

    A waiter approaches a table to take an order. What is the probability that the first customer to

    order at the table:

    a) Orders a dessert?

    b) Is a male?

    c) Is a female and does not order a dessert?

    d) Is a female or does not order a dessert?

    e) Orders a dessert given a customer is a female?

    20. Use the binomial formula to compute the following probability:

    𝑛 = 7, 𝑝 = 0.6, 𝑥 = 4.

    21. A 35-year-old woman purchases a $100,000 term life insurance policy for an annual

    payment of $360. Based on a period life table for the U.S. government, the

    probability that she will survive the year is 0.999057. Find the expected value of the

    policy for the insurance company.

    E company premium – payout

    **## math216week2hw.pdf**

    Borough of Manhattan Community College

    Mathematics Department

    Name___________________________ Instructor L. Erstenyuk

    Date ___________________________ MAT 216-_____________

    EXAM 1 REVIEW

    Instructions. Show all steps and label answers. Papers will be graded on clarity, neatness

    and organization as well as correctness. You may use a regular scientific calculator during

    the exam.

    1. Create a tree diagram to represent the possible combinations of outfits for a school

    dress code. The pants must be either navy or tan and the shirts must be white, red, or

    blue.

    2. Create a product table illustrating the possible outcomes of rolling two four-sided dice

    (with numbers 1 – 4). Then answer the questions.

    a.) List the ways that both dice are show even numbers?

    b.) What is the probability that both dice are showing even numbers?

    c.) What is the probability the sum of the dice is at most seven?

    d.) What are the odds in favor of the dice summing to at most seven?

    Die 1 (down),

    Die 2 (across)

    Yvonne Logan

    6/4/25

    Red shirt

    white shirt

    blue shirt

    Navy pants

    tan pants

    Navy pants

    tan pants

    navy pants

    tan pants

    1

    2

    3

    4

    1

    2

    3

    4

    2

    4

    6

    8

    3

    4

    5

    3

    4

    5

    5

    6

    5

    7

    6

    7

    ( 2,2) (4,4)

    50% because there are an equal amount of even and odd numbers

    Evaluate without using a calculator.

    3. 4!

    4. 6!

    5.
    10!

    8!

    6.
    12!

    9! ∙ 3!

    7. How many odd four-digit numbers exist in our Hindu-Arabic number system?

    8. How many odd four-digit numbers that do not contain the digits 2 or 4 exist in our Hindu-

    Arabic number system?

    9. The town of Holmdel, NJ has three prefixes (the first three digits of a 7-digit phone

    number), 946, 739, and 264. Assuming no other restrictions, how many phone numbers

    can be given to residents of Holmdel?

    4x3x2x1

    =24

    6x5x4x3x2x1

    =720

    10x9x /8!

    8!

    10 x 9 = 90

    12 x 11 x 10 9 x 8 x 7 x 6 x 5 x4 3!

    9! x 3!

    79,833,600

    362,880

    220

    four digit A, B, C, D must be odd 1, 3, 5, 7, 9

    10. Write the formula, substitute, then evaluate:

    a) ⬚13𝑃3

    b) ⬚21𝐶18

    11. The Stand Up Comedy Club at Webber College has 6 members:

    {Abe, Bart, Carl, Homer, Lisa, Marge}

    ai.) How many ways could they be ordered for a show?

    aii.) What is the probability the first comedian will be female?

    bi.) How many ways could two people be chosen to attend a Laugh-a-Minute workshop?

    bii.) What is the probability the two people chosen for the workshop are both male?

    12. How many different Golf hands could be dealt from a standard deck of 52 cards if in

    the game of Golf each player receives 4 cards?

    p( n,r)= n!
    (n-r)!

    13!
    (13-3) !

    21!
    18! 3!

    2 female
    4 males
    6 total members

    2 female
    4 males
    6 total members

    13. Utah’s license plates have two letters followed by three numbers followed by another

    letter. How many possible combinations of Utah license plates exist (before not

    allowing inappropriate plates)?

    14. Find the number of distinguishable arrangements of the letters of the word

    HAVANNAH.

    15. Refer to Pascal’s Triangle. Suppose seven fair coins are tossed.

    a) How many ways could the 7 coins land total?

    b) Find the number of ways there could be exactly two heads.

    c) What is the probability exactly two coins will land on heads?

    d) What is the probability that at least two coins will land on heads?

    16. Consider the standard deck of 52 cards.

    a) If a single card is chosen from the deck, what is the probability it will be a ten or a

    red card?

    b) If two cards are dealt from a deck of cards, then what is the probability they will

    both be face cards?

    17. If an integer is chosen at random from 1 – 38, what is the probability it is a multiple

    of 3 or a multiple of 4?

    18. There are 9 black, 6 navy, and 5 green marbles in a bag. One marble is chosen at

    random and its color is recorded. A second marble is drawn and its color is recorded.

    Create a probability tree representing this information.

    a) What is the probability of choosing two green marbles?

    b) What is the probability at least one marble is black?

    c) What is the probability of selecting one navy marble and one black marble (in either

    order, that is, navy then black or black then navy)?

    d) What is the probability neither marble is black?

    19. The owner of a restaurant serving Continental-style entrees was interested in studying

    ordering patterns of patrons for the Friday-to-Sunday weekend time period. Records

    were maintained that indicated the demand for dessert during the same period of time:

    DEMAND FOR DESSERT

    Desert Ordered Male Female Total

    Yes 96 40 136

    No 224 240 464

    Total 320 280 600

    A waiter approaches a table to take an order. What is the probability that the first customer to

    order at the table:

    a) Orders a dessert?

    b) Is a male?

    c) Is a female and does not order a dessert?

    d) Is a female or does not order a dessert?

    e) Orders a dessert given a customer is a female?

    20. Use the binomial formula to compute the following probability:

    𝑛 = 7, 𝑝 = 0.6, 𝑥 = 4.

    21. A 35-year-old woman purchases a $100,000 term life insurance policy for an annual

    payment of $360. Based on a period life table for the U.S. government, the

    probability that she will survive the year is 0.999057. Find the expected value of the

    policy for the insurance company.

    E company premium – payout

  • [Solved] Math 1342 excel spresdsheet

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    Can anyone help with excel and statistic? – ## chapter6excelassignment.docx – ## math1342_database3.xlsx **## chapter6excelassignment.docx** 1. Top of Form Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course: [MATH 1342 Database.xlsx](https://cont…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Can anyone help with excel and statistic?

    – ## chapter6excelassignment.docx

    – ## math1342_database3.xlsx

    **## chapter6excelassignment.docx**

    1.

    Top of Form

    Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course:
    [MATH 1342 Database.xlsx](https://content.ctcd.edu/courses/math1342-lec/m23/docs/math1342_database.xlsx)

    Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using
    **=AVERAGE(A2:A36)** and =
    **STDEV(A2:A36)**.

    (Round your answers to 5 decimal places)

    Fill in the blank:

    The
    **mean** of the DRIVE variable is
    **Blank 1**.

    The
    **standard deviation** of the DRIVE variable is
    **Blank 2**.

    · Blank 1

    · Blank 2

    Bottom of Form

    2.

    Top of Form

    Question 2

    **Question 2**

    **2 Points**

    Question 2

    Assuming that this variable is normally distributed, what proportion of the data would you predict to be less than 40 minutes? This would be based on the calculated probability.

    To approximate this probability with Excel, find a free cell on the spreadsheet and use the formula
    **=NORM.DIST(40,mean,stdev,TRUE)**. For the "mean" and "stdev" in the formula, you
    _don't_ want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The proportion of values that I expect to be less than 40 minutes is _____________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    3.

    Top of Form

    Question 3

    **Question 3**

    **2 Points**

    Question 3

    Now, determine the
    **_actual_** proportion of data points in the dataset that fall within this range (less than 40 minutes). To find the actual proportion, sort the DRIVE variable, and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The actual proportion of values less than 40 minutes is ___________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    4.

    Top of Form

    Question 4

    **Question 4**

    **2 Points**

    Question 4

    How does your predicted probability from question 2 compare to the actual probability calculated in question 3? In other words, if these values are different, why do you think they're different, etc?

    Option A

    The probability calculations are different. In part 2, we calculated the probability based on the assumption that the distribution of the "drive" variable is normally distributed. If the distribution is not bell-shaped, then the probability estimation (in part 2) would not be accurate.

    Option B

    The probability calculations are the same.

    Option C

    The probability calculations are different. This must mean that something is wrong with our technology.

    Bottom of Form

    **## math1342_database3.xlsx**

    ## MATH399 Data Sheet

    | | | | | | | | | | | | |
    | — | — | — | — | — | — | — | — | — | — | — | — |
    | Drive (miles) | Birth Year | State | Shoe Size | Height (inches) | Sleep (hours) | Gender | Class Standing | Car Color | TV (hours) | Money (dollars) | Coin |
    | 4 | 1988 | NY | 9 | 69 | 7 | F | Sophomore | blue | 5 | 21.00 | 5 |
    | 6 | 1990 | OR | 13 | 75 | 10 | M | Junior | silver | 6 | 7.00 | 4 |
    | 6 | 1978 | MI | 10 | 66 | 6 | M | Freshman | black | 5 | 34.00 | 3 |
    | 20 | 1977 | IL | 5 | 62 | 7 | F | Junior | black | 3 | 10.00 | 2 |
    | 20 | 1985 | OR | 7 | 65 | 4 | F | Sophomore | green | 1 | 46.00 | 4 |
    | 25 | 1988 | CA | 8 | 69 | 6 | F | Senior | silver | 4 | 30.00 | 4 |
    | 25 | 1995 | GA | 9 | 63 | 7 | M | Junior | silver | 3 | 53.00 | 5 |
    | 28 | 1992 | NY | 7 | 67 | 4 | F | Freshman | black | 1 | 25.00 | 4 |
    | 29 | 1990 | TX | 11 | 70 | 7 | M | Freshman | silver | 2 | 28.00 | 3 |
    | 33 | 1985 | SC | 11 | 68 | 8 | M | Sophomore | blue | 1 | 9.00 | 4 |
    | 33 | 1990 | TX | 9 | 75 | 7 | M | Senior | silver | 5 | 54.00 | 7 |
    | 36 | 1982 | MI | 10 | 61 | 7 | M | Senior | blue | 6 | 5.00 | 2 |
    | 36 | 1996 | TX | 7 | 66 | 5 | M | Freshman | orange | 3 | 7.00 | 3 |
    | 36 | 1990 | IL | 12 | 61 | 7 | M | Junior | red | 4 | 14.00 | 3 |
    | 36 | 1988 | OR | 9 | 73 | 7 | M | Sophomore | blue | 5 | 23.00 | 5 |
    | 40 | 1987 | IL | 10 | 68 | 6 | M | Sophomore | silver | 5 | 16.00 | 5 |
    | 42 | 1962 | IL | 8 | 65 | 6 | F | Junior | red | 4 | 4.00 | 4 |
    | 54 | 1968 | FL | 9 | 70 | 8 | F | Freshman | green | 2 | 5.00 | 3 |
    | 54 | 1970 | NV | 11 | 65 | 4 | F | Freshman | silver | 5 | 54.00 | 7 |
    | 55 | 1997 | OH | 9 | 67 | 6 | F | Freshman | dark blue | 4 | 27.00 | 2 |
    | 63 | 1990 | PA | 10 | 66 | 8 | F | Sophomore | silver | 3 | 5.00 | 7 |
    | 63 | 1986 | MI | 5 | 69 | 7 | F | Sophomore | orange | 3 | 9.00 | 2 |
    | 71 | 1984 | MI | 11 | 64 | 6 | F | Freshman | silver | 2 | 1.00 | 2 |
    | 73 | 1968 | FL | 12 | 70 | 7 | F | Junior | green | 4 | 15.00 | 3 |
    | 73 | 1987 | SC | 11 | 68 | 7 | F | Junior | red | 2 | 18.00 | 5 |
    | 76 | 1985 | PA | 11 | 70 | 8 | F | Sophomore | blue | 3 | 5.00 | 4 |
    | 76 | 1992 | NY | 9 | 65 | 7 | F | Freshman | red | 6 | 7.00 | 2 |
    | 76 | 1990 | PA | 11 | 63 | 4 | M | Sophomore | silver | 5 | 13.00 | 5 |
    | 76 | 1991 | NY | 9 | 63 | 6 | M | Sophomore | silver | 4 | 38.00 | 2 |
    | 78 | 1995 | CA | 11 | 63 | 6 | M | Junior | blue | 2 | 47.00 | 2 |
    | 80 | 1989 | NV | 12 | 69 | 8 | M | Senior | white | 4 | 3.00 | 4 |
    | 80 | 1990 | SC | 10 | 63 | 8 | F | Senior | black | 2 | 7.00 | 7 |
    | 80 | 1999 | FL | 9 | 66 | 7 | F | Freshman | black | 5 | 22.00 | 2 |
    | 88 | 1998 | SC | 6 | 63 | 5 | F | Freshman | black | 3 | 43.00 | 6 |
    | 94 | 1983 | KY | 11 | 74 | 8 | M | Sophomore | red | 3 | 20.00 | 4 |

    ## Sheet1

    |
    |

    **## math1342_database3.xlsx**

    ## MATH399 Data Sheet

    | | | | | | | | | | | | |
    | — | — | — | — | — | — | — | — | — | — | — | — |
    | Drive (miles) | Birth Year | State | Shoe Size | Height (inches) | Sleep (hours) | Gender | Class Standing | Car Color | TV (hours) | Money (dollars) | Coin |
    | 4 | 1988 | NY | 9 | 69 | 7 | F | Sophomore | blue | 5 | 21.00 | 5 |
    | 6 | 1990 | OR | 13 | 75 | 10 | M | Junior | silver | 6 | 7.00 | 4 |
    | 6 | 1978 | MI | 10 | 66 | 6 | M | Freshman | black | 5 | 34.00 | 3 |
    | 20 | 1977 | IL | 5 | 62 | 7 | F | Junior | black | 3 | 10.00 | 2 |
    | 20 | 1985 | OR | 7 | 65 | 4 | F | Sophomore | green | 1 | 46.00 | 4 |
    | 25 | 1988 | CA | 8 | 69 | 6 | F | Senior | silver | 4 | 30.00 | 4 |
    | 25 | 1995 | GA | 9 | 63 | 7 | M | Junior | silver | 3 | 53.00 | 5 |
    | 28 | 1992 | NY | 7 | 67 | 4 | F | Freshman | black | 1 | 25.00 | 4 |
    | 29 | 1990 | TX | 11 | 70 | 7 | M | Freshman | silver | 2 | 28.00 | 3 |
    | 33 | 1985 | SC | 11 | 68 | 8 | M | Sophomore | blue | 1 | 9.00 | 4 |
    | 33 | 1990 | TX | 9 | 75 | 7 | M | Senior | silver | 5 | 54.00 | 7 |
    | 36 | 1982 | MI | 10 | 61 | 7 | M | Senior | blue | 6 | 5.00 | 2 |
    | 36 | 1996 | TX | 7 | 66 | 5 | M | Freshman | orange | 3 | 7.00 | 3 |
    | 36 | 1990 | IL | 12 | 61 | 7 | M | Junior | red | 4 | 14.00 | 3 |
    | 36 | 1988 | OR | 9 | 73 | 7 | M | Sophomore | blue | 5 | 23.00 | 5 |
    | 40 | 1987 | IL | 10 | 68 | 6 | M | Sophomore | silver | 5 | 16.00 | 5 |
    | 42 | 1962 | IL | 8 | 65 | 6 | F | Junior | red | 4 | 4.00 | 4 |
    | 54 | 1968 | FL | 9 | 70 | 8 | F | Freshman | green | 2 | 5.00 | 3 |
    | 54 | 1970 | NV | 11 | 65 | 4 | F | Freshman | silver | 5 | 54.00 | 7 |
    | 55 | 1997 | OH | 9 | 67 | 6 | F | Freshman | dark blue | 4 | 27.00 | 2 |
    | 63 | 1990 | PA | 10 | 66 | 8 | F | Sophomore | silver | 3 | 5.00 | 7 |
    | 63 | 1986 | MI | 5 | 69 | 7 | F | Sophomore | orange | 3 | 9.00 | 2 |
    | 71 | 1984 | MI | 11 | 64 | 6 | F | Freshman | silver | 2 | 1.00 | 2 |
    | 73 | 1968 | FL | 12 | 70 | 7 | F | Junior | green | 4 | 15.00 | 3 |
    | 73 | 1987 | SC | 11 | 68 | 7 | F | Junior | red | 2 | 18.00 | 5 |
    | 76 | 1985 | PA | 11 | 70 | 8 | F | Sophomore | blue | 3 | 5.00 | 4 |
    | 76 | 1992 | NY | 9 | 65 | 7 | F | Freshman | red | 6 | 7.00 | 2 |
    | 76 | 1990 | PA | 11 | 63 | 4 | M | Sophomore | silver | 5 | 13.00 | 5 |
    | 76 | 1991 | NY | 9 | 63 | 6 | M | Sophomore | silver | 4 | 38.00 | 2 |
    | 78 | 1995 | CA | 11 | 63 | 6 | M | Junior | blue | 2 | 47.00 | 2 |
    | 80 | 1989 | NV | 12 | 69 | 8 | M | Senior | white | 4 | 3.00 | 4 |
    | 80 | 1990 | SC | 10 | 63 | 8 | F | Senior | black | 2 | 7.00 | 7 |
    | 80 | 1999 | FL | 9 | 66 | 7 | F | Freshman | black | 5 | 22.00 | 2 |
    | 88 | 1998 | SC | 6 | 63 | 5 | F | Freshman | black | 3 | 43.00 | 6 |
    | 94 | 1983 | KY | 11 | 74 | 8 | M | Sophomore | red | 3 | 20.00 | 4 |

    ## Sheet1

    |
    |

    **## chapter6excelassignment.docx**

    1.

    Top of Form

    Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course:
    [MATH 1342 Database.xlsx](https://content.ctcd.edu/courses/math1342-lec/m23/docs/math1342_database.xlsx)

    Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using
    **=AVERAGE(A2:A36)** and =
    **STDEV(A2:A36)**.

    (Round your answers to 5 decimal places)

    Fill in the blank:

    The
    **mean** of the DRIVE variable is
    **Blank 1**.

    The
    **standard deviation** of the DRIVE variable is
    **Blank 2**.

    · Blank 1

    · Blank 2

    Bottom of Form

    2.

    Top of Form

    Question 2

    **Question 2**

    **2 Points**

    Question 2

    Assuming that this variable is normally distributed, what proportion of the data would you predict to be less than 40 minutes? This would be based on the calculated probability.

    To approximate this probability with Excel, find a free cell on the spreadsheet and use the formula
    **=NORM.DIST(40,mean,stdev,TRUE)**. For the "mean" and "stdev" in the formula, you
    _don't_ want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The proportion of values that I expect to be less than 40 minutes is _____________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    3.

    Top of Form

    Question 3

    **Question 3**

    **2 Points**

    Question 3

    Now, determine the
    **_actual_** proportion of data points in the dataset that fall within this range (less than 40 minutes). To find the actual proportion, sort the DRIVE variable, and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The actual proportion of values less than 40 minutes is ___________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    4.

    Top of Form

    Question 4

    **Question 4**

    **2 Points**

    Question 4

    How does your predicted probability from question 2 compare to the actual probability calculated in question 3? In other words, if these values are different, why do you think they're different, etc?

    Option A

    The probability calculations are different. In part 2, we calculated the probability based on the assumption that the distribution of the "drive" variable is normally distributed. If the distribution is not bell-shaped, then the probability estimation (in part 2) would not be accurate.

    Option B

    The probability calculations are the same.

    Option C

    The probability calculations are different. This must mean that something is wrong with our technology.

    Bottom of Form

    **## math1342_database3.xlsx**

    ## MATH399 Data Sheet

    | | | | | | | | | | | | |
    | — | — | — | — | — | — | — | — | — | — | — | — |
    | Drive (miles) | Birth Year | State | Shoe Size | Height (inches) | Sleep (hours) | Gender | Class Standing | Car Color | TV (hours) | Money (dollars) | Coin |
    | 4 | 1988 | NY | 9 | 69 | 7 | F | Sophomore | blue | 5 | 21.00 | 5 |
    | 6 | 1990 | OR | 13 | 75 | 10 | M | Junior | silver | 6 | 7.00 | 4 |
    | 6 | 1978 | MI | 10 | 66 | 6 | M | Freshman | black | 5 | 34.00 | 3 |
    | 20 | 1977 | IL | 5 | 62 | 7 | F | Junior | black | 3 | 10.00 | 2 |
    | 20 | 1985 | OR | 7 | 65 | 4 | F | Sophomore | green | 1 | 46.00 | 4 |
    | 25 | 1988 | CA | 8 | 69 | 6 | F | Senior | silver | 4 | 30.00 | 4 |
    | 25 | 1995 | GA | 9 | 63 | 7 | M | Junior | silver | 3 | 53.00 | 5 |
    | 28 | 1992 | NY | 7 | 67 | 4 | F | Freshman | black | 1 | 25.00 | 4 |
    | 29 | 1990 | TX | 11 | 70 | 7 | M | Freshman | silver | 2 | 28.00 | 3 |
    | 33 | 1985 | SC | 11 | 68 | 8 | M | Sophomore | blue | 1 | 9.00 | 4 |
    | 33 | 1990 | TX | 9 | 75 | 7 | M | Senior | silver | 5 | 54.00 | 7 |
    | 36 | 1982 | MI | 10 | 61 | 7 | M | Senior | blue | 6 | 5.00 | 2 |
    | 36 | 1996 | TX | 7 | 66 | 5 | M | Freshman | orange | 3 | 7.00 | 3 |
    | 36 | 1990 | IL | 12 | 61 | 7 | M | Junior | red | 4 | 14.00 | 3 |
    | 36 | 1988 | OR | 9 | 73 | 7 | M | Sophomore | blue | 5 | 23.00 | 5 |
    | 40 | 1987 | IL | 10 | 68 | 6 | M | Sophomore | silver | 5 | 16.00 | 5 |
    | 42 | 1962 | IL | 8 | 65 | 6 | F | Junior | red | 4 | 4.00 | 4 |
    | 54 | 1968 | FL | 9 | 70 | 8 | F | Freshman | green | 2 | 5.00 | 3 |
    | 54 | 1970 | NV | 11 | 65 | 4 | F | Freshman | silver | 5 | 54.00 | 7 |
    | 55 | 1997 | OH | 9 | 67 | 6 | F | Freshman | dark blue | 4 | 27.00 | 2 |
    | 63 | 1990 | PA | 10 | 66 | 8 | F | Sophomore | silver | 3 | 5.00 | 7 |
    | 63 | 1986 | MI | 5 | 69 | 7 | F | Sophomore | orange | 3 | 9.00 | 2 |
    | 71 | 1984 | MI | 11 | 64 | 6 | F | Freshman | silver | 2 | 1.00 | 2 |
    | 73 | 1968 | FL | 12 | 70 | 7 | F | Junior | green | 4 | 15.00 | 3 |
    | 73 | 1987 | SC | 11 | 68 | 7 | F | Junior | red | 2 | 18.00 | 5 |
    | 76 | 1985 | PA | 11 | 70 | 8 | F | Sophomore | blue | 3 | 5.00 | 4 |
    | 76 | 1992 | NY | 9 | 65 | 7 | F | Freshman | red | 6 | 7.00 | 2 |
    | 76 | 1990 | PA | 11 | 63 | 4 | M | Sophomore | silver | 5 | 13.00 | 5 |
    | 76 | 1991 | NY | 9 | 63 | 6 | M | Sophomore | silver | 4 | 38.00 | 2 |
    | 78 | 1995 | CA | 11 | 63 | 6 | M | Junior | blue | 2 | 47.00 | 2 |
    | 80 | 1989 | NV | 12 | 69 | 8 | M | Senior | white | 4 | 3.00 | 4 |
    | 80 | 1990 | SC | 10 | 63 | 8 | F | Senior | black | 2 | 7.00 | 7 |
    | 80 | 1999 | FL | 9 | 66 | 7 | F | Freshman | black | 5 | 22.00 | 2 |
    | 88 | 1998 | SC | 6 | 63 | 5 | F | Freshman | black | 3 | 43.00 | 6 |
    | 94 | 1983 | KY | 11 | 74 | 8 | M | Sophomore | red | 3 | 20.00 | 4 |

    ## Sheet1

    |
    |

    **## chapter6excelassignment.docx**

    1.

    Top of Form

    Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course:
    [MATH 1342 Database.xlsx](https://content.ctcd.edu/courses/math1342-lec/m23/docs/math1342_database.xlsx)

    Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using
    **=AVERAGE(A2:A36)** and =
    **STDEV(A2:A36)**.

    (Round your answers to 5 decimal places)

    Fill in the blank:

    The
    **mean** of the DRIVE variable is
    **Blank 1**.

    The
    **standard deviation** of the DRIVE variable is
    **Blank 2**.

    · Blank 1

    · Blank 2

    Bottom of Form

    2.

    Top of Form

    Question 2

    **Question 2**

    **2 Points**

    Question 2

    Assuming that this variable is normally distributed, what proportion of the data would you predict to be less than 40 minutes? This would be based on the calculated probability.

    To approximate this probability with Excel, find a free cell on the spreadsheet and use the formula
    **=NORM.DIST(40,mean,stdev,TRUE)**. For the "mean" and "stdev" in the formula, you
    _don't_ want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The proportion of values that I expect to be less than 40 minutes is _____________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    3.

    Top of Form

    Question 3

    **Question 3**

    **2 Points**

    Question 3

    Now, determine the
    **_actual_** proportion of data points in the dataset that fall within this range (less than 40 minutes). To find the actual proportion, sort the DRIVE variable, and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points.

    (Keep your answer in decimal form and round your answer to 3 decimal places)

    **Fill in the Blank:** The actual proportion of values less than 40 minutes is ___________.

    **Blank 1**

    · Blank 1

    Bottom of Form

    4.

    Top of Form

    Question 4

    **Question 4**

    **2 Points**

    Question 4

    How does your predicted probability from question 2 compare to the actual probability calculated in question 3? In other words, if these values are different, why do you think they're different, etc?

    Option A

    The probability calculations are different. In part 2, we calculated the probability based on the assumption that the distribution of the "drive" variable is normally distributed. If the distribution is not bell-shaped, then the probability estimation (in part 2) would not be accurate.

    Option B

    The probability calculations are the same.

    Option C

    The probability calculations are different. This must mean that something is wrong with our technology.

    Bottom of Form

    **## math1342_database3.xlsx**

    ## MATH399 Data Sheet

    | | | | | | | | | | | | |
    | — | — | — | — | — | — | — | — | — | — | — | — |
    | Drive (miles) | Birth Year | State | Shoe Size | Height (inches) | Sleep (hours) | Gender | Class Standing | Car Color | TV (hours) | Money (dollars) | Coin |
    | 4 | 1988 | NY | 9 | 69 | 7 | F | Sophomore | blue | 5 | 21.00 | 5 |
    | 6 | 1990 | OR | 13 | 75 | 10 | M | Junior | silver | 6 | 7.00 | 4 |
    | 6 | 1978 | MI | 10 | 66 | 6 | M | Freshman | black | 5 | 34.00 | 3 |
    | 20 | 1977 | IL | 5 | 62 | 7 | F | Junior | black | 3 | 10.00 | 2 |
    | 20 | 1985 | OR | 7 | 65 | 4 | F | Sophomore | green | 1 | 46.00 | 4 |
    | 25 | 1988 | CA | 8 | 69 | 6 | F | Senior | silver | 4 | 30.00 | 4 |
    | 25 | 1995 | GA | 9 | 63 | 7 | M | Junior | silver | 3 | 53.00 | 5 |
    | 28 | 1992 | NY | 7 | 67 | 4 | F | Freshman | black | 1 | 25.00 | 4 |
    | 29 | 1990 | TX | 11 | 70 | 7 | M | Freshman | silver | 2 | 28.00 | 3 |
    | 33 | 1985 | SC | 11 | 68 | 8 | M | Sophomore | blue | 1 | 9.00 | 4 |
    | 33 | 1990 | TX | 9 | 75 | 7 | M | Senior | silver | 5 | 54.00 | 7 |
    | 36 | 1982 | MI | 10 | 61 | 7 | M | Senior | blue | 6 | 5.00 | 2 |
    | 36 | 1996 | TX | 7 | 66 | 5 | M | Freshman | orange | 3 | 7.00 | 3 |
    | 36 | 1990 | IL | 12 | 61 | 7 | M | Junior | red | 4 | 14.00 | 3 |
    | 36 | 1988 | OR | 9 | 73 | 7 | M | Sophomore | blue | 5 | 23.00 | 5 |
    | 40 | 1987 | IL | 10 | 68 | 6 | M | Sophomore | silver | 5 | 16.00 | 5 |
    | 42 | 1962 | IL | 8 | 65 | 6 | F | Junior | red | 4 | 4.00 | 4 |
    | 54 | 1968 | FL | 9 | 70 | 8 | F | Freshman | green | 2 | 5.00 | 3 |
    | 54 | 1970 | NV | 11 | 65 | 4 | F | Freshman | silver | 5 | 54.00 | 7 |
    | 55 | 1997 | OH | 9 | 67 | 6 | F | Freshman | dark blue | 4 | 27.00 | 2 |
    | 63 | 1990 | PA | 10 | 66 | 8 | F | Sophomore | silver | 3 | 5.00 | 7 |
    | 63 | 1986 | MI | 5 | 69 | 7 | F | Sophomore | orange | 3 | 9.00 | 2 |
    | 71 | 1984 | MI | 11 | 64 | 6 | F | Freshman | silver | 2 | 1.00 | 2 |
    | 73 | 1968 | FL | 12 | 70 | 7 | F | Junior | green | 4 | 15.00 | 3 |
    | 73 | 1987 | SC | 11 | 68 | 7 | F | Junior | red | 2 | 18.00 | 5 |
    | 76 | 1985 | PA | 11 | 70 | 8 | F | Sophomore | blue | 3 | 5.00 | 4 |
    | 76 | 1992 | NY | 9 | 65 | 7 | F | Freshman | red | 6 | 7.00 | 2 |
    | 76 | 1990 | PA | 11 | 63 | 4 | M | Sophomore | silver | 5 | 13.00 | 5 |
    | 76 | 1991 | NY | 9 | 63 | 6 | M | Sophomore | silver | 4 | 38.00 | 2 |
    | 78 | 1995 | CA | 11 | 63 | 6 | M | Junior | blue | 2 | 47.00 | 2 |
    | 80 | 1989 | NV | 12 | 69 | 8 | M | Senior | white | 4 | 3.00 | 4 |
    | 80 | 1990 | SC | 10 | 63 | 8 | F | Senior | black | 2 | 7.00 | 7 |
    | 80 | 1999 | FL | 9 | 66 | 7 | F | Freshman | black | 5 | 22.00 | 2 |
    | 88 | 1998 | SC | 6 | 63 | 5 | F | Freshman | black | 3 | 43.00 | 6 |
    | 94 | 1983 | KY | 11 | 74 | 8 | M | Sophomore | red | 3 | 20.00 | 4 |

    ## Sheet1

    |
    |

    – 1
    – 2

  • [Solved] Operations Management: Process Selection and Cost Analysis

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    I'm currently working on an assignment for my Operations Management course and need assistance with process selection based on cost analysis. **Scenario:** A company is evaluating two production processes for a new product: – **Process A**: Fixed Costs = $50,000; Variable Cost per Unit = $10 – **Pro…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    I'm currently working on an assignment for my Operations Management course and need assistance with process selection based on cost analysis.
    **Scenario:**
    A company is evaluating two production processes for a new product:
    – **Process A**: Fixed Costs = $50,000; Variable Cost per Unit = $10
    – **Process B**: Fixed Costs = $25,000; Variable Cost per Unit = $18
    **Tasks:**
    1. Determine the break-even point where both processes have equal total costs.
    2. Identify which process is more cost-effective at production volumes of 3,000 and 7,000 units.
    3. Provide a brief explanation of how the break-even analysis informs the decision-making process in operations management.

  • [Solved] Prof Double R

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    ## Scenario You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the company’s Pacific region salespeople is working to design a new advertisement. The initial draft of the advertisement states that the average cost per square foot of home sales in th…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    ## Scenario
    You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the company’s Pacific region salespeople is working to design a new advertisement. The initial draft of the advertisement states that the average cost per square foot of home sales in the Pacific region is $280. The salesperson claims that the average cost per square foot in the Pacific region is less than $280.  He wants you to make sure he can make that statement (that the average cost per square foot is less than $280) before asking for the advertisement text to be changed. In order to test his claim, you will generate a random sample size of 750 using data for the Pacific region and use this data to perform a hypothesis test.
    ## Prompt
    Generate a sample of size 750 houses using data for the Pacific region. Then, design a hypothesis test and interpret the results using significance level α = .05. You will work with this sample in this assignment. Briefly describe how you generated your random sample.
    Use the [House Listing Price by Region](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20House%20Listing%20Price%20by%20Region.xlsx?ou=1923642) document to help support your work on this assignment. You may also use the [Descriptive Statistics in Excel PDF](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20Descriptive%20Statistics%20in%20Excel.pdf?isCourseFile=true&ou=1923642) and [Creating Histograms in Excel PDF](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20Creating%20Histograms%20in%20Excel.pdf?ou=1923642) tutorials for support.
    Specifically, you must address the following rubric criteria, using the [Module Five Assignment Template Word Document](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20Module%20Five%20Assignment%20Template.docx?isCourseFile=true&ou=1923642)
    – **Introduction:** Describe the purpose of this analysis and how you generated your random sample size of 750 houses.
    – **Hypothesis Test Setup:**Define your population parameter, including hypothesis statements, and specify the appropriate test.
    – Define your population parameter.
    – Write the null and alternative hypotheses.
    – Specify the name of the test you will use.
    – Identify whether it is a left-tailed, right-tailed, or two-tailed test.
    – **Data Analysis Preparations:**Describe sample summary statistics, provide a histogram and summary, check assumptions, and identify the test significance level.
    – Provide the descriptive statistics (sample size, mean, median, and standard deviation).
    – Provide a histogram of your sample.
    – Summarize your sample by writing a sentence describing the shape, center, and spread of your sample.
    – Check whether the assumptions to perform your identified test have been met.
    – Identify the test significance level. For example, α = .05.
    – **Calculations:** Calculate the _p_ value, describe the _p_ value and test statistic in regard to the normal curve graph, discuss how the p value relates to the significance level, and compare the _p_ value to the significance level to reject or fail to reject the null hypothesis.
    – Calculate the sample mean and standard error.
    – Determine the appropriate test statistic, then calculate the test statistic.
    – **Note:** This calculation is (mean – target)/standard error. In this case, the mean is your regional mean (Pacific), and the target is 280.
    – Calculate the _p_ value using one of the following tests.
    – **Choose your test from the following:**
    – **=T.DIST.RT([test statistic], [degree of freedom])**: right-tailed test
    – **=T.DIST([test statistic], [degree of freedom], 1)**: left-tailed test
    – **=T.DIST.2T([test statistic], [degree of freedom])**: two-tailed test
    – **Note:** The degree of freedom is calculated by subtracting 1 from your sample size.
    – Using the normal curve graph as a reference, describe where the p value and test statistic would be placed.
    – **Test Decision:**Compare the relationship between the p value and the significance level, and decide to reject or fail to reject the null hypothesis.
    – Compare the relationship between the _p_ value and significance level.
    – Decide to reject or fail to reject the null hypothesis.
    – **Conclusion:**Discuss how your test relates to the hypothesis and discuss the statistical significance.
    – Explain in one paragraph how your test decision relates to your hypothesis and whether your conclusions are statistically significant.
    ## What to Submit
    Submit your completed Module Five Assignment Template as a Word document that includes your response, supporting charts/graphs, and your Excel file.
    \
    MAT240ModuleFiveAssignmentTemplate.docx](https://www.sweetstudy.com/files/mat240modulefiveassignmenttemplate-docx-10310927 "MAT240ModuleFiveAssignmentTemplate.docx")
    \
    MAT240HouseListingPricebyRegion.xlsx](https://www.sweetstudy.com/files/mat240houselistingpricebyregion-xlsx-10310929 "MAT240HouseListingPricebyRegion.xlsx")

  • [Solved] MAT-274 Inferential Statistics

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    You suspect that among fraternal twins born across the United States, the second-born twin has a higher resting heart rate from ages 0-2 years. Your instructor will provide an Excel sheet containing resting heart rate data (in beats per minute) for 129 pairs of fraternal twins, measured at age 1 yea…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    You suspect that among fraternal twins born across the United States, the second-born twin has a higher resting heart rate from ages 0-2 years. Your instructor will provide an Excel sheet containing resting heart rate data (in beats per minute) for 129 pairs of fraternal twins, measured at age 1 year. You will be addressing the following areas, including relevant calculations and explanations; see the assignment style guide for details about what to consider in your responses:
    (1)Consider how your data is obtained.
    (2)Select an appropriate hypothesis test.
    (3)Describe your hypothesis in mathematical and nonmathematical terms.
    (4)Using your Excel sample data, complete the relevant hypothesis test calculations.
    (5)Make a formal decision on your null hypothesis.
    (6)Using your Excel sample data, complete the relevant confidence interval calculations.
    (7)Discuss how to interpret your confidence interval.
    (8)Consider the effects of increasing the sample size.
    (9)Consider confounding variables
    \
    MAT-274-RS-InferentialStatisticsProject-FA24.docx](https://www.sweetstudy.com/files/mat-274-rs-inferentialstatisticsproject-fa24-docx-10308227 "MAT-274-RS-InferentialStatisticsProject-FA24.docx")
    \
    MAT-274-RS-InferentialStyleGuide-FA24.docx](https://www.sweetstudy.com/files/mat-274-rs-inferentialstyleguide-fa24-docx-10308229 "MAT-274-RS-InferentialStyleGuide-FA24.docx")
    \
    4-14MAT274ProjectData.xlsx](https://www.sweetstudy.com/files/4-14mat274projectdata-xlsx-10308231 "4-14MAT274ProjectData.xlsx")