Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1)Open a blank EXCEL spreadsheet, then click on the following: 2)Click File 3)Click Options (lower left) 4)Click Add-Ins (on left) 5)Click Analysis ToolPak-VBA 6)Click Go

1)Open a blank EXCEL spreadsheet, then click on the following:

2)Click "File"

3)Click "Options" (lower left)

4)Click "Add-Ins" (on left)

5)Click "Analysis ToolPak-VBA"

6)Click "Go" (near the bottom)

7)Click "Analysis ToolPak-VBA" (in window)

8)Click "Ok"

9)Terminate EXCEL then restart it

10)Click on "Data" tab.

11)Under data tab, there is a "Data Analysis" tab on the right.Click on it.

12)"Regression" is one of the pull down options; click on it.

13)Once the regression window opens, specify where the "Y" data is, where "X" data is.If you have multiple X variables, place the data in columns next to one another and highlight all the rows and columns that have X data. EXCEL will interpret each column of data as a different independent variable.Lastly, specify where in the spreadsheet you want the output to be displayed then click on "Ok".

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics

Authors: Austan Goolsbee, Steven Levitt, Chad Syverson

3rd Edition

1319105564, 978-1319105563

More Books

Students also viewed these Economics questions

Question

Why do you think this problem has occurred?

Answered: 1 week ago