
Write one Microsoft excel formula that works for conditions below on cell C1 for any number: a) IF A1+B1<=4, return $20 b) IF A1+B1>4 but <=9, return $35 c) IF A1+b1>9 but <=14, return $50 d) And IF A1+B1>15, return $75

Formula to multiply the number in cell 4k times standard deviation of the numbers in cell z2 through z10 I don't understand cell z2 through z10 I have never had excel (4kxz2xz10) Please write this correctly

Dear Sir, thanks very much for your the very detail instruction which I am still working on it. I need some help in using Microsoft Excel to format rational number in the form a/b( not in reduced form :eg. 3/6 but Excel will return value either in reduced form 1/2 or .5). What...

Return 2005 Return 2006 Return 2007 I have a data table with returns for 3 different years. I want to use a filter that only includes records where the return is increasing each year(i.e.: 2005<2006<2007) I"m stuck please help.

How would you write a formula to multiply the number in cell k4 times the standard deviation of the number in cell z2 through z10


How would you write a formula to divide the number in the cell v45 by the number in cell b78

How would I write a formula to multiply the number in cell z675 times the number in cell a1

How would I write a formula to multiply the number in cell k4 times the standard deviation of the numbers in cell z2 through z10

Determine the present value of a pension plan that will pay you 20 yearly payments of $7,000 each;the current rate of return in 7.5%

How would you write a formula to divide the quantity of cell c1 plus c 8 by the number in a 98

According to a recent survey, 65% of all customers will return to the same grocery store. Suppose 11 customers are selected at random,what is the probability that A) exactly 5 will return? B) all 11 will return? C) at least 6 will return D) at least one will return E) how many...

It is equally probable that stock A will have a +10% or 10% rate of return The only other possibility is that it will return 0%.The probability of 0% is twice that for a return of +10%. What is the expected return and Standard deviation of the return for stock A?

10. David has a small business and is working on an Excel worksheet to help manage his inventory. David realizes cell E14 has the wrong output. To check the problem, David should first select cell E14 and look at the _______ to check the formula. A. range B. Formula bar C. ...

According to a recent survey, 65% of all customers will return to the same grocery store. Suppose 11 customers are selected at random,what is the probability that A) exactly 5 will return? B) all 11 will return? C) at least 6 will return D) at least one will return E) how many...

According to a recent survey, 75% of all customers will return to the same grocery store. Suppose 8 customers are selected at random: A) What is the probability that exactly five of the customers will return? B) What is the profability that all 8 will return? C) What is the ...


Here are data on $1,000 par value bonds issued by Microsoft, Ford, and Xerox at the end of 2008. Assume you are thinking about buying these bonds as of January 2009. Answer the following questions: a.) Calculate the values of the bonds if your required rates of return are as ...

I am trying to use the Goal Seek Method in Microsoft Excel but i keep getting a message that says "Cell must contain a value". Since the cell does contain a value what could be the error.

Design a program that asks the user for the number of fat grams and calories in a food item. Validate the input as follows. Make sure the number of fat grams and calories are not less than 0. According to nutritional formulas, the number of calories cannot exceed fat grams * 9...

I need help with c programming, i need to fill in the code and I got these (need help with question 4), I run the grader and I only got question 1 right. grader code: gcc worksheet.c; ./a.out 0; if [ $? eq 0 ] then echo 'Question 0 Correct'; else echo $? 'is not correct for ...

Over a four year period the value of a stock increased from $15 per share to $24.89. Determine the total return and annual return.State answers to the nearest 0.01%.Total Return: Annual Return:

I think that I already typed this in, but forgot to click on the submit question button. Could you please provide me with some reference material as to how vertical lookup works? All of the formula fields cause me to become clueless! What are lookup values, table arrays, ...

You are given monthly annualized total return data for two mutual funds, A and B. Using linear regression, develop a relationship which gives the annualized return of fund B as a function of the return of fund A. What is the coefficient of determination of this relationship? ...

Hi, I need to learn how to explain and solve the following Finance problem. I don't understand this at all!!!, please show all solutions... Calculate the required return on an asset that has a beta of 1.25, when the expected return on the market portfolio is 10% and the ...

K this is what I have so far. I am wondering if i did the CAPM right and if that is all i need for that part and then I need to know how to do the Constant Growth Model. When you do yours, assume the riskfree return as 6% Assume the expected market return 12% The beta, ...

Hi, Im doing my maths coursework andI need to type in a formula and press enter and then I need "FILL DOWN (CTRL D)". How do I do this? I don't want to get the same number from what Ive alreay typed in on the previous cell, I just want that formula to function in the rest of ...


One way to think about the required rate of return is: as the highest return a riskaverse investor wants from an investment. as the riskfree rate of return plus a risk premium. as the historical rate of return plus a risk premium. as a comparison between the expected and ...

{Exercise 3.55} Morningstar tracks the total return for a large number of mutual funds. The following table shows the total return and the number of funds for four categories of mutual funds (Morningstar Funds500, 2008). a. Using the number of funds as weights, compute the ...

IBM's common stock has a beta of 0.85. If the expected riskfree return is 4.5% and the market risk premium is 7%. a) Calculate IBM’s required rate of return (10pts) b) Assume IBM’s actual realized return is 15%. Calculate its abnormal return (i.e. alpha). (5pts)

Suppose that cell B2 contains the budgeted amount and cell C2 contains the actual amount. Write the formula (including the IF conditions) that would insert the word under if the actual amount was less than the budgeted amount and insert the word over if the actual amount was ...

A stock has an expected return of 15 percent, its beta is 0.4, and the riskfree rate is 6.75 percent. The expected return on the market must be ?percent. This sample give the ERM as 0.2738 but dosent give the formula. What would the formula be?

I have a review question that says: The formula for the circumference of a circle is C = pi x d, where d represents the circle's diameter. Which statementis correct? Would it be D? Wasn't sure if a diameter could have a decimal or fraction. A. the formula only works if d is 1 ...

I had to create a c code that gets a number, returns how many digits it has,the digits sum, the digits product, to check if the digits sum is equal to product if yes return "1" else return 0, and in the end write a program the prints the first 20 numbers that the sum of their ...

You need to use the help section in your Excel program (press the F1 key and then use the search feature). If you need additional information about Excel, you can use your textbook or go to http://support.microsoft.com/search/, select the particluar program you want (there are...

