Once you have your data, you will need to present it to your teacher and science fair judges. In a science publication, you would choose between a table and a graph, but for the science fair project it is acceptable, and even encouraged, to showcase the data in both forms.

**Type of graphs:** Your first choice is to determine which type of graph would best communicate your findings. Your basic choices are bar graph, line graph, pie chart, or scatter plot.

**BAR GRAPH **โ This is the most common type for science fair projects. You may select a bar graph when your independent variable is qualitative (categories) or quantitative (numbers).

Look closely and make sure your bar graph has all the highlighted parts:

**LINE GRAPH** โ This is the second most common, but frequently used incorrectly, so be careful here. You should only select a line graph if your independent variable is quantitative (numbers) and you hypothesized that the changes in the independent variable would result in changes in the dependent one. For example, line graphs are great for showing changes in the dependent variable over time or distance along a transect.

Again double check the axes:

**PIE CHART** โ Pie charts are good for projects that have qualitative independent variables and have generated data that can be expressed as percentages of the total. For example, if your data were counts (i.e. the number of times something happened), then this might be your best choice to compare different treatments.

**SCATTER PLOT** โ If the purpose is to see if the variables are related (common in environmental projects), but there was not a clear choice for independent and dependent variables (for example wind speed and water temperature), then a scatter plot would be your best choice. This option typically requires much more data than the others to observe a trend.

Chris HarrrisThis is Really Helpful

AnnetteMy daughter did an experiment to see which long stemmed flower would last the longest. What would be a good graph or is it possible to graph the results?

Dr. Maille LyonsBar graph: flower type on x-axis; time on y-axis. Hopefully you had at least 3 flowers (e.g. 3 roses) for each flower type. Present photos if you have them to show when you decided the flower was “done”

AnnetteThank you!

arianna salinasHi y daughter is doing a project on if an apple can charge a phone,and she doesn’t know what to put on a he graph or which one to use.

Dr. Maille LyonsShe can only make a graph if she measured something such as the time the charge lasts, or the amount of charge generated, etc.

If she just did it to see if she could… she won’t have a graph because the answer will be yes/no. This is more of an “engineering project” than a “science experiment” – unless… she continues by testing different types of apples, or some other variable.

cindyHello Dr. Lyons, my 6th grade daughter is doing a science fair project involving which type of shipping envelope holds up best under the elements, heat, weight and water. Cardboard envelope, paper and plastic. We are unclear which type of graph to use.

Dr. Maille LyonsIt would be a bar graph with the element on the x-axis and whatever you measured for “holds up best” on the y-axis. If you did not measure something – for example, if you just have visual observations of which is “best”, then you don’t have data to graph. Use a table and photos.

Lizbeth MartinezI am doing a science fair project and its about apples not turning brown with lemon juice and water and left alone. What graph should I use? Need response ASAP

Dr. Maille Lyonsbar graph: put the conditions on the x-axis (lemon juice, water and nothing) and whatever you measured on y-axis. If you did not measure anything, then you can not make a graph. Present photos for results.

ManarHow about if she did how does colored water affect the color of the flower. What should she do for the graph.

Dr. Maille LyonsSounds like her “results” are yes or no … so there is nothing to graph. There has to be something quantitative (i.e. a number like time or temperature or distance or percent change) to make a graph

LeaWhat graph would be good to use when having to graph cleaning solution example which solution cleaned the coin the best i don’t know what graph to use

Dr. Maille LyonsBar graph with clean solutions on the x-axis and however you measured “best” on the y-axis. If you do not have a number for the “best”, then you can not make a graph. Present the observations in a table.

MelissaI’m doing an experiment on: How does the amount of water affect the growth of plants? I’m conflicted in which type(s) of graph I should use.

Dr. Maille LyonsYou could do a bar graph, for each different volume of water used (x-axis) with the final growth (height? weight? number of new leaves? etc.) on the y-axis.

You could also do a line graph with time on x-axis and growth on y-axis, using a different colored line for each volume used, if you measured growth over several time points.

Desiree & AlairaWe LOVE this idea…..our project is due in TWO MORE DAYZZZZ!!! and we didn’t even start on our projects yet because we didn’t know which one to pick…..and we have NEVER done a science project in our lives! the last part we needed was a chart to go with what our experiment was about….and all we wanted 2 say was thnk you! with love from Beaufort Middle School (South Carolina)

Sophia ParkerMy son is doing a Science Fair Project on bacteria I have 8 different samples and 3wks of work what chart do you think I may need?

Dr. Maille LyonsWhat are the 8 samples?

What did you measure?

What do you mean by 3 weeks of work (i.e. what did he actually do?)

Most likely a bar graph (based on 8 different types of samples), but potentially a line graph because time (3 weeks) is quantitative.

cindyMy 4th grade daughter decided to do her Science Fair Project on the benefits of using worm compost on plants. For the experiment she planted 6 of the same seeds (lima beans) 3 were controlled (no worm compost applied) 3 were her independent variables with .25, .50 and .75 ml of compost applied at planting. Over the course of 2 weeks she collected data. We are not sure what type of graph would be best since “plant height” doesn’t necessarily make it the best plant. Thicker stem, larger true leaves, overall health of the plant in other words really tells the story of how the compost has affected the plant, not only height. Being that these are quite small and she is in 4th grade, measuring the exact size of the tiny stems is not possible yet some are clearly thicker than others. Do you have any suggestions. All plants were in same location, with same amount of sunlight and given the same amount of water every other day.

Dr. Maille LyonsGreat idea for a project.

Was there only one seed in each of the three amounts of compost? Next time, have 3 seeds for each treatment so she has some measure of variability. There were three for the control… how much variability was there between the results among those three? The problem with only one seed per amount of compost is that it will be difficult to tease apart the natural variation in seed to seed differences with that of the differences due to amount of compost.

Since both of the independent variables are quantitative (0, 0.25, 0.5 and 0.75ml compost and 0 to 2 weeks time), she can select either line graphs or bar graphs. She could make both and decide which she likes better.

Generally I would recommend the bar graph for the amount of compost and a line graph for the changes over time. She will need to decide what she is defining as “best” and plant height is one metric. She can use photos to explain that it wasn’t the only one.

cindyThank you so much this is great feedback.

Diego MoralesI am doing a science fair project on if music can improve taking free throws in basketball and I don’t know what graph to use

Dr. Maille LyonsBar graph, with music vs. no music (or type of music) on x-axis and number (or percentage) of baskets made on y-axis

Zoe MooreDid a science project on which substances made metal rust. No time involved. All metal rusted in different solutions

Dr. Maille LyonsDid they all rust the same amount? What was your control (plain water – maybe?) Did the control also rust as much as the others? Do they look different in ANY way? What metal objects did you use? What solutions did you test?

Zoe MooreThank you. The penny and nail and paper lip all rusted at different time frames. Control was water and it rusted as much as the others. Metal button rusted at different rate. We also had the nail in mud and it rusted. The penny and button had white and black on it. The nail had orange on it. The paper lip was just black

Dr. Maille LyonsYour best bet will be photos with a data table for your observations (i.e. what you described each as). There really isn’t anything to graph unless you can somehow estimate the percent coverage of rust.

AdenI am doing a science fair project on changing the color of carnations. I am using red, blue and green dye.

