Question

In: Statistics and Probability

How do I plug in the finite function in excel?

Expert Solution

The QUADF function of Excel will be Very useful while doing this

The Syntax is :

=QUADF(f, x, a, b, [options])

The Integral will look like:

With optional arguments, you can override the default integration algorithm as well as supply singular points for the integrand f(x) if applicable.

You will understand it better using the Below Example

Suppose we have the following finite function:

Steps:

Type the Formula into an Empty Cell (NOTE: Excel will throw Error if you Simply Type variable as X. You will have to Type it as X1)

Now give Reference of this Cell to Quad Function

You will get answer as:

Excel reports the error #DIV/0! for the formula in A1 since X1 is undefined. This error can be ignored since X1 serves only as a dummy variable for the integrand function and its value is irrelevant for the integration computed in A2.

The Final Answer is in A2

NOTE: Just incase you want to use Infinite Function, you can use INF & -INF

Please UpVote. It Helps. Thank You

orchestra answered 1 year ago

I believe I can do this in excel but not sure which equation or function to...

I believe I can do this in excel but not sure which equation or function to use? Would appreciate any help! You are offered an add-on loan for $4,500 at 18% for 5 years. What is the monthly payment? What is the amount of interest? What is the true interest rate cost of this loan? If you could pay the same loan above at a compound rate, What would the monthly payment be? What would the amount of interest be?

I am not understanding how to do this in excel, I have half of it, but...

I am not understanding how to do this in excel, I have half of it, but not sure where to put the 1100, 2900, 2400, 1500. Questions asked are a plus. M4_A1. Edsel Motors produces cars in Los Angeles and Detroit. The company supplies cars to customers in Houston and Tampa. The costs of shipping a car between various points shown in the table below. The dashes in the table indicate a shipment between locations that is not allowed. Los...

I have done a fcff in excel and i was wondering how do i preform a...

I have done a fcff in excel and i was wondering how do i preform a sensitivity analysis with it. I did the FCFF but need help with the sensitivity analysis. Here is the question: You are thinking of investing $1000 in a machine today. It would be used to produce sales for 10 years. The projected sales number in year 1 is 1200, after which sales will grow at 2% annually. Cost of manufacturing for this project is 50%...

Please answer in excel only. How do I create the graphs in excel and show the...

Please answer in excel only. How do I create the graphs in excel and show the data. Discuss the following two cost functions: TC=20+4Q TC=20+2Q+0.5Q^2 a) Calculate all cost curves and plot these curves on graphs. Total Cost Total Fixed Cost Total Variable Cost Average Total Cost Average Fixed Cost Average Variable Cost Marginal Cost b) In each case, indicate the point at which diminishing returns occur. (For question a), compute the required costs and plot the curves for quantities...

Where do I find price/earnings ratio (PE) and how do I equate it in excel? Is...

Where do I find price/earnings ratio (PE) and how do I equate it in excel? Is it in the income sheet? If so, what is the formula?

How do I do this in excel? The data contains data on monthly mortgage payments for...

How do I do this in excel? The data contains data on monthly mortgage payments for 150 homeowners for year 2010 and year 2015. Note that this is a matched sample. Using the appropriate Excel data analysis tool or formulas, test the hypothesis to determine if mortgage payments have risen from 2010 to 2015. The data is too long. If you can make a small example with random variables. Use α = .05. State hypothesis used for this.

W74) Please answer in detail with EXCEL Function since I am learning in EXCEL function Tests...

W74) Please answer in detail with EXCEL Function since I am learning in EXCEL function Tests with Chi-Square distribution Variance A random sample of the number of games played by individual NBA scoring leaders is shown below and reproduced in the Excel answer workbook. If a sports analyst argues that this sample variance is no different from 40 at α = .05, is she correct? Assume, of course, that the number of games played variable is normally distributed....

How do I find the test statistic and p value in excel?

How do I calculate the bin minimum, maximum, and length in Microsoft Excel?

**I need to know how to do it by had without a financial calculator or excel....

**I need to know how to do it by had without a financial calculator or excel. Unsure of what formula to use.** If a 4-year bond with a 7% coupon and a 10% yield to maturity is currently worth $904.90, how much will it be worth 1 year from now if interest rates are constant? A)$947.93 B) $925.39 C) $904.90 D)$1,000.00