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 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?
I need the EXCEL formula for the following questions, please. What is the formula to calculate...
I need the EXCEL formula for the following questions, please. What is the formula to calculate how much a savings account would be worth if the initial balance is $1,000 with monthly deposits of $75 for 10 years at 4.3% annual interest compounded monthly? What is the formula result? You want a savings account to grow from $1,000 to $5,000 within two years. Assume the bank provides a 3.2% annual interest rate compounded monthly. What is the formula to calculate...
Creating and interpreting a Normal Quantile-Quantile (Normal Q-Q) plot. The data you will be using is...
Creating and interpreting a Normal Quantile-Quantile (Normal Q-Q) plot. The data you will be using is the distance in miles from home to campus for statistics students. 150      30        105      88        94        15        55        122      45        67        18        126      30 143      98        15        30        62        111      87        38        20        34        39        46        14 144      23        94        44        97        65        120      123      99        45        57        209      20 133      72 Column 1: Sort the data values from least to greatest. Use the...
How do i do these using excel and its functions 15.       Find the present value of...
How do i do these using excel and its functions 15.       Find the present value of a $1000 annuity that begins at the end of the 3rd year and continues until the end of the 10th year, given a 12% discount rate. 16.       Calculate the value today that is equivalent to $150 at the end of year 1, $450 at the end of year 2, and $300 at the end of year 3, given a discount rate of 10%.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT