Answer all the questions related to the exercises below. You can use Excel or work the exercise manually, as you prefer. You must detail the steps. That is, even with the support of the schedule, the process should be reflected in the worksheet
Ans:
Use Binomial distribution with n=8 and p=0.15
P(x=k)=8Ck*0.15k*(1-0.15)8-k
a)
P(x=5)=8C5*0.155*0.853=0.0026
b)
P(at least 3)=P(x>=3)
=1-P(x<=2)
=1-P(x=0)-P(x=1)-P(x=2)
=1-8C0*0.150*0.858-8C1*0.151*0.857-8C2*0.152*0.856
=1-0.2725-0.3847-0.2376
=0.1052
Answer all the questions related to the exercises below. You can use Excel or work the...
how would these questions be answered and what are the formulas
to use in excel?
The 4 digit id is 6305
Step 24 of 40: Transaction #3 es Shareholder' s ity 2 Your turn: Transaction # 3 Nunya Business has received 25% of the amount you recorded in Transaction #2 as partial payment of Its accounts receivable. After you record this transaction: The amounts will be based on formulas in the worksheet cells, as opposed to numbers that you've calculated...
how would these questions be answered and what are the formulas
to use in excel?
Step 24 of 40: Transaction #3 es Shareholder' s ity 2 Your turn: Transaction # 3 Nunya Business has received 25% of the amount you recorded in Transaction #2 as partial payment of Its accounts receivable. After you record this transaction: The amounts will be based on formulas in the worksheet cells, as opposed to numbers that you've calculated outside of Excel and then manually...
CREDIT CARDS: If you have a credit card, you may use it to answer these questions. If you don't have a credit card or don't want to use your credit card, then use one you get in the mail or one from on-line. Find the following information: 1. What type of credit card is it? store (or airlines) card or bank card or other? 2. How is the finance charge (FC) calculated? 3. What is the APR for this credit...
can
you please do all work in steps on a paper if possible
Exercises: Parity conditions in real markets and financial markets EXERCISE 4 (Purchasing Power Parity) We live in a four-country world where people only grow and eat coconuts. We have the following data: Brazil a Mexico Argentina United States Price of one BRL 2,000 MXN 5 ARS 1.5 USD 1.4 coconut Exchange rate MXN/BRL 400 ARS/BRL 1,200 USD/BRL 1,400 a) Does Purchasing Power Parity hold for the BRL...
In a study entitled How Undergraduate Students Use Credit Cards, it was reported that undergraduate students have a mean credit card balance of $3,304. This figure was an all-time high and had increased 41% over the previous five years. Assume that a current study is being conducted to determine if it can be concluded that the mean credit card balance for undergraduate students has continued to increase compared to the report. Based on previous studies, use a population standard deviation...
Use an excel spreadsheet to solve the following problem. Please submit your spreadsheet with your answer. Make sure to use variable costs and fixed cost appropriately. You have been asked to perform a break-even analysis on the summer art camp. You need to determine how many students must attend in order for the camp to break-even this summer. Setup an Excel spreadsheet with the data below and use the goal seek option in Excel to determine your answer. Submit the...
This question must be answered in Excel and you need to use Excel formulas to do your calculations in order to earn full credit. When you have finished, upload your Excel file. A company buys a fixed asset at a cost of $100,000. The asset has an estimated useful life of 5 years. a . For the second year of the asset's life, what amount of depreciation expense will appear on the income statement? Use a formula in Excel to...
use
excel
The typical American household owes approximately $15,000 in credit card debt. Assume you owe this amount today and will not to put another charge on your credit card until this debt is paid off. Your credit card has an APR of 18% and minimum payments are calculated as 2% of outstanding balance or $15, whichever is greater. Using two (2) decimal places for dollar amounts, determine: a) How many years will it take to pay the entire amount...
PLEASE SHOW THE ANSWER OF (a)(b)(c) ? thank you
Homework: Section 5.5 - Exercises Save 10 of 13 (10 complete) v HW Score: 51.79%, 14.5 of 28 pts Score: 0.5 of 4 pts Xx) 5.5.19-T Question Help Determine whether you can use the normal distribution to approximate the binomial distribution. If you can, use the normal distribution to approximate the indicated probabilities and sketch their graphs. If you cannot, explain why and use the binomial distribution to find the indicated...
All work must be shown. If you use a calculator shortcut, please show what you used. 1. Exercise 4.16 on page 73. A beverage company makes weekly deliveries from its warehouse to a supermarket. The delivery time varies based on interstate traffic and scheduling factors, but is normally distributed with a mean of 17 hours and a standard deviation of 3 hours. What is the probability it will take between 12 and 15 hours to make this weeks delivery? 2....