Practical Research 2 Data Analysis

Draw the symbol for "Summation"

Which of the following is the correct Google Sheet formula for Percentage?

• =(PART/WHOLE)*10

• =(PART/WHOLE)*100

• =(WHOLE/PART)*10

• =(WHOLE/PART)*100

Which of the following is the correct Google Sheet formula for Mean?

• =Ave(n:n)

• =Mean(n:n)

• =Average(n:n)

• =Average(n)

Which of the following is the correct Google Sheet formula for sample Standard Deviation?

• =STDEV.S(n:n)

• =STDEV(n:n)

• =SDEV.S(n:n)

• =SDEV(n:n)

What is the Google Sheet formula for correlation? (use x as IV and y as DV)