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

I\'m not sure how to find the mean or median. I also don\'t know what to do in t

ID: 3068197 • Letter: I

Question

I'm not sure how to find the mean or median. I also don't know what to do in terms of plugging them into excel for instance.

Large Data Sets from Appendix B. In Exercises 25-28, refer to the indicated data set in Appendix B. Use software or a calculator to find the means and medians - 25. Tornadoes Use the F-scale measurements from the tornadoes listed in Data Set 22 Torna- does) in Appendix B. Among the 500 tornadoes, how many have missing F-scale measurements? Caution: In some technologies, missing data are represented by a constant such as -9 or 9999.)

Explanation / Answer

Calculating mean:

For mean calculations for variable lets say F SCALE we know out of 500 values we have 10 values which are absurd or missing. While calculating mean we will remove those 10 values from the calculation i.e. mean of the F SCALE column will be

Mean = ( sum of F SCALE for 490 observation) / 490

Calculating Median:

The same way we will calculate the median of the column. For the same column F SCALE we will only consider 490 values and use the formula to calculate the median.

First arrange observations in assending order then

Median = (( 490/2 th observation) + ( (490/2) +1)th observation)/2

By following same method we can calculate mean and median fir all the columns.

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote