Excel

Question

I am attempting to use the Regression Analysis tool in the Data Analysis Toolpak, using the following x and y variables, I am given wrong answers for all outputs.

x	y
2	8
6	20
9	9
13	28
20	24

I am highlighting 8-24 for Y range and 2-20 for the X range.

An example of wrong output; for Standard Error I get 8.727. slope of .667 and intercept of 12.286. When I put those answers into my HW I am marked down for wrong answer. So, I decided to solve by hand to see if I get the same answer and I some how copied and pasted wrong or something. After following the formulas to find Standard Error, slope and intercept I get the right answers for all three. (SE=7.459 , slope=.9, intercept=8.8. The funny thing is I completed all calculations through excel.

Anyways, why is excel giving wrong answers for the this tool and how do I fix it.

Also, I have notice multiple answers being off by similar margins for multiple questions throughout my statistics class, while others are spot on.

Answer 1

Glad you have been able to detect the issue.

Answer 2

OMG I just saw the errors in my way. I had labels marked so Excel was taking out the first row. I have fixed that and excel is in fact, giving the proper answers now.

The problem lied between the keyboard and the chair.

Answer 3

Femi,

See below for the screenshots. I tried selecting the confidence level and received the same answer.

![](https://learn-attachment.microsoft.com/api/attachments/4b09909b-675a-4792-abf2-111e66a787af?platform=QnA

Answer 4

Hi Samurai C, I'm Femi and I'd be happy to help you with your question. Apologies for the challenges experienced. Kindly provide additional details so I can be able to assist you. You can attach screenshot(s) where applicable to further aid my understanding.

Best Regards, Femi

Answer 5

Here are my results using both LINEST and the Regression tool of the ATP.

Here is the Regression setting for the ATP:

Some of my output is not showing on my 1st screenshot above.