Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question: I know how to run an excel analysis of regression when there are 2 variables, but how do I run the following with 3?

Question: I know how to run an excel analysis of regression when there are 2 variables, but how do I run the following with 3? I am so confused and cannot find anything in the textbook to explain...

Criterion:Use Excel to complete an analysis of regression.

Data: Use the data from the table below.

Instruction: Complete the following steps.

  1. Open Excel and work in a new sheet.
  2. Enter the data from the table below. Cell A1 will be X. Cell B1 will be Y. Then, enter the data below
Stress Levels
High Moderate Low
10 9 9
7 4 4
8 7 6
12 6 5
6 8 7
  1. Cell A1 will be X. Cell B1 will be Y. Then, enter the data below.
  2. Go to the tool bar, click Data Analysis, and select Regression.
  3. Put a check next to Labelsand Confidence Level.
  4. In Input Y Range: $B$1:$B$11, In Input X Range: $A$1:$A$11
  5. Select Ok. Your data will appear in a new Sheet to the left.
  6. Copy and paste the output to this document.

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

Calculus Early Transcendentals

Authors: James Stewart

7th edition

538497904, 978-0538497909

More Books

Students also viewed these Mathematics questions