Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.
When you look at the Excel screen you see a rectangular table or grid of rows and columns. The horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C). For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC.
The intersection point between a column and a row is a small rectangular box known as a cell. A cell is the basic unit for storing data in the spreadsheet. Because an Excel spreadsheet contains thousands of these cells, each is given a cell reference or address to identify it. The cell reference is a combination of the column letter and the row number such as A3, B6, AA345.
In my class last month, i have been introduce to the new function in excel that is scatter plot.
Scatter Plot Graphs
Scatter plot graphs are used to show trends in data. They are especially useful when you have a large number of data points. Like line graphs, they can be used to plot data recorded from scientific experiments, such as how a chemical reacts to changing temperature or atmospheric pressure. Whereas line graphs connect the dots or points of data to show every change, with a scatter plot you draw a "best fit"line. The data points are scattered about the line. The closer the data points are to the line the stronger the correlation or affect one variable has on the other.
If the best fit line increases from left to right, the scatter plot shows a positive correlation in the data. If the line decreases from left to right, there is a negative correlation in the data.
Below is the link on how to make the scatter plot in excel:
The scatter plot will be like shown below:
The difference between scatter chart and line chart in excel are as follow:
| TYPE | SCATTER CHART | LINE CHART |
| Axis Value Variable Type | Continuously Variable Numeric Values | Non-Numeric Attributes (even if numbers are used) |
| Axis Scale Limits | Adjustable | Fixed |
| Stacked Series | Not Supported | Supported |
Below is one of the picture of exercise that i have done in class in scatter plot:
exercise 1
No comments:
Post a Comment