HED 489 Biostatistics

1 / 42

# HED 489 Biostatistics - PowerPoint PPT Presentation

HED 489 Biostatistics Assignment 5 Figures Review the following tutorials Graphs Graphing in Excel 1 Graphing in Excel 2 Assignment Click here to open an excel file . This file will have some simple data. You are to take this data and make the following: Line Graph Bar Graph Pie Chart

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'HED 489 Biostatistics' - Albert_Lan

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### HED 489 Biostatistics

Assignment 5

Figures

Review the following tutorialsGraphs

Graphing in Excel 1Graphing in Excel 2

Assignment
• Click here to open an excel file. This file will have some simple data. You are to take this data and make the following:
• Line Graph
• Bar Graph
• Pie Chart
Make certain that the graphs have a proper title, that the scales/headings are visibly and appropriate titled…

First, highlight the data you want graphed. In this case, wewant to graph the height of each of the 10 people.After highlighting, then click the ‘chart wizard’

…or, instead of click the ‘chart wizard’, one can pull downthe ‘Insert’ menu, highlight ‘chart’ and click left mousebutton

You’ll now get this box…we’re just doing ‘columns’ with thissample…you can choose the type you want…after choosing, click ‘next’

You’ll now have the wizard tell you what data is beingconsidered for this chart…since you already highlightedthe cells A1 to B11, the wizard automatically puts it into the data range line

The next folder will ask of you a lot of details about the actual chart…the first folder, Titles, gives you an opportunity to put down thetitles…in this case, the Chart Title and the Values on the y axis

With gridlines, you can choose to have more pronounced linesor less lines. Default is to keep major in both…we’ll use the default of major

The legend folder gives you an opportunity to select where you wantthe legend, or even if you want to eliminate the legend.By default, it’s the right…but in this case, we don’t wanta legend…so we unclick the ‘Show Legend’ box

The ‘data label’ folder allows you to put the numeric data in the figure…by doing so one can make the figure very confusing…experiment…in most instances, one will only want the ‘value’ to be checked…in our case, we’ll leave all blank

Data Table gives you the opportunity to put the data outsidethe figure…most of the time it makes it very confusing..We’ll leave ours uncheckedClick the ‘next’ button

This box allows us to tell Excel where we want this chart to appear…by default it will be listed in Sheet 1…however, go to the next pageto see where we want this chart…

Here it is in sheet 2 of the excel file. You can enlarge itby click the outside line of the box and dragging to your desired size…

You can see that this is substantially larger than the original. You can alsocopy and paste this into any other documents, such as Word or PPT

You can make changes by simply click onto the area you wantchanged…for example, click around the title and you can edit it…

The y axis seems a little crowded…perhaps you might want to remove someof the numbers…put the mouse over that scale and double click…you’ll get this box…go to Scale.

Instead of having every 10 inches shown, change it to 20…you can also resize the fonts, number style, or alignment…we’ll keep them as they appear

As you can see, the names of the people are at a slight angle…you can change the direction…for example, if you want the names to appear‘flat’, click to this point, then click OK

You’ll note that you’ve lost some names..the space doesn’t allow all names to be visible. You could change the fonts,or keep them at an angle…we’ll go with the angle.

Let’s say that you choose to use a line instead of a column foryour graph…going back to the first page, we’ll highlight the names and height, but this time we’ll choose the line for the charttype. Note that there are numerous types of line options…we’ll keep it simple…

We’ve increased the size of the chart…and we’ve highlighted the legend…by click the delete button that legend will be removed…

Let’s also reduce the number of items on the y axis and have itonly list 20, 40 60, 80 and 100 inches…

Opps…we forgot to put the title and the information on the ‘y axis’…first, double click the on the current title

To add or change information on the chart, pull down the‘Chart’ menu…and in this case highlight ‘Chart Options’

Click the title folder and make the change (adding Height) onthe y axis…note you can move to the other folders byclicking their title…when done, click ‘ok’

So there you have it. To be honest, it’s somewhat a dud of achart…that’s because there’s not a great amount of difference inheight…you can show the differences by modifying they axis data…first, double click on the y axis numbers…

OK, here are some changes…first, we’ve changed the minimum from 0 to 50…since none of these individuals are only 0 inches tall you can do that…I’ve chosen 50 only because I so desired…I could have chosen 60..Since nobody is 100 inches tall, I’ve reduced the maximum to 80…finally, the ‘major units’ are back to 10

This chart now shows more detail in the differences in height…let’s change itto a minimum of 60…

Let’s now take a look at a pie chart. A pie chart can be used only for certain data, and it represents a part of the ‘whole’… for our example, we’ll use the political persuasion of our 10 people. Note that all have either a democratic or republican persuasion, thus there will be a total of 10 subjects in the pie. Click the next button

Note, that one also needs to total the numbers…in this case,there are five democrats and 5 republicans…

In this case, the legend is important, since it says thatthe blue are democrats and the maroon are republicans…click nextdirect this chart to Sheet 4 and then click finish…