Social Anxiety Support Forum banner
1 - 3 of 3 Posts

·
Suit up!
Joined
·
390 Posts
Discussion Starter · #1 ·
Excel is driving me bananas. I have to set a trendline to some data and calculate values. Okay, fine. I did that. However, when I enter a value for x the y value it gives me in return makes no sense. For y=1 my value should be around 56, but it gives me a value over 100.

Is there anyone that can help me out? Maybe take a look at it? I've been trying to figure this out for so long I can't stand staring at it anymore.
 

·
Suit up!
Joined
·
390 Posts
Discussion Starter · #3 ·
I actually figured it out. Even though the x axis was in fractions, the trend line was treating the x values as whole numbers and also started at 1 instead of 0. So like 1 was really 11 to my trendline. It was weird, but whatever. As long as I figured it out!
 
1 - 3 of 3 Posts
Top