Adapt Chart Article For Free

okay so I'm gonna show you now how to take this bar graph that we made before and I have a video on how to make this I'll put the link to that video right here so I'll put a link to that in the in the description below but I'm going to show you how to make this graph look a lot closer to what you would see in a scientific publication specifically in my area which is in Physiology so right now you look at this and it looks like a fairly generic graph that was made in Excel there's a lot of things that Excel does that researchers who published tend to not do or they do in slightly different ways or Excel does oh it doesn't do some things that publications would require and so I'm going to show try to show you how to best get something from Excel to something that would be adequate for publication purposes all right so first thing that I would do is I would add some sort of error bars to this so error bars tell us something about the variability of the data and it's something that some people use standard deviation but more often in my field at least it's going to be standard error of the mean so I want to quickly calculate standard error with mean for for this average to average supine heart rate which is 60 in the average standing heart rate which is 67 so I'm just gonna move this t-test result out of the way for now so I'm just dragging it down and then let's do let's put new standard deviations and let's do sample size so n value so in order to do standard deviation you can just do Excel has a function for that so you do equal standard deviation or start typing it out and you're gonna see the second one once you get stn you're going to see standard Eve for population and standard if for first sample we are not doing population statistics here so we should be doing Sam so I'm gonna double click this and then I'm going to highlight the data that we want so this is under the supine heading here so let's do all the supine data and you can either hits and pregnancy and then enter or Excel knows that if you don't do that in parentheses that just means you're essentially being lazy but it will put it in for you so I hit enter and then here is our standard deviation using the sample the sample equation for our supine group now let's do the same thing for standing so equal start typing it double-click the standard EV for the sample which is the dot s highlight all the standing data entered ok so here our standard deviations now what we need to do is figure out how many people are in each of these so they should be the same but we'll do it independently anyways so an easy way to do that so we're gonna do another basic Excel function here so type in the equal sign and start typing count and so you can see this description here of the standard count equation it counts the number of cells in a range that contain numbers and because all these are numbers so all of our data is numbers that will tell us how many numbers we have so let's go ahead and use that...