Use appropriate grapical or statistical techniques

Xerox Abuses Your firm is located in a 10-story building. Each floor has its own Xerox machine in a copy room. The firm owns these machines but must pay for paper, toner, and occasional maintenance. Each employee has a key that opens the copy room door on his or her floor only and does not have access to Xerox machines on other floors. Because the Xerox machines are “free goods” right now, you suspect that the firm’s Xerox costs could be cut pretty drastically. To test this theory, you have decided to perform an experiment. Each person on the 10th floor has been given a card that operates the 10th-floor machine. These employees have been told that their card will generate a daily ... click for more

Use simplex method

1. Use simplex method to find the answer Maximize z =3x1+4x2 Subject to x1+x2<=50 X1+x2 >=25 2x1+x2<=60 x1>=0 and x2>=0 2. Use simplex method to find the answer Minimize w =4y1 + 2y2 Subject to 3y1+y2>=22 y1+4y2 >=26 y1>=0 and y2>=0

Probability that a given patient is a smoker given that the patient has a serious illness

I'm trying to set up an excel spreadsheet to solve a statistical probability. Patients 23% (smokers) -18% have a chance of contracting a serious illness 77% (non smoker) - 6% have a chance of contracting a serious illness I'm trying to figure out the probability that a given patient is a smoker if the patient has a serious illness.

Use a probability tree to make a determination

I'm practicing probability problems and not sure how to set up and solve a problem using an excel spread sheet. The senate consist of 100 senators, 34 republicans and 66 democrats. thirty-five percent of democrats and 70 percent republicans favor a bill. the bill requires a simple majority. using a probability tree, determine the probability that the bill will pass.

Develop a joint probability table

I own three fuel terminals. one in the north, one in the south and one in the mid-west. My north terminal house 25% of my employees, my south terminal house 40% of my employees and my mid-west house 35% of my employees. 10% of my north employees failed a management test, 15% of my south and 5% of my mid-west. Using excel I'm trying to create a probability tree showing all marginal, conditional and joint probabilities. Im also trying to develop a joint probability table and determine the probability that an employee selected at random would fail the management test.