Answered step by step
Verified Expert Solution
Link Copied!

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 :

  1. Create two frequency tables based on two separate questions from your survey.
  2. Create a bar graph and a pie chart based on the data in the frequency tables.
  3. Determine the class intervals and create frequency distribution for each of the frequency tables.
  4. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finite Math And Applied Calculus

Authors: Stefan Waner, Steven Costenoble

7th Edition

1337515566, 9781337515566

More Books

Students also viewed these Mathematics questions