Let me believe that we all already
know what a graph is, but for those of us who are not sure what a graph is;
“GRAPH is a diagram showing the
relation between variable quantities, typically of two variables, each measured
along one of a pair of axes at right angles”.
There are various kinds of graphs,
but I will write specifically on Linear graphs.
Let me also assume you all already
know how to plot graphs, but if my
assumption is false, kindly follow this link
to learn how to plot graphs How to Plot Graphs in Microsoft Excel.
Considering how precious my time is
to me, I will “hit the nail on the head”.
STEPS
TO GENERATING EQUATION AND SQUARE ROOTS VIA GRAPHS
Step
1: Compute your values in X and Y format (See below)
Time
|
1
|
2
|
3
|
4
|
5
|
6
|
X
|
3.4
|
6.7
|
5
|
6
|
4.8
|
2.09
|
Y
|
2.5
|
3.7
|
6
|
5
|
7
|
2
|
Step
2: Highlight all
the values (both X and Y axes). On Insert menu, click on Scatter (also known as
X and Y Chart). Automatically a graph will appear on your worksheet looking
like this (see below).
Step
3: Right click on
each of the graph nod-lines as shown below and click on Add Trendlines.
Then, on the box that will appear, tick Display Equation on Graph, and Display R-Squared Value on Chart. See
below.
Finally click Close and you are good.
Is this post helpful, kindly encourage the author by hitting the share button and also leave a comment.
Thank you very much for stopping by.
