Question One: Online Shopping - The trend of online shopping is increasing significantly. Although the number of people who purchase various products and services online is increasing more than ever before, this trend is still relatively low among people older than 60. To learn more about this issue, a sample of 250 customers (refer to the Excel file) older than 60 who have bought an item online were selected. The number of hours spent related to online shopping during the past six months was recorded.

link for excel (for this one, question 2, and question 3): https://docs.google.com/spreadsheets/d/1QU7LYlvsdffY8eVKl3p0s1B1g5YcKxHn/edit?usp=sharing&ouid=114245390309576542037&rtpof=true&sd=true

a) Calculate the mean, median, and mode of the number of hours spent related to online shopping.

b) Calculate the variance and standard deviation of the number of hours spent related to online shopping.

c) Draw a box plot related to the number of hours spent related to online shopping.

d) Determine the first, second, third quartiles, and interquartile range of the number of hours spent related to online shopping.

e) Briefly describe what you have learned from the statistics you calculated.

Note: For part a, b, and d, you must show manual solution, calculation, and formula. For part c, use software to draw box plots.

Question Two: Speed Limit - An insurance company claims that speed limits inside the city are low, and most drivers drive at speeds that they consider safe. The company believes that the city should set the speed limit at a "New" speed limit of the 85th percentile.

They collected a random sample of 400 speeds (refer to the Excel file) where the limit is 60 km/hr was recorded. Compute the "New" speed limit that the company suggests. Note: You must show manual solution, calculation, and formula.

Question Three: CO-OP Salary - A business management student wants to learn more about the difference between coop salaries related to her field of study. She uses a recent survey regarding the degree and co-op salary of four groups of graduates: (1) Business Administration, (2) Accounting, (3) Finance, and (4) Marketing.

a) Draw box plots to compare the four groups of starting salaries.

b) Report your findings. Note: Use software to draw box plots.