Scribd
Upload
2 views7 pages

Excel Tutorial

This document provides a step-by-step tutorial on how to install the Data Analysis ToolPak in Excel and perform regression analysis. It includes instructions for selecting data ranges, configuring options, and generating regression outputs. Additionally, it explains how to plot data points using scatter plots in Excel.

Uploaded by

blasterxd1314
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
2 views7 pages

Excel Tutorial

This document provides a step-by-step tutorial on how to install the Data Analysis ToolPak in Excel and perform regression analysis. It includes instructions for selecting data ranges, configuring options, and generating regression outputs. Additionally, it explains how to plot data points using scatter plots in Excel.

Uploaded by

blasterxd1314
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”.

C
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.
7

You might also like