I will try to find which color is absorbed the fastest. LIght, amount of wate, temperature of water and the number of dye drops will all be the same. I dont have a clue as to how to graph this project. Any ideas? Please help!

Dr. Maille LyonsIf you measure the time it takes to first see color and/or the time it takes to get a fully colored flower, you will be able to make a bar graphs for time vs. treatment (each color).

Alternatively you could photo at the start, then 1 hour, 6 hours, 12 hours, 24 hours, then once each day until you don’t see any further color changes (or any other time periods you think are best). You will then be able to make a line graph with time on the x-axis and percent colored on the y-axis. You will have three lines (one for each color). You can estimate percent coverage from the photos and compare.

JackMy science fair project deals with behavior science. I am testing about 10-20 people between the ages of 15-60. I want to know how to make a graph or chart showing how well people remember a short poem. I am documenting how many pauses and mistakes and if they have to start over. I do not know how to show my findings though. Please give me advice. Thank you.

Dr. Maille LyonsYou could group the data by male and female and make a bar graph for number of mistakes (y-axis) vs. male/female.

You could group the data by age (pick 5 or 10 year categories like: 15-20, 20-25, 25-30, etc.) and do the same as above.

You could also make a scatter plot graph with age on the x-axis and number of mistakes on the y-axis to see if older trends toward more mistakes.

Anita RodriguezI am doing a science project on which gum is stickier, chewing gum or bubble gum. I measured the tack of the gum by sticking each piece of gum (each piece cut to 2 grams) “sandwiched” between two pieces of foam board. I pulled the foam board apart and measured how far it stretched (stuck together) until it fell apart, at which point i measured the distance in cm. At that point I also recorded the area that was still covered in gum and recorded the percentage of gum still stuck to the foam board. Is there another (or better way) to measure the stickiness of the gum? How would I put the data on to a graph?

Your help is much appreciated!

Dr. Maille LyonsSounds like you have already made the project your own and have quantitative dependent variables which is exactly what you want! Nice job.

OK – for the graph, you can make at least 2bar graphs with Gum Type on the x-axis: 1 bar for chewing and 1 for bubble; then the y-axis will be Stickiness, measured as the length reached before breaking (in cm) = 1 graph and Stickiness, measured as the amount left stuck behind (in % still stuck) for the 2nd graph.

If you want to do more work, you could also use your system, rigging a small cup/holder to the second board and see how much weight it can support before breaking (so instead of pulling up, let gravity pull down) – your metric would be the number of pennies (or other small weights) the gum can hold before breaking.

You could also test more types of gum (e.g. different brands of each type) or if you can somehow get an estimate of sugar content you could compare “stickiness” vs. sugar content.

KimberMy child is preparing for a science fair project – wants to know does different types of paint affect the drying time of the paint? The indepentent variable being the different types of paint. We have identified the level of dryness as the dependent variable though we are stuck on how to measure & then graph using quantitative measures since it is more qualitative. We identified a nonstandard measuring tool as a rubber glove with identifying 3 different levels of dryness (adjectives- wet, dry and tacky) by applying finger- touch pressure. We are not convinced this is correct- even though part of the experiment will be to test in certain, set increments of time & record the level of dryness. Would the time increments be the dependent variable instead of the level of dryness? Please offer any thoughts on this and graphing suggestions. I believe the x axis is to show the independent variable (types of paint), but it makes more sense to have the increments of time on the x axis and level of dryness (dependent variable) on y-axis & the graph show the different types of paint. Thoughts?

Dr. Maille LyonsEvery time you “touch” mark the time. Best if you “touch” at regular intervals of time (e.g. every minute, every 5 minutes, etc. whatever you feel will capture differences) – make sure you touch different parts of the flat object to be painted. I recommend painting something long and skinny (e.g. 2 by 4 piece of wood) so that you can systematically touch it and keep track of wet and tacky and dry. Take photos of the rubber glove to show the difference between tacky (some paint) and dry (no paint on glove).

Then your dependent variable is level of dryness, measured as the time it takes to stop being tacky (quantitative).

You will be able to make a bar graph with the type of paint on the x-axis and the average time to dry (as measured by touching) on the y-axis (because you should have at least 3 painted objects for each type of paint).

You will also be able to make a data table with time across top (columns) and type of paint as rows with “wet” or “tacky” or “dry” in each corresponding box. If you touch systematically along a 2×4 then you should also have great matching photos.

Data could look something like:

Type 1: wet, wet, wet, tacky, tacky, dry

Type 2: wet, tacky, tacky, tacky, tacky, dry

Type 3: wet, wet, wet, wet, tacky, dry,

You will not be able to make a line graph because “wet/tacky/dry” are not quantitative, but you have outlined a creative way to answer the question.

Dawne SheffieldMy son is making a crystal radio for a science experiment and is just testing whether it works or not. So it is yes or no results, how should this be graphed. What would the independent and dependent variable be ?

Dr. Maille LyonsThis sounds more like a project and less like an experiment… There do not really appear to be any independent and dependent variables. Perhaps if you add more details – did he ask a question? did he test any particular aspects of the building? did he try different crystals?

Kim SprouseMy daughter is doing an experiment on Bubble gum – Which graph would I use? She needs to show which one lost is color the fastest on Trials 1-10 and we used grape, strawberry and sour apple – Thanks!

Dr. Maille LyonsBar Graph! Sounds like you measured “time” as your dependent variable, so would go on the y-axis (average of ten trials); and “Type of Gum” or “Gum Flavor” would go on the x-axis, then label each bar accordingly (grape, strawberry or sour apple). I would couple this with a data table to clearly indicate you did 10 trials for each flavor. Or you could make an individual bar graph for each flavor, with time on the y-axis and trial number on the x-axis, showing 10 bars. This would be an indication of how variable your method of determining when the color was lost was. Good Luck.

sarahMy son is doing an experiment on erosion,he needs to find the results and is wondering if a pie chart would work best,he put a plant and soil in one pan,the other sand,and another soil.Which one should he use?Thanks!

Dr. Maille LyonsWhat did he measure? From the details provided, I would generally recommend a bar graph with each “treatment” on the x-axis (i.e. each condition he tested) and whatever was measured on the y-axis (hopefully a number of some sort).

A pie chart is more for percentages – for example % yes vs. % no to a particular question; Or the % of people that picked a certain color; etc.

Ashley FordMy son is doing a science fair project how many pennies does it take to sink a boat made out of aluminum foil what would are graph be

Dr. Maille LyonsThat’s not really a science fair project unless you made several boats with something changed for each one (e.g. size, shape, material made out of). Then you would make a bar graph with type of boat on the x-axis and the number of pennies need to sink on the y-axis.

emilywhat website could we use to make a bar graph online

Dr. Maille LyonsGoogle “create a graph” and this should be one of the top hits:

http://nces.ed.gov/nceskids/createagraph/

It’s user friendly and you can print your graph

RoseHi, my son is doing a science fair project and wanted to see what kind of graph should he use. His project is he tested 6 people to guess 4 flavors of kool aid while blindfolded and see who guessed all correctly. Some only guessed 2 right and so on.

Dr. Maille LyonsHe could do a bar graph with each person on the x-axis and the number of correct guess (or percentage correct) on the y-axis

