際際滷

際際滷Share a Scribd company logo
Computing Regression using
          Excel




                             1
Make sure you have Data Analysis Add-In
          already in your Excel




                                            2
Select Regression




                    3
Select the cells and tick the relevant boxes




                                               4
Summary output




                 5
Getting your chart and Regression Line




                                         6
7
Double click on the chart and pull down the options for Charts- select the chart
option with the fx




                                                                                   8
You will then get your regression line with the
           regression equation too.




Check that your regression variables match with the table
that has been generated earlier (see slide 5)


                                                            9
Forecast
 Substitute the next period ( in this case Yr
  9) into the equation and solve
 y = 1024.8x + 292.75
 Solve for X=9




                                                 10
What about MAD
 Go back to your regression generated
  table
 Look at the section on Residuals
 List the values as absolute
 Add and then divide by number of periods
  to get average (MAD)



                                             11
Residuals




            12
Add the absolute values and divide
   by number of observations




                                 13

More Related Content

Viewers also liked (12)

Introduction to Regression Analysis
Introduction to Regression AnalysisIntroduction to Regression Analysis
Introduction to Regression Analysis
Minha Hwang
Measuring risk essentials of financial risk management
Measuring risk essentials of financial risk managementMeasuring risk essentials of financial risk management
Measuring risk essentials of financial risk management
Chho Phet
analysis of Investment option available in market
analysis of Investment option available in market analysis of Investment option available in market
analysis of Investment option available in market
Kalakar Chokro
Correlation and Regression Analysis using SPSS and Microsoft Excel
Correlation and Regression Analysis using SPSS and Microsoft ExcelCorrelation and Regression Analysis using SPSS and Microsoft Excel
Correlation and Regression Analysis using SPSS and Microsoft Excel
Setia Pramana
Measuring of risk
Measuring of riskMeasuring of risk
Measuring of risk
Dr. Anees Alyafei
Investment Analysis Project Presentation
Investment Analysis  Project PresentationInvestment Analysis  Project Presentation
Investment Analysis Project Presentation
nroopraj24
Measuring risk
Measuring riskMeasuring risk
Measuring risk
GALAXY GLOBAL GROUP OF INSTITUTIONS
Analysis of investment decisions
Analysis of investment decisionsAnalysis of investment decisions
Analysis of investment decisions
Vaibhav Baitalwar
Regression Analysis
Regression AnalysisRegression Analysis
Regression Analysis
nadiazaheer
Investment Analysis Final Project
Investment Analysis  Final ProjectInvestment Analysis  Final Project
Investment Analysis Final Project
nroopraj24
Harvard Management Company Investment Analysis
Harvard Management Company Investment AnalysisHarvard Management Company Investment Analysis
Harvard Management Company Investment Analysis
bensigler
Reporting a single linear regression in apa
Reporting a single linear regression in apaReporting a single linear regression in apa
Reporting a single linear regression in apa
Ken Plummer
Introduction to Regression Analysis
Introduction to Regression AnalysisIntroduction to Regression Analysis
Introduction to Regression Analysis
Minha Hwang
Measuring risk essentials of financial risk management
Measuring risk essentials of financial risk managementMeasuring risk essentials of financial risk management
Measuring risk essentials of financial risk management
Chho Phet
analysis of Investment option available in market
analysis of Investment option available in market analysis of Investment option available in market
analysis of Investment option available in market
Kalakar Chokro
Correlation and Regression Analysis using SPSS and Microsoft Excel
Correlation and Regression Analysis using SPSS and Microsoft ExcelCorrelation and Regression Analysis using SPSS and Microsoft Excel
Correlation and Regression Analysis using SPSS and Microsoft Excel
Setia Pramana
Investment Analysis Project Presentation
Investment Analysis  Project PresentationInvestment Analysis  Project Presentation
Investment Analysis Project Presentation
nroopraj24
Analysis of investment decisions
Analysis of investment decisionsAnalysis of investment decisions
Analysis of investment decisions
Vaibhav Baitalwar
Regression Analysis
Regression AnalysisRegression Analysis
Regression Analysis
nadiazaheer
Investment Analysis Final Project
Investment Analysis  Final ProjectInvestment Analysis  Final Project
Investment Analysis Final Project
nroopraj24
Harvard Management Company Investment Analysis
Harvard Management Company Investment AnalysisHarvard Management Company Investment Analysis
Harvard Management Company Investment Analysis
bensigler
Reporting a single linear regression in apa
Reporting a single linear regression in apaReporting a single linear regression in apa
Reporting a single linear regression in apa
Ken Plummer

Similar to AMCA Excel Regression (guide) (11)

3.10 3.11 Notes A
3.10 3.11 Notes A3.10 3.11 Notes A
3.10 3.11 Notes A
mbetzel
Precalculus 09 Matrices.pptx
Precalculus 09 Matrices.pptxPrecalculus 09 Matrices.pptx
Precalculus 09 Matrices.pptx
KarloFritz
Precalculus 09 Matrices.pptx
Precalculus 09 Matrices.pptxPrecalculus 09 Matrices.pptx
Precalculus 09 Matrices.pptx
PiyaliBhar1
Ch 5 book - systems of linear equations
Ch 5 book - systems of linear equationsCh 5 book - systems of linear equations
Ch 5 book - systems of linear equations
Septiya Wulandari
Linear Regression Modeling
Linear Regression ModelingLinear Regression Modeling
Linear Regression Modeling
petermanr22
April 13, 2015
April 13, 2015April 13, 2015
April 13, 2015
khyps13
Image Processing
Image ProcessingImage Processing
Image Processing
yuvhashree
Nov. 16 Quadratic Inequalities
Nov. 16 Quadratic InequalitiesNov. 16 Quadratic Inequalities
Nov. 16 Quadratic Inequalities
RyanWatt
Using microsoft excel for weibull analysis
Using microsoft excel for weibull analysisUsing microsoft excel for weibull analysis
Using microsoft excel for weibull analysis
Melvin Carter
MS_Excel_Module4.1 ffor beginners yo .pptx
MS_Excel_Module4.1 ffor beginners yo .pptxMS_Excel_Module4.1 ffor beginners yo .pptx
MS_Excel_Module4.1 ffor beginners yo .pptx
shagunjain2k22phdcs0
Precalculs of matrices all operations and properties
Precalculs of matrices all operations and propertiesPrecalculs of matrices all operations and properties
Precalculs of matrices all operations and properties
MaamounBadraoui
3.10 3.11 Notes A
3.10 3.11 Notes A3.10 3.11 Notes A
3.10 3.11 Notes A
mbetzel
Precalculus 09 Matrices.pptx
Precalculus 09 Matrices.pptxPrecalculus 09 Matrices.pptx
Precalculus 09 Matrices.pptx
KarloFritz
Precalculus 09 Matrices.pptx
Precalculus 09 Matrices.pptxPrecalculus 09 Matrices.pptx
Precalculus 09 Matrices.pptx
PiyaliBhar1
Ch 5 book - systems of linear equations
Ch 5 book - systems of linear equationsCh 5 book - systems of linear equations
Ch 5 book - systems of linear equations
Septiya Wulandari
Linear Regression Modeling
Linear Regression ModelingLinear Regression Modeling
Linear Regression Modeling
petermanr22
April 13, 2015
April 13, 2015April 13, 2015
April 13, 2015
khyps13
Image Processing
Image ProcessingImage Processing
Image Processing
yuvhashree
Nov. 16 Quadratic Inequalities
Nov. 16 Quadratic InequalitiesNov. 16 Quadratic Inequalities
Nov. 16 Quadratic Inequalities
RyanWatt
Using microsoft excel for weibull analysis
Using microsoft excel for weibull analysisUsing microsoft excel for weibull analysis
Using microsoft excel for weibull analysis
Melvin Carter
MS_Excel_Module4.1 ffor beginners yo .pptx
MS_Excel_Module4.1 ffor beginners yo .pptxMS_Excel_Module4.1 ffor beginners yo .pptx
MS_Excel_Module4.1 ffor beginners yo .pptx
shagunjain2k22phdcs0
Precalculs of matrices all operations and properties
Precalculs of matrices all operations and propertiesPrecalculs of matrices all operations and properties
Precalculs of matrices all operations and properties
MaamounBadraoui

