microsoft excel formulas in telugu BUY TELUGU TUTORIAL DVD'S:::: SEO::3500/-,DCA(DOS,WINDOWS,WORD,EXCEL,POWER POINT, MS ACCESS, INTERNET CONCEPTS)::499/-,DTP(PHOTOSHOP,PAGEMAKER, CORELDRAW,TELUGU TYPING)::999/-,C::700,C++::900,TALLY ERP 9:: 999,ORACLE:999/-,CORE JAVA::1000/-,SPOKEN HINDI:500,HTML::500/-,AUTOCAD::2500/-,DCA+DTP::1000/-,DCA+TALLY::1000,C,C++,JAVA::1500, ALL COURSES(DCA,DTP,C,C++,JAVA,ORACLE,TALLY,HTML,SPOKEN HINDI,AUTOCAD):: 3500/-..CONTACT : SYED HAFIZ, SHOPPING COMPLEX,8INCLINE COLONY,GODAVARI KHANI,KARIMNAGAR, TELANGANA,CELL:9395306603,EMAIL:COOLHAFI7@GMAIL.COM.
Home / Ms Office / Ms Excel 2007 / Microsoft excel formulas in telugu Forecast Formula

Microsoft excel formulas in telugu Forecast Formula

Microsoft excel formulas in telugu

Explanation: Excel uses the method of least squares to find a line that best fits the points. The R-squared value equals 0.9295, which is a good fit. The closer to 1, the better the line fits the data.

When you add a trendline to an Excel chart, Excel can display the equation in a chart. You can use this equation to calculate future sales. The FORECAST and TREND function give the exact same result.
Explanation: Excel uses the method of least squares to find a line that best fits the points. The R-squared value equals 0.9295, which is a good fit. The closer to 1, the better the line fits the data.

MS Excel: FORECAST Function in telugu

This Excel tutorial explains how to use the Excel FORECAST function with syntax and examples.

Description

The Microsoft Excel FORECAST function returns a prediction of a future value based on existing values provided.

Syntax

The syntax for the Microsoft Excel FORECAST function is:

FORECAST( x-value, known_y_values, known_x_values )

Parameters or Arguments

x-value is the x-value used to predict the y-value.

known_y_values is the known y-values used to predict the y-value.

known_x_values is the known x-values used to predict the y-value.

Note

  • If x-value is not a numeric value, the FORECAST function will return the #VALUE! error.
  • If known_y_values and known_x_values contain different numbers of elements, the FORECAST function will return the #N/A error.

Applies To

The FORECAST function can be used in the following versions of Microsoft Excel:

  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The FORECAST function can be used in Microsoft Excel as the following type of function:

  • Worksheet function (WS)

Example (as Worksheet Function)

Let’s look at some Excel FORECAST function examples and explore how to use the FORECAST function as a worksheet function in Microsoft Excel:

About Hafiz

Check Also

Microsoft excel 2013 for beginners in telugu

Microsoft excel 2013 for beginners in telugu Part 1

Microsoft excel 2013 for beginners in telugu In this Microsoft excel 2013 for beginners in …

One comment

  1. Patchala Subbaiah

    Sheet no 1
    No. Name. Rank Location
    1. Joseph. Asi. Guntur
    2. Ramesh si. Vizak
    ఇక్కడ నమోదు చేసిన డాటా నం2 sheet లొ change how

    Sheet no 2

    No. Location. Insp. Si. Asi.
    1. Guntur 0. 0. 1
    2. Vizak. 1. 1. 1
    3. Home. 1 1 1

    Guntur. 0. 0. 0
    Vizak. 1. 1. 1
    Home. 1. 1. 1

Leave a Reply

Your email address will not be published. Required fields are marked *

STATE BANK OF HYDERABAD, ***NAME:Hafiz SD, BRANCH:JALLARAM, ACCOUNT.NO:62041435239, IFSC CODE:SBHY0020609,****, ANDRA BANK*** NAME:SYED HAFEEZ BABA, BRANCH:8INCLINE COLONY, ACCOUNT.NO:116710100037533****SBI****NAME:SYED HAFEEZ BABA,ACCOUNT NO:35321924009,IFSC CODE:SBIN0013338,BRANCH:GODAVARIKHANI.,...