Basic ABA line graph in excel - How to

This video reviews how to create a basic line graph in excel that meets ABA (applied behaviour analysis) graphing conventions

[@recarderleon9590]

Out of the 15 videos I watched, this one was the least complicated. Thanks for uploading this tutorial!

[@shaylarobertson2379]

Thank you so much for sharing! As someone who is not excel savvy, you have helped me make the basic line graph, I have been trying to figure out for years!!!

[@LawlaLeyshonArchives]

Thanks for this! I have been needing to figure out how to do these properly for ages!

[@maryellenhodge9529]

I'm just learning how to do these. This video was very helpful! I can't wait to watch more of your videos!

[@jessethuku9407]

You explain so well with an outstanding gentleness. Asante.

[@user-sr9gc2fy1z]

This was the easiest video to follow. Thanks so much!

[@katmoore2841]

I cannot tell you how much u just helped me. Thank you so much!

[@DrNO-kr6zm]

I appreciate so much. You are a life saver. I needed this for my thesis.

[@jalissalake564]

Thank you for creating this video. Very helpful!

[@luismelendez5569]

Excellent demonstration!

[@ottiejoseph7109]

Thank you so much for taking the time to do this

[@felipefonoaudiologo]

Thank you so much for sharing, I'm Brazilian and your video helped me a lot

[@magrelladf]

It was so helpful! Thank you for sharing 😊

[@lauraestrada6163]

jenna your a life saver! thank you!!

[@ethantomkins1206]

We need more people like Jenna Bales. If the Avengers were real I have no doubt Jenna would be one of them.

[@PeaceKeeper347]

Great video!!!

[@Jwcounseling]

Hello. I wrote mine down like yours but my line graph did not separate between the spaces. Is there a reason?

[@shalmarhinds2022]

I really enjoy your channel.

[@jennabales2144]

I appreciate that!

[@jennabales2144]

FemmeLifeOrg sorry I got an email with your question but it doesn't show up on this page. Your question: Hi! How do I add the gap between baseline data and the following data? Answer: either adding in a blank horizontal line in between baseline and intervention data OR by disconnecting the line on the data path (double click on the data point to select only that point-->right click -->format data point-->select no line) hope that helps!

[@kayleek9150]

THANK YOU FOR THIS

[@danatahan8344]

thank you so much!

[@jenarose1814]

Same! I wish I could have a tutoring session with you on graping

[@jennabales2144]

Jena I have a pretty crazy schedule but if there’s a specific topic I can try to make a video within a few months!

[@alimal8179]

Thank you so much for your help🙌

[@jennabales2144]

Happy to help!

[@jennabales2144]

KZbin won't allow me to turn on subtitles so details of faded sound below: Subtitles for faded sound: 1:56 "delete because ABA graphs don't have grid lines" 2:06 "this one will be frequency and this one will be date" 2:42 "how to insert phase change lines" 3:03 "because we want it to be black" 3:51 "this is my intervention data" 4:10 "if I want to add my second column in there, if I click on the graph" 4:24 "it's automatically going to insert"

[@yevettie]

thank you

[@jennabales2144]

You're welcome

[@MaryLeigh226]

I have followed your instructions on your video which has been very helpful but I can't get the spacing between the baseline and the other data to show up on my graph when I go to make it. It connects all the points together.

[@jennabales2144]

MaryLeigh226 is there a blank row in your data set between the data that you want disconnected? That is probably the easiest way. Another way is to right click on the data point that you want disconnected and select format data point and then no line. Hope that helps!

[@franc-n4t]

How do you create that gap, my lines are connecting

[@agustincruz3923]

would you like to do some consulting work for my comany Safe and Stable Families Wellness Center PC in Richmond VA?

[@Jwcounseling]

When I do this my spaces don’t show up in the graph. Like you have between your first three dates then the second set of dates .my graph doesn’t recognize the space .

[@jennabales2144]

Sorry don’t check comments often but I’ll answer anyways! Do you have a space in your raw data? That should add one right away. Alternatively, on the graph select the data point that you want the line to the left to disappear-right click -choose format data series-click on the paint can to get to series options - then on the line select no line

[@stalkingSTALKER101]

How do you get the baseline and intervention lines to not connect? Mine keep connecting

[@jennabales2144]

Sorry late reply, just saw your comment. You can either add an empty row in between sets of raw data or double click to select the data point on the graph, right click and select ‘format data point’, and choose ‘no line’

[@mirianmartinez9378]

would it be the same procedure for momentary time sampling?

[@jennabales2144]

For MTS you would graph the percent of + intervals, over sessions or days, yes

[@ChloeCook2000]

my husband showed me how to do this lol

[@SpazValle29]

Why do you need a baseline?

[@jennabales2144]

Baseline data helps show whether your intervention is effective or not.

[@SpazValle29]

@@jennabales2144 how do I know when I need to use it? Like how do you know which date is consider the baseline? How many days should the baseline go up to?

[@jennabales2144]

@@SpazValle29 You should be taking baseline data prior to any intervention, at least 3 days worth but really enough to ensure that data is stable and that the behaviour isn't already increasing or decreasing (depending if its targeted for increase or decrease) for some other reason. Are you in a course sequence? This will likely be reviewed in much more detail at some point if you are.

[@SpazValle29]

@@jennabales2144 Thank you so much! This was extremely helpful! If I have any more questions may I reach out?

[@jennabales2144]

@@SpazValle29 sure you can, there are also alot of great groups on facebook where you can get great feedback for these types of questions where the response may be quicker

[@elainefargo2570]

Your voice completely faded out and I wish I knew what. you said so I could do that part correctly.

[@roberth.miller6031]

You don't explain how you draw the Phase line. You didn't draw it so how did you place it where you wanted? You never explained the process. You assume too much, you must go slower and explain what you are doing otherwise the video is of no value.

[@jennabales2144]

At 2:55 in video- click on your ‘insert’ tab and select insert line. As soon as you click anywhere the line will automatically insert itself and then you can drag it to where you want it to go.