1) What is the Arithmetic Mean? Discuss.

2) What is Geometric Mean? Discuss.

3) What is a Harmonic Mean? Discuss.

Do the problem using Microsoft Excel.

3.65 The download and upload speeds of a mobile data carrier is of great interest to both individual and business users. Fastest download speeds in Mbps for 100 cities in the United States are here: https://broadbandnow.com/fastest-cities(Links to an external site.)

For the average download speed:

• Calculate the mean, median, first quartile, and third quartile.
• Calculate the range, interquartile range, variance, standard deviation, and coefficient of variation.
• Construct a boxplot. Are the data skewed? If so, how?
• What can you conclude about the download speeds for the various U. S. cities?