Statistics Individual Project – Refer to the two Data Sets under DocSharing on our course webpage. The project is due no later than Midnight on Sunday, in Week 8 — the last day of class.
Under DocSharing on our COURSE WEBPAGE are two Excel spreadsheets. These are also attached below for easy access. Open and print these two spreadsheets labeled:
Individual Project Female Data Set (Data set 1 women.xlsx)
Individual Project Male Data Set (Data set 1 men.xlsx)
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.)
Question 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.
Question 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.
Question 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.
FURTHER CLARIFICATION and HELPFUL REFERENCES for answering the above three questions!
These data sets are for Male and Female and are also in the Doc Sharing tab at 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. The online textbook is accessible through the MULTIMEDIA LIBRARY on our course homepage.
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.
We are committed to making our customer experience enjoyable and that we are keen on creating conditions where our customers feel secured and respected in their interactions with us.
With our qualified expert team who are available 24/7, we ensure that all our customer needs and concerns are met..
Our refund policy allows you to get your money back when you are eligible for a refund. In such a case, we guarantee that you will be paid back to your credit card. Another alternative we offer you is saving this money with us as a credit. Instead of processing the money back, keeping it with us would be an easier way to pay for next the orders you placeRead more
All orders you place on our website are written from scratch. Our expert team ensures that they exercise professionalism, the laid down guidelines and ethical considerations which only allows crediting or acknowledging any information borrowed from scholarly sources by citing. In cases where plagiarism is confirmed, then the costumier to a full refund or a free paper revision depending on the customer’s request..Read more
Quality is all our company is about and we make sure we hire the most qualified writers with outstanding academic qualifications in every field. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.Read more
We understand that students are not allowed to seek help on their projects, papers and assignments from online writing services. We therefore strive to uphold the confidentiality that every student is entitled to. We will not share your personal information elsewhere. You are further guaranteed the full rights of originality and ownership for your paper once its finished.Read more
By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.Read more