Category Archives: Programming

The Importance of the LINEST Function in Microsoft Excel

Posted on by
Reply

In Microsoft Excel, the LINEST function is easy to use. However, you have to master the array function concept. When this array function is entered within a single spreadsheet, the cell produces results filling the few cells. Here are steps to help you through the linear curve fitting process.

• Key-in the data within two columns, one is for the y variables and the other is for the x variables.
• Choose the area holding the array formula output.
• Click the formula bar, which is located at the top of the spreadsheet. Now, press the wizard button function. This is within the formula bar that is labeled as fx. Two scroll box will appear; LINEST is in the right and STATISTICAL is located on the left scroll box. Click the NEXT> button. There you will see through the spreadsheet, which contains the y values through dragging inside the original spreadsheet with the mouse. Click the dialog box which contains ‘known_x’s’ then choose the cells that contain the x values. Type the keyword ‘TRUE’ within its last two dialog boxes. The first TRUE points out the line that to be within the form of ‘y=mx+b’ having the intercept of non-zero. The other specifies the error estimates, which have to be listed.

Permanent link to this post (212 words, estimated 51 secs reading time)

The Are Several Basic Ways to Learn How to Use the LARGE Function in Microsoft Excel

Posted on by
Reply

Excel Math

Excel Math teaches you how to subtract, add, divide or multiply numbers in Excel. In addition, it also helps to show you exactly how you can do it.

Entering Data in Microsoft Excel

This covers the basic instructions on how to manually enter data into the Excel spreadsheet. Moreover, you can also use this for items such as planning the layout of the spreadsheet right before entering the given data, the kinds of data which you are ought to enter, widening of columns, and learning how to edit cells in changing the data.

Spreadsheet Formatting in Microsoft Excel

Formatting is said to be part of worksheet completion. It covers the features in formatting such as

• Adding percent and currency symbols
• Shading alternate data rows
• Changing the alignment of data
• Widening columns

Guidelines in Formatting and Creating Excel Charts

A chart or graph is known to be the visual representation of spreadsheet data. It often helps you to easily understand the given data within the worksheet since users can easily pick out the trends and patterns, which is illustrated in the chart. In Microsoft Excel the types of graphs or charts that are most often used are bar graph, pie chart, column chart, line graph and Sparklines, which are available in Microsoft Excel 20

Permanent link to this post (220 words, estimated 53 secs reading time)

Computing the Value of Kurtosis on a Set of Data Using the Microsoft Excel KURT Function

Posted on by
Reply

What is the KURT Function?

The KURT function is utilized to calculate the kurtosis of a set of data. Kurtosis describes the flatness or the rising of certain distribution against the normal distribution. Positive kurtosis designates relevance in increase on the value distribution in a given set of data. On the other hand, negative kurtosis designates flatness in the value distribution in a set of data.

What is the KURT Function Formula?

In order to obtain accurate result in Excel, right formula should be used. The right formula to use for KURT function is:

=KURT(number 1, number 2… and so on)

Whereas:

Number 1, number 2… and so on – are from 1 to 30 arguments where kurtosis will be calculated. In this, the arguments could be in the form of a single range or reference to certain range rather than of arguments that are divided by comma.

What are the Necessary Facts to Remember?

In all Excel functions, there are essential details to keep in mind to use a certain function successfully. With KURT function, the important facts to think about when using the function are as follows:

Permanent link to this post (190 words, estimated 46 secs reading time)

How to Compute Intercept in Microsoft Excel Through the INTERCEPT Function

Posted on by
Reply

Aside from using it as a database, it is also an excellent tool for calculation of mathematical problems. Because of the different functions of the program, certain mathematical problems can be computed easily. One of the functions that are usually utilized in Excel is the INTERCEPT function. By reading the article, Excel programmers will be acquainted to one of the essential functions of Microsoft Excel.

INTERCEPT Function Overview

The function is used to compute the point where a certain line will meet the y-axis with the use of the given values of x and y. The point of intersection is in accordance with the well fitted regression line that is plotted using the identified value of x and y. The function is recommended to be used when determining the value of the dependent variable when that the value of independent variable is equal to zero.

Correct Syntax to Use

In order to employ the function correctly, the right formula to use is:

=INTERCEPT(known_y’s, known_x’s)

Where:

• Known_y’s – is the set of dependent data or information
• Known_x’s – the set of independent data or information

Important Details to Remember

Since Excel is a Microsoft program that function based on formula, there are certain things that need to be remembered in order to use the program efficiently and they are:

• The arguments must be names, numbers, arrays or cell reference containing numbers.
• Once the reference or the range arguments contain logical values, text or blank cells, then the values are all ignored. But, the cell that contains a zero value is included in the computation.
• Once the value of known_y’s and known_x’s are diverse numbers of data points, the answer of the function would be #N/A! error.

INTERCEPT Function Example

For a better understanding of the function, take a look at the given example below and try using the INTERCEPT function.

Find for the intercept if the given value for y is 5, 6, 8, 2 and 3. On the other hand the given value for x is 10, 3, 7, 5 and 4.

To compute for the intercept using Microsoft Excel, below are the steps to be followed:

This is a preview of How to Compute Intercept in Microsoft Excel Through the INTERCEPT Function. Read the full post (411 words, estimated 1:39 mins reading time)