Question

How do I write a formula in a cell for Excel for this statement: "In cell...

How do I write a formula in a cell for Excel for this statement:

"In cell B27, determine the hold time failure rate by using the SUM function to total the values in column I and then dividing that sum by the total number of calls overall in cell B6."

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Greetings!!

Assumed that column I is having 20 data and B6 has a value 12. The equation that needs to have at cell B27 is =SUM(I2:I21)/B6. It calculates the sum of all the 20 elements in the column I and divide it with the value 12 which is stored at cell B27.

Output screenshot:

Please comment for more help

Hope this helps

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
How do I write a macro in excel for the CAPM formula??
How do I write a macro in excel for the CAPM formula??
How would I write in excel a formula for started at 60 % and increase their...
How would I write in excel a formula for started at 60 % and increase their capacity factor by 16 % a year till they reached a 100% capacity factor. (This meant that the capacity factor for year 2, CF2, would be = CF1*(1+growth_rate), and stop once it hit 100%
How do I write a function which has two parameters F3 and F4, and it will...
How do I write a function which has two parameters F3 and F4, and it will return the multiplication of F3 and F4. (using R ) f1 <- function(n1,n2){ sum(n1*n2) } f1(10,20) is this correct?
Question 1 Write functions that do the following: i) A function that takes 2 arguments and...
Question 1 Write functions that do the following: i) A function that takes 2 arguments and adds them. The result returned is the sum of the parameters. ii) A function that takes 2 arguments and returns the difference, iii) A function that calls both functions in i) and ii) and prints the product of the values returned by both. Question 2 Write functions: i) One that prompts a user for 2 numbers. ii) Adds the two numbers if they are...
How do I convert volume % to volumetric flow rate? This is occurring in a disitillation...
How do I convert volume % to volumetric flow rate? This is occurring in a disitillation column. I have the volume amount poured into the tank, 10L that is 7% methanol. I have a power input of 1.5 kW. I understand the mass balance of a distillation column. What I am confused about is after I found in the distillate, the 1 microliter sample is 5% methanol and 95% water at 5 minutes, how do I conver this to volumetric...
how do i solve this with excel and what function/s do i use Suppose you can...
how do i solve this with excel and what function/s do i use Suppose you can deposit $186.29 on each January 1st from 1988 through 1991, but you need $1000 on January 1, 1991. What interest rate with annual compounding must you have to achieve this goal?
Practice using EXCEL – Part of your Orientation Assignment to prepare for class on the first...
Practice using EXCEL – Part of your Orientation Assignment to prepare for class on the first day. Step by Step instructions on completing PR1-5B. BEFORE STARTING TO WORK THE PROBLEM YOU NEED TO WRITE ALL BALANCE FORMULAS. To do so do the following in order. Click on Cell D39. In D39 you will write a formula to add rows D37 and D38. To do so do the following: a)    Start in Cell D39 and press = sign b)    Highlight cell...
How do I find critical values in excel given alpha with a two-tailed hypothesis test. I...
How do I find critical values in excel given alpha with a two-tailed hypothesis test. I have a t- test statistic/
I am trying to figure out how to find the test statistic using Excel. I understand...
I am trying to figure out how to find the test statistic using Excel. I understand the formula- that I need to use parameter 'p' and 'normal distribution' ….z= sample proportion and minus the 'population portion' then we divide p*q and divide n -sample size. I understand how to populate the data in the formula. I just can't figure out how to solve this using Excel. (my only option with my class) I need step by step directions if possible....
How do I solve this in Excel: Let x be a normally distributed random variable with...
How do I solve this in Excel: Let x be a normally distributed random variable with mean 16 and standard deviation 14. Please express your answer as a number between 0 and 100. If you want to write 52%, please enter 52. What is the probability that x is between 14 and 28?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT