Start on cell K3 on the Dice worksheet. Enter the following formula: =COUNTIF($C$3:$H$8,J3). In cell L3, enter the following formula: =K3/36. Complete the

  • Start on cell K3 on the Dice worksheet.
  • Enter the following formula: =COUNTIF($C$3:$H$8,J3).
  • In cell L3, enter the following formula: =K3/36.
  • Complete the similar formulas for the range K4:L13. (Hint: You could use the drop and drag feature in Excel.)
  • In cell E16, enter the appropriate formula to calculate the probability of either rolling a 7 or 11.
  • In cell E17, enter the appropriate formula to calculate the probability of either rolling a 2, 3, or 12.
  • Save your work so far and go to cell E8 on the Roulette worksheet.
  • Considering that the roulette ball can land on the numbers 1 through 36 or land on a 0 or 00, calculate the appropriate probability of landing on a red number.
  • On cell E9, calculate the appropriate probability of landing on a 0 or 00.
  • On cell E10, calculate the appropriate probability of landing on a black number.
  • On cell E12, calculate the appropriate probability of landing on an even number not 0 or 00.
  • On cell E13, calculate the appropriate probability of landing on an odd number not 0 or 00.
  • Save your work so far and move to step 3.

Step 3: Calculate Probability, Mean, Variance, and Standard Deviation

  • Go to cell D2 on the Rescue Cats and Dogs worksheet.
  • Calculate the probability of rescuing any cat or dog being rescued in a week. You will divide the frequency (cell C1) by the total number of weeks in a year (cell C16). Make sure that you use an absolute reference for the total number of weeks in the year.
  • In cell E2, calculate the mean of the number of cats and dogs rescued for the frequency by multiplying the number of cats and dogs rescued (B2) by the probability (cell D2).
  • In cell F2, enter the following formula: =(B2-$E$16)^2.
  • In cell G2, enter the following formula: =F2*D2.
  • Complete the cells in range D3:G12 by using the drag and drop fill option in Excel.
  • The mean in cell K2 should be 5.52 and the variance in cell K3 should be 7.25. Please note this is the actual number rounded to two decimal spaces.
  • Calculate the standard deviation in cell K4 by entering the following formula: =SQRT(K3).
  • Save your work so far and move to Step 4.

Step 4: Complete and Submit Work

Submit your Microsoft Excel file to Canvas.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Module Two Project Proposal Guidelines and Rubric instructions attached HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course,

Module Two Project Proposal Guidelines and Rubric instructions attached HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course, we are exploring how the humanities teach us Module Two Project Proposal Guidelines and Rubricinstructions attached  HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course, we

2-1 Discussion: Diverse PerspectivesPossible Points: 40 Food is a staple in each person’s life. It is a way we learn about cultural values and society.

2-1 Discussion: Diverse PerspectivesPossible Points: 40 Food is a staple in each person’s life. It is a way we learn about cultural values and society. It gives us many different perspectives while simultaneously bringing us all together through shared experiences. Identifying and understanding diverse perspectives adds value to creative works. In

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are designations used to describe complex economic market structures. These represent three of the categories which are further broken down. Keep in mind, perfect markets are a theoretical construct. Case 3 Resources What Does Imperfect

Module 3 – SLPImplications of Market StructuresAssignment Overview Economics and Cryptocurrency Cryptocurrency has supporters and detractors. Is it a

Module 3 – SLPImplications of Market StructuresAssignment Overview Economics and Cryptocurrency Cryptocurrency has supporters and detractors. Is it a tool for transparency in digital transactions? Is it a way to evade taxes or hide net worth? Session Long Project 3 Resources Cryptocurrency Explained With Pros and Cons for Investment (2024)The Crypto

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are designations used to describe complex economic market structures. These represent three of the categories which are further broken down. Keep in mind, perfect markets are a theoretical construct. Case 3 Resources What Does Imperfect