Bue Today at 11:59 PM CST mn C is a list of quest er to each question. And final

Question

Bue Today at 11:59 PM CST mn C is a list of quest er to each question. And finally Column Fdisplays To place your answers from Column E into the blanks below, use the copy/paste keyboard shortout: Ctri+ C and Cer+v on a C or Cmd C and Cmd+V on a Ma f you would like to learn more about a specific function, you can always visit the the formula you used to generate your answer in Colume t site and type the function into the search box at the top-right of the page What is the sum of the data? What is the minimum value of the dsta? 0/10 pts (0% 2

Explanation / Answer

Note: For all the exercises below, the data set is stored in A2 to A12

1) Formula to use:=COUNT(A2:A12)

Ans: 11

2) Fomula: =SUM(A2:A12)

Ans: 859

3)=AVERAGE(A2:A12)

Ans: 78.0909

4)=MEDIAN(A2:A12)

Ans: 75

5)=MIN(A2:A12)

ans: 59

6)=MAX(A2:A12)

Ans: 98

7)=SQRT(A2:A12)

Ans: 7.681146

8)=POWER(A4,2)

Ans: 6241

9)=ROUND(C8,2) ===> C8 is the cell where the value of square root of A2 is stored

Ans: 7.68

10) =ROUNDDOWN(C8,0) ===> C8 is the cell where the value of square root of A2 is stored and '0' has been chosen for whole nos.

Ans: 7

11)=ROUNDUPC8,0) ===> C8 is the cell where the value of square root of A2 is stored and '0' has been chosen for whole nos.

Ans: 8

12)=VAR(A2:A12)

Ans: 224.4909

13)=STDEV(A2:A12)

Ans: 14.98302

14) =ROUND((VAR(A2:A12)),2)

Ans: 224.49

15) =ROUND((STDEV(A2:A12)),2)

Ans: 14.98

16)=COUNTIF(A2:A12,"<75")

Ans: 5

17) =IF((AVERAGE(A2:A12))<75,"True","False")

The first part is the logical test to check if the average is less than 75, returns "True" if correct and "False" if incorrect

Ans: False

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.