Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

-46 poihts 1 2 H 100. My Notes Ask Your The population full-time equivalent numb

ID: 3283651 • Letter: #

Question

-46 poihts 1 2 H 100. My Notes Ask Your The population full-time equivalent number o students (FTES) at Lake Tahoe Community College for 2005-2006 through 2010-2011 was given in an updated report. The data are reported here 2005-06 200607 2007-082008-9209-10 2010 t Total FTES 1.585 1.690 1.735 1,935 2.021 1,090 3 1,935 2.021 1.890 Calculate the mean, median, standard deviation, the first quartile, the third quartile and the 1QR, Round to one decimal place, 809 33 1812.5 standard deviation first quartile third quanie iQR Submit Assignmant Save Assignment Progres

Explanation / Answer

Using Excel Functions:

mean=AVERAGE(A1:A6)

median=MEDIAN(A1:A6)

standard deviation=STDEV.S(A1:A6)

First Quartile=QUANTILE(A1:A6;1)

Third quartile=QUANTILE(A1:A6;3)

IQR=third quartile-first quartile

Total FTES 1585 1690 1735 1935 2021 1890 MEAN 1809.3 MEDIAN 1812.5 STANDARD DEVIATION 165.6 FIRST QUARTILE 1701.3 THRD QUARTILE 1923.8 IQR=third quartile-first quartile 222.5