Based on the values in Cell A51: A55, what formula can you copy and paste in to Cells

Question 1

Based on the values in Cell A51: A55, what formula can you copy and paste in to Cells B51: B55 to return the values shown?

If the formula in Cell D49 is copied to Cells E49:F49, what sequence of values would be generated in Cells D49:F49?

Question 2

In cell B28, calculate the number of workdays to deliver the order based on the lookup table in the range A14:C17 of the Deliver Calculator worksheet and using the value of cell B27 as the lookup value. If the formula returns an error value, display no text in the cell.
Question 3

a) Discuss the impact of departure from normality on the one-way analysis of variance.

b) Discuss the impact of departure from homoscedasticity (constant variance) on the one-way analysis of variance.

c) What is a conservative test of hypothesis?

d) Which multiple comparisons method (s) should be used if the residuals show a clear departure from normality?

Correct Option is =IF(A51=”Red”,”Yes”,”No”)

Explanation : If content of cell A51 is Red, print Yes in B51 else print No

Correct Option is C,C,C

The cell content is absolutely reffered and hence content of cell D49 is copied as it is

Put following formula in Cell B28

=IFERROR(VLOOKUP(B28,’Deliver Calculator’!A14:C17, 3),””)

Above will put the value of Column C for the matching value of Cell B28 in A14 to A17

For the highlighted 3 in above formula, replace it according to your need

• If you want value from Column A then put 1 here
• If you want value from Column B then put 2 here
• If you want value from Column C then put 3 here