Advice 1: As in excel to build a dependency

Most often in the spreadsheet, put the data sets containing interrelated group of values. To evaluate the existing dependence visually and for this we need to build the corresponding graph. The table editor Microsoft Office Excel has very advanced tools for this work, but using them is not difficult.
As in excel to build a dependency
You will need
  • The table editor Microsoft Office Excel 2007 or 2010.
Instruction
1
Start Excel and load the document with the correct table. If the data dependence which is necessary to display adjacent rows or columns of one sheet, select them.
2
On the Insert tab on the Excel menu, open the drop-down list of "Point" - it is placed in the middle of the right column of icons of the group of commands Charts. This list contains schematic representations of different types of charts from which to choose the most appropriate to display the interdependence of data from your table. Then Excel adds in edit menu three tabs to work with the schedule, combined with the title "Working with diagrams".
3
If the first step you have selected the columns, the graph will be built automatically and this step can be skipped. Otherwise, it will be created only an empty region. Click "Select data" command group "Data" on one of the added tabs Design. In the opened window click "Add" under "legend entries (series)" and Excel will show you another window containing three fields.
4
In the field "series Name" specify the graph title, e.g. click on the cell with the name of the data column. In the next field - "X-Values" - put the address of the range table, which contains numbers that identify the distribution of points along the x-axis. This can be done with the keyboard or select the desired cell range with the mouse. The same thing, but for the data on the y-axis, proceed as in the "Y Values".
5
Click OK in the two open dialogs, and the graph of dependencies will be built.
6
Using the control elements on the tab "Layout" and "Format" menu of the table editor to customize the appearance of generated graphics. You can change the colors and fonts of the labels of the graph, and appearance of the substrate. It can give volume, change the shape, set the color and fill effects, select texture, etc.

Advice 2: How to build a regression in excel

Microsoft Office Excel has many applications in various fields, including such disciplines as econometrics, also employ this software utility. Almost all of the laboratory and practical work is done in Excel.
How to build a regression in excel
Instruction
1
To build the regression, use the software Microsoft Office Excel or its analogs, for example, similar utility in Open Office. Thus to calculate the index, use the LINEST():(Znaczenia; Znacheniyah; Const; stats).
2
Calculate the set of points on the regression line using the function called "TREND" (Znaczeniu; Znacheniyah; Novietne; Konst). Calculate using the given numbers unknown value of the coefficients m and b. Actions here may vary depending on this you the conditions of the problem, so check the order of evaluation, after reviewing the additional material on the topic.
3
If you have any problems with the construction of the regression equation, use special literature in econometrics, and use the additional material themed sites, for example, http://office.microsoft.com/ru-ru/excel-help/CH006252831.aspx?CTT=97, http://www.cyberforum.ru/ms-excel/, http://emm.ostu.ru/lect/lect6.html laboratory work in the discipline - http://teacher.dn-ua.com/old_version/excel/. Please note that also the regression equation may be different, so pay attention to additional information in the subject.
4
In the event that you have problems using Microsoft Office Excel download special tutorials on the subject, which is causing you trouble, or enroll in special training courses which is available for almost all cities.
5
This will also make sure that these skills will come in handy in the future, as econometrics is often included in the programs in the faculties of Humanities to expand General knowledge and are unlikely to be useful in the future, for example, lawyers.
Useful advice
Learn the power of Excel for calculations.

Advice 3: As Excel to plot the histogram

In Microsoft Office Excel, you can create different types of charts. The histogram is a graph that presents data in the form of vertical bars of various height, values for which are taken from the specified cells.
As Excel to plot the histogram
Instruction
1
Start Excel and enter the data on the basis of the created histogram. Select the range of cells, including the names of rows and columns that will be used in the chart legend.
2
Go to the Insert tab. On the standard toolbar under "Graphs" click on thumbnail Histogram. In the drop-down menu, select from the options the pattern that is best suited for your purposes. The histogram can be conical, pyramidal, cylindrical, or look like an ordinary rectangular column.
3
Select the created histogramby clicking on it with the left mouse button. Will be available in the context menu "charts" with three tabs: Design, Layout and Format. To configure the appearance of charts on your own – to change the type of positioning data in a different order, choose the right style, use the design tab.
4
On the Layout tab edit the contents of the histogram: set the name of graph and coordinate axes, define whether to display the grid and so on. Part of the operations you can perform in the window of the graph. Click, for example, on the field "chart Title" with the left mouse button, the specified region will be highlighted. Delete the existing text and enter your own. To exit the edit mode of the selected field, click the left mouse button anywhere outside the selection borders.
5
Using the tab "Format" to adjust the size of the histogram, pick the color, contour, and effects for shapes using the corresponding sections on the toolbar. Part of the operations chart can also be performed with the mouse. So to change the size of the area of the histogram, you can either use the "Size" or move the cursor to the corner of the chart, hold down the left mouse button to draw the contour in the right direction.
6
Configure the histogram you can use the context menu via a right-click of the mouse on the region of the histogram. If selected, the entire diagram will be available to the General settings. To edit a specific data group, first select it, then in the drop down menu options appear for selection.

Advice 4: As in excel to construct a trend

MS Excel, even without being a full-fledged statistics package, has a rather large range of possibilities in forecasting events based on existing data. One of the most simple, at first glance, the method of prediction is the construction of the trend line.
As in excel to construct a trend
Instruction
1
The easiest way to graph the trend immediately after any existing data in the array. On the sheet with the data table select at least two cells of the range for which the chart will be built, and immediately after that insert the chart. You can use these types of diagrams as graph, scatter, histogram, bubble, stock. Other types of charts do not support trending.
2
In the menu "Chart", select "Add trendline". In the window that opens on the tab "Type" select the type of trendline that in the mathematical equivalent means and also method of data fitting. When using the described method you will have to do it "by eye", since no mathematical calculations to plot you are carried out.
3
So just think about what type of function best describes the graph of the available data: linear, logarithmic, exponential, power law or another. If you are in doubt about choosing the type of approximation, can construct several lines, and for greater forecast accuracy on the Parameters tab of the same window check the "place on the chart the value of reliability approximation (R^2)".
4
Comparing the values of R^2 for different lines, you will be able to choose the type of graph that characterizes your data most accurately, and therefore builds the most reliable forecast. The closer the value of R^2 is to unity, the more precisely you choose the type of line. Here, on the Settings tab, you must specify the period for which the forecast.
5
This method of trend construction is very rough, so it is better to produce at least the most primitive statistical processing of available data. This will help to build a forecast more accurately.
6
If you assume that the available data are described by a linear equation, simply highlight them with the cursor and generate auto-complete for the desired number of periods or the number of cells. In this case there is no need to find the value of R^2, because you previously adjusted the forecast to the equation of the line.
7
If you think that the known value of the variable can best be described by exponential equations, and also select source range and make the autocomplete of the required number of cells, hold down the right mouse button. With autocomplete you will not be able to build other types of lines, in addition to these two.
8
Therefore, for most accurate forecasting you will have to use one of several aggregate functions: "forecast", "TREND", "GROWING", "linear" or "lehrprobe". In this case, you will have to calculate the value for each subsequent forecast period manually. If you need to make a more complex regression analysis of the data, you will need the add-in "analysis ToolPak", which is not included in the standard installation of MS Office.
Is the advice useful?
Search