Excel 2013 Statistical Analysis #62: Calculate Slope and Intercept for Regression Line

preview_player
Показать описание

Topics in this video:
1. (00:09) Discussion of Slope and y-intercept formulas
2. (03:30) X Y Scatter Chart / Plot
3. (05:00) Calculate Slope and Intercept
4. (09:55) Use equation to predict
5. (10:48) Example 2 for calculating Slope and Intercept
  1. excelisfun
  2. Excel 2013
  3. Statistical Analysis
  4. Excel Statistics
  5. Highline College
  6. Business and Economic Statistical Analysis
Рекомендации по теме
Excel 2013 Statistical 0:14:29

Excel 2013 Statistical Analysis #62: Calculate Slope and Intercept for Regression Line

Excel 2010 Statistics 0:13:27

Excel 2010 Statistics 62: Calculating Bell Normal Distribution Probabilities & X Values 10 Examp...

Excel 2013 Statistical 0:15:13

Excel 2013 Statistical Analysis #40: Normal (Bell) Probability Distribution Area Chart, X & Z Va...

MS Excel Tutorial 0:03:21

MS Excel Tutorial - Lesson 62 - Unlocking and protecting worksheets

Basic Excel Business 0:11:34

Basic Excel Business Analytics #62: Excel Solver: Maximize Portfolio Returns

Use Excel 2016 0:06:08

Use Excel 2016 to make Frequency distribution and Histogram for quantitative data

Excel 2013 Tutorial#62 0:02:43

Excel 2013 Tutorial#62 Ceiling Function in Excel

Logical Reasoning???#viral #vidumzn 0:00:11

Logical Reasoning???#viral #vidumzn

Data Analysis using 1:11:19

Data Analysis using MS-Excel 2013 Spreadsheet Recorded lesson

How to eat 0:00:16

How to eat Roti #SSB #SSB Preparation #Defence #Army #Best Defence Academy #OLQ

Intro to using 0:22:43

Intro to using Excel for basic statistical analysis

Vijay Mallya spotted 0:00:11

Vijay Mallya spotted driving Bentley in London🇬🇧

Activating the Data 0:01:11

Activating the Data Analysis ToolPak Add-In in Excel

Remove subtotals from 0:00:10

Remove subtotals from data in Microsoft Excel

Descriptive Statistics in 0:05:36

Descriptive Statistics in Excel Using the Data Analysis Tool

Aspirants practicing eatingetiquette 0:00:11

Aspirants practicing eatingetiquette # SSB #SSBPreparation #NDA #CDS #Defence #DefenceAcademy

Excel 2013 Tutorial 0:04:16

Excel 2013 Tutorial for Beginners #64: Formatting the Data, Type, Location, and Elements of a Chart

EAF #62 - 0:09:21

EAF #62 - Make Four Dynamic Excel Charts in 10 minutes

Basic Excel 2013,2010 0:05:10

Basic Excel 2013,2010 and 2007 statistical functions and how to correct problems

Excel Walkthrough - 0:02:24

Excel Walkthrough - Data Analysis Toolpak

Average, Mode, Median, 0:03:58

Average, Mode, Median, Mean funcions | Microsoft Excel 2013

How to Calculate 0:04:33

How to Calculate a Correlation Matrix in Excel (Three or More Variables)

Data Analysis in 0:19:17

Data Analysis in MS Excel including Sorting, Filtering , SUM, AVERAGE and IF functions

Ladies Compartment in 0:00:32

Ladies Compartment in Delhi Metro.(1)

Комментарии
Автор

Excel 2013 Statistical Analysis #62: Calculate Slope and Intercept for Regression Line
Topics in this video:
1. (00:09) Discussion of Slope and y-intercept formulas
2. (03:30) X Y Scatter Chart / Plot
3. (05:00) Calculate Slope and Intercept 
4. (09:55) Use equation to predict
5. (10:48) Example 2 for calculating Slope and Intercept

excelisfun
Автор

Oh my god, after more than 10 years of excel using, I just know the existence of RSQ, SLOPE and INTERCEPT, simple but really very useful, both this video and the functions ~

zhouyinwei
Автор

Mike, I have been watching your YouTube channel for 3 years. I have to thank you, your videos not only are the reason I have a career as a Financial Analyst, but am know as the excel guru in the office.  So thank you, I don't think I can truly put into words how much I have learned from you.

I also wanted to see if while you are doing your statistics series if you could do a video on forecasting. My goal is to build a forecast model from historical retail product sales data( with different retail prices every week.be it list or promo ) . My goal is to forecast sales units based on price point, seasonality, and trend. I have seen videos on forecasting time series that helps with the seasonality, and forecasting with linear regression that helps with the price point, but none that tie them together.  Again thank you for all the hard work you put in to this channel I greatly appreciate it.

michaelspagnolo
Автор

This video is actually #32. Not #62. Just in case anyone is going through the playlist and thinking that they are starting 'Analysis of Variance'. This video was inserted incorrectly into the playlist.

timpinckney
Автор

Thank you Mike! BTW, a quick question, are you planning to teach Power View in the near future?

chriswang
Автор

Is there any video for multiple regression or non linear regression?

georgeiolas