HOW TO GENERATE EQUATIONS AND SQUARE ROOTS FROM A GRAPH (MICROSOFT EXCEL)

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.

Comments

HOW TO CREATE NNPC LOGO with Corel Draw

Creating the Nigerian National Petroleum Corporation (NNPC) logo in Corel draw is very easy, on this tutorial, I shall give the details on how you can complete the logo on your own. Below are the steps: Step 1: Insert an ellipse tool (draw a circle) on your Corel draw page. ( Note: to draw a perfect circle; press down CTRL key while dragging the circle) This way, you can ensure the width and height of the circle is equal. That makes a circle or ellipse tool perfect.

SOME KEYBOARD SECRETS REVEALED

The key board is an input device used to enter commands and instructions into the computer system. The keyboard functions are usually called "SHORT-CUTS ". This is because they provide you with quick access to complex functions with just hitting a key on the keyboard or some couples of keys. Shortcuts are likely used by gurus (IT experts) as they understand the importance of using them; they know how fast they can be when they apply those shortcut keys in their day to day use of computer. Why waste your time going to OFFICE BUTTON (FILE) each time you want to SAVE your work when you can just hold down your CTRL key and press S (CTRL+S) or why stress yourself trying to Select All text in your document by dragging from beginning to End when you can simply use this command (CTRL + A). I am certain that most of you Already know these simple shortcut keys, but if there is any one reading this post who cannot apply these simple shortcuts from CTRL+A to CTRL+Z, th...

Various Components of the Computer System identified (Section 1)

In this session, you will learn to: Identify the major components of personal computers. Identify the major components of the system unit. Identify the various types of storage devices used in personal computers. Identify personal computer connection methods. There are four primary categories of components in a typical personal computer: System unit Display device Input devices External devices

GOSPEL MUSIC AFRICA (GMA)

Search This Blog