Hi,
I'm trying to basically help somebody track data in Excel, and use that data to make predictions. To do this, I'm trying to find an easier way of making graphs for them. I'll have an extremely basic set of data, something like this:
Apples Oranges Pears Lemons Limes 2008 20 26 28 24 32 2009 15 18 20 19 26 2010 20 30 28 14 18 2011 24 19 18 20 6 2012 22 17 32 19 20
Now, the person I'm working with has never used Excel, and hasn't used computers very often in general, so I'm trying to make this as simple as possible for him. But I haven't used Excel much myself and don't know about the more advanced functions.
So I have two questions:
1. I'm looking for a way to make it so he can essentially click a button for the independent variable, and a button for the dependent variable, and a scatter plot shows up with a trend line. So basically, he just clicks a little button or checks a box that says apples, a little button that says oranges, and a scatter plot shows up that plots apples vs. oranges with a trend line, with the trend line equation and the r squared value showing. Maybe even have it give apples and oranges as the axes titles. Is there a way to do something like this?
2. Similarly to the first one, I basically want to make it so he could use the TREND function without actually needing to use the function. So instead of typing TREND([orangevalues],[applevalues],[2013 apple value]), I'm wondering if there's a way to make that simpler for him. Something like he clicks apples and oranges (as with the graph) and the following gets something like:
Apples Oranges [He inputs 2013 apples] TREND([orangevalues],[applevalues],[his 2013 apple value])
I have absolutely no idea what I'm doing, but I'm really hoping to help him out here. Are these things even remotely feasible? Thanks.
To sum up, in case I didn't explain it well, I'm hoping to find a way that he can have clickable buttons or check boxes for his variables, and then can click two variables and have the following happen: a scatterplot is created (preferably with axes titles) along with a trend line, trend line equation, and and r2 value, and a trend function is created where he can easily input a number and get a projection for the next year.
Thanks in advance!
Bookmarks