I have an assignment on Data analysis but I am really struggling to upload it, the course is MBA 5300, University of Ottawa.

1.Do VIP clients who are members of private club spend more time weekly than players on a public sport club?the amount of time(minutes) taken for a sample of 115 private and public sport clubs was recorded in the first week of summer. data can be found in the excel file As1.XlSx( sport club) in the excel directory.

For both private and public sports clubs:

a) sort spending time in a appropriate number of classes. Give the frequency distribution

b)construct a histogram.describe the shape of the distribution suggested by the histogram

C)find the three central tendency measures:mean,median and mode (from individual data). What do they tell you about the distribution of time spent?

d) compare the mean for individual data with the mean calculated for grouped data.