Question: For below data Please can create separate Excel table for below items and share via google docs or via email to 1..r@gmail.com. Please see data
For below data Please can create separate Excel table for below items and share via google docs or via email to 1..r@gmail.com. Please see data below :
- Create two frequency tables based on two separate questions from your survey.
- Create a bar graph and a pie chart based on the data in the frequency tables.
- Determine the class intervals and create frequency distribution for each of the frequency tables.
- Create one frequency polygon of the data from the frequency distribution.
| User Number | Age (Years): | Gender | What is your goal of joining this one month program | What are your challenges maintaining your ideal weight?(Check all that apply)? | What method will you prefer to use to lose weight? | Do you anticipate keeping up with the method at the end of the program? | What is the ideal weight that you want to reach | What is your biggest motivation for joining the weight loss program | |
| 1 | 31-40 | Female | To lose weight | Become healthier | Detox Diet | Yes | 140 lbs | Self | |
| 2 | 31-40 | Male | To lose weight | Become healthier | Eating better | Yes | 160 lbs | Self | |
| 3 | 31-40 | Male | To lose weight | Become healthier | Exercise | Yes | 160 lbs | Self | |
| 4 | 20-30 | Male | For better overall health | Become healthier | Exercise | Yes | 160 lbs | Self | |
| 5 | 41-50 | Male | For better overall health | Become healthier | Eating better | Yes | 160 lbs | Self | |
| 6 | 41-50 | Male | For better overall health | Become healthier | Eating better | Yes | 160 lbs | Family | |
| 7 | 41-50 | Male | For better overall health | Become healthier | Eating better | Maybe | 140 lbs | Family | |
| 8 | 20-30 | Female | For better overall health | Become healthier | Exercise | Yes | 160 lbs | Self | |
| 9 | 41-50 | Male | For better overall health | Become healthier | Exercise | Yes | 160 lbs | Self | |
| 10 | 31-40 | Male | For better overall health | Become healthier | Exercise | 160 lbs | Friends | ||
| 11 | 41-50 | Female | For better overall health | Not enough physical activity | Exercise | Yes | 160 lbs | Family | |
| 12 | 31-40 | Male | To lose weight | Not enough physical activity | Eating better | Yes | 160 lbs | Self | |
| 13 | 41-50 | Male | For better overall health | Not enough physical activity | Eating better | Maybe | No opinion | Self | |
| 14 | 31-40 | Male | For better overall health | Not enough physical activity | Eating better | Maybe | No opinion | Family | |
| 15 | 41-50 | Male | To lose weight | Not enough physical activity | Eating better | Yes | 160 lbs | Family | |
| 16 | 31-40 | Male | For better overall health | Not enough physical activity | Exercise | No | 150 lbs | Friends | |
| 17 | 41-50 | Female | For better overall health | Fitness | Exercise | Yes | 160 lbs | Self | |
| 18 | 41-50 | Male | To lose weight | Nil | Exercise | Yes | 160 lbs | Self | |
| 19 | 20-30 | Male | For better overall health | Not enough physical activity | Exercise | Yes | 140 lbs | Self | |
| 20 | 31-40 | Male | For better overall health | Not enough physical activity | Eating better | Yes | 160 lbs | Self | |
| 21 | 41-50 | Male | For better overall health | Not enough physical activity | Eating better | Yes | No opinion | Self | |
| 22 | 41-50 | Male | For better overall health | Not enough physical activity | Detox Diet | Maybe | No opinion | Self | |
| 23 | 41-50 | Male | To lose weight | Not enough physical activity | Exercise | Yes | Self | ||
| 24 | 20-30 | Male | To lose weight | Not enough physical activity | Detox Diet | Yes | 140 lbs | Self | |
| 25 | 20-30 | Female | For better overall health | Become healthier | Eating better | Yes | 140 lbs | Internet | |
| 26 | 31-40 | Male | For better overall health | Become healthier | Exercise | Yes | 150 lbs | Friends | |
| 27 | 41-50 | Male | For better overall health | Become healthier | Exercise | Maybe | 140 lbs | Friends | |
| 28 | 41-50 | Male | For better overall health | Become healthier | Eating better | Maybe | 160 lbs | Friends | |
| 29 | 41-50 | Female | For better overall health | Become healthier | Exercise | Maybe | Friends | ||
| 30 | 31-40 | Male | For better overall health | Become healthier | Exercise | Maybe | 160 lbs | Friends | |
| 31 | 20-30 | Female | To lose weight | Improve physical appearance | Eating better | Yes | 140 lbs;150 lbs | Friends | |
| 32 | 31-40 | Male | To lose weight | Not enough physical activity | Exercises | Yes | Other | Family |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