Calculate the return and standard deviation for the following stock, in an economy with five possible states. If a Boom (Probability=25%) economy occurs, then the expected return is 30%. If a Good (Probability=25%) economy occurs, then the expected return is 15%. If a Normal (...

How would you expect the return on a stock market fund to differ from the return on savings account? Why do you think the two rates of return differ?


Aset P has a beta of 0.9. The riskfree rate of return is 8%, while the return on the S&P 500 is 14%. Asset P's required rate of return is:

How would you expect the return on a stock market fund to differ from the return on savings account? Why do you think the two rates of return differ?

The firstyear retention rate is the percentage of entering freshman at a given college who return to that same college for their sophomore year. Many colleges use the firstyear retention rate as one measure of their quality. Suppose that the firstyear retention rate at a ...

12. You’ve created a pie chart in Excel and placed it in a PowerPoint presentation. When you edit the pie chart in Excel, the pie chart in PowerPoint doesn’t retain the changes you’ve made. This means that the object has been A. hyperlinked. C. linked. B. embedded. D. ...

Under normal conditions (70% probability), Financing Plan A will produce $24,000 higher return than Plan B. Under tight money conditions (30% probability), Plan A will produce $40,000 less than Plan B. What is the expected value of return for Plan A over Plan B? $28,800 $4,000...

I am so confused can anyone help me understand which one is correct and why.... Beta is estimated as the slope of a regression line fit to pairs of periodic returns, (rx, ry), where: rx is the return for a market index such as the S&P 500 Index. rx is the return for the stock ...

entering the formula=SUM(C5:C18)is cell C19 will resolve in which of the following? (a)cells C5 and C18 will be added together (b)cells C5 and C18,and C19 will be added together (c)the total of cells C5 to C19 will appear in cell C19 (d0the total of cells C5 to C18 will appear...

Given the current financial information for both Microsoft and Coca Cola, how do calculate the expected dividend yield of Microsoft(MSFT) and Coca Cola(KO. The growth or capital gains yield? The total expected return for Microsoft and Coca Cola? I'm not quite sure what numbers...

There are three investment plans for your consideration. Each plan calls for an investment of $25,000 and the return will be one year later. Plan A will return $27,500. Plan B will return $27,000 or $28,000 with probabilities of 0.4 and 0.6, respectively. Plan C will return $...

Access the user manual for any one of the following programs or applications: • Microsoft® Access • Microsoft® PowerPoint® • Microsoft® Excel • Microsoft® Word • Microsoft® Outlook® User manuals are available via the “Help” menu in any of the above ...


Can anyone help me? Here's what I'm looking for: Col. A = Base period number Col. B = Given number this current period. NEEDED: Spreadsheet formula for: If B >= A, what is %? (Example: A=20, B=30, the # I want should read 50.0, not 1.5) Further, If B < A, what is the ...

9. The variable (A) in the utility formula represents the: a. investor’s return requirement. b. investor’s aversion to risk. c. certainty equivalent rate of the portfolio. d. preference for one unit of return per four units of risk.

Consider the following spreadsheet: What formula would you use to calculate the number in cell B2? Cell A Cell B Cell C Cost of item 4% tax cost of before tax item with tax $130 5.2 $135.2 $150 6 $156 I do not know how to write a formula for calculate cell B.

Consider the following spreadsheet: What formula would you use to calculate the number in cell B2? Cell A Cell B Cell C Cost of item 4% tax cost of before tax item with tax $130 5.2 $135.2 $150 6 $156 I do not know how to write a formula to calculate cell B.

How would you write a formula to multiply the number in a cell z675 times the number in cell a 1

Taggart Inc's stock has a 50% chance of producing a 21% return, a 30% chance of producing a 10% return, and a 20% chance of producing a 28% return.What is the firms expected rate of return? Please help

hi i'm taking compsci and I need someone to give me some examples of these classes, thanks! You will have to write a class to represent one of the following items. Note that each class must a proper constructor even though the constructor is not explicitly named. 1. a Fraction...

I have my employee schedule in a excel sheet. It is a weekly schedule that doesn't change week by week, but changes day by day within a week. Every Monday, Tuesday, etc. is the same schedule. In the file are days for Monday, Tuesday, etc.. I don't know if this possible, but I ...

Ann, an accountant, prepares a tax return for a client, Beta Sales Company. Carl, who is not an accountant, prepares a tax return for Dina's business, Delta Services. Can an accountant who prepares a tax return for a client be liable for any false statements in the return? Can...

I do not know what subject to put this uh ok how do I put this into one cell into microsoft excell into one cell  .49 m when i put "" it thinks I'm entering a formula which is not what I'm tyring to do i want negetive .49 m m being meters into one cell and do not know how to


Could you please provide me with some reference material as to how vertical lookup works? All of the formula fields cause me to become clueless! What are lookup values, table arrays, column index numbers, and range lookups? As for what Writeacher proposed, I am already ...

1. You hold 20 shares of stock worth $12.75 per share on June 1. Over the next 12 months you receive total dividends of $.055 per share. On June 1 of the following year, each share is worth $12.95. a. Dividend return:  b. Appreciation/Deprecation:  c. Total return:  d. ...

You are a share analyst for an investment firm and are investigating the return on shares in the Eastern Mining Corporation over the last four years. The return on Eastern Mining Corporation shares over the last four years is presented. Calculate the geometric mean rate of ...

You are a share analyst for an investment firm and are investigating the return on shares in the Eastern Mining Corporation over the last four years. The return on Eastern Mining Corporation shares over the last four years is presented. Calculate the geometric mean rate of ...

The expected return on the market is 12% and the risk free rate is 7%. The standard deviation of the return on the market is 15%. Ones investor creates a portfolio on the efficient frontier with an expected return of 10%. Another creates a portfolio on the efficient frontier ...

1. probability can be used to determine the likelihood of specific ________(fill in the blank). A. games B. occurrences C. questions D. opportunities 2. Tally marks are completed in groups of ______ because they are quick to mark and easier to count (fill in the blank). A. 2 B...

Allen must decide whether to invest $10,000 in the stock market or in a certificate of deposit (CD) at an interest rate of 9%. If the market is good , he believes that he could get a 14% return on his money. With a fair market, he expects to get an 8% return. If the market is ...

A features that displays only the data in column (s) according to specified criteria A. Formula B. Sorting C. Filtering* D. Pivot

NEED HELP!!Hi, I have been trying to figure this one math problem for awhile and I am stuck. I believe the answer is between A or B. Skip is practicing tennis serves against a wall. The distance between Skip and the tennis ball, in feet, at any time T, measured in seconds, is ...

Hello, I need to use a matrix to solve this but am stumped on how to do it. All I need is a little nudge to push me in the right direction. Please help. Thank you You have been hired as a consultant for Crazy Al’s Car Rentals, a new car rental agency in the city of ...


Hello, I need to use matrices in order to solve this problem but I am having a hard time getting started with the problem. I just need a little push to nudge me in the right direction. Please help. Thank You. You have been hired as a consultant for Crazy Al’s Car Rentals, a ...

Arithmetic operations, cell references, and __________ can be used in Excel formulas. constants macros programs procedures is it A 2Using the mouse to select a specific cell is when creating a formula is called: sizing. moving. accessing. pointing. is it D 3.To ensure that the...

How would I graph equations in Microsoft Excel 2003 and the residuals? I want to graph linear, quadratic and exponential equations but I don't know how.

I'm completely drawing a blank on how to do this. A woman has $500,000 invested into two real estate properties. One yields an annual return on 12% and the other returns 15% per year on her investment. Her total annual return from the two investments is $64,500. If X ...

Is the main conflict in Return of the soldier between Chris's desire to return to the past and his responsibility to the present, between Jenny and Kitty or is it between two other opposing forces? I must write an essay about this so please help me. I do feel its the first ...

I'm completely drawing a blank on how to do this. A woman has $500,000 invested into two real estate properties. One yields an annual return on 12% and the other returns 15% per year on her investment. Her total annual return from the two investments is $64,500. If X ...

you have won a lottery with two option. A: take 500000 immediately, B: take 40000 at the end of every year 1000000, over a period of 25 years. Required rate of return is 5% Q1. what option would you prefer? Q2. What will be your answer if rate of return is 7% Q3. At what rate ...

It's a lot of words, but short questions. I got most of it, but I'm confused on a and c. Help would be greatly appreciated: Theater Seven wants to increase its popularity. They want to determine the best number of newspaper (N), Radio (R), and Television (T) ads to produce in ...

Selena needs to publish her research about Chinese culture. Her research includes audio clips from an interview with a Chinese citizen, written notes, and photographs from her tour of a Chinese exhibit in a local museum. Based on each application’s strengths and weaknesses, ...

a. Calculate the values of the bonds if your required rates of return are as follows: Microsoft, 6 percent; Ford, 15 percent; Xerox, 10 percent; where MICROSOFT FORD XEROX Coupon interest rate 5.25% 7.13% 8.00% Years to maturity 30 25 16


• (Workers) Name Hours per day John 5 6 4 7 8 Jack 7 3 5 7 4 Jill 2 9 4 3 5 James 6 6 2 4 5 Jacob 5 6 6 3 3 Jeremy 5 5 5 8 8 Jim 8 8 4 7 4 Jerry 6 4 5 6 7 Jamie 3 2 6 7 4 • If worker payment is $6.50 per hour, write methods to calculate: o Average Working hours for every ...

Name Hours per day John 5 6 4 7 8 Jack 7 3 5 7 4 Jill 2 9 4 3 5 James 6 6 2 4 5 Jacob 5 6 6 3 3 Jeremy 5 5 5 8 8 Jim 8 8 4 7 4 Jerry 6 4 5 6 7 Jamie 3 2 6 7 4 If worker payment is $6.50 per hour, write methods to calculate: Average Working hours for every Worker > Return ...

Hi, I have been trying to figure this one math problem for awhile and I am stuck. I believe the answer is between A or B. Skip is practicing tennis serves against a wall. The distance between Skip and the tennis ball, in feet, at any time T, measured in seconds, is D(T)=1.5(T...

Hi, I have been trying to figure this one math problem for awhile and I am stuck. I believe the answer is between A or B. Skip is practicing tennis serves against a wall. The distance between Skip and the tennis ball, in feet, at any time T, measured in seconds, is D(T)=1.5(T...

Hi, I need to write an Excel formula and I am trying to double check my work. We are asked to find the difference and relative difference for this account. So the values are: $10,000 $10,700 $11,400 $12,100 $12,800 $13,500 etc. The difference for each is $700 I have two ways ...

California Clinics, an investorowned chain of ambulatory care clinics, just paid a dividend of $2 per share. The firm’s dividend is expected to grow at a constant rate of 5% per year, and investors require a 15 % rate of return on the stock. 1. What is the stock’s value? ...

Name Hours per day John 5 6 4 7 8 Jack 7 3 5 7 4 Jill 2 9 4 3 5 James 6 6 2 4 5 Jacob 5 6 6 3 3 Jeremy 5 5 5 8 8 Jim 8 8 4 7 4 Jerry 6 4 5 6 7 Jamie 3 2 6 7 4 If worker payment is $6.50 per hour, write methods to calculate: Average Working hours for every Worker > Return ...

Her are the data on $1000 par value bonds issued by Microsoft, Ford, and Xerox at the end of 2008, Assume you are thinking about buying these bonds as of January 2009. Answer the following questions. a. Calculate the values of the bonds if your required rates of return are as ...

One of nature's patterns connects the percent of adult birds in a colony that return from the previous year and the number of new adults that join the colony. Following are data for 13 colonies of sparrowhawks: Percent return 73 61 79 54 75 62 53 46 57 50 62 45 35 New adults 4...

The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result? A. =(25*(27/9)+5+309)*2 B.=25*((27/9+5)+309*2) C.=25*(27/9+5)+309*2 D. =25*27/9+5+309*2 Even understanding the basics of Excel was ...


Analyzing a Stock. The beta, B of a stock represents the relative risk of a stock compared with a market basket of stocks, such as Standard and poor's 500 Index of stocks. Beta is computed by finding the slope of the line of best fit between the rate of return of the stock and...

When you link a worksheet and a chart in a business report as well as on a slide, which Microsoft Office applications are integrated? A. Word, Excel, PowerPoint B. Excel, Access, Word C. Word, Access, PowerPoint D. Excel, PowerPoint, Publisher

When considering how profitably your company is operating, you examine: a) inventory turnover. b) sales and the return on your investment. c) depreciation and liquidity. d) tangible and intangible assets. e) the price of the Canadian dollar. I think the answer should be b = ...

Write a 34 Page Paper That Summarizes Your Findings From The Four Scenarios As Well As How Using Microsoft Excel Helped You With This Process

how do i write this equation cars the marton family took a vacation that covered a total distance of 1356 miles. the return of the trip was 284 miles shorter than the first part of the trip. how long was the return trip?

In cell D21, type the formula to calculate the % change from January to February. That formula is: =(J18E18)/ABS(E18). Format the result in the Percentage style and decrease the decimal places if necessary to round the result to the nearest whole percent (569.46521.07)/abs(...

1.Fraction that has a numerator and a denominator. The class should have methods that can: (a) add and subtract two Fractions together and return the resulting Fraction, (b) create a duplicate of itself and return the duplicate, (c) see if another Fraction is equivalent to ...

Skip is practicing tennis serves against a wall. The distance between Skip and the tennis ball, in feet, at any time T, measured in seconds, is D(T)=1.5T8+9. which analysis of the formula is true? A. Skip is 9 feet from the wall and the ball will return to him in 1.5 ...

what is the rate of return on an initial investment of $2000 and you generate $500 return?

what is the rate of return on an initial investment of $2000 and you generate $500 return?


What is the return type of a method that does not return a value? A. null B. void C. 0(zero) D. int

: The Crescent Corporation just paid a dividend of $2 per share and is expected to continue paying the same amount each year for the next 4 years. If you have a required rate of return of 13%, plan to hold the stock for 4 years, and are confident that it will sell for $30 at ...

A women has $500,000 invested in two rental properties. One yields an annual return of 14% on her investment, and the other returns 10% per year on her investment. Her total annual return from the two investments is $59,000. How much is invested at each return?

A women has $500,000 invested in two rental properties. One yields an annual return of 14% on her investment, and the other returns 9% per year on her investment. Her total annual return from the two investments is $52,000. How much is invested at each return?

A motorist makes a journey of 240 km from Singapore to Malacca to visit his inlaws at an average speed of x kilometers. On his return journey, his average speed is reduced by 6km/hour due to traffic. If the return journey takes 20 minutes longer, form an equation with x and ...
 Pages:
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
 100