Answer the following questions and use Excel to show your work. A student has an important...

Answer the following questions and use Excel to show your work.

A student has an important exam coming up and is contemplating not studying for the exam in order to attend a party with his friends. The student must earn a minimum score of 70% on the exam in order to successfully maintain his desired GPA. Suppose the student knows in advance that the exam will consist of 20 multiple-choice questions with 4 possible answers for each question. Answer questions 1–3 using the preceding information and modeling this situation as a binomial distribution.

1. What is the probability that the student will successfully earn exactly the required minimum score of 70% on the exam based solely on randomly guessing the correct answer for each question? a) 2.57 b) 2.57E-02 c) 2.57E-05 d) 2.57E-04

2. What is the probability that the student will earn less than the required minimum score of 70% on the exam based solely on randomly guessing the correct answer for each question? a) 0.74673 b) 0.85198 c) 0.99997 d) 0.23499

3. What is the probability that the student will successfully earn no less than the required minimum score of 70% on the exam based solely on randomly guessing the correct answer for each question? a) 3.51E-04 b) 2.95E-05 c) 6.87E-06 d) 1.27E-03

Expert Solution

milcah answered 1 year ago

Answer the following questions and use Excel to show your work. The mean time required to...

Answer the following questions and use Excel to show your work. The mean time required to complete a certain type of construction project is 52 weeks with a standard deviation of 3 weeks. Answer questions 4–7 using the preceding information and modeling this situation as a normal distribution. 4. What is the probability of the completing the project in no more than 52 weeks? a) 0.25 b) 0.50 c) 0.75 d) 0.05 5. What is the probability of the completing...

Answer the following questions and use Excel to show your work. Customers arrive at a supermarket...

Answer the following questions and use Excel to show your work. Customers arrive at a supermarket check-out counter with an average arrival rate of 9 customers per hour. Answer questions 8–10 using the preceding information and modeling this situation as a Poisson distribution. 8. What is the probability of less than 5 customers arriving at the supermarket check-out counter in a given 1-hour period? a) 0.054 b) 0.446 c) 0.359 d) 0.612 9. What is the probability of exactly 12...

Answer the following questions and use Excel or this document to show your work. 1. Consider...

Answer the following questions and use Excel or this document to show your work. 1. Consider the following results for two samples randomly taken from two normal populations with equal variances. Sample I Sample II Sample Size 28 35 Sample Mean 48 44 Population Standard Deviation 9 10 a. Develop a 95% confidence interval for the difference between the two population means. b. Is there conclusive evidence that one population has a larger mean? Explain.

Use the following information to answer the questions in this quiz. Please show your work by...

Use the following information to answer the questions in this quiz. Please show your work by submitting a Word, Excel, or JPEG file in the "Project 2 Drop Box". INFORMATION OLD MACHINE: Original Purchase Price $ 550,000.00 Original Life 10 YEARS Remaining Life 5 YEARS Straight line depreciation in use Salvage Value $ 50,000.00 Current Fair Market Value $ 260,000.00 INFORMATION NEW MACHINE A: Purchase Price $895,000.00 Estimated Life 5 YEARS Use Straight Line Depreciation Method Estimated Salvage Value...

Create an excel workbook for the following questions. Answer these questions under your Solver work for...

Create an excel workbook for the following questions. Answer these questions under your Solver work for each respective problem. 1. Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the...

Use the following information to answer the next three questions. Show ALL your work! Consider the...

Use the following information to answer the next three questions. Show ALL your work! Consider the cash flows from two mutually exclusive projects: Cash Flow Year Project A Project B 0 -$420,000 -$420,000 1 $150,000 $390,000 2 $230,000 $110,000 3 $321,000 $140,000 The appropriate discount rate is 11.7%. -Calculate the net present value (NPV) for both projects, and determine which project should be accepted based on NPV. Round both NPVs to the nearest dollar. -Calculate the internal rate of return...

Answer the following questions. Show all work leading to your answer. On a network with an...

Answer the following questions. Show all work leading to your answer. On a network with an IP address of 140.133.28.72 and a subnet mask of 255.248.0.0, what is the network ID? You have decided to create 254 subnets on your Class B network. What subnet mask will you use to accomplish this? What is the maximum number of hosts you can assign to any single subnet? Your workstation's IP address is 10.35.88.12, and your supervisor's workstation's IP address is 10.35.91.4....

Please Use Excel to Show All Work, I will like your answer :) 15.54 The Tire...

Please Use Excel to Show All Work, I will like your answer :) 15.54 The Tire Rack, America’s leading online distributor of tires and wheels, conducts extensive testing to provide customers with products that are right for their vehicle, driving style, and driving conditions. In addition, the Tire Rack maintains an independent consumer survey to help drivers help each other by sharing their long-term tire experiences. The following data show survey ratings (1 to 10 scale with 10 the highest...

Use Excel to show your work and include the formula in the cell to show how...

Use Excel to show your work and include the formula in the cell to show how you arrived at your figures. Round percentages (example if 49.2, round to 49). Background: ABC, Inc., produces widgets. The company manufactures three levels of widgets-Economy, Better and Best. Selected information on the widgets is given below. Economy Better Best Selling price per widget $40.00 $60.00 $90.00 Variable expense per widget production $22.00 $27.00 $31.50 Selling (5% of selling price) $2.00 $3.00 $4.50 All sales...

Show your work, the formulas used, and the substitutions to answer the questions about the following...

Show your work, the formulas used, and the substitutions to answer the questions about the following data: Can your high school GPA predict your college GPA? To try to answer this, the following data were collected: High School GPA: 1.72 3.51 2.45 2.85 2.84 3.46 1.97 3.47 College GPA: 2.61 3.66 3.25 3.23 3.46 3.07 2.88 3.16 Create a scatter plot of the data Find the equation of the regression line Calculate the correlation coefficient. Is there a significant correlation...

Question