Question

The following data was collected from a survey on student's exercise habits. Hours Frequency 0 to 2 3 to 5 6 to 8 9 to 11 12 to 14 10 12 13 Preferred Exercise Frequency Runnin Yoga Weights Exercise Class Swimming 15 1) Use Excel to create a bar graph (column graph in Excel) or a histogram for each table. Use the appropriate graph for each table. Include a chart title and axis labels on each graph. 2) How is the data on the 'hours exercised weekly' distributed? (symmetrical, left or right) What does this tell us about student's exercise habits? Submit your response via the link provided in lvyleartn

Answer 1

Solution :-

In table 1 the data given is cumulative frequency distribution, so first we convert it into normal distribution and the solve it.

So the new table is :-

0.. 10% 11:06 K- You Just now hours exercised weekly frequency 0 to 2 3 to 5 6 to 8 6 9 to 11 2 12 to 14

Graph for table 1 is below

Table-1 6 5 4 6 frequency 3 1 0 0to 2 3 to 5 6 to8 9 to11 12 to 14 hours exercised weekly

Graph for table 2 is below

Table-2 16 14 12 10 15 frequency 4 4 0 weights exercise class swimming running yoga Preferred exercise

Answer no 2. ) The data on table 1 is unsymmetrically distributed as most of frequency is towards left, hence the graph is left. As most of the students exercise below 2 hrs as compared to others. We can see this from graph that most of data is leftly distributed.

Hope this helps you. Best of luck and thank you.