Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started