oints: Please select the correct answer A BCDE A B CD E 3 2 2 4 6 8 4 3 3 6 9 12

Question

oints: Please select the correct answer A BCDE A B CD E 3 2 2 4 6 8 4 3 3 6 9 12 5 4 4 8 12 16 Let's say you want each blank cell to equal its row header multiplied by its column header, as shown above. Which of the following cell B2 formulas would give the correct result when pasted into the remaining empty cells? =A2*B1 estion 2(8+8+8+8+8+8+8 56 points: For this exercise, open the data file called "Hw1 Dataset1.xls". To get a copy of the data set, go to the course website (Canvas) and select the Hw1 DataSet1.xls in Data folder found on the page. Make sure you pay attention to where you save the file so that you can open it from Excel. This file contains two main tabs. The first tab in the file contains the data. The second tab contains a description of the variables in the data set. Please answer these questions: Calculate the total writing score for the 30 students in the sample (you can enter the formula in any cell in Excel.) Calculate the mean (average) of writing and math scores. Calculate the average writing and math score for each gender separately Calculate the median writing score. Which one is bigger, the mean (average) or the median? Hint: The formula for calculating the median is:MEDIAN Calculate the median writing score. Hint: The formula for calculating the mode is:-MODE Calculate the standard deviation for the writing data. Hint: The formula for calculating the standard deviation is:STDEV Use the Quartile function described in the below, and find the quartiles for the "math" variable Hint: The quartile formula can be used to calculate the minimum value, the lower quartile, the median, the upper quartile, and the maximum value. Enter the formula as below 1. 2. 3. 4. 5. 6. 7. QUARTILE Then select the group of cells (math), and press the comma, ",".Next, enter one of the following numbers, depending on which quartile you'd like: 0 Gives the minimum value 1 Gives the lower quartile (25th percentile) 2 Gives the median

Explanation / Answer

$A$2*$B$1 IS THE ANSWER FOR FIRST QUESTION WHERE $A$2 REPRESENTS THE ENTRY OF A2 AND $B$1 REPRESENTS THE ENTRY OF B1

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

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