Recently uploaded (20)

BIDA Summit Presentation_Ashik Chowdhury.pptx
BIDA Summit Presentation_Ashik Chowdhury.pptxBIDA Summit Presentation_Ashik Chowdhury.pptx
BIDA Summit Presentation_Ashik Chowdhury.pptx
JaneMama
Veronika Myltseva: 亢仆舒仂亟仆 亠仆亟亳 亠亞仍ミ火夷出術 丿: 仂 于舒亢仍亳于仂 亰仆舒亳 弍亰仆亠...
Veronika Myltseva: 亢仆舒仂亟仆 亠仆亟亳 亠亞仍ミ火夷出術 丿: 仂 于舒亢仍亳于仂 亰仆舒亳 弍亰仆亠...Veronika Myltseva: 亢仆舒仂亟仆 亠仆亟亳 亠亞仍ミ火夷出術 丿: 仂 于舒亢仍亳于仂 亰仆舒亳 弍亰仆亠...
Veronika Myltseva: 亢仆舒仂亟仆 亠仆亟亳 亠亞仍ミ火夷出術 丿: 仂 于舒亢仍亳于仂 亰仆舒亳 弍亰仆亠...
Lviv Startup Club
Lion One Metals Corporate Presentation April 2025
Lion One Metals Corporate Presentation April 2025Lion One Metals Corporate Presentation April 2025
Lion One Metals Corporate Presentation April 2025
Adnet Communications
Business Enviornment Amazon Warehouse Workers Protest
Business Enviornment Amazon Warehouse Workers ProtestBusiness Enviornment Amazon Warehouse Workers Protest
Business Enviornment Amazon Warehouse Workers Protest
decodeai03
Beyond the Basics: Flow, Forecasting & Decision-Making
Beyond the Basics: Flow, Forecasting & Decision-MakingBeyond the Basics: Flow, Forecasting & Decision-Making
Beyond the Basics: Flow, Forecasting & Decision-Making
Orderly Disruption
sach-giao-khoa-toan-11-tap-2-canh-dieu.pdf
sach-giao-khoa-toan-11-tap-2-canh-dieu.pdfsach-giao-khoa-toan-11-tap-2-canh-dieu.pdf
sach-giao-khoa-toan-11-tap-2-canh-dieu.pdf
10LMinhHin8a1
Navigating Emerging Technologies in Business
Navigating Emerging Technologies in BusinessNavigating Emerging Technologies in Business
Navigating Emerging Technologies in Business
Arik Fletcher
Professional Business Report Presentation.pptx.pptx
Professional Business Report Presentation.pptx.pptxProfessional Business Report Presentation.pptx.pptx
Professional Business Report Presentation.pptx.pptx
Jundil Galamiton
Oleksii Ivanchenko: Generative AI architecture patterns in production (UA)
Oleksii Ivanchenko: Generative AI architecture patterns in production (UA)Oleksii Ivanchenko: Generative AI architecture patterns in production (UA)
Oleksii Ivanchenko: Generative AI architecture patterns in production (UA)
Lviv Startup Club
Event Report - Google Cloud Next 2025 - Google Cloud completes and leads
Event Report - Google Cloud Next 2025 - Google Cloud completes and leadsEvent Report - Google Cloud Next 2025 - Google Cloud completes and leads
Event Report - Google Cloud Next 2025 - Google Cloud completes and leads
Holger Mueller
IAB-Ad-Funding-Online-Services-Report-2025-FINAL.pdf
IAB-Ad-Funding-Online-Services-Report-2025-FINAL.pdfIAB-Ad-Funding-Online-Services-Report-2025-FINAL.pdf
IAB-Ad-Funding-Online-Services-Report-2025-FINAL.pdf
agatadrynko
China Business Expeditions June 2025.pdf
China Business Expeditions June 2025.pdfChina Business Expeditions June 2025.pdf
China Business Expeditions June 2025.pdf
Ireland in China
Own Your Own AI Infrastructure that is Scalable, Affordable, and Secure!
Own Your Own AI Infrastructure that is Scalable, Affordable, and Secure!Own Your Own AI Infrastructure that is Scalable, Affordable, and Secure!
Own Your Own AI Infrastructure that is Scalable, Affordable, and Secure!
ideatoipo
Realistic & High-Quality Sex Dolls YJL Sex Doll Factory
Realistic & High-Quality Sex Dolls  YJL Sex Doll FactoryRealistic & High-Quality Sex Dolls  YJL Sex Doll Factory
Realistic & High-Quality Sex Dolls YJL Sex Doll Factory
yjlsexdoll7
Participation of Chinese citizens i .pdf
Participation of Chinese citizens i .pdfParticipation of Chinese citizens i .pdf
Participation of Chinese citizens i .pdf
Rbc Rbcua
Raman Bhaumik - A Junior Software Developer
Raman Bhaumik - A Junior Software DeveloperRaman Bhaumik - A Junior Software Developer
Raman Bhaumik - A Junior Software Developer
Raman Bhaumik
CBV - GST Collection Report - March 2025.pdf
CBV - GST Collection Report - March 2025.pdfCBV - GST Collection Report - March 2025.pdf
CBV - GST Collection Report - March 2025.pdf
writer28
Hiring WordPress Developers Best Practices and Key Consideration
Hiring WordPress Developers Best Practices and Key ConsiderationHiring WordPress Developers Best Practices and Key Consideration
Hiring WordPress Developers Best Practices and Key Consideration
marianjures
From Zero to Funded: How Small Businesses Can Build Credibility Without Perso...
From Zero to Funded: How Small Businesses Can Build Credibility Without Perso...From Zero to Funded: How Small Businesses Can Build Credibility Without Perso...
From Zero to Funded: How Small Businesses Can Build Credibility Without Perso...
The Red Spectrum
Jignesh Shah The Visionary Who Transformed India's Financial.pdf
Jignesh Shah The Visionary Who Transformed India's Financial.pdfJignesh Shah The Visionary Who Transformed India's Financial.pdf
Jignesh Shah The Visionary Who Transformed India's Financial.pdf
Jignesh Shah
BIDA Summit Presentation_Ashik Chowdhury.pptx
BIDA Summit Presentation_Ashik Chowdhury.pptxBIDA Summit Presentation_Ashik Chowdhury.pptx
BIDA Summit Presentation_Ashik Chowdhury.pptx
JaneMama
Veronika Myltseva: 亢仆舒仂亟仆 亠仆亟亳 亠亞仍ミ火夷出術 丿: 仂 于舒亢仍亳于仂 亰仆舒亳 弍亰仆亠...
Veronika Myltseva: 亢仆舒仂亟仆 亠仆亟亳 亠亞仍ミ火夷出術 丿: 仂 于舒亢仍亳于仂 亰仆舒亳 弍亰仆亠...Veronika Myltseva: 亢仆舒仂亟仆 亠仆亟亳 亠亞仍ミ火夷出術 丿: 仂 于舒亢仍亳于仂 亰仆舒亳 弍亰仆亠...
Veronika Myltseva: 亢仆舒仂亟仆 亠仆亟亳 亠亞仍ミ火夷出術 丿: 仂 于舒亢仍亳于仂 亰仆舒亳 弍亰仆亠...
Lviv Startup Club
Lion One Metals Corporate Presentation April 2025
Lion One Metals Corporate Presentation April 2025Lion One Metals Corporate Presentation April 2025
Lion One Metals Corporate Presentation April 2025
Adnet Communications
Business Enviornment Amazon Warehouse Workers Protest
Business Enviornment Amazon Warehouse Workers ProtestBusiness Enviornment Amazon Warehouse Workers Protest
Business Enviornment Amazon Warehouse Workers Protest
decodeai03
Beyond the Basics: Flow, Forecasting & Decision-Making
Beyond the Basics: Flow, Forecasting & Decision-MakingBeyond the Basics: Flow, Forecasting & Decision-Making
Beyond the Basics: Flow, Forecasting & Decision-Making
Orderly Disruption
sach-giao-khoa-toan-11-tap-2-canh-dieu.pdf
sach-giao-khoa-toan-11-tap-2-canh-dieu.pdfsach-giao-khoa-toan-11-tap-2-canh-dieu.pdf
sach-giao-khoa-toan-11-tap-2-canh-dieu.pdf
10LMinhHin8a1
Navigating Emerging Technologies in Business
Navigating Emerging Technologies in BusinessNavigating Emerging Technologies in Business
Navigating Emerging Technologies in Business
Arik Fletcher
Professional Business Report Presentation.pptx.pptx
Professional Business Report Presentation.pptx.pptxProfessional Business Report Presentation.pptx.pptx
Professional Business Report Presentation.pptx.pptx
Jundil Galamiton
Oleksii Ivanchenko: Generative AI architecture patterns in production (UA)
Oleksii Ivanchenko: Generative AI architecture patterns in production (UA)Oleksii Ivanchenko: Generative AI architecture patterns in production (UA)
Oleksii Ivanchenko: Generative AI architecture patterns in production (UA)
Lviv Startup Club
Event Report - Google Cloud Next 2025 - Google Cloud completes and leads
Event Report - Google Cloud Next 2025 - Google Cloud completes and leadsEvent Report - Google Cloud Next 2025 - Google Cloud completes and leads
Event Report - Google Cloud Next 2025 - Google Cloud completes and leads
Holger Mueller
IAB-Ad-Funding-Online-Services-Report-2025-FINAL.pdf
IAB-Ad-Funding-Online-Services-Report-2025-FINAL.pdfIAB-Ad-Funding-Online-Services-Report-2025-FINAL.pdf
IAB-Ad-Funding-Online-Services-Report-2025-FINAL.pdf
agatadrynko
China Business Expeditions June 2025.pdf
China Business Expeditions June 2025.pdfChina Business Expeditions June 2025.pdf
China Business Expeditions June 2025.pdf
Ireland in China
Own Your Own AI Infrastructure that is Scalable, Affordable, and Secure!
Own Your Own AI Infrastructure that is Scalable, Affordable, and Secure!Own Your Own AI Infrastructure that is Scalable, Affordable, and Secure!
Own Your Own AI Infrastructure that is Scalable, Affordable, and Secure!
ideatoipo
Realistic & High-Quality Sex Dolls YJL Sex Doll Factory
Realistic & High-Quality Sex Dolls  YJL Sex Doll FactoryRealistic & High-Quality Sex Dolls  YJL Sex Doll Factory
Realistic & High-Quality Sex Dolls YJL Sex Doll Factory
yjlsexdoll7
Participation of Chinese citizens i .pdf
Participation of Chinese citizens i .pdfParticipation of Chinese citizens i .pdf
Participation of Chinese citizens i .pdf
Rbc Rbcua
Raman Bhaumik - A Junior Software Developer
Raman Bhaumik - A Junior Software DeveloperRaman Bhaumik - A Junior Software Developer
Raman Bhaumik - A Junior Software Developer
Raman Bhaumik
CBV - GST Collection Report - March 2025.pdf
CBV - GST Collection Report - March 2025.pdfCBV - GST Collection Report - March 2025.pdf
CBV - GST Collection Report - March 2025.pdf
writer28
Hiring WordPress Developers Best Practices and Key Consideration
Hiring WordPress Developers Best Practices and Key ConsiderationHiring WordPress Developers Best Practices and Key Consideration
Hiring WordPress Developers Best Practices and Key Consideration
marianjures
From Zero to Funded: How Small Businesses Can Build Credibility Without Perso...
From Zero to Funded: How Small Businesses Can Build Credibility Without Perso...From Zero to Funded: How Small Businesses Can Build Credibility Without Perso...
From Zero to Funded: How Small Businesses Can Build Credibility Without Perso...
The Red Spectrum
Jignesh Shah The Visionary Who Transformed India's Financial.pdf
Jignesh Shah The Visionary Who Transformed India's Financial.pdfJignesh Shah The Visionary Who Transformed India's Financial.pdf
Jignesh Shah The Visionary Who Transformed India's Financial.pdf
Jignesh Shah

AMCA Excel Regression (guide)