PATRIQUE LARCOHello:

What kind of graph could I use to display the distribution age by two different treatment groups?

Spinal Cord Simulation vs. Physical Therapy

Sample Size

โขMuch Bigger โขMuch Smaller

Age

โขHigher mean โขLower mean

Age

โขBigger range in population age (4 to 72 years old) โขSmaller range in population range (11 to 59 years old)

Sex

โขClose to 40% and 60% distribution โขClose to 20% to 80% distribution

Duration of disorder

โขHigher mean โขLower mean

Duration of disorder

โขBigger range in population’s duration โขSmaller range in population’s duration

Dr. Maille LyonsIt’s not clear from the question what you measured… But if you have two treatment groups, they would usually go on the x-axis of a bar graph with whatever you measured (a number) on the y-axis to show how they compare. For example, if I had coffee drinkers vs. soda drinkers and I measure average height, I would make a bar graph with 1 bar for coffee drinkers and 1 bar for soda drinkers and then each bar would be the average height (height on y-axis).

But from your groupings, I am not convinced that is what you have for data…

If the two treatments were: Spinal Cord Simulation vs. Physical Therapy, then these would go on the x-axis and you would have 1 bar for each. Your y-axis could be age (1 bar each to show which treatment had older/younger subjects).

Usually if you are interested in age distribution, you would make categories (for example group the data by year-class of 5 or 10 year intervals) and then graph the thing you want to show (maybe the number of subjects that use physical therapy?) for each age class. If you did one color bar for physical therapy and a different color bar for spinal cord simulation then you may be able to show there is a difference in the typical ages of who prefers which treatment…

Hope that helps! If not, re-phrase you question or be more specific on the data you have.

PATRIQUE LARCOThank you that’s perfect. I really wanted to see what kind of graph(s) could be used to display the distribution of age by treatment group?

I think you’ve made it clear for me.

jacob pelletierim doing a progect with heavy and light paper airplanes. what graph do i use?

Dr. Maille LyonsA bar graph with two categories on the x-axis (horizontal one) – Light and Heavy; then whatever you measured (distance?) on the y-axis (vertical one). Don’t forget to label both!!

jacob pelletierthanks

CynthiaMy sister is doing a science fair project on will sunlight outside or inside affect the growth of a plant. What type of graph can she use

