How to calculate a Regression Equation Using Excel Statistics

  Рет қаралды 93,941

statisticsfun

statisticsfun

15 жыл бұрын

Using Microsoft Excel to calculate Standard Deviation, Mean, and Variance, Presented by David Longstreet
Like us on: / partymorestudyless
Playlist on Regression: kzfaq.info?list=EC...

Пікірлер: 21
@statisticsfun
@statisticsfun 11 жыл бұрын
Happy to save you :). I added a link to an entire playlist on regression in the description of this video. This video is one of my older ones and I have revise and improved the newer ones on regression. Good luck in your class!
@Orangewolf11
@Orangewolf11 11 жыл бұрын
thank you so much! you saved me from failing my homework! you do so much more than we cover in class. and I understand it now :)
@statisticsfun
@statisticsfun 11 жыл бұрын
Great to hear things are better.
@statisticsfun
@statisticsfun 12 жыл бұрын
Thanks for the compliment. Make sure you look at the playlist on regression on my channel statisticsfun.
@statisticsfun
@statisticsfun 11 жыл бұрын
Thanks for the tip!
@skyfire24x
@skyfire24x 14 жыл бұрын
thank you for posting this!
@statisticsfun
@statisticsfun 11 жыл бұрын
You are very welcome. Make sure you like MyBookSucks on Facebook (see link in video description).
@cdogcdogcdog
@cdogcdogcdog 12 жыл бұрын
Thanks for video. Very helpful
@ossielmais
@ossielmais 12 жыл бұрын
you are a hero, thank you sir
@Marmit42424
@Marmit42424 9 жыл бұрын
Hello! Firstly, thank you so much for making these videos! Secondly, I was wondering what the criteria is for choosing your initial x and y variable. If I want to predict the number of tea gallons that will likely be sold, should I use the number of people who walked in the store on the same day last year? That does not seem to be correct to me, but I'm not sure what else to predict such a thing off of. Whether or not you answer the question, I appreciate your time!
@statisticsfun
@statisticsfun 12 жыл бұрын
Appreciate the feedback.
@statisticsfun
@statisticsfun 11 жыл бұрын
1. It could be you need to increase the width of your excel column. 2. You may need to reduce the number of decimal points. You can attach your spreadsheet or a photograph of your work on messages on MyBookSucks FaceBook fan page (see link in the description of this video). I will look at it and see if can't figure out what you are doing wrong.
@ShayneCT
@ShayneCT 11 жыл бұрын
Thank you sir very much
@sdd0078
@sdd0078 10 жыл бұрын
Thanks for the video. Please explain how to check significance of r2 or r.
@statisticsfun
@statisticsfun 10 жыл бұрын
You can see a complete playlist on Regression and I explain R squared in one of the videos. kzfaq.info?list=ECF596A4043DBEAE9C
@sdd0078
@sdd0078 10 жыл бұрын
Ok thanks. Your videos are nice and understandable. I want to ask if slopes of two or more than two regression lines (b) is possible to compare by t-test or Ancova.
@abhi124s
@abhi124s 12 жыл бұрын
Amaaaazing
@mar10001wan
@mar10001wan 13 жыл бұрын
love you
@SKLexi
@SKLexi 11 жыл бұрын
Just to make things easier - if you want to keep some cell constant in a formula in excel, you don't have to put there mechanically $ signs, just hit F4 key and the computer puts the signs there for you ;-)
@mar10001wan
@mar10001wan 13 жыл бұрын
love you
Linear Regression Using R
5:26
statisticsfun
Рет қаралды 58 М.
Interpreting Linear Regression Results
16:08
Sergio Garcia, PhD
Рет қаралды 301 М.
Spot The Fake Animal For $10,000
00:40
MrBeast
Рет қаралды 195 МЛН
Nastya and SeanDoesMagic
00:16
Nastya
Рет қаралды 43 МЛН
Playing hide and seek with my dog 🐶
00:25
Zach King
Рет қаралды 37 МЛН
How To Perform Simple Linear Regression In Excel
14:51
Steven Bradburn
Рет қаралды 425 М.
How to Calculate ANOVA with Excel (Analysis of Variance)
15:12
statisticsfun
Рет қаралды 463 М.
Linear Regression and Correlation - Example
24:58
slcmath@pc
Рет қаралды 1 МЛН
Correlation and Regression Analysis: Learn Everything With Examples
9:50
LEARN & APPLY : Lean and Six Sigma
Рет қаралды 1,5 МЛН
Calculating Standard Deviation Using Excel
6:00
statisticsfun
Рет қаралды 72 М.
Regression Analysis | Full Course
45:17
DATAtab
Рет қаралды 794 М.
How to Calculate R Squared Using Regression Analysis
7:40
statisticsfun
Рет қаралды 853 М.
An introduction to z scores
3:53
statisticsfun
Рет қаралды 417 М.
Spot The Fake Animal For $10,000
00:40
MrBeast
Рет қаралды 195 МЛН