Question

Write an Excel equation that I can copy from trial 1 to calculate the results for...

Write an Excel equation that I can copy from trial 1 to calculate the results for additional trials.  The equation is R = d2+ 36*d + k.  k can change depending on conditions.  Show it as an Excel formula

A

B

C

D

E

F

1

Trial

1

2

3

4

5

2

d

4

3

7

1

5

3

R

4

K

74.2

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer

In A3 block you just put the below answer
=A2*A2+36*A2+A4

Explanation

А3 • f B A Trial =A2%A2+36*A2+A4 C D 1 2 3 45 115 - rum 45.2

You need to go to the 3rd row and first column. Since it has the d value.

There you should give the above answer because d is in A2 cell and K is in A4 cell

Please up vote!!

Add a comment
Know the answer?
Add Answer to:
Write an Excel equation that I can copy from trial 1 to calculate the results for...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Excel Insert Draw Page Layout Copy BIU G19 In cells indicated 1. Write a formula that...

    Excel Insert Draw Page Layout Copy BIU G19 In cells indicated 1. Write a formula that uses cell references and/or functions to compute the expected value of the sample mean. 2. Write a formula that uses cell references and/or functions to compute the standard error of the mean 3. Write formula that uses cell references and/or functions to compute the probabilities the sample mean is greater less than and between the values given Probably the Expected value of the sample...

  • 1. what is the mole ratio for trial 1 and 2? 2. whats the average mole...

    1. what is the mole ratio for trial 1 and 2? 2. whats the average mole ratio for trial 1 and 2? 3. whats the average deviation for trial 1 and 2? * please include the steps if you dont mind* ng down the equation ahd an example calculation, The example calculation only needs to be done for one trial. The results of the remaining trials can be written down in a table in your notebook. (Part 1)) Determine the...

  • s) For the questions below, you must write out exactly what you would need to type into Excel (starting with the equal sign) in order to have Excel perform the correct calculation. Be mindful of...

    s) For the questions below, you must write out exactly what you would need to type into Excel (starting with the equal sign) in order to have Excel perform the correct calculation. Be mindful of writing the parenthesis correctlyl a) (4 points) What formula would need to be typed in cell B2 in order to have Excel perform the correct calculation? Your formula needs to reference cell A2 so that it could be dragged down to the entire input-output table....

  • Can you please solve it in Excel? Also i cannot understand how i calculate all averages,...

    Can you please solve it in Excel? Also i cannot understand how i calculate all averages, s. deviations and result with just one function for every compound.(The problem that i cannot understood is explained in p.s. section) 3. Fluorescence values of 4 different compounds (A, B, C and D) were measured (each in triplicate) and the results of each compound were given in the table. Compound Measurement Result Mean Standard Deviation Result (%) No. 100 | 1. 2. 3. 1....

  • For the questions below, you must write out exactly what you sign) in order to have Excel perform the correct calculation. Be mindful of writing the parenthesis correctlyl would need to type into...

    For the questions below, you must write out exactly what you sign) in order to have Excel perform the correct calculation. Be mindful of writing the parenthesis correctlyl would need to type into Excel(starting with the equal a) (4 points) What formula would need to be typed in cell B2 in order to have Excel perform the correct calculation? Your formula needs to reference cell A2 so that it could be dragged down to the entire input-output table. f(x) =...

  • Write the point slope form of the line's equation satisfying the given conditions. Then use the...

    Write the point slope form of the line's equation satisfying the given conditions. Then use the point slope form of the equation to write the slope-intercept form of the equation Slopes -2, passing through -4,- What is the point-slope form of the equation of the line? (Simplity your answer. Use integers or fractions for any numbers in the equation) What is the slope-intercept form of the equation of the line? (Simplify your wwwer. Ute integer or tractions for any numbers...

  • 1. Solve the following ODE's using the Trial Solution Method. This method is also know as...

    1. Solve the following ODE's using the Trial Solution Method. This method is also know as the Classical Solution Technique. Initial Conditions are given for each equation r(0) 2 (a) 36r 4, (b)816r 0, (0)3, (0)2 (c) 312x 0, r(0) 2, (0)=2 (d) 658x 116, (0)0, (0)= 1 2. Choose one problem from part 1 of this assignment. Write a MATLAB program to do the following (a) Plot the solution over a reasonable range of the independent variable. (b) Verify...

  • This assignment uses R/Rstudio to the normal, uniform, and lognormal distribution. You must use R/RStudio for...

    This assignment uses R/Rstudio to the normal, uniform, and lognormal distribution. You must use R/RStudio for this assignment. Compile your results into Word, write any explanations, and turn in the hard copy. Work on your personal computer or use the computers on campus. Get started early! I need the R studio command to get this answer! thank you!! 4.  Consider the formula f(k)=1−(1/k2) A.Evaluate the formula for k = 2. B.Evaluate the formula for k=3

  • For the following questions: a)Calculate ??????for the spontaneous reaction b)Write the overall cell equation c)Write the...

    For the following questions: a)Calculate ??????for the spontaneous reaction b)Write the overall cell equation c)Write the cell notation for the cell d)Calculate ??? e)Calculate ?????where non-standard conditions are stated 1)cell is made from the ??3+,(??,0.10?)|??and the ???4-(??,0.25?)|??2+,(??,1.50?)half cells, where pH is 1.67 at 298 K(no need to calculate ???for this Q) 2)A cell is made from the ??|??+,(??,0.010?)and the ???4-(??,2.0?)|???2half cells, where pH is 0 at 298 K(no need to calculate ???for this Q)

  • Hi can You please solve [t-BuCl] remaining for my table the concentration of it remaining I only...

    hi can You please solve [t-BuCl] remaining for my table the concentration of it remaining I only used time trial attempt 1 heres my data with the table thats not filled in on the picture: for % t-BuCl remaining for trials 2-4: I got 85 % trial 2, 90 % trial 3, and 95% trial 4 for trials 1-4 for time 1st attempt I got 87 seconds trial 1 72 seconds trial 2 35 seconds trial 3 7 seconds trial...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT