Answer Happy

Question 1 Open a spreadsheet (Excel, Google Sheet, or any spreadsheet you choose), then type in (or copy and paste) the column heading "data" plus the following numbers: data 34 42 51 17 52 46 52 53 60 25 Put them in cells A1 through A11, so it looks like this: A data 34 42 51 17 52 46 52 53 60 25 1 2 3 6 7 8 9 0/9 pts 3 Details 10 11 • In a blank cell, type =SUM(A2:A11). This will find the total of all the numbers in cells A2 through A11. Enter your answer here:
11 25 . In a blank cell, type -SUM(A2:A11). This will find the total of all the numbers in cells A2 through A11. Enter your answer here: • In a blank cell, type =COUNT(A2:A11). This will give the number of numerical observations in the array. Enter your answer here: • In a blank cell, type -MIN(A2:A11). This will compute the minimum number in the cells A2 through A11. Enter your answer here: • In another blank cell, type=QUARTILE(A2:A11,1). This will compute the first quartile. Enter your answer here: • In another blank cell, type =MÈDIAN(A2:A11). This will compute the median. Enter your answer here: . In another blank cell, type -QUARTILE(A2:A11,3). This will compute the third quartile. Enter your answer here: . In another blank cell, type =MAX(A2:A11). This will compute the maximum. Enter your answer here:
In another blank cell, type -QUARTILE(A2:A11,3). This will compute the third quartile. Enter your answer here: • In another blank cell, type =MAX(A2:A11). This will compute the maximum. Enter your answer here: In another blank cell, type =AVERAGE(A2:A11). This will compute the mean. Enter your answer here: • In another blank cell, type =STDEV(A2:A11). This will compute the standard deviation. Enter your answer here: Question Help: Post to forum Submit Question