For this problem, you must use Excel to perform the necessary calculations. Below are the formulas...

For this problem, you must use Excel to perform the necessary calculations. Below are the formulas and equations you will need to use. Click on the image below to download a power point version if the text is blurry or too small.

If it is appropirate to use the binomial distribution, use the formula=binom.dist(number_s,trails,probability,cumulative) to calculate the probability. In this formula, number_s is the number of successful trails, trails is the total number of trails, probability is the probability for a single trail expressed as a decimal, and cumulative should be set as false. This will report the binominal distribution probability for a single outcome. You are tasked with reporting a cumulative probability.

If it is appropriate to use the normal approcimation of the binomial distribution, calculate Z using the correct equation from the option below and then use either the formula = (1-(norm.dist(Z,0,1,TRUE))) when calculating a right-tailed probability or the formula =(norm.dist(Z,0,1,TRUE)) for a left-tailed probability

Right-tailed tests find probabilities for X>_ observed while left-tailed tests find probabiliteis for X =< observed

Question

In Europe, 53% of the flowers of the Rewardless Orchid, Dactylorhiza sambucina, are yellow, whereas the remaining flowers are purple. For this problem, only use the normal approximation where it is appropriate. Use the binomial distribution where the normal approximation is inappropriate.

If we took a random sample of a single individual from this population, what is the probability, reported as a percent, that it would be purple?

Determine the probability, reported as a decimal rounded to two decimal places, that if we took a random sample of 6 flowers, at least 3 would be purple.

If we took a random sample of 260 individuals, what is the probability, reported as a decimal rounded to four decimal places, that 150 or fewer of the orchids are purple?

Expert Solution

orchestra answered 1 year ago

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for the problem in the first worksheet named LightbulbLife of the data table down below It gives the data on the lifetime in hours of a sample of 50 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for...

Perform the exercises listed below: You must use the required formulas the same as the corresponding...

Perform the exercises listed below: You must use the required formulas the same as the corresponding tables: I. Problem Depreciation Original Cost $ 400,000 Estimated Useful life 5 years Salvage Value $ 0 Instructions A. Use the following Depreciation methods 1. Straight line 2. Double Declining Balance 3. Sum of the years 4. Modified accelerated Cost Recovery B. Calculate which Depreciation method will be more advantageous at the end of the first year, from the tax and payment point of...

, Excel allows us to create our own formulas and functions to perform calculations and solve...

, Excel allows us to create our own formulas and functions to perform calculations and solve problems within the spreadsheet. Which of the functions or formulas that you experimented with in Presentation 1 did you find the most valuable? How do you think this particular function will save time in using Excel spreadsheets? What other functions do you think you will use on a regular basis? Why? Explain. Was there a function that is new to you?

Show all calculations within the cells of the template. This means that you must use formulas...

Show all calculations within the cells of the template. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well; no hard coding of solutions. Submit a single MS Excel file for grading. The deliverable is as follows: The completed Form 1040-Schedule E template. ACT405 – Portfolio Project Case 1 Comprehensive Tax Problem – Option 1 Taxpayer Information Name: John Washington...

Create an Excel spreadsheet that can do the calculations for the credit card below. Using formulas...

Create an Excel spreadsheet that can do the calculations for the credit card below. Using formulas and the drag function of Excel (see the notes), find the values for 1 year of charges. You can start this by taking the finance charge in month 1. With a beginning balance of $2500 and no additional charges, there is no grace-period, you will just pay the minimum payment each month for the next year. The APR is 24.99% and the minimum payment...

#2: Inventory valuation: All calculations must be indicated via Excel formulas. 1. Calculate the $ ending...

#2: Inventory valuation: All calculations must be indicated via Excel formulas. 1. Calculate the $ ending inventory and $ cost of goods sold using each of the following inventory methods: a. FIFO b. LIFO c. Average cost Unit Unit Cost Total Cost Beg. Inventory 1000 4 4000 Purchase 1 1200 5 6000 2 1600 6 9600 3 800 8 6400 Sales: 3200 units 2. Which inventory method would you recommend for reporting for income tax purposes to minimize taxable income?...

***Excel is required to solve this problem. Please use excel and show all formulas used in...

***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...

In EXCEL Please: you must show your work in Excel, which includes providing the formulas in...

In EXCEL Please: you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail. JLR Enterprises provides consulting services throughout California and uses a job-order costing system to accumulate the cost of client projects. Traceable costs are charged directly to individual clients; in contrast, other costs incurred by JLR, but not identifiable with specific clients, are...

For problems involving calculations you must show your work for credit. For each problem below, you...

For problems involving calculations you must show your work for credit. For each problem below, you may assume aqueous solutions at T = 25. °C. 1) For each of the cell diagrams below find the half-cell oxidation reaction, the half-cell reduction reaction, the net cell reaction, and the standard cell potential (E°cell). You may use the half-cell reduction potential table in the ppt presentation to find E°cell. a) Cd(s) | Cd2+(aq) || I-(aq) | I2(s) | Pt(s) b) Pb(s) |...

Question