Question 10 (1 point) For this question, you will need to download Excel data fi

Question

Question 10 (1 point) For this question, you will need to download Excel data file called "Grade" from Excel Data for Midterm xam module in Content in D2L. You can also download the grade file by clicking "Grade" right here. Use Excel Program on your computer. A sample of 30 Students took an exam in a pilot project and their grades are saved in Grade file. What is the mean? Round to 1 decimal. Your Answer: Answer Save Question 11 (1 point) For this question, you will need to download Excel data file called "Grade" from Excel Data for Midterm Exam module in Content in D2L. You can also download the grade file by clicking "Grade" right here. Use Excel Program on your computer. A sample of 30 Students took an exam in a pilot project and their grades are saved in Grade file. What is the median? Round to 1 decimal. Your Answer:

Explanation / Answer

Ans:

(excel function Average and median are used for calculating mean and median respectively)

Student grade 1 78 2 54 3 77 4 98 5 54 6 87 7 77 8 89 9 91 10 56 11 54 12 87 13 98 14 100 15 43 16 54 17 49 18 78 19 65 20 66 21 54 22 76 23 87 24 67 25 72 26 95 27 93 28 58 29 68 30 79 Mean 73.5 median= 76.5

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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