Got Homework?
Connect with other students for help. It's a free community.
Here's the question you clicked on:
 0 viewing
ggrree
Group Title
not really a math problem, but I need to make a graph for math class and I need help with using excel! please help :X (details in next post)
 2 years ago
 2 years ago
ggrree Group Title
not really a math problem, but I need to make a graph for math class and I need help with using excel! please help :X (details in next post)
 2 years ago
 2 years ago

This Question is Closed

ggrree Group TitleBest ResponseYou've already chosen the best response.0
dw:1331794223458:dw
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
essentially, I want to draw a graph like this. I've got continuous data (time) on the y axis, and I want to make a sort of scatter plot with the day of the week on the x axis.
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
but it's also important that I get the x axis to look somewhat like I drew it here (monday, tuesday wednesday on the x axis)
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
well there are some things that can go wrong with trying to plot data in excel but if you set it out right you should be okay. Have you tried insert>scatter graph? Also which excel are you using?
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
looking at this may also help http://academic.brooklyn.cuny.edu/economic/friedman/scatterdiagramexcel.htm
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
I think the issue is I'm putting a discrete variable on the x axis. this is what it looks like now http://gyazo.com/7d5f78bb743624f443bb91e465eaf8ef
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
ah right yes, that would have an effect on that, gimme a sec while I open up my excel :P
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
Thank you so much! I'm pulling my hair out over here :P
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
I know the feeling :) okay try using a line graph instead of a scatter graph, this will put your days of the week as you have them written on the spreadsheet.
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
http://gyazo.com/a7e9a6bf0d4ff44b6ca9e7f8de85494c This is what the spreadsheet looks like, by the way.
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
oh, it already is a line graph, apparently.
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
If I select scatter chart it gives me a bizarre combination of numbers on the x axis that I didn't even input
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
Also do you have any idea on how to add error bars to this whole mess? I will need them eventually but I guess I can omit them if it's too much hassle.
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
ah yes, I do know how to get error bars :) while clicked in your chart go to the layout tab, then in the "analysis" section click error bars>more error bar options then in the box that opens click custom and select your error. You will have to calculate it on the sheet  as excel doesn't have a standard error function (standard error is standard deviation over the square root of n).
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
okay I got your graph in the end :) 1. you're going to have to rearrange your data (annoying but I can't think of any other way). put it in like in the attachment: (i've just made up some times instead of using yours) 2. make sure you highlight all the numbers when you make the graph and make it a line graph. 3. The graph will have one line in it, just right click on the line or a data point on the line and in the properties turn the line transparent.
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
ok, I'll try it now. Thanks so much!
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
sorry for putting such a giant screenshot in, this one will load faster
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
and no worries :)
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
oh and its not properties, its "format data series", then line colour :)
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
I think it worked! thanks!
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
yaaay! :)
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
One last thing :P since my values are entered as times it won't let me do any simple calculations (like mean or standard deviation) do you know any easy way around this or do I just need to manually convert the cells to a manageable format?
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
thank you so very much!
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
yeah you'll have to change it to a manageable format  like decimals
 2 years ago

ggrree Group TitleBest ResponseYou've already chosen the best response.0
oh poop :P I guess I won't be sleeping tonight after all :P thank you so much for your time, you've really helped me out! :)
 2 years ago

TranceNova Group TitleBest ResponseYou've already chosen the best response.1
no worries, yeah.. I can't think of an easy way to do that. Hope it goes okay!.. I've gotta go too :P
 2 years ago
See more questions >>>
Your question is ready. Sign up for free to start getting answers.
spraguer
(Moderator)
5
→ View Detailed Profile
is replying to Can someone tell me what button the professor is hitting...
23
 Teamwork 19 Teammate
 Problem Solving 19 Hero
 Engagement 19 Mad Hatter
 You have blocked this person.
 ✔ You're a fan Checking fan status...
Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.