Using the data in all the pictures below, which lists the classes homework avera

Question

Using the data in all the pictures below, which lists the classes homework averages up to HW 3, and their exam 1 scores, calculate several statistics you have learned in this class (mean of exam 1, mean of up to HW 3, standard deviation of exam 1, standard deviation of up to HW 3, ssx, ssy, median of each and mode of each, variance)and use them to write a paragraph or two discussing the characteristics, trends, and patterns within this data.
Support your written response with statistics you have calculated
T-Mobile LTE * 51% 9:01 PM bbhosted.cuny.edu Emplid Exam 1 GrAvg to HW3 23683475 23278429 23307797 23213582 15394102 23404557 23531741 14046680 15230162 15336410 23265726 23232082 14201058 14152579 23307692 15005706 15001329 23297541 23082240 23146407 23439455 23382456 23282646 23147948 23193824 23163111 23592332 14194504 23409912 23272965 23470507 14182703 15033716 23739810 23430210 14094726 23688977 23396072 66 80.22391 82 93.72531 60 78.11436 48 86.21153 52 84.96966 64 82.5462 82 93.97029 66 77.92307 0 66 83.6612 58 76.16895 80 95.36887 73 60 79.74625 70 76.83523 74 76.65067 2 84.54366 66 80.77481 80 90.46483 76 94.72124 74 90.48959 80 82.66235 74 88.83193 82 93.17034 68 56.04239 66 91.37623 64 39.65384 84 71.69103 58 57.19141 84 92.46521 80 97.7022 46 58.32038 62 75.67923 84 89.93957 52 71.25361 54 77.10396 74 88.50774 82 93.86887 4 64

Explanation / Answer

Sol:

please provide data ine xcel to calulate mean ,sd ,patterns,

I will do it in R or excel

mean=AVERAGE(COL RANG)

that is AVERAGE(say A1:A100)

std deviation is givena s in excel

STDDEV=STD.S(col range)

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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