Scribd
Upload
3 views7 pages

Excel Tutorial

This document provides a tutorial on how to install the Data Analysis ToolPak in Excel and perform regression analysis. It includes step-by-step instructions for installing the add-in, conducting regression analysis with specified variables, and plotting data points using a scatter plot. The tutorial is structured with clear steps and visual aids to guide the user through the process.

Uploaded by

parthbinitabrwl
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views7 pages

Excel Tutorial

This document provides a tutorial on how to install the Data Analysis ToolPak in Excel and perform regression analysis. It includes step-by-step instructions for installing the add-in, conducting regression analysis with specified variables, and plotting data points using a scatter plot. The tutorial is structured with clear steps and visual aids to guide the user through the process.

Uploaded by

parthbinitabrwl
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Chapter 6 Excel Tutorial (Regression Analysis)

If you do not see the Data Analysis option, the following steps will show you how to install this add-in.

How to install the Data Analysis tool pack:

Step 1) Select “File” from the window option and choose “Option”. You will see the following window.

1
Step 2) Choose “Add-Ins” in the menu. You will then see the following window.

Step 3) In the above window, choose “Analysis ToolPak” in the Add-In list. Next, see the bottom of the
window and you will find “Manage”. Make sure that you have “Excel Add-ins”. Click “Go” button. You
will see the following window.

Step 4) Choose “Analysis ToolPak” as shown in the above window and click “OK” button to install the
data analysis add-in. After the installation, you should be able to see the “Data Analysis” option on the
top right of your Excel screen.

2
Regression Analysis

Step 1) Let’s assume that you have the following data set (year, Y variable, X variable). Click “Data
Analysis” option.

Step 2) You will see the following window. Choose “Regression” and click “OK” button.

3
Step 3) You will see the following window. Fill in the Y variable range and the X variable range. Choose
the options that you like. In my case, I chose “Label”, “Confidence Level” 95%, and “New Worksheet Ply”.
Click “OK” button.

Step 4) You will see the following regression output in a different worksheet.

4
Plotting data points

Step 1) Choose “Insert” option and you will see the following screen. Click “Chart” in the menu bar. I
choose scatter plot. Click “OK”.

Step 2) You will see the empty graph section. Choose “Select Data” option.

5
Step 3) You will see the following screen. Click “Add” in Legend entries.

Step 4) You will see the following screen. Enter your graph title, the range of X variable data, and the
range of Y variable data, as shown in the screen. Click “OK” and click “OK” again in the subsequent
screen.

6
Step 5) You will get the following scatter plot.

You might also like