Display the IF TG status as normal high value of each patient using the

Display the if tg status as normal high value of each

This preview shows page 1 - 3 out of 3 pages.

Display the IF-TG status as normal / high value of each patient using the following criterion: A patient has a normal value IF TG < 150 mg/dL6.Insert a new sheet and name it Graphs. Copy in Graphssheet using Paste Special option [Home – Paste– Paste Special – Values and Numbers Format]all data from Datasheet. Create in this file the followinggraphical representations:a.Pie chart: Use Pivot Table and PivotChart Reports option to create the frequency table gender.Based on the obtained frequency table create in Graphssheet a Pie chart.b.100% Stacked Column chart: Use Pivot Table and PivotChart Reports option to create acontingency table with gender on rows and genetic susceptibility on columns. Copy the valuesof the contingency table in a new table as:Genetic susceptibility=yesGenetic susceptibility=noFemaleMaleBased in the above table, create a 100% Stacked Column chart.c.Histogram (no constrains regarding the classes of frequencies): Create the distribution of HLD.Your graphical representation is expected to be like the one in the image bellow:1
Background image
MICROSOFTEXCEL: DESCRIPTIVESTATISTICS© Sorana D. BOLBOACĂ, 2014
Background image
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Spring '18
  • Dr. Moez
  • Histogram

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes