Math project | Mathematics homework help

Under DocSharing on our COURSE WEBPAGE are two Excel spreadsheets. Open and print these two spreadsheets labeled:

Get a plagiarism free copy of this essay from our experts
Math project | Mathematics homework help
For as low as \$13/Page

Individual Project Female Data Set
Individual Project Male Data Set

You will need these two files ABOVE to do your Individual Project assignment. (Hint: Excel allows you to SORT. Use this feature on the above Data Sets to help categorize by teens, 20’s, 30’s, 40’s, 50’s, 60’s, and 70’s ONLY for questions 1. and 2.below.)

1. Create a bar graph using two different colors to represent the male and female categories. Use age (on the x-axis) to categorize and graph the average BMI on the y-axis. Categorize the data points by age groups as indicated above. Do a grouping of teens and determine their average BMI, average BMI for ages 20 – 29, average BMI for ages 30 – 39, etc. You will end up with fewer bars and a more useful graph.

2. Create a pie chart to represent the systolic blood pressure for participants. Categorize the data points by age groups as indicated above. Do a grouping of teens and determine their average systolic blood pressure, average systolic for ages 20 – 29, average systolic for ages 30 – 39, etc. You will end up with fewer partitions and a more useful pie graph.

3. Compare ALL males (not by age group) as a WHOLE and ALL females (not by age groups) Diastolic blood pressure. Support your results by including the following Measures of Central Tendencies and Measures of Dispersion that we have covered in this course. These require you to find the Mean, Median, Mode, Midrange, Range, and Standard Deviation. You need to do these separately for Males and separately for Females.

These data sets are for Male and Female and are in the Doc Sharing tab at the top of our course webpage.

QUESTIONS 1. AND 2. ABOVE: BAR GRAPH (aka Histograms) and PIE CHARTS (aka Circle graphs)

Your very first assignment for this course was to read certain sections in Chapter 1. Well, that is where you will find the basics necessary to create these graphs.

Examples of how to do these are in Section 1.2, starting on page 19. Look specifically at Examples 5, 6, 7, and 8

Section 12.1 on page 771 and 772 also shows Bar Graphs (Histograms). Look at Example 4 and also Figure 12.1.

After reading these sections for comprehension, then create a Bar Graph and a separate Pie Chart for the MALE data set and do the same for the FEMALE data set.

To do the bar graph, just use the AGE and BMI columns from the data set. Do it for males and females. No means, median, mode, range, midrange, or standard deviation need to be calculated for this graph.

To do the pie chart, just use the AGE and SYSTOLIC BLOOD columns from the data set. Do it for males and females. No means, median, mode, range, midrange, or standard deviation need to be calculated for the pie chart.
=====================================================

QUESTION 3 ABOVE – MEASURES OF CENTRAL TENDENCY and DISPERSION with Textbook Reference Pages

1. MEAN REFERENCES – Page 782 – Example 2
2. MEDIAN REFERENCES – Page 783 – Examples 3 – 6 with Bar Graph
3. MODE REFERENCES – Page 788 – Example 8
4. MIDRANGE REFERENCES – Page 789 – Example 9

COMBINED REFERENCES – For the preceding four measures of central tendency, go to Page 790 and review Example 10

5. RANGE REFERENCES – Page 795 – Example 1
6. STANDARD DEVIATION REFERENCES – Page 795 – Examples 2 thru 4

To do the measures of Central Tendency and Dispersion, just use the Diastolic Blood column from the data set. Do it for males. Then do these calculations again for females. This is where you do the calculations for means, median, mode, range, midrange, and standard deviation.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.