Dr. Maille LyonsBar graph: “Inside” and “Outside” are the independent variables (x-axis) with whatever was measured (size? # of leaves? height? etc.) on y-axis.

VickiHi Thank you for all the information available. It’s very helpful. My daughter is doing a project where she applies a treatment to a rose petal to see the results. The treatment is water, vitamin E, and “air.” The objective is to determine the impact that vitamin E has on the appearance of skin where the petal represents the skin. We are not sure what to graph. She plans to run the experiment over 10 days and repeat it 5 times. We were thinking time on the x-axis and color on the y-axis and have a line graph for water, vitamin E and air. Do you think this is the best representation? How would she show that she repeated the experiment?

Dr. Maille LyonsWhat is she actually measuring? That is the dependent variable and goes on the y-axis – it must be quantitative (not just “color”). It could be “time to first signs of losing color” or it could be “percent of petal with a color change” or something else (even percent change compared to the control), but it must be associated with a number.

One independent variable is the treatment, so you could make a bar graph with treatment on the x-axis (water, vitamin E, and air) and a final outcome on the y-axis (one bar each, or one bar for each time she repeated the experiment).

You can only make a line graph with time on the x-axis if you have quantitative dependent variable that changes with respect to time (e.g. percent of pedal with color loss); then you can have a line for each treatment. Same as above, there can be a line for each time she repeated it or she can present the trials (hopefully at least 3?) in a data table, then graph just the average as the line.

VickiThank you so much Dr. Lyons! Very helpful!

omeldaMy son is doing a project on Roots – how do different types of soils affect the ability of roots to anchor plants what should he do. please help

Dr. Maille LyonsSo your independent variable is “type of soil”, that’s what he is changing. The dependent variable must be quantitative (i.e. result in a number) – so how will he measure “ability of roots to anchor plants”? This is what he needs to figure out. How can this be measured? How can this be estimated?

omeldathank you so much

omeldaso sorry for asking but how would he measure it he the doesn’t understand it

Dr. Maille LyonsThat will be his choice for the design. I don’t know how to measure that “ability”, perhaps he should try something easier – like root length or number of new roots?

milliCan any body please tell me which graph would be best for my daughter to use if she is doing how much of a temperature increase would occur when testing several different foods?

thanks

Dr. Maille LyonsWhat exactly is she “testing” ??

From the limited information, it sounds like a bar graph with the type of food on the x-axis and temperature on the y-axis

MaiHello

My daughter is doing a science experiment in heat insulation.

She is comparing commercial and natural materials, she had done 6 trials. What is the best graph to describe her results. Plotting it on a line graph sincethe data was recorded over a period of time. Or a bar graph of the average of temperature of the 6 trials. Thank you

Dr. Maille LyonsIt’s hard to say without more information.

If she is interested in which material insulated something “better” then a bar graph with the type of material on the x-axis and the average of whatever “measurement” of “better” on the y-axis would show that.

If she is interested in which material insulated something “longer” then a line graph with time on the x-axis and whatever was measured on the y-axis (with the average of each of the materials graphed in a different color) would show that.

If she is interested in which material was “more consistent” then graphing all six trials for each material would show that.

StephanMy daughter is doing a science project on which color feeder a blue jay would like best…What graph does she use? Please Help!

Dr. Maille LyonsBar Graph: Put color on the x-axis and whatever she measured as “best” on the y-axis

LourynHi I did a science fair project to see when a apple goes brown on what day each day we wrote down what it looked like whould I be able to do a graph and wich one should I use.

Yours sincerly Louryn

Dr. Maille LyonsYou could graph days until browning on y-axis and whatever you tried to keep the apple from browning on the x-axis – probably a bar graph.

CourtneyMy 4th grade daughter is completing her science fair project tonight on density. She has corn syrup, vegetable oil, maple syrup, water, and dish soap that she poured into a glass. Each trial was done in a different order to see if the corn syrup had the most density. How would she graph this? No time was documented. The variable was the order the liquids were poured.

Thanks for your help.

Dr. Maille LyonsSince the dependent variable (order) really isn’t quantitative… you can’t graph this. Her best bet will be to use pictures/drawings to show the order of liquids poured vs. the order of liquids layered in the glass. If she observed that corn syrup layered on the bottom, regardless of when it was poured in — then she could conclude it was the most dense of the liquids evaluated.

KayleighMy brother is doing a science fair project on which candle melts the fastest and I wasn’t sure what graph to use because there are 5 candles.

Dr. Maille LyonsBar graph with each type of candle on the x-axis and time on the y-axis

kurtasWe are confused how to make an accurate graph. The project was which materials clean up oil the best. The conclusion was based off of visual observations. How do you put an amount or percentage to this and then form a graph?

Dr. Maille LyonsWhat did you measure as “best” – if it is a number then it would go on the y-axis and the type of material would go on the x-axis (bar graph, one bar per material type).

If you just looked and decided which one looked like it removed the most, but didn’t actually measure anything … then you can’t make a graph. Instead make a table with the observations in it.

JammieWe are doing a project on what water filter works best. Using sediments. How could we graph this?

Dr. Maille LyonsHow are you measuring “best”? You will need a number… water clarity? light transmission? weight of solids removed? etc.

That will go on the y-axis; with type of water filter on the x-axis (bar graph)

JacquieWorking on a water, salt, egg floatation experiment. I charted the time I finished dissolving the salt, how many tablespoons were in the water at the time and of course, the state of the egg at that time. My question, is there some time of graph I could make to represent these findings? What information should go on which axis?

Thank you so much!

Dr. Maille LyonsProbably a bar graph… with “Amount of Salt” on the x-axis and whatever you measured as the “state of the egg” on the y-axis. If you did not measure anything (just made observations about how it looked? or yes/no for floating?) then you don’t have the data to make a graph, but you could present your results in a Table.

EssiHello my daughter is doing her project on home made snow but I am not sure what graph I can use?

Dr. Maille LyonsIt depends on what she actually did… In general, what was measured goes on the y-axis and what was changed goes on the x-axis. Bar graph if the “thing” on the x-axis is a category; Line graph if it is quantitative (e.g. time, temperature, distance, etc.).

JackieHello my son is doing a science fair project on how well vinegar and water cleans tile when ketchup, mud, honey, crayon, jelly get on it. I am stumped on what type of graph to use and how to set it up. Thanks

Dr. Maille LyonsIt would be a clustered bar graph with two different colored bars, one for vinegar and one for water, for each “stain” tested (ketchup, mud, honey, crayon, jelly) across the x-axis. Alternatively, you could do two bar graphs, one for water and one for vinegar and display them side by side.

What ever you measured as “how well it cleans” must be a number and will go on the y-axis.

RikkiI need help to know how to describe how you would draw a graph to compare the different temperature requirements for various bacteria.

Dr. Maille LyonsEither a bar graph with temperature on the y-axis and type of bacteria on the x-axis;

Or

Line graph with temperature on the x-axis and some measure of growth for each type of bacteria on the y-axis.

Sasha p.I did a project on the affects of putting a glow stick in a different environment like to see how long it would glow,any changes in it etc. What kind of graph should I use?

Dr. Maille LyonsBar graph: Environment on x-axis; time (how long it glowed) on y-axis

FYI: Your project was on the EFFECTS (not affects) of putting ….

RitaMy son is doing a project on can sound travel on string by making plastic cup telephones with 3 different types of strings of cotton ,metal n nylon.can I show that on chart or graph or tables or anything else

Dr. Maille LyonsIs the answer yes/no? or good/better/best? A table will be his best means of presenting the results.

If he is measuring something (so more than just yes or no answer or more than ranking), then you could make a bar graph with type of string on the x-axis and whatever was measured on the y-axis.

Sydney CorbettSo, my hypothesis for my science experiment is that dogs best respond to dog treats, not verbal praise. How should I graph my data for a x axis and y axis chart?

Dr. Maille LyonsWhat did you measure?

zuzaizaithank you a lot I will use these content to teach my student who gonna be a good scientist in future as soon as has this nice website.. thank you

AmyMy sons project is on the effects sugar has on teeth. We put 6 baby teeth in a container of different kinds of soda and watched the amount of decay. We also measured the phone level in each soda and are making a bar graph with that information. We need on more graph or chart.

Dr. Maille LyonsYou could make a BAR GRAPH: The different kinds of soda will go on the x-axis and whatever you measured will go on the y-axis.

You might be able to make a Line graph with time on x-axis and whatever you measured on y-axis, one line per type of soda

Melissa SkirpanMy son is seeing if a red eared slider turtle can recognize color. He is food training the turtle in front of the color red for one week. He will then change the position of the color red with three other colors. Four instance the color position could be red, blue, green, and yellow. We will then see if the turtle will go to the color red when we change the position of the red in the order on each night. This will be measured by which color zone he goes to first. We are struggling with independent and D pendant variable’s and then how to graph this. Any advice?

Dr. Maille LyonsFirst, remember the turtles have backbones so make sure you have school permission to do the experiment.

If you do, then your independent variable (the thing you change) is color; your dependent variable is the thing you measure. It should be quantitative – so a number. Maybe time it takes to go to the red? Maybe time it take to go to each color? Maybe percentage of time turtle goes to red? If it is just yes or no, then you will not be able to construct a graph. If it is something measurable then color goes on the x-axis and whatever you measure goes on the y-axis (bar graph)

Patty LavanMy son is working on an experiment measuring grafitti/paint removal–utilizing 4 different surfaces— metal, vinyl (siding), brick (stone ), and wood and 4 different cleaning agents. What graph would be best to use to shoe results?

Dr. Maille LyonsThe only graph he can properly make is a bar graph.

ONE option: He could put surface on the x-axis and whatever he measures on the y-axis with a different colored bar for teach cleaning agent AND/OR another option would be that he could put cleaning agent on the x-axis and whatever he measured on the y-axis and a different colored bar for each surface.

Make sure what he measures is quantitative (i.e. a number) – maybe percent taken off? or even the amount of time it takes to get it all off? or some other number. Take photos for the display – but to make a graph it has to be more than “better/best” or “more/less” or other adjectives

Bharti VermaHi Dear, my son is in grade 5th. as his science project, he is planning to do “how to make simple motor” by using copper wire, d battery, needles and magnets, but not sure how to display that in graphs.. pls. advice.

Dr. Maille LyonsSo… this sounds more like an engineering project than a science experiment. Did he “experiment” with any of the components? For example, type of wire, amount of wire, type of magnets, number of magnets, etc. If yes, then he could put that on the x-axis as the independent variable that he “changed”. He would need to measure something more than yes/no for worked or didn’t work for a dependent variable which would then go on the y-axis for a bar graph of results.

Bharti vermathanks for getting back, how will he show this in line graph?

Dr. Maille LyonsThe only way he can make a line graph is if the independent variable is continuous, for example, time or temperature. Otherwise, it will be a bar graph.

Bharti Vermaso,in this case his independent variable will be i guess, spinning time and dependent variable could be the shape of wire, round of wire i guess. i hope i am on the right track?

Dr. Maille LyonsAlmost – You have them flipped. The independent variable is the one that is manipulated by the researcher – so in this case, the shape of the wire, type of wire, gauge, etc. and the dependent variable is the one that is measured, so in this case spinning time. Still looks like he’ll be making a bar graph, not a line graph.

MeganHow do you make a bar graph of which brand of glue has the strongest bond? Because this is for my experiment and I am having a major problem!! I don’t undersand how to plan this??!

MeganI’m doing this with the three different brands of glue, to test the strongest bond at 20mins. What do you suggest?

Dr. Maille LyonsThe bar graph would have the brand of glue on the x-axis (horizontal one) and whatever you measured as “strong” on the y-axis (vertical one).

How did you measure which one was the “strongest”? If it is quantitative (a number) you are all set; but if it was not … if it was qualitative (an adjective) you can not make a graph. You will just have to rank them, so use a table instead.

SallyI tested whether the temperature of water would affect the speed of a tablets reaction and I don’t know whether to use a bar graph or line graph?

Dr. Maille LyonsSince temperature is a continuous variable, you can correctly do either one. I would recommend:

If you did 2 to 5 temperatures (OR if the temperatures were relative measures: cold, room, hot, etc.), then do a bar graph.

If you did 5 or more temperatures AND the temperatures were measured with a thermometer, so you have a real number; then do a line graph

JulieMy daughter is doing a science project on which stain remover is the best at getting out stains, what kind of graph would she use.

Dr. Maille LyonsIt will depend on what she measured. How did she determine which was “best”? If it was anything quantitative (a number) then she will most likely make a bar graph (stain remover on x-axis; whatever was measured on the y-axis). If it was just a visual observation, then she can not make a graph. She should present her results in a table.

AriHi, I’m doing an experiment on how direction of gravity effects root growth.

I’m not sure what graph I should use, as I have not measured the lengths until the very last day. I have around 20 radish roots. thank you!!

Dr. Maille LyonsMost likely you should make a bar graph with direction on the x-axis and root length (or number or whatever) on the y-axis. It would have been better to measure more often because then you could have made line graphs for each direction; but it’s fine. Just make the bar graph to show the final results

RubyHello, my son is doing a science project on the effect certain drinks have on our teeth over time. Pretty much we soaked egg shells in different beverages and will watch the eggs throughout the next few days. I was thinking about doing a graph on how the egg shells change color (representing tooth decay), but was not sure what graph or chart to use. Can you please let me know what would be best for this?

Dr. Maille LyonsHi – in order to do a graph he has to measure something that is in numbers (e.g. time, weight, length, speed, etc.). If it is just observations (this one is darker than that one) then there is no graph.

He might be able to measure time to first signs of discoloration, if the observations are drastic enough. He might also be able to measure percent change in color if the shell does not discolor all at the same rate… although this will be tough on a curved shell.

The best way to present the observations will be a table, with descriptions in the boxes for each drink type on each day (or at the end)

RubyThank you for your quick response. So, let’s say we measure time to show signs of discoloration. Assuming time would represent the days, I’m not sure exactly how it should look. So, a bar graph or several bar graphs? My vertical axis would be the time (days) and my horizontal axis would be the different beverages. Would that be correct?

Also, just to verify is the following correct:

independent variable – different beveraes

dependent variable – shades of discoloration

costant variable – eggs??

Again, thank you for your assistance! ๐

Dr. Maille LyonsMost likely, you will have one bar graph with beverages on the x-axis and the number of days until discoloration started on the y-axis.

independent: different beverages

dependent: time it takes to start to see a change

constants: size of egg shells, type of egg shells, temperature, volume of liquid

Control… probably water

LizzyMy project involves color change. How does Clorox affect a plant’s life span? So which graph should I use or can my experiment not be graphed?

Dr. Maille LyonsIt all comes down to what you measured. If you measured anything that is a number – for example, time to see first signs of a color change or percent of the leaf that changes color, then make a bar graph with that number on the y-axis and treatment on the x axis with bars for control and Clorox. If your result is yes or no… then you will not have anything to graph. Present the answer in a table or as a statement.

Rebecca ForthesMy 11 year old son is doing density of liquid layers… He thinks these are the correct variables…

Constant variable- Volume of each sample of liquid (100ml)

Independent Variable- Type of liquid used

Dependent Variable- the different masses and densities the samples of liquids had, that varied depending on which liquid was being used.

Can you guide us on how to make a chart or graph??

WhAT WOULD BE THE EXPERIMENTAL GROUP???

Dr. Maille LyonsThis sounds a bit more like a demonstration than an experiment.

Did he measure the density and/or masses of the liquids? – if not, then that is not the dependent variable.

You can’t graph anything until you figure out what to measure… time to layer? height at which it layered? etc. It has to be something measured with a number. Then that number goes on the y-axis. The liquids will go on the x-axis and it would be a bar graph.

The experimental group is the trial in which you change something…. here again, since this is a demonstration… it’s a bit hard to name the experimental group. You could call water the control group and each other liquid an experimental group – some will be positive and some will be negative, but that’s ok. The positive ones are lighter than water, negative ones are heavier than water.

Rebecca ForthesAlso, what the control group would be??

Dr. Maille LyonsMost likely – water

DianeHow do you graph a candle illusion. My son’s project is due this Monday & I’m lost trying to figure this out.

Dr. Maille LyonsWithout more details this is a hard question to answer… I don’t quite understand what his project was.

But, Generally if he did an experiment (not just a demonstration) then whatever he measured goes on the y-axis (vertical one) and whatever he changed to see if it had an impact on the result goes on the x-axis (horizontal). The control is what was not changed, or the “normal” or “ordinary” or “regular” condition; with the change being the actual experiment.

For example, if he manipulated … the light source? the distance from the light? etc. That’d be on your x-axis and if he measured… size of the illusion? that would go on the y-axis; it would be a bar graph

Rebecca ForthesThank you… The “problem” he states was :

Does liquid’s density affect how they react with each other and objects place in them?

Hypothesis:

If water, oil and honey are placed together in the same cup, then their difference in density will cause them to separate in different layers and objects will fall in different places,,,

What will the experimental and control group be?

And the dependent, independent and controlled variables be?

Dr. Maille LyonsSo… it still sounds like a demonstration…. there is no control and there is no dependent variable because he is not measuring anything…

How about: How do the characteristics of an object affect the object’s buoyancy?

Set up the layered honey, water, oil. For each object, measure its size (length? circumference? etc.) and its weight (should be able to use a kitchen food scale).

Look for as many objects as you can, so that you have some that are the same size, but weigh different amounts and some that weigh the same, but are of different sizes.

CHANGE the object (this is the independent variable): coins, marbles, nuts, bolts, grapes, almonds, washers, safety pin, etc.

MEASURE: the height at which it “floats” within the three layers (tape a ruler to the container with the fluids; this is the dependent variable).

Analyze: Was it size or weight that better matched where the objects layered in the fluids? Make line graphs with size (1) and weight (2) on the x-axis and height object stayed at in the fluid on the y-axis. Is there a pattern in the data (straight line? curved line? no line?); why or why not ??

Control variables are the three liquids, temperature, etc. Everything that doesn’t change between dropping each object into the layered fluid.

The control is the smallest object for size and the lightest object for weight. Then as the size/weight of an object is increased… the object will float (higher/lower/stay the same – PICK ONE for the hypothesis).

Rebecca ForthesWow!!! Thank You!!!

You rock!! Keep up the good work!

Jill LewisHi I am doing a science fair project on how rust forms. I have four jars each under different circumstances such as calcium chloride or vinegar. I am not sure which kind of graph to use for this sort of information. 2 of the 4 jars formed rust by the way.

Dr. Maille LyonsWhat are you measuring? Presence or absence of rust? Then your dependent variable is not quantitative (i.e. not a number) so there is no graph you can make. Are there more than one “thing” in each jar? Maybe you can measure the number of them that rusted… but if it’s all or nothing in each jar, then you still don’t really have a graph to make.

If you measured something (maybe % rusted or time to first signs of rust?) – that number would go on the y-axis and whatever is in the jars would go on the x-axis; it would be a bar graph

Angelica B SanchezAre there any graph websites that you would recommend

Dr. Maille Lyonshttps://nces.ed.gov/nceskids/createagraph/

Nicole obrienDoing a project on the milk and dish soap experiment where you put food coloring milk(fat free,2%,whole) then add dish soap to watch it swirl. Can’t figure out what type of chart/graph to do!! Please help!!

Dr. Maille LyonsIt will be a bar graph. Put the type of milk on the x-axis and whatever you measured on the y-axis.

Kashima L.Hello! My daughter is doing a project in which she is growing bacteria samples from common objects and growing them in agar plates. Half of the plates have been swabbed in bacteria and the other half has an anti-bacterial agent spread on it to see if it will inhibit the spread of the bacteria. What type of graph if any can she use and what would be the appropriate way to label it. Thank you very much for your time!!!

Dr. Maille LyonsWhat did she actually measure?

Sounds like she has yes/no type data (either bacteria there or not there?) – in which case she does not have data to graph. Graphing requires a quantitative dependent variable such as, the number of colonies, or time to first growth, etc. Something with a number.

Was the antibacterial agent put on the agar plates? or on the common objects? Sounds like, at best, she has a yes or no as to whether or not the antibacterial agent prevented bacterial growth after transfer – regardless of the object. Was that her question/project?

Kashima L.Hi Dr. Lyons,

Her question was two parts. First, to see which objects swabbed contained the most bacteria (colonies grown). Second, to see if the colonies were kept from spreading over to the anti-bacterial side of the dish.

Dr. Maille LyonsOK – then she can make a bar graph with the items tested on the x-axis and the number of colonies on the y-axis. She could have two bars per item – one for the agar and one for the agar plus antibacterial.

Kashima L.THANK YOU !! I really appreciate your time in helping us with our graphing. I am a homeschooling mom who is trying to make sure that our daughter has a good science and math background. She is super excited to finish her science fair project!!

SamI need to prepare a lab report on how air has mass and weight. I decided to weigh 2 balloons on a hanger(one inflated and one deflated) and the one that is inflated goes down, which will prove that air has weight. But I don’t understand how to record this into a graph or form a proper hypothesis.

Dr. Maille LyonsNot really sure… but you might try:

Hypothesis: If air has weight, then a balloon full of air will weigh more than an empty balloon and larger balloons will weigh more than smaller balloons.

Experiment: Add air to one balloon, no air to another and observed which balloon is heavier. Repeat three times. Better if you have same sized balloons filled to different sizes.

Data: really yes/no or which balloon tips the hanger down. But better is quantitative, so maybe if you use three balloons filled to different sizes (use same size balloon but measure the circumference of the balloon) and time how fast or to what angle the hanger dips.

Graph: size of the balloon vs. time or angle

SamThank you so much! This was really helpful!

RhaynI’m doing a biology project on “What effect will adding soap to water have on surface tension?” what type of graph would you recommend?

Dr. Maille LyonsBar graph with: soap and no soap (your control) on x-axis and what ever you measured on y-axis

V.S.My project is on how a growth mindset score is affected by feedback given by a game. What graph/s should I use?

V.S.Actually, how different types of feedback affects mindset assessment scores

Dr. Maille LyonsMost likely will be a bar graph…

The metric for mindset score (hopefully a number) goes on the y-axis

The different types of feedback (does not have to be a number, can be a category) goes on x-axis

V.S.Thank you!

SherylHello, my daughter is doing flipping bottels with density. What kind of graph would you recommend to measure the density? Would you recommend to use two different graphs for flipping and measurement?

Dr. Maille LyonsProbably a bar graph…

BUT – What is she measuring? – that would go on y-axis; whatever she “changed” goes on the x-axis

JoselineHello, my daughter is doing a project on which drinks stain your teeth enamel the most. She is using a hollowed out eggshell to put in each of the 5 drinks( soda, tea, lemonade, water, and coffee.) Her hypothesis is,I think that soda will cause the most discoloration to the teeth enamel because of the dark pigment in it.

Which graph would you recommend and how would you recommend to set it up.

Dr. Maille LyonsShe should be measuring something so that she has a quantitative dependent variable – she needs a number. That number would go on the y-axis. The type of drink would go on the x-axis and it would be a bar graph.

If she is not measuring anything – i.e. she will just rank them… then there is no data to graph. Her results will be a rank order (no graph)

Lori HilfertyHelp! My daughter has done her science project on growing crystals. Borax and water. 4 different temperatures. What type of graph would work best. Line graph? Regards!

Dr. Maille LyonsA bar graph would be better. Put the 4 temperatures as categories on the x-axis in increasing order from coldest to warmest. Put whatever was measured on the y-axis: time to see growth? maximum size attained? it must be a number not an adjective (like clarity or color etc).

Looking at the graph, she should be able to answer: As temperature increases… what happens to the growth of the crystals?

Hudson ChrisMy daughter is doing a project involving soaking gummy bears in water and in salty and sugary water. What type of graph should she use?

By the way, this was really helpful.

Dr. Maille LyonsBar graph, with type of water on the x-axis and whatever she measured on the y-axis… I would guess… time to dissolve??

TommieMy science project is on how different types of disposable diapers will change the moisture level

In potted plant soil and keep the potting soil from drying out. How to graph my result after 4 trials and watering every week. I used water crystals as my control.

Dr. Maille LyonsHow did you measure moisture level? That will go on the y-axis. Type of diaper will go on the x-axis. You could make a bar graph.

If you measured levels over time, you could also make a bar graph with time on x-axis, moisture on y-axis and a different line for each type of diaper.

imogenthanks this give me my science test answers

CynthiaHello..my daughter is doing a science project on which type of water will produce the most growth in a spider plants..which graph is more appropriate..she did not measure the plant length..should she…

Thank you

ZOE

Dr. Maille LyonsMost likely a bar graph with type of water on the x-axis and whatever she did measure on the y-axis.

CynthiaThank you Dr Lyons. .we did not measure the actual length of the plant but know which grew the most..do we need a number on the y axis

Dr. Maille LyonsYes – in order to make a graph, she needs a measurement. If you have photos of the plants (or still have the plants), you might be able to get a measurement from the pictures. Otherwise, she could make a table, reporting which type of water resulted in the most growth.

CynthiaVery helpful..thanks again!

mikiMy son did a chromatography experiment using permanent black marker, washable black marker, red skittles, red M&Ms, red Nerds candy, and red dye. The mobile phase for the black markers was a combination of isopropyl alcohol and water. He used salt water for the mobile phase for the red candy and dye. He calculated the retention factor value for each component, and also calculated an average retention factor value. What type of graph do you think he should use to display this information? Thank you.

Dr. Maille LyonsNeeds to be a bar graph with all the stuff he tested on the x-axis and retention factor value on y-axis. Perhaps grouped by the solvent (alcohol vs. salt water) into two separate graphs.

jenMy DD did an experiment removing one ingredient in a cupcake recipe. She ran the experiment 6 times, each time eliminating a new ingredient. How would i chart the effects each ingredient had on cooked cupcake

Dr. Maille LyonsWhat did she measure? – that goes on y-axis; on the x-axis would be a description of what was still in the cupcake. If she did not measure anything (i.e. she has no “numbers”) then the best you can do is present photos or words to describe the cupcake.

YinHello my son is doing: HOW DOES COLOR AFFECT TEMPERATURE?

HYPOTESIS: if dark and light color get tested for how they affect temperature, then dark colors will raise the temperature the most and quicker.

MATERIALS: * pair of white socks

* black dye

What is independent variable, dependent variable and controlled in this case?

Should he use graph? Which one?

Dr. Maille LyonsThe independent variable is the one that is manipulated, in this case color.

The dependent variable is the one that is measured, in this case temperature.

The controlled variables are everything that stayed the same: sock, time, etc.

He will use a bar graph with temperature on the y-axis and color on the x-axis

YinThank you so much for your help. You are ablessing to us. Thank you

EllaHi! I’m doing a science fair project and I need a graph for my presentation. I’m not really sure what type of graph to use though. It is behavioral science and is about how caffeine affects the body. I had ten people go off of coffee for four days and answer two surveys about how their body/mind during experiment. They filled out one before the experiment and one after the experiment so I could compare results. The problem is that I was testing two group to see how the side affects would differ, five heavy coffee drinkers and five light coffee drinkers. So I don’t know what type of graph to use. If you could get back to me, great and thank you!

Dr. Maille LyonsYou could probably make a bar graph with your groups on the x-axis and the score on any given survey question, providing there were numbers for answers? You might be able to compile the scores and compare a sum total before and after for each of the two groups. It’s hard to answer without more information on what the survey was.

Superstar901I have to think of 2 or 3 controlled experiment ideas that use line graphs, NOT bar graphs plz help!!!!!!!!

Dr. Maille LyonsIn order to make a line graph, both the dependent and independent variables need to be quantitative (i.e. something measured with a number, not a category). For example: time, temperature, distance, size, concentration, etc.

So: what is the effect of temperature on concentration?; or How does size vary over time? etc.

Jamie-LeahHello I am trying to do a bar graph for a science expo I am doing it on cleaning coins

what I am doing is cleaning the coins with coke, salt and vinegar, lemon, water

so I will place one coin into 4 separate bowls and put the liquid in each bowl first for 10 minutes then 20minutes then 30 minutes and I want to do it in a bar graph but I don’t know how to please get back urgently…thank you ๐

Dr. Maille LyonsIn order to make a bar graph you have to have a quantitative dependent variable … that means you have to measure something with a number. So you will need to figure out a way to measure the amount or level or degree of “cleaning” that each liquid does. That number would go on the y-axis; with the liquid type on the x-axis. But, if there is no number generated then there can be no graph. Use photos instead.

NellyHi I need some advise what kind of chart would you recommend if for my project I did how big of an impact does the sun have on plants basically I planted a flower but I did planted four and placed them in different places in my house and i measured each plant each day to see how tall they grew with or without the sun and I am to turn it in to a chart and I don’t know which kind of chart to use or how to organize it can you please help me out? Please answer as soon as possible thank you for your time.

Dr. Maille LyonsYou can make a bar graph with “place in your house” (maybe: North, South, East, West ???) on the x-axis and Final Size (or height or mass or whatever you measured) on the y-axis (one measurement from the last day). Each “place” would have two bars, one for with sun and one for without.

You can also make a line graph with Day/Time on the x-axis and size (whatever you measured) on the y-axis. Make a different line for each “place” with and without sun.

JesicaMy son is trying to make a graph showing timed trials of an electromagnetic train that he made. He has 3 variables – a battery with 2 magnets on each end, one with 3 and one with 4. He ran each trial 3 times over a fixed length of copper coil. We can’t figure out which type of graph would best for this information.

Dr. Maille LyonsFrom the description, it sounds like he only has one independent variable (i.e. the number of magnets on each end) and one dependent variable (speed? or time?).

If that’s the case, he should make a bar graph with number of magnets on the x-axis (2, 3 and 4 – one bar each) and time (or speed which is distance/time) on the y-axis.

loriMy son is doing an experiment on the various sound vibrations – “Can sound vibrations move objects” i believe the bar graph is best as it is in various sound types. What do you think?

Dr. Maille LyonsProbably… it would be sound type on the x-axis and whatever you measured (not just yes and no) on the y-axis. If the answers are yes/no (i.e. did the sound move the object or not) then he will not have data for a graph so present the results in a table.

MadisonI’m foing a project on if celery stays fresher in foil or in what it came in but I need a graph for it but I don’t know what graph I need to do.. please help!! It’s all do this Wednesday.

Dr. Maille LyonsIt would be a bar graph with foil or original package on the x-axis and whatever your measure of “freshness” was on the y-axis. If you don’t have a number for “freshness” you can not make a graph. Present the results as photos or in a table as words describing the outcome.

MariameHello, my project is on whether or not adding banana peels or eggshells as a fertilizer to the soil of a pea plant would promote the growth of the plant the most, which type of graph should I use?

Dr. Maille LyonsMost likely a bar graph with treatment (peels vs. shells) on the x-axis and some measure of growth (height – maybe?) on the y-axis. Depending on how often you measured the plants you could make a line graph with time on the x-axis and growth on the y-axis with 1 line for peels and 1 line for shells.

Sara HeckmanI’m doing the science fair project and I’m doing what gets a sharpie mark you the best what kind of graph should I use I have 3 different object that I’m using to see if it gets the mark out

Dr. Maille LyonsMost likely a bar graph, IF you have a quantitative way to measure “gets the mark out”; otherwise, you can not make a graph – so use pictures and a table

Mark68Hi, do you allow guest posting on science-fair-coach.com ? ๐ Please let me know on my email

Dr. Maille Lyonsyes – but I review the post before posting What topic were you considering?

Fernanda M TedescoMy son is doing a quick home experiment to show he can follow the scientific process. It’s supposed to be done with materials around the house, so he decided to do something with our dog and what is her favorite food(we joke we cannot even say the word CHICKEN that she goes crazy!).

Anyway, he needs to create a data chart AND graph to collect AND display results.

Can you give us suggestions, please?

Thank you!

I love your website, by the way!!

Dr. Maille LyonsIt’s tough to do projects with animals and most schools have banned them – so check first with the teacher.

I would recommend a popcorn project (I have several listed) which would be all stuff from around the house (popcorn and a microwave).

But if he is set on a project with the dog… He would need to set up several “trials” where the dog is offered two choices – probably a bowl with dog food (the control) and a bowl with dog food and different foods, for example, chicken, beef, veggies, and fruit (experiment).

He could count the choices and measure the time it takes for the choice to be made. The data chart would be the number of times the dog chooses each item. To make a graph he could graph the average time for each choice.

GraceI had a lab testing who’s the fastest out of four people and they ran 15m each and were timed at 5m increments ( 0-5m, 5-10m, 10-15m). We also did two trials. How would you graph this? I’m thinking the people are the independent variable and speed is the dependent variable, however if 0-5, 5-10, 10-15 were controlled variables with also the trials, the graph would be too big. What is the correct way to graph this?

Dr. Maille LyonsYou have one dependent variable: speed.

You have two independent variables: person and distance in the increment.

I would put distance on the x-axis and speed on the y-axis. Then make 4 lines, one for each person. This should allow you to quickly see who was fastest in each segment.

Alternatively, you could make 3 different bar graphs with person on the x-axis and speed on the y-axis; making one for each segment/increment.

Shelly GuidryMy daughter is doing a science fair project to see if different liquids cause objects to rust at a different rate. which type of graph should she use?

Dr. Maille LyonsYour best choice will be a bar graph with each liquid listed on the x-axis and the time to rusting on the y-axis.

jazzwhich graph on plant growth based on typees of water

Dr. Maille Lyonsbar graph; type of water on x axis; growth on y axis

JenniferHello,

MY son is doing a science fair project and is experimenting with height predictions. Specifically he is trying to figure out whether the height predictions based on a mother and father’s height are accurate. He has created a survey which asks for the participants height, age, mother’s height, father’s height, gender, and race. As of right now he has over 300 responses and we expect more. What we are having difficulty with right now is how to create a proper chart to show his results in Excel. Could you offer any advice on the best way to do this in Excel or what type of graph and what data points should be included in each graph? Any help you can offer would be greatly appreciated. Thank you, Jennifer and Gavin

Dr. Maille LyonsSo… this really is not an “experiment” and it’s not clear what the hypothesis is/was. It looks more like a math fair project.

What is the height prediction of the person? Is it an average of the mother and father? If yes… then he could calculate what the average should be (i.e. “predicted”) and compare it to what the height actually is (i.e. “calculated”). It would be a bar graph with one bar for predicted and one bar for calculated, with the average height graphed for each. There could be an overall graph and then one for each of the categories also collected. So he could look at what is the overall trend, and does that trend hold for men only, women only, different races, different ages, etc.

Another way to present the data would be to calculate the difference between predicted and calculated for each individual and graph that difference for each category.

Hope that helps.

Dennis LynchDr. Lyons,

My son is finishing the experiment portion of his science fair project where he placed steel bars in 6 solutions (oil, milk, lemon juice, white vineger, salt water and well water) to see which produced the most rust/corrosion). He took pictures every two days to document the process. He doesn’t know how to best Quantify the results to produce the required data charts. His science teacher has been no help. do you have any suggestions on how to quantify this?

Dr. Maille LyonsThe best approach is to get a measurement from the photos.

If he were to overlay a grid on the bar in the photo, he should be able to estimate the percentage of the bar (for both submerged and not so parts) that is “affected” (the smaller the squares within the grid, the more accurate; percent affected would be calculated as the number of squares in the grid showing corrosion divided by the total number of squares in the grid x 100). He should then be able to track the development of the corrosion over time of the experiment – that would be a line graph with time (days) on the x-axis and percent affected on the y-axis and one line for each of the six liquids.

This would answer the question of which was affected most, but will also address which was affected first (might be the same liquid, but might not).

He could also make a bar graph for the data on the final day with type of liquid on the x-axis and final percent affected on the y-axis. It could be a simple bar graph (only the submerged data) or a stacked bar graph also showing the unsubmerged region.

Dennis LynchAs a followup to the previous questions, he was thinking of ranking them from 1-6 from least affected to most affected by Corrosion/Rust. He has two sets of results as well. the second unexpected result was the corrosion that was produced on the portion of the bar not submerged (i.e. both the vinegar and lemon just produced significant amounts of corrosion on the immediate portion of the bar not submerged while the submerged portion remained clean/free of corrosion/rust. Do you think a bar chart with two color bars for each (submerged portion vs un-submerged portion) would work best?

Dr. Maille LyonsI would not recommend ranking – its not quantitative, so mathematically it wouldn’t belong on a graph – even though technically you can because its a number.

JackelynHi Dr. Lyons,

Iโm doing a project on The Effect Of Acid Rain On Seedling Germination. I have four different pH waters

pH:2.17 pH:3 pH:4.04 and a control water and I have four beans in each of these waters. So I have to measure the length of the stems in cm, and see the growth everyday. Iโm having a hard time choosing a graph and I was thinking a Line Graph but I donโt know what to do with each four beans in each of the water?!?

Dr. Maille LyonsI hope you have 4 beans in each of 4 waters (16 total?).

You could make a bar graph with pH on the x-axis (as a category not a number) and maximum length of stems on the y-axis; you would have four bars for each water type or you can average the four beans in each type of water and show the average. Whichever you choose, clearly indicate it is an average of 4 or it is 4 individual beans.

You could make a line graph with time on the x-axis (as a number) and stem length on the y-axis; Average the results for 4 beans each day and make one line for each water type. You could plot one line for each bean, but 16 lines on a graph will be overwhelming.

nicole bushMy son is doing a science fair project on which boat will float better…a styraphom one or one made of legos, all the work is done just not sure which chart or graph should be used and what exactly to list? We have never did a science fair project yet.

Dr. Maille LyonsIt will be a bar graph with each type of boat on the x-axis; the y-axis will be whatever you used to determine which floated better (weight of objects? number of objects? time until sinking?)

zahraahow about a histogram when do u use that

Dr. Maille LyonsWhen you have a continuous independent variable grouped into “bins” – for example, age or height

zahraaok so my project is the effect of mothwash on oral bacteria growth the bacteria i have my dad for the bacteria colony

the control is 104 ,109 ,102 ,136 , 200, 95 ,110 ,122 ,125 ,189 ,108, 115 ,129 ,188 ,157

colgate count: 121, 230 ,158 ,133, 126 ,148 ,177 ,129 ,140 ,146 ,164 ,122 ,107, 98 ,136

Crest count: 93, 67, 77, 115 ,136 ,205, 58, 96 ,73, 80 ,92 ,112 , 157 ,185, 126

how can i put this in a histogram

Dr. Maille LyonsMake a bar graph; average the 15 numbers and graph mean and standard deviation for each condition: control, Colgate, Crest (1 graph, 3 bars)

IF you want to highlight the variability within each condition, you could also make a bar graph with each dish, numbered 1-15 on the x-axis and counts (CFU/ml) on the y-axis; it’s ok to rank them low to high since that will show their distribution and median. You would make 1 bar graph for EACH condition for a total of three additional graphs. If you put 45 bars on one graph it will be too overwhelming.

zahraalike i need three bins but what goes on the x-axis and the y-axis like what exactly do i write

Thanks for your help

Dr. Maille LyonsNo bins. Average all 15 for each condition.

Lindai need a graph to show how dry the plant was in 24 hours

Dr. Maille LyonsHow did you measure “dryness”?

If you have a measurement (a number), it will go on the y-axis with weed killer on the x-axis; it will be a bar graph

If you have an observation (you looked at it and decided how dry it was), you can not make a graph. Use photos and a table to report your observations

AndreaMy daughter did an experiment to show if a flower absorbed cold water faster than warm water by using red and blue food coloring. What would be the best graph for her to use to show this ?

Dr. Maille LyonsSounds like a bar graph with cold and warm water on the x-axis and time on the y-axis

ZahraaHello my teacher wants me to write a paragraph of my results and then an paragraph for analysis and conclusion. so my project is about the effect of mouthwash over oral bacteria so what should i write for my results like should i just state which mouthwash killed the most bacteria. I cant think of anything else to explain in my results. Do u have some guide that i can follow on what i should include and how about my analysis and conclusion isnโt that the same thing as results

Thank you:))

Dr. Maille LyonsGenerally, there is a data/results section with the actual numbers collected. The Analysis is an evaluation of that data (mean, statistics, graphs, comparisons, etc.). The conclusion is whether or not the analysis of the data supports or does not support the hypothesis. Some teachers want an additional evaluation of why that is important or not, etc. to tie